Lock wait timeout exceeded; try restarting transaction

use information_schema;                
select * from INNODB_LOCKS;
SHOW ENGINE INNODB STATUS;
show variables like 'innodb_lock_wait_timeout';
set innodb_lock_wait_timeout=500;

 

 

>프로시저 권한 문제였다.

^^;;;;;;;;