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 moreSubmitted by Eelco Visser on 2 October 2010 at 20:45

On 4 October 2010 at 11:04 Sander Vermolen commented:

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.

Log in to post comments