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
SHOW CREATE TABLE PM_SPEC_DOC_APPROVE
to the question, as well asSHOW FULL PROCESSLIST
while the second one is running (the one that times out)? – Derek Downey Jul 25 '12 at 14:25