Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2015-04-10 13:57:34,090 [qtp407541736-181] u:admin/d: INFO org.kuali.rice.krad.service.impl.DocumentServiceImpl - storing document 3598
- [EL Warning]: 2015-04-10 13:58:25.759--UnitOfWork(1713971778)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
- Internal Exception: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
- Error Code: 1205
- Call: SELECT DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR FROM KREW_DOC_HDR_T WHERE (DOC_HDR_ID = ?) FOR UPDATE
- bind => [1 parameter bound]
- Query: ReadObjectQuery(name="readDocumentRouteHeaderValue" referenceClass=DocumentRouteHeaderValue sql="SELECT DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR FROM KREW_DOC_HDR_T WHERE (DOC_HDR_ID = ?) FOR UPDATE")
- 2015-04-10 13:58:25,791 [qtp407541736-181] u:admin/d: FATAL org.kuali.rice.core.framework.persistence.jta.KualiTransactionInterceptor - Exception caught by Transaction Interceptor, this will cause a rollback at the end of the transaction.
- javax.persistence.PessimisticLockException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
- Internal Exception: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
- Error Code: 1205
- Call: SELECT DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR FROM KREW_DOC_HDR_T WHERE (DOC_HDR_ID = ?) FOR UPDATE
- bind => [1 parameter bound]
- Query: ReadObjectQuery(name="readDocumentRouteHeaderValue" referenceClass=DocumentRouteHeaderValue sql="SELECT DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR FROM KREW_DOC_HDR_T WHERE (DOC_HDR_ID = ?) FOR UPDATE")
- at org.eclipse.persistence.internal.jpa.EntityManagerImpl.executeQuery(EntityManagerImpl.java:912)
- at org.eclipse.persistence.internal.jpa.EntityManagerImpl.findInternal(EntityManagerImpl.java:843)
- at org.eclipse.persistence.internal.jpa.EntityManagerImpl.find(EntityManagerImpl.java:719)
- at sun.reflect.GeneratedMethodAccessor1430.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:606)
- at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:366)
- at com.sun.proxy.$Proxy44.find(Unknown Source)
- at sun.reflect.GeneratedMethodAccessor1430.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:606)
- at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:241)
- at com.sun.proxy.$Proxy44.find(Unknown Source)
- at org.kuali.rice.kew.routeheader.dao.impl.DocumentRouteHeaderDAOJpa.lockRouteHeader(DocumentRouteHeaderDAOJpa.java:107)
- at org.kuali.rice.kew.routeheader.service.impl.RouteHeaderServiceImpl.lockRouteHeader(RouteHeaderServiceImpl.java:90)
- at sun.reflect.GeneratedMethodAccessor1635.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:606)
- at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
- at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
- at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
- at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
- at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
- at com.sun.proxy.$Proxy179.lockRouteHeader(Unknown Source)
- at org.kuali.rice.kew.impl.action.WorkflowDocumentActionsServiceImpl.init(WorkflowDocumentActionsServiceImpl.java:225)
- at org.kuali.rice.kew.impl.action.WorkflowDocumentActionsServiceImpl.executeActionInternal(WorkflowDocumentActionsServiceImpl.java:1385)
- at org.kuali.rice.kew.impl.action.WorkflowDocumentActionsServiceImpl.approve(WorkflowDocumentActionsServiceImpl.java:424)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:606)
- at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
- at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
- at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
- at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
- at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
- at com.sun.proxy.$Proxy166.approve(Unknown Source)
- at org.kuali.rice.kew.impl.document.WorkflowDocumentImpl.approve(WorkflowDocumentImpl.java:345)
- at org.kuali.rice.krad.workflow.service.impl.WorkflowDocumentServiceImpl.approve(WorkflowDocumentServiceImpl.java:150)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:606)
- at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
- at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
- at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
- at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
- at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
- at com.sun.proxy.$Proxy102.approve(Unknown Source)
- at org.kuali.rice.krad.service.impl.DocumentServiceImpl.approveDocument(DocumentServiceImpl.java:244)
- at org.kuali.rice.kns.web.struts.action.KualiDocumentActionBase.approve(KualiDocumentActionBase.java:898)
- at org.kuali.coeus.common.budget.impl.struts.BudgetActionsAction.approve(BudgetActionsAction.java:509)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:606)
- at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
- at org.kuali.rice.kns.web.struts.action.KualiAction.dispatchMethod(KualiAction.java:173)
- at org.kuali.coeus.sys.framework.controller.KcTransactionalDocumentActionBase.dispatchMethod(KcTransactionalDocumentActionBase.java:165)
- at org.kuali.rice.kns.web.struts.action.KualiAction.execute(KualiAction.java:131)
- at org.kuali.rice.kns.web.struts.action.KualiDocumentActionBase.execute(KualiDocumentActionBase.java:181)
- at org.kuali.coeus.sys.framework.controller.KcTransactionalDocumentActionBase.execute(KcTransactionalDocumentActionBase.java:144)
- at org.kuali.coeus.common.budget.impl.struts.BudgetAction.execute(BudgetAction.java:189)
- at org.kuali.coeus.common.budget.impl.struts.BudgetActionsAction.execute(BudgetActionsAction.java:138)
- at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor$1.doInTransaction(KualiRequestProcessor.java:508)
- at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)
- at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processActionPerform(KualiRequestProcessor.java:504)
- at org.kuali.coeus.sys.framework.controller.interceptor.KcRequestProcessor.processActionPerform(KcRequestProcessor.java:73)
- at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processFormActionAndForward(KualiRequestProcessor.java:233)
- at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.strutsProcess(KualiRequestProcessor.java:220)
- at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.process(KualiRequestProcessor.java:99)
- at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
- at org.kuali.rice.kns.web.struts.action.KualiActionServlet.process(KualiActionServlet.java:202)
- at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
- at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:696)
- at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1515)
- at org.kuali.coeus.sys.framework.controller.interceptor.RequestLoggingFilter.doFilter(RequestLoggingFilter.java:92)
- at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1503)
- at org.kuali.rice.kew.web.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:78)
- at org.kuali.rice.kew.web.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:62)
- at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1503)
- at org.kuali.rice.krad.web.filter.UserLoginFilter.doFilter(UserLoginFilter.java:89)
- at org.kuali.rice.krad.web.filter.UserLoginFilter.doFilter(UserLoginFilter.java:77)
- at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1503)
- at org.kuali.rice.krad.web.filter.BootstrapFilterChain.doFilter(BootstrapFilter.java:327)
- at org.kuali.rice.krad.web.filter.DummyLoginFilter.doFilter(DummyLoginFilter.java:82)
- at org.kuali.rice.krad.web.filter.DummyLoginFilter.doFilter(DummyLoginFilter.java:62)
- at org.kuali.rice.krad.web.filter.BootstrapFilterChain.doFilter(BootstrapFilter.java:320)
- at org.kuali.rice.krad.web.filter.BootstrapFilter.doFilter(BootstrapFilter.java:199)
- at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1503)
- at org.kuali.coeus.sys.framework.controller.interceptor.PerformanceLoggingFilter.doFilter(PerformanceLoggingFilter.java:66)
- at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1503)
- at org.kuali.coeus.sys.framework.controller.interceptor.SessionExpiredFilter.doFilter(SessionExpiredFilter.java:46)
- at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1503)
- at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
- at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1503)
- at org.kuali.rice.krad.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:68)
- at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1503)
- at org.springframework.web.filter.AbstractRequestLoggingFilter.doFilterInternal(AbstractRequestLoggingFilter.java:214)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
- at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1495)
- at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:519)
- at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:138)
- at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:564)
- at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:213)
- at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1097)
- at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:448)
- at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:175)
- at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1031)
- at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:136)
- at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:200)
- at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109)
- at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
- at org.eclipse.jetty.server.Server.handle(Server.java:446)
- at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:271)
- at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:246)
- at org.eclipse.jetty.io.AbstractConnection$ReadCallback.run(AbstractConnection.java:358)
- at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:601)
- at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:532)
- at java.lang.Thread.run(Thread.java:745)
- Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
- Internal Exception: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
- Error Code: 1205
- Call: SELECT DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR FROM KREW_DOC_HDR_T WHERE (DOC_HDR_ID = ?) FOR UPDATE
- bind => [1 parameter bound]
- Query: ReadObjectQuery(name="readDocumentRouteHeaderValue" referenceClass=DocumentRouteHeaderValue sql="SELECT DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR FROM KREW_DOC_HDR_T WHERE (DOC_HDR_ID = ?) FOR UPDATE")
- at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
- at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:682)
- at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558)
- at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2002)
- at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:298)
- at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
- at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
- at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectOneRow(DatasourceCallQueryMechanism.java:714)
- at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRowFromTable(ExpressionQueryMechanism.java:2801)
- at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRow(ExpressionQueryMechanism.java:2754)
- at org.eclipse.persistence.queries.ReadObjectQuery.executeObjectLevelReadQuery(ReadObjectQuery.java:545)
- at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1168)
- at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899)
- at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1127)
- at org.eclipse.persistence.queries.ReadObjectQuery.execute(ReadObjectQuery.java:431)
- at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1215)
- at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
- at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
- at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1786)
- at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1737)
- at org.eclipse.persistence.internal.jpa.EntityManagerImpl.executeQuery(EntityManagerImpl.java:900)
- ... 130 more
- Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
- at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
- at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
- at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2840)
- at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
- at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2212)
- at org.enhydra.jdbc.core.CorePreparedStatement.executeQuery(CorePreparedStatement.java:92)
- at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1007)
- at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:642)
- ... 149 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement