mysql 报错

mysql报错： ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction的问题解决

解决：锁表了；  debug一半卡主了 ！！ 导致的

SELECT * FROM information_schema.INNODB_TRX;

kill 616694

ok了

[SQL]
DELETE from sys_log ;
[Err] 1031 - Table storage engine for 'sys_log' doesn't have this option

[SQL]
ALTER TABLE `sys_log`
ADD COLUMN `nickname`  varchar(255) NULL AFTER `username`;
[Err] 1022 - Can't write; duplicate key in table '#sql-2370_39d0'

改为