[GitHub] [incubator-doris] Yao-MR opened a new issue #4813: query can not execute casue the be hit the unhealthy tablet in the be

[GitBox <gi...@apache.org>]

Yao-MR opened a new issue #4813:
URL: https://github.com/apache/incubator-doris/issues/4813


   **Describe the bug**
   ERR LOG:
   
   `Scans failed: index: 1 caused by com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: errCode = 2, detailMessage = failed to get tablet. tablet_id=158625, with schema_hash=1455698802, reason=tablet does not exist 
   `
   
   **To Reproduce**
   Steps to reproduce the behavior:
   1. user just submit one query,  and the hit table has 3 replica, 
   2. sometime the same query can execute normally but sometimes the query can not submit casuse the errlog
   `Scans failed: index: 1 caused by com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: errCode = 2, detailMessage = failed to get tablet. tablet_id=158625, with schema_hash=1455698802, reason=tablet does not exist 
   `
   
   **Expected behavior**
   in my opinion the tablet has 3 replica and when the query cast to the execute plan , the fe should 
   select the healthy tablet , 
   
   but in fact ,the execute plan generate the work, and the work hit the unhealthy tablet, and know this is an unhealthy
   tablet, so the query can execute, 
   
   **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**
   用户提交query遭遇报错
   报错信息：
   `Scans failed: index: 1 caused by com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: errCode = 2, detailMessage = failed to get tablet. tablet_id=158625, with schema_hash=1455698802, reason=tablet does not exist 
   `
   从报错信息来看是be节点在执行自己任务的时候发现分配给自己任务的数据块在机器上
   
   按照正常的执行逻辑是catalog 中是有这些数据元信息的，在执行计划生成阶段选择的副本本来就是经过挑挑选的健康副本，
   
   但目前简单来看是在节点be执行时才发现这个副本不健康
   
   


----------------------------------------------------------------
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:
users@infra.apache.org



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