mysql Lock wait timeout exceeded; try restarting transaction: Timeout on record in index:

error 

Lock wait timeout exceeded; try restarting transaction: Timeout on record in index:

solution

show processlist;

kill <process id>;

참고 사이트 : https://stackoverflow.com/questions/5836623/getting-lock-wait-timeout-exceeded-try-restarting-transaction-even-though-im