[Bug]: BVT failed: MO does not return result in 300000 ms

[aptend]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

main, 2.0-dev

Commit ID

88803ef

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

https://github.com/matrixorigin/matrixone/actions/runs/12744571311/job/35516883914?pr=21200

2025-01-13 10:16:23 ERROR Executor:209 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/dml/show/database_statistics.sql][row:107][select mo_table_rows("test_db","t1"),mo_table_size("test_db","t1");] MO does not return result in 300000 ms,con[id=0, user=dump, ***
2025-01-13 10:16:23 ERROR Executor:219 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/dml/show/database_statistics.sql][row:107][select mo_table_rows("test_db","t1"),mo_table_size("test_db","t1");] was executed failed, con[id=0, user=dump, ***
2025-01-13 10:16:23 ERROR Executor:221 - [EXPECT RESULT]:
mo_table_rows(test_db, t1)    mo_table_size(test_db, t1)
0    0
2025-01-13 10:16:23 ERROR Executor:222 - [ACTUAL RESULT]:
MO does not return result in 300000 ms. 
2025-01-13 10:16:23 INFO  Executor:225 - Start to collect pprof information,please wait........
2025-01-13 10:16:53 INFO  Executor:724 - The pprof operation has been executed successfully.
2025-01-13 10:16:23 The server addr is : 127.0.0.1
2025-01-13 10:16:23 The debug port is : 12345

Expected Behavior

No response

Steps to Reproduce

Run BVT

Additional information

2025/01/13 10:27:36.311921 +0000 ERROR cn-service found long running txn {"uuid": "", "txn-id": "70f70f4866a9b62a181a389dafb9875b", "create-at": "2025/01/13 10:11:22.934889 +0000", "options": "Features:1 CN:\"dd1dccb4-4d3c-41f8-b482-5251dc7a41bf\" SessionID:\"01945f22-31a6-7050-a308-ec09425bd22e\" ConnectionID:503 UserName:\"dump\" counter:\"commit: enter:0, exit:0 rollback: enter:0, exit:0 runSql: enter:1, exit:0 incrStmt: enter:1, exit:1 rollbackStmt: enter:0, exit:0 txnMeta: 70f70f4866a9b62a181a389dafb9875b/Active/S:1736763082933075831-1 footPrints: [6: enter:1, exit:0] [7: enter:1, exit:0] [8: enter:1, exit:0] [13: enter:1, exit:0] [15: enter:1, exit:0] [16: enter:1, exit:0] [99: enter:1, exit:0] [101: enter:1, exit:0] [102: enter:1, exit:0] \" sessionInfo:\"connectionId 503|127.0.0.1:37328|account sys:dump|goRoutineId 2059|migrate-goRoutineId 0|01945f22-31a6-7050-a308-ec09425bd22e\" inRunSql:true autocommit:true ", "profile": "ETL:/profile/CN_dd1dccb4-4d3c-41f8-b482-5251dc7a41bf_leakcheck_routine_01945f34-62f7-7ccd-8f97-d781cd31ddf7.gz"}
2025/01/13 10:27:36.312206 +0000 ERROR cn-service found long running txn {"uuid": "", "txn-id": "70f70f4866a9b62a181a389dafbc2675", "create-at": "2025/01/13 10:16:54.677861 +0000", "options": "Features:1 CN:\"dd1dccb4-4d3c-41f8-b482-5251dc7a41bf\" SessionID:\"01945f2a-9798-7966-ae33-f4efa94ed1b8\" AccountID:10010 ConnectionID:556 UserName:\"test_user\" counter:\"commit: enter:0, exit:0 rollback: enter:0, exit:0 runSql: enter:1, exit:0 incrStmt: enter:1, exit:1 rollbackStmt: enter:0, exit:0 txnMeta: 70f70f4866a9b62a181a389dafbc2675/Active/S:1736763414677378538-1 footPrints: [6: enter:1, exit:0] [7: enter:1, exit:0] [8: enter:1, exit:0] [13: enter:1, exit:0] [15: enter:1, exit:0] [16: enter:1, exit:0] [99: enter:1, exit:0] [101: enter:1, exit:0] [102: enter:1, exit:0] \" sessionInfo:\"connectionId 556|127.0.0.1:48802|account test_account:test_user|goRoutineId 430795|migrate-goRoutineId 0|01945f2a-9798-7966-ae33-f4efa94ed1b8\" inRunSql:true autocommit:true ", "profile": "ETL:/profile/CN_dd1dccb4-4d3c-41f8-b482-5251dc7a41bf_leakcheck_routine_01945f34-62f7-7ccd-8f97-d781cd31ddf7.gz"}
2025/01/13 10:27:36.312296 +0000 ERROR cn-service found long running txn {"uuid": "", "txn-id": "70f70f4866a9b62a181a389dafbc7f73", "create-at": "2025/01/13 10:17:50.298505 +0000", "options": "CN:\"dd1dccb4-4d3c-41f8-b482-5251dc7a41bf\" SessionID:\"01945f2b-71da-7703-a60b-6d09d29aa06c\" ConnectionID:74751101 UserName:\"internal\" counter:\"commit: enter:0, exit:0 rollback: enter:0, exit:0 runSql: enter:1, exit:0 incrStmt: enter:1, exit:1 rollbackStmt: enter:0, exit:0 txnMeta: 70f70f4866a9b62a181a389dafbc7f73/Active/S:1736763470301506274-1 footPrints: [6: enter:1, exit:0] [7: enter:1, exit:0] [13: enter:1, exit:0] [15: enter:1, exit:0] [16: enter:1, exit:0] [18: enter:1, exit:0] [70: enter:1, exit:0] [116: enter:1, exit:1] \" inRunSql:true autocommit:true ", "profile": "ETL:/profile/CN_dd1dccb4-4d3c-41f8-b482-5251dc7a41bf_leakcheck_routine_01945f34-62f7-7ccd-8f97-d781cd31ddf7.gz"}
2025/01/13 10:27:36.312362 +0000 ERROR cn-service found leak txn {"uuid": "", "txn-id": "70f70f4866a9b62a181a389dafbc7f75", "create-at": "2025/01/13 10:17:50.301750 +0000", "options": "Features:32 CN:\"dd1dccb4-4d3c-41f8-b482-5251dc7a41bf\" SessionID:\"01945f2b-71dd-7b05-8d81-bdd007341cb7\" counter:\"commit: enter:0, exit:0 rollback: enter:0, exit:0 runSql: enter:2, exit:2 incrStmt: enter:2, exit:2 rollbackStmt: enter:0, exit:0 txnMeta: 70f70f4866a9b62a181a389dafbc7f75/Active/S:1736763470301506274-1 footPrints: [3: enter:2, exit:3] [6: enter:2, exit:2] [9: enter:2, exit:2] [10: enter:2, exit:2] [11: enter:2, exit:3] [12: enter:2, exit:3] [13: enter:2, exit:2] [14: enter:2, exit:2] [15: enter:2, exit:2] [16: enter:2, exit:2] [85: enter:3, exit:3] [86: enter:3, exit:3] [87: enter:3, exit:3] [92: enter:10, exit:10] [93: enter:10, exit:10] [95: enter:10, exit:10] [100: enter:2, exit:2] [117: enter:2, exit:3] [119: enter:10, exit:10] \" byBegin:true autocommit:true ", "profile": "ETL:/profile/CN_dd1dccb4-4d3c-41f8-b482-5251dc7a41bf_leakcheck_routine_01945f34-62f7-7ccd-8f97-d781cd31ddf7.gz"}
2025/01/13 10:27:36.312418 +0000 ERROR cn-service found long running txn {"uuid": "", "txn-id": "70f70f4866a9b62a181a389dafbe7a09", "create-at": "2025/01/13 10:22:51.249872 +0000", "options": "CN:\"dd1dccb4-4d3c-41f8-b482-5251dc7a41bf\" SessionID:\"01945f30-0971-7be9-8eab-67ef102aaea1\" ConnectionID:74751101 UserName:\"internal\" counter:\"commit: enter:0, exit:0 rollback: enter:0, exit:0 runSql: enter:1, exit:0 incrStmt: enter:1, exit:1 rollbackStmt: enter:0, exit:0 txnMeta: 70f70f4866a9b62a181a389dafbe7a09/Active/S:1736763771250325493-1 footPrints: [6: enter:1, exit:0] [7: enter:1, exit:0] [13: enter:1, exit:0] [15: enter:1, exit:0] [16: enter:1, exit:0] [18: enter:1, exit:0] [70: enter:1, exit:0] [116: enter:1, exit:1] \" inRunSql:true autocommit:true ", "profile": "ETL:/profile/CN_dd1dccb4-4d3c-41f8-b482-5251dc7a41bf_leakcheck_routine_01945f34-62f7-7ccd-8f97-d781cd31ddf7.gz"}
2025/01/13 10:27:36.312474 +0000 ERROR cn-service found leak txn {"uuid": "", "txn-id": "70f70f4866a9b62a181a389dafbe7a0a", "create-at": "2025/01/13 10:22:51.252045 +0000", "options": "Features:32 CN:\"dd1dccb4-4d3c-41f8-b482-5251dc7a41bf\" SessionID:\"01945f30-0974-7011-ba37-fd930da3f4c8\" counter:\"commit: enter:0, exit:0 rollback: enter:0, exit:0 runSql: enter:1, exit:1 incrStmt: enter:1, exit:1 rollbackStmt: enter:0, exit:0 txnMeta: 70f70f4866a9b62a181a389dafbe7a0a/Active/S:1736763771250325493-1 footPrints: [3: enter:1, exit:2] [6: enter:1, exit:1] [9: enter:1, exit:1] [10: enter:1, exit:1] [11: enter:1, exit:2] [12: enter:1, exit:2] [13: enter:1, exit:1] [14: enter:1, exit:1] [15: enter:1, exit:1] [16: enter:1, exit:1] [85: enter:2, exit:2] [86: enter:2, exit:2] [87: enter:2, exit:2] [92: enter:8, exit:8] [93: enter:8, exit:8] [95: enter:8, exit:8] [100: enter:1, exit:1] [117: enter:1, exit:2] [119: enter:8, exit:8] \" byBegin:true autocommit:true ", "profile": "ETL:/profile/CN_dd1dccb4-4d3c-41f8-b482-5251dc7a41bf_leakcheck_routine_01945f34-62f7-7ccd-8f97-d781cd31ddf7.gz"}
2025/01/13 10:27:36.312543 +0000 ERROR cn-service found long running txn {"uuid": "", "txn-id": "70f70f4866a9b62a181a389dafbeb46a", "create-at": "2025/01/13 10:23:33.640457 +0000", "options": "Features:1 CN:\"dd1dccb4-4d3c-41f8-b482-5251dc7a41bf\" SessionID:\"01945f2a-961f-7ae5-b078-1c2845246437\" ConnectionID:555 UserName:\"dump\" counter:\"commit: enter:0, exit:0 rollback: enter:0, exit:0 runSql: enter:1, exit:0 incrStmt: enter:1, exit:1 rollbackStmt: enter:0, exit:0 txnMeta: 70f70f4866a9b62a181a389dafbeb46a/Active/S:1736763813638129910-1 footPrints: [6: enter:1, exit:0] [7: enter:1, exit:0] [8: enter:1, exit:0] [13: enter:1, exit:0] [15: enter:1, exit:0] [16: enter:1, exit:0] [99: enter:1, exit:0] [101: enter:1, exit:0] [102: enter:1, exit:0] \" sessionInfo:\"connectionId 555|127.0.0.1:48786|account sys:dump|goRoutineId 430525|migrate-goRoutineId 0|01945f2a-961f-7ae5-b078-1c2845246437\" inRunSql:true autocommit:true ", "profile": "ETL:/profile/CN_dd1dccb4-4d3c-41f8-b482-5251dc7a41bf_leakcheck_routine_01945f34-62f7-7ccd-8f97-d781cd31ddf7.gz"}

[gouhongshen]

fixed