ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
mysql 報事務衝突；
用以下sql 查看host 及對應端口；html
select * from information_schema.processlist where DB = 'database';
lsof -i:$port;
獲取進程pid；並通以下命令知道具體進程；
jsp -lvm :grep $pidmysql
kill 相應的trx_mysql_thread_id，即information_schema.processlist表中ID；web
mysql> kill $trx_mysql_thread_id;