@[TOC](記錄一次MySql鎖等待 (Lock wait timeout exceeded)異常)

Java執行一個SQL查詢未提交，遇到1205錯誤。

java.lang.Exception:
### Error updating database.  Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transactionClusterManager: Error managing cluster: Failure recovering jobs: Lock wait timeout exceeded; try restarting transaction

解決辦法：
執行mysql命令:

SELECT * FROM information_schema.innodb_trx;

然后找出trx_state值為“LOCK WAIT”的記錄，根據記錄中查詢語句的系統id（trx_mysql_thread_id）：kill掉被鎖住的線程id

KILL trx_mysql_thread_id ;