MySQL Forums
Forum List  »  MySQL Administrator

MySQL 4.0.20 errors out : Native error code : #1205 and insert operation is failing.
Posted by: Asai N
Date: July 15, 2005 05:13AM

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 ?

Options: ReplyQuote


Subject
Written By
Posted
MySQL 4.0.20 errors out : Native error code : #1205 and insert operation is failing.
July 15, 2005 05:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.