MySQL errors out : Native error code : #1205 and insert operation is failing.
Posted by:
Asai N
Date: July 15, 2005 05:11AM
Description:
We are using an enterprise product called Web Delivery that uses MySQL 4.0.20.
We hit a problem with the below error message :
mwserver[18820]: [info] Start processing request (27)
Mon Nov 22 20:35:27 mwserver[18820]: [info] Request submitted by user
"postman".
Mon Nov 22 20:36:18 mwserver[18820]: [error] SQLExecDirect has Failed. RC=-1.
Mon Nov 22 20:36:18 mwserver[18820]: [error] Database Error:
Mon Nov 22 20:36:18 mwserver[18820]: [error] INSERT INTO DmsDoc ( DocId,
DocLoc, DocAuthor, DocName, DocType, DocFormat, DocIsNew, DocDelete, DocOpenMd,
DocOpenCt) VALUES ( '', '', '', '', '', 'application/pdf', 1, 0, 0, 0)
Mon Nov 22 20:36:18 mwserver[18820]: [error] SQLSTATE = S1000
Mon Nov 22 20:36:18 mwserver[18820]: [error] NATIVE ERROR = 1205
Mon Nov 22 20:36:18 mwserver[18820]: [error] MSG = [MySQL][ODBC 3.51 Driver]
[mysqld-4.0.20-log]Lock wait timeout exceeded; Try restarting transaction
Our application does not use LOCK table,and we have set autocommit=0 in our
product code.
How can this problem be avoided ?
Any comments on this ?
YOur responses would be highly appreciated !!
Regds,
- Asai.