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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
