[MariaDB/Procedure]lock wait timeout exceeded try restarting transaction

 

 

프로시저 돌렸을 때, lock wait timeout exceeded try restarting transaction 에러 발생

 

 

LOCK 걸린 곳 확인

use information_schema;
select * from INNODB_LOCKS;
select * from INNODB_LOCK_WAITS;

 

SHOW variables like '%wait_timeout%';

| Variable_name 			| Value	|
| innodb_lock_wait_timeout	| 50	|
| lock_wait_timeout			| 86400 |
| wait_timeout				| 28800 |

 

 

LOCK 걸린 것 변경