The error is as follows:
Lock wait timeout exceeded; try restarting transaction ; Lock wait timeout
Finally, it was found that it was caused by a local debug jam. Just stop it
If a deadlock occurs, you can use the following command to differential lock and kill it
select * from information_schema.innodb_trx
Check Lock WAIT of trx_status field
copy trx_id
kill trx_id
If trx_status is RUNNING, ignore it, it means that the transaction is being executed without locks
Read More:
- Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)
- [Solved] Centons7 docker:mysql:5.7 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
- [Solved] centos Install MYSQL Error: another app is currently holding the yum lock
- How to release Oracle PLSQL data lock table
- [Solved] mysqldump: Got error: 1556: “You can‘t use locks with log tables.“ when using LOCK TABLES
- Oracle11g Startup Database Error: ORA-27154: post/wait create failed
- [Solved] Worker 1 failed executing transaction ‘ANONYMOUS‘ at master log mall-mysql-bin.000001, end_log_pos
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
- [Solved] ORA-00020: maximum number of processes (150) exceeded
- MySql Install Error: Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
- [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
- (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- [Solved] CentOS installs MySQL and starts MySQL with error 2002 (HY000)
- [Solved] MYSQL Error: ERROR! MySQL server PID file could not be found!
- [Solved] Mongo Error: cant post the change to mongodb there is transaction error
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- How to Solve MYSQL Error: Failed to start MySQL 8.0 database server