Re: Lock wait timeout exceeded; try restarting transaction

[shiva kumar]

I solved this problem in the following way.

the table which your are going to insert or update is used by other application
for ex : I have used hibernate in my web application(tomcat), where I am executing the query and not committing the hibernate session, so the table is still accessing by web application. I restarted my web server.

It works fine for me.

So, you need to identify the application which is accessing the table and stop those application.

Thank you,

Shiva Kumar p