[Bug]: Matrixone Upgrade CI / Compatibility Test With Release fail occasionally about matrixone HOT 2 CLOSED

2024-05-11 15:16:56 ERROR Executor:197 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/log/query_tae_table.sql][row:32][select account from system.statement_info where statement_id = @uuid_create_table;] was executed failed, con[id=1, user=query_tae_table:admin:accountadmin, ***
2024-05-11 15:16:56 ERROR Executor:199 - [EXPECT RESULT]:
account
query_tae_table
2024-05-11 15:16:56 ERROR Executor:200 - [ACTUAL RESULT]:
account
2024-05-11 15:16:56 ERROR RSSet:164 - The row count does not equal with each other, one is 4, the other is 0
2024-05-11 15:16:56 ERROR Executor:197 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/log/query_tae_table.sql][row:35][select statement from system.statement_info where statement_id in (@uuid_hide_1, @uuid_hide_2, @uuid_hide_3, @uuid_hide_4);] was executed failed, con[id=1, user=query_tae_table:admin:accountadmin, ***
2024-05-11 15:16:56 ERROR Executor:199 - [EXPECT RESULT]:
statement
create user u identified by '******'
create user if not exists abc1 identified by '******', abc2 identified by '******', abc3 identified by '******', abc3 identified by '******'
create external table t (a int) URL s3option{'endpoint'='s3.us-west-2.amazonaws.com', 'access_key_id'='******', 'secret_access_key'='******', 'bucket'='test', 'filepath'='*.txt', 'region'='us-west-2'}
select 1
2024-05-11 15:16:56 ERROR Executor:200 - [ACTUAL RESULT]:
statement
2024-05-11 15:16:56 ERROR RSSet:164 - The row count does not equal with each other, one is 1, the other is 0
2024-05-11 15:16:56 ERROR Executor:197 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/log/query_tae_table.sql][row:37][select account, statement from system.statement_info where statement_id = @uuid_insert_table limit 1;] was executed failed, con[id=1, user=query_tae_table:admin:accountadmin, ***
2024-05-11 15:16:56 ERROR Executor:199 - [EXPECT RESULT]:
account    statement
query_tae_table    insert into query_tae_table values (1)
2024-05-11 15:16:56 ERROR Executor:200 - [ACTUAL RESULT]:
account    statement
2024-05-11 15:16:56 INFO  Executor:690 - select mo_ctl('cn','synccommit','') with sys user[dump] successfully.
2024-05-11 15:16:56 ERROR RSSet:164 - The row count does not equal with each other, one is 3, the other is 0
2024-05-11 15:16:56 ERROR Executor:197 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/log/query_tae_table.sql][row:44][select status, err_code, error from system.statement_info where account = 'query_tae_table' and statement in ('use query_tae_table', 'select syntax error stmt', '/*issue_[816](https://github.com/matrixorigin/matrixone/actions/runs/9043434382/job/24853229697?pr=16027#step:13:817)8*/use query_tae_table') and status != 'Running' order by request_at desc limit 3;] was executed failed, con[id=0, user=dump, ***
2024-05-11 15:16:56 ERROR Executor:199 - [EXPECT RESULT]:
status    err_code    error
Failed    20303    SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 58 near " stmt;";
Failed    20303    SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 58 near " stmt;";
Success    0    
2024-05-11 15:16:56 ERROR Executor:200 - [ACTUAL RESULT]:
status    err_code    error
2024-05-11 15:16:56 INFO  Executor:289 - The script file[/home/runner/work/matrixone/matrixone/head/test/distributed/cases/log/query_tae_table.sql] has been executed, and cost: 26.653s, total:27, success:23, failed:4, ignored:0, abnoraml:0