[GitHub] [doris] sodamnsure opened a new issue, #14855: [Bug] BE is down because enable_vectorized_engine was set to true

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

sodamnsure opened a new issue, #14855:
URL: https://github.com/apache/doris/issues/14855

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   Apache Doris 1.1.4 Release
   
   ### What's Wrong?
   
   1. I have two tables named `bug_type_insert_ods` and `bug_type_insert_dim`, each with the following data
       
       ```sql
       mysql> select trade_id
           -> from test.bug_type_insert_ods;
       +---------------+
       | trade_id      |
       +---------------+
       |             1 |
       |         2.888 |
       | 1000000000004 |
       +---------------+
       3 rows in set (0.01 sec)
       ```
       The table `bug_type_insert_dim` has no data
       ```sql
       mysql> select trade_id
           -> from test.bug_type_insert_dim;
       Empty set (0.01 sec)
       ```
   
   2. The only difference between the two tables is the type of the `trade_id` field. For `bug_type_insert_ods`, the `trade_id` field is a `decimal(27, 6)`, while for `bug_type_insert_dim`, it is an` int`
   3. Now enable `enable_vectorized_engine` to true and run the following SQL
       ```sql
        mysql> SET global enable_vectorized_engine = true;
        Query OK, 0 rows affected (0.00 sec)
       ```
       ```sql
       mysql> insert into test.bug_type_insert_dim select trade_id from test.bug_type_insert_ods;
       ```
   4. The following error occurs
       ```sql
        ERROR 1105 (HY000): errCode = 2, detailMessage = There exists unhealthy backend. backend 11004 is down
       ```
   5. At this time, observe the Be WARNING log
       The first node to have a problem
       ```sh
       tail -f be.WARNING
       F1206 16:55:31.853216 84445 data_type_decimal.h:303] Decimal convert overflow
       ```
        The second and other problematic nodes
       ```sh
        W1206 16:55:39.267967 55725 tablet_sink.h:149] failed to send brpc batch, error=Host is down, error_text=[E112]Not connected to 192.168.*.*2:8060 yet, server_id=513 [R1][E112]Not connected to 192.168.*.*2:8060 yet, server_id=513 [R2][E112]Not connected to 192.168.*.*2:8060 yet, server_id=513 [R3][E112]Not connected to 192.168.*.*2:8060 yet, server_id=513 [R4][E112]Not connected to 192.168.*.*2:8060 yet, server_id=513 [R5][E112]Not connected to 192.168.*.*2:8060 yet, server_id=513 [R6][E112]Not connected to 192.168.*.*2:8060 yet, server_id=513 [R7][E112]Not connected to 192.168.*.*2:8060 yet, server_id=513 [R8][E112]Not connected to 192.168.*.*2:8060 yet, server_id=513 [R9][E112]Not connected to 192.168.*.*2:8060 yet, server_id=513 [R10][E112]Not connected to 192.168.*.*2:8060 yet, server_id=513
       ```
   
   ### What You Expected?
   
   BE is not down
   
   ### 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-unsubscribe@doris.apache.org.apache.org

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