Lock wait timeout exceeded; try restarting transaction even in single db single user

[newtomysql]

Dear All,
I am updating few databases all which I keep as one transaction using .net connector. The best part is that I can still run into this error of "Lock wait timeout exceeded; try restarting transaction" even though I am the only single soul using my database at that time. Any idea how to over come this problem. Thanks.

[csgeek]

take a look at this bug report; All the way at the bottom, last two posts are pretty insightful.

http://bugs.mysql.com/bug.php?id=10641

[sajisathian]

We also come across same problem and solved by freeing the sql connection which was utilized in previous queries.So there won't be any mistakes with your current queries and code.But you have to free the connections after usage for reusing them from the connection pool(Guess you are using one either directly or indirectly).

Thanks and Regards,
Saji T Sathian

[sajisathian]

If still problems exist Debug your SQL Server