mysql:ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
mysql 报事务冲突；
用如下sql 查看host 及对应端口；

select * from information_schema.processlist where DB = 'database';

lsof -i:$port;
获取进程pid；并通如下命令知道具体进程；
jsp -lvm :grep $pid

kill 相应的trx_mysql_thread_id，即information_schema.processlist表中ID；

	mysql> kill $trx_mysql_thread_id;

参 : https://www.cnblogs.com/topicjie/p/7323248.html