exception occurred in researchr

exception during execution of action
org.hibernate.exception.GenericJDBCException: could not update: [org.researchr.www.domain.User#d9e3249b-c411-4ac5-ba6d-c5fcf9509cde]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2596)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2478)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2805)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:114)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:268)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:260)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:180)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1206)
at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:344)
at $Proxy58.flush(Unknown Source)
at org.researchr.www.beans.addAuthorForPublication_identifyPersonAction0StringStringStringStringURLAbstractAuthorPublication_Template$1.addAuthorForPublication_identifyPersonAction0_addAuthor1(addAuthorForPublication_identifyPersonAction0StringStringStringStringURLAbstractAuthorPublication_Template.java:662)
at org.researchr.www.beans.addAuthorForPublication_identifyPersonAction0StringStringStringStringURLAbstractAuthorPublication_Template.handleActionsInternal(addAuthorForPublication_identifyPersonAction0StringStringStringStringURLAbstractAuthorPublication_Template.java:536)
at utils.TemplateServlet.handleActions(TemplateServlet.java:51)
at org.researchr.www.beans.identifyPersonStringStringStringString_Template.handleActionsInternal(identifyPersonStringStringStringString_Template.java:3222)
at utils.TemplateServlet.handleActions(TemplateServlet.java:51)
at org.researchr.www.beans.identifyAliasAlias_Template.handleActionsInternal(identifyAliasAlias_Template.java:492)
at utils.TemplateServlet.handleActions(TemplateServlet.java:51)
at org.researchr.www.beans.addAuthorForPublicationPublicationAbstractAuthor_Template.handleActionsInternal(addAuthorForPublicationPublicationAbstractAuthor_Template.java:365)
at utils.TemplateServlet.handleActions(TemplateServlet.java:51)
at org.researchr.www.beans.resolveAuthorPublicationAbstractAuthor_Template.handleActionsInternal(resolveAuthorPublicationAbstractAuthor_Template.java:587)
at utils.TemplateServlet.handleActions(TemplateServlet.java:51)
at org.researchr.www.beans.showAuthorPublicationAbstractAuthor_Template.handleActionsInternal(showAuthorPublicationAbstractAuthor_Template.java:896)
at utils.TemplateServlet.handleActions(TemplateServlet.java:51)
at org.researchr.www.beans.showAuthorsPublication_Template.handleActionsInternal(showAuthorsPublication_Template.java:537)
at utils.TemplateServlet.handleActions(TemplateServlet.java:51)
at org.researchr.www.beans.publicationAuthorsPublication_Template.handleActionsInternal(publicationAuthorsPublication_Template.java:484)
at utils.TemplateServlet.handleActions(TemplateServlet.java:51)
at org.researchr.www.beans.publication_localBody0StringStringPublication_Template.handleActionsInternal(publication_localBody0StringStringPublication_Template.java:2173)
at utils.TemplateServlet.handleActions(TemplateServlet.java:51)
at org.researchr.www.beans.localMenuPage_body0_Template.handleActionsInternal(localMenuPage_body0_Template.java:774)
at utils.TemplateServlet.handleActions(TemplateServlet.java:51)
at org.researchr.www.beans.main_Template.handleActionsInternal(main_Template.java:556)
at utils.TemplateServlet.handleActions(TemplateServlet.java:51)
at org.researchr.www.beans.localMenuPage_Template.handleActionsInternal(localMenuPage_Template.java:240)
at utils.TemplateServlet.handleActions(TemplateServlet.java:51)
at org.researchr.www.beans.publicationPagePublicationStringString_Template.handleActionsInternal(publicationPagePublicationStringString_Template.java:286)
at utils.TemplateServlet.handleActions(TemplateServlet.java:51)
at org.researchr.www.beans.publication_Template.handleActionsInternal(publication_Template.java:356)
at utils.TemplateServlet.handleActions(TemplateServlet.java:51)
at org.researchr.www.beans.PublicationPage.serve(PublicationPage.java:100)
at utils.DispatchServletHelper.handlePage(DispatchServletHelper.java:905)
at utils.DispatchServletHelper.doServe(DispatchServletHelper.java:862)
at utils.DispatchServlet.doPost(DispatchServlet.java:162)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2578)
… 65 more

Submitted by Eelco Visser on 2 October 2010 at 20:45

This may be hard to debug: The transaction throwing the exception was waiting for another transaction to finish. Hence it is the ‘other’ transaction which is the root cause of the exception. The exception unfortunately does not give any information on any other transactions. It may have been caused by a slow query. Perhaps more information from webdsl (e.g. which requests are being processed) can help solve locking issues in future.