[GitHub] [incubator-doris] xinghuayu007 opened a new issue #5726: [Bug][Cache] Get cache returns unknow error

Wed, 28 Apr 2021 02:08:33 -0700 


xinghuayu007 opened a new issue #5726:
URL: https://github.com/apache/incubator-doris/issues/5726


   **Describe the bug**
   When a query executed with cache enabled, it returns error:
   2021-04-26 16:18:25,898 WARN (doris-mysql-nio-pool-3|156) 
[StmtExecutor.execute():337] execute Exception
   `java.lang.NullPointerException: null
           at 
org.apache.doris.qe.cache.CacheProxy$FetchCacheResult.setResult(CacheProxy.java:229)
 ~[palo-fe.jar:3.4.0]
           at 
org.apache.doris.qe.cache.CacheBeProxy.fetchCache(CacheBeProxy.java:97) 
~[palo-fe.jar:3.4.0]
           at org.apache.doris.qe.cache.SqlCache.getCacheData(SqlCache.java:44) 
~[palo-fe.jar:3.4.0]
           at 
org.apache.doris.qe.cache.CacheAnalyzer.getCacheData(CacheAnalyzer.java:280) 
~[palo-fe.jar:3.4.0]
           at 
org.apache.doris.qe.StmtExecutor.handleCacheStmt(StmtExecutor.java:646) 
~[palo-fe.jar:3.4.0]
           at 
org.apache.doris.qe.StmtExecutor.handleQueryStmt(StmtExecutor.java:737) 
~[palo-fe.jar:3.4.0]
           at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:273) 
~[palo-fe.jar:3.4.0]
           at 
org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:192) 
~[palo-fe.jar:3.4.0]
           at 
org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:324) 
~[palo-fe.jar:3.4.0]
           at 
org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:509) 
~[palo-fe.jar:3.4.0]
           at 
org.apache.doris.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:50)
 ~[palo-fe.jar:3.4.0]
           at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) 
[?:?]
           at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) 
[?:?]
           at java.lang.Thread.run(Thread.java:834) [?:?]`
   
   **To Reproduce**
   Steps to reproduce the behavior:
   1. create a table with 3 more partitions, set enable_sql_cache=true:
   ![2021-04-28 
16-44-37屏幕截图](https://user-images.githubusercontent.com/12771191/116375415-d6803880-a841-11eb-977a-1e136131d2f7.png)
   
   2. insert some data into partition p201707, this partition becomes the 
lastest partition
   ![2021-04-28 
16-45-00屏幕截图](https://user-images.githubusercontent.com/12771191/116375577-00d1f600-a842-11eb-8aab-e77fbc867704.png)
   
   3. query twice this table, the cache has been planted.
   ![2021-04-28 
16-45-38屏幕截图](https://user-images.githubusercontent.com/12771191/116375659-1515f300-a842-11eb-839a-7876b5e2663c.png)
   
   4. insert some data into partition p201709, this partition becomes the 
lastest partition
   ![2021-04-28 
16-45-58屏幕截图](https://user-images.githubusercontent.com/12771191/116375862-4393ce00-a842-11eb-929c-a7b4d9002752.png)
   
   5. query twice this table, the cache has been planted.
   ![2021-04-28 
16-46-11屏幕截图](https://user-images.githubusercontent.com/12771191/116375894-4e4e6300-a842-11eb-8caf-8fbd33f7ff76.png)
   
   6. insert some data into partition p201708, this partition becomes the 
lastest partition
   ![2021-04-28 
16-46-25屏幕截图](https://user-images.githubusercontent.com/12771191/116376025-6cb45e80-a842-11eb-9d92-bdbcc3b95775.png)
   
   9. quey this table， return error
   ![2021-04-28 
16-46-38屏幕截图](https://user-images.githubusercontent.com/12771191/116376098-8190f200-a842-11eb-9f58-e000f9edfbee.png)
   
   
   **Expected behavior**
   A clear and concise description of what you expected to happen.
   
   **Screenshots**
   If applicable, add screenshots to help explain your problem.
   
   **Desktop (please complete the following information):**
    - OS: [e.g. iOS]
    - Browser [e.g. chrome, safari]
    - Version [e.g. 22]
   
   **Smartphone (please complete the following information):**
    - Device: [e.g. iPhone6]
    - OS: [e.g. iOS8.1]
    - Browser [e.g. stock browser, safari]
    - Version [e.g. 22]
   
   **Additional context**
   Add any other context about the problem here.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to