|
本帖最后由 fuhao009 于 2023-10-17 16:28 编辑 版本：8.0.25-16 TRANSACTIONS ------------ Trx id counter 402901548 Purge done for trx's n  < 402901548 undo n < 0 state: running but idleHistory list length 80 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421986673117032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421986673115208, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421986673114296, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 402851757, ACTIVE (PREPARED) 93 sec recovered trx 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 5 TABLE LOCK table `intell`.`dws_station_min_flow` trx id 402851757 lock mode IX ---TRANSACTION 402851749, ACTIVE (PREPARED) 93 sec recovered trx 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 7 TABLE LOCK table `intell`.`dws_station_min_flow` trx id 402851749 lock mode IX ---TRANSACTION 402851742, ACTIVE (PREPARED) 93 sec recovered trx 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 11 TABLE LOCK table `intell`.`dws_station_min_flow` trx id 402851742 lock mode IX ---TRANSACTION 383545873, ACTIVE (PREPARED) 93 sec recovered trx 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 51 TABLE LOCK table `intell`.`dws_gantry_min_flow` trx id 383545873 lock mode IX ---TRANSACTION 383545866, ACTIVE (PREPARED) 93 sec recovered trx 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 64 TABLE LOCK table `intell`.`dws_gantry_min_flow` trx id 383545866 lock mode IX ---TRANSACTION 383545859, ACTIVE (PREPARED) 93 sec recovered trx 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 73 TABLE LOCK table `intell`.`dws_gantry_min_flow` trx id 383545859 lock mode IX ---TRANSACTION 374488323, ACTIVE (PREPARED) 93 sec recovered trx 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 13 TABLE LOCK table `intell`.`dws_station_min_flow` trx id 374488323 lock mode IX ---TRANSACTION 374488322, ACTIVE (PREPARED) 93 sec recovered trx 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 4 TABLE LOCK table `intell`.`dws_station_min_flow` trx id 374488322 lock mode IX ---TRANSACTION 374488315, ACTIVE (PREPARED) 93 sec recovered trx 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 7 TABLE LOCK table `intell`.`dws_station_min_flow` trx id 374488315 lock mode IX ---TRANSACTION 356501551, ACTIVE (PREPARED) 93 sec recovered trx 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 12 TABLE LOCK table `intell`.`dws_station_min_flow` trx id 356501551 lock mode IX ---TRANSACTION 356501550, ACTIVE (PREPARED) 93 sec recovered trx 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 13 TABLE LOCK table `intell`.`dws_station_min_flow` trx id 356501550 lock mode IX ---TRANSACTION 356501542, ACTIVE (PREPARED) 93 sec recovered trx 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 22 TABLE LOCK table `intell`.`dws_station_min_flow` trx id 356501542 lock mode IX ---TRANSACTION 285556683, ACTIVE (PREPARED) 93 sec recovered trx 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 33 TABLE LOCK table `intell`.`dws_gantry_min_flow` trx id 285556683 lock mode IX ---TRANSACTION 285556682, ACTIVE (PREPARED) 93 sec recovered trx 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 TABLE LOCK table `intell`.`dws_gantry_min_flow` trx id 285556682 lock mode IX ---TRANSACTION 285556675, ACTIVE (PREPARED) 93 sec recovered trx 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 32 TABLE LOCK table `intell`.`dws_gantry_min_flow` trx id 285556675 lock mode IX 查询事务的线程id是0 |
|
|
yejr
2023-10-17 13:49:13
| |
|
|
fuhao009
2023-10-17 13:52:28
| |
|
|
fuhao009
2023-10-17 13:53:43
| |
|
|
fuhao009
2023-10-17 13:54:16
| |
|
|
yejr
2023-10-17 15:27:31
| |
|
|
fuhao009
2023-10-17 15:31:27
| |
|
|
yejr
2023-10-17 15:35:10
| |
|
|
yejr
2023-10-17 15:36:21
| |
|
|
yejr
2023-10-17 16:03:27
| |
合作电话：010-64087828
社区邮箱：greatsql@greatdb.com
