I have set InnoDB lock wait time-out to 120 seconds.
When I run the query below for first time, it works fine. However, the second time, the same query with a different value gives me:
Error Code: 1205 Lock wait timeout exceeded; try restarting transaction
INSERT INTO PM_SPEC_DOC_APPROVE ( SDA_SYS_NUM, SDA_SPEC_SYS_NUM, SDA_SYS_REV, SDA_APPR_UID, SDA_APPR_DATE, SDA_CR_UID, SDA_CR_DT, SDA_SRNO, SDA_NOTE) VALUES ( '7414', '24510', NULL, 'E13462', '2012-07-25 16:35:49', 'E13462', '2012-07-25 16:35:49', '3', NULL)
We are using MySQL v5.1