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

mysql> show variables like 'innodb_lock_wait%';

+--------------------------+-------+

| Variable_name            | Value |

+--------------------------+-------+

| innodb_lock_wait_timeout | 5     |

+--------------------------+-------+

1 row in set (0.00 sec)

 

 

查看默认值设置过小

这个参数最小1，最大1073741824

 

更改大些

比如设置为100s

 

在 /etc/my.cnf配置文件更改，然后重启数据库