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

ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction  오류가 발생하는 경우 아래 내용 확인 후 처리

 

1단계 : 현재 설정 확인 

mysql> select @@innodb_lock_wait_timeout;
+----------------------------+
| @@innodb_lock_wait_timeout |
+----------------------------+
|                         50 |
+----------------------------+

 

2단계: 적절하게 타임아웃 변경

mysql> SET innodb_lock_wait_timeout=2000;

 

3단계: 확인

mysql> select @@innodb_lock_wait_timeout;
+----------------------------+
| @@innodb_lock_wait_timeout |
+----------------------------+
|                       2000 |
+----------------------------+