mysql出现SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded； try restarting transaction

Lock wait timeout exceeded

已超过锁定等待超时

1. 输入进程查询命令

show full processlist;

2. 找出所操作数据库中"Sleep"状态的语句，进行清除即可

kill 12335473;