Solutions:
Execute mysql command: Show Full ProcessList;
Then find the system ID of the query statement: kill the thread ID that is being locked
Select * from information_schema.innodb_trx; select * from information_schema.innodb_trx;
Refer to the article: http://my.oschina.net/quanzhong/blog/222091
http://blog.sina.com.cn/s/blog_53e68b3b0101bjxi.html
Read More:
- MySQL error 1205 (HY000): lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded — transaction and index
- Global lock, table lock and row lock in MySQL
- Uncaught (in promise) Error: timeout of 5000ms exceeded
- Centos 7 | mariadb/mysql | [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
- Error: timeout of 5000ms exceeded error is always reported during post request
- Get connection timeout retry: 1 MySQL errorcode 0, state 08s01 docker container accessing MySQL container is very slow and sometimes interrupted
- node.js Server MySQL database connection timeout (error: connect etimeout)
- Unity Cursor Lock& Camera Lock
- [TCP] TCP connection SYN timeout retransmission times and timeout period
- MySQL Workbench: Error Code: 2013. Lost connection to MySQL server during query solution
- Solution of server startup timeout in eclipse
- After installing MySQL again under Linux, the solution of ‘MySQL module failed to start’ appears
- Outofmemoryerror: GC overhead limit exceeded solution
- Vscode failed to update plug-in XHR timeout error solution
- When linux installs rpm, it prompts: can’t create transaction lock on /var/lib/rpm/.rpm.lock error
- Golang MySQL error SQL: unknown driver “MySQL” (Forgotten import?) solution
- MySQL local connection Error 1130_ The solution of MySQL 1130 error report when remote connection through Navicat for MySQL
- Java:java.lang.OutOfMemoryError : GC overhead limit exceeded solution
- The difference between sleep() and wait() in Java