Page 1 of 1

MYSQL Insert Error handling

Posted: Wed Feb 19, 2003 9:30 pm
by theclay7
I tried to insert a row into a table in MySQL and it gave me the following error? WHY and WHAT should I do?

ERROR 1205: Lock wait timeout exceeded; Try restarting transaction
:lol:

Posted: Fri Feb 21, 2003 2:51 am
by twigletmac
Could we see the code you are using to insert the row?

Mac

Posted: Fri Feb 21, 2003 1:49 pm
by BDKR
It sounds like something is else failing to unlock a table. It's obviously a write lock as your insert fails. Are you using table locking, transactions? Check the manual concerning these things. The risk with table locks is that if they are not released, things come grinding to a halt. 8O

Cheers,
BDKR