MYSQL Insert Error handling

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
theclay7
Forum Commoner
Posts: 50
Joined: Wed Feb 19, 2003 3:17 am

MYSQL Insert Error handling

Post 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:
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Could we see the code you are using to insert the row?

Mac
User avatar
BDKR
DevNet Resident
Posts: 1207
Joined: Sat Jun 08, 2002 1:24 pm
Location: Florida
Contact:

Post 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
Post Reply