Mysql 錯誤ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

時間 2019-12-07 標籤 mysql 錯誤 error 1205 hy000 hy 000 lock wait timeout exceeded try restarting transaction

1，查看數據庫的隔離級別：mysql

mysql> select @@tx_isolation;
+-----------------+
| @@tx_isolation |
+-----------------+
| REPEATABLE-READ |
+-----------------+
1 row in set (0.00 sec)

sql

2，去查看先當前庫的線程狀況：數據庫

mysql> show full processlist; spa

mysql> SELECT * FROM information_schema.INNODB_TRX;.net

mysql> kill 156665;線程

mysql> SELECT * FROM INNODB_TRX;orm

Empty set (0.00 sec)ssl