[GitHub] [incubator-doris] weajun opened a new issue #6967: [Bug] sql execution sometimes error with errmsg: failed to get tablet

[GitBox]

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


   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and 
found no similar issues.
   
   
   ### Version
   
   0.15.1-rc03
   0.14.13.1
   
   
   ### What's Wrong?
   
   1. Description:
       sql sometimes runs successfully and sometimes fails. When it fails, the 
error message is: 1064 - errCode = 2, detailMessage = failed to get tablet. 
tablet_id=2258584, with schema_hash=1465588534, reason=tablet does not exist, 
Time: 0.794000s
   
   2. Detailed description
   - The display is normal when `SHOW PROC 
'/dbs/xxx/xxx/partitions/xxx/xxx/2258584'` is executed on different fe , and 
The returned `backendId` field value is 10004, 10005, 10006
   - When executing SQL, sometimes the scanNode task of the tablet is assigned 
to the be node where there is no replication of the tablet.  the tablet 2258584 
replication is in backendId(10004, 10005, 10006)，but sometimes scanNode task 
was assigned to backendId 10007 or other backend：
   <img width="1279" alt="4C07985A-0971-473C-B2D8-BA6DC2656A48" 
src="https://user-images.githubusercontent.com/6142924/139366160-6067fa8c-d6e1-4caa-9679-96688405d421.png";>
   -  When I open the debug log of fe, I get the following information, host 
xxx.xxx.xxx.116 backendId is 10007
   <img width="1279" alt="4C07985A-0971-473C-B2D8-BA6DC2656A48" 
src="https://user-images.githubusercontent.com/6142924/139366527-3c9df236-8bfd-45ff-ac38-eb466fe7135b.png";>
   
   
   
   
   ### What You Expected?
   
   sql exec success
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

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