[Bug] BE is down because enable_vectorized_engine was set to true

[sodamnsure]

Search before asking

• I had searched in the issues 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

   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

   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

    mysql> SET global enable_vectorized_engine = true;
    Query OK, 0 rows affected (0.00 sec)

   mysql> insert into test.bug_type_insert_dim select trade_id from test.bug_type_insert_ods;

4. The following error occurs

    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

   tail -f be.WARNING
   F1206 16:55:31.853216 84445 data_type_decimal.h:303] Decimal convert overflow

   The second and other problematic nodes

    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

• I agree to follow this project's Code of Conduct