MySQL Forums
Forum List  »  InnoDB

Lock wait timeout exceeded; try restarting transaction
Posted by: Sunil Kulkarni
Date: March 18, 2010 06:20AM

Hi,

I am using MySQL 5.0 , EJB 3.0 and seam framework for my web application.

I am doing the transaction using EJB transactions.
This transaction is only reads one MySQL table.

When I started 2 transaction in parallel, application is throwing an exception as

11:08:55,296 ERROR [JDBCExceptionReporter] Lock wait timeout exceeded; try restarting transaction
11:08:55,327 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
...


Please help me on that.
Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Lock wait timeout exceeded; try restarting transaction
7884
March 18, 2010 06:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.