Lock wait timeout exceeded; try restarting transaction

[crs27]

Hai,

I have a simple query fired on click of a button.
i.e., update table_name set column1='20' , column2='15' where id='1';

Even through the query browser it is giving
Lock wait timeout exceeded; try restarting transaction ,this exception.

The same was working a couple of days before.
what might be the reason for this exception.

Thanks in advance

[r035198x]

Just a simple query? Is it part of a large transaction? What version are you using? You could try increasing the TransactionDeadlockDetectionTimeout but I'd like to hear the answers to these questions first.

[crs27]

Yes, it is a part of a transaction.But what i wonder is even if i execute the same query in Mysql Query Browser also it is giving the same exception.
Im using Mysql 5.1
Query Browser MySql Query Browser 1.2.12

[r035198x]

Increase that TransactionDeadlockDetectionTimeout. More importanlty though, how long is the transaction and is it possible to break it down to smaller transactions?
About the failure in the query browser, I think you may have to restart the server for the error to go away (not sure about that one though).

P.S How much data is in the table and why is the id text instead of one of the more common numeric types?