13:46:26,498 WARN [org.hibernate.util.JDBCExceptionReporter] [ODEServer-2] SQL Error: 30000, SQLState: 40001 13:49:04,013 ERROR [org.apache.ode.bpel.runtime.INVOKE] [ODEServer-9] Failure during invoke: Dangling invocation (mexId=6094850), forcing it into a failed state. 13:48:05,763 ERROR [org.apache.ode.axis2.ODEService] [DefaultThreadPool 458] Timeout or execution error when waiting for response to MEX {MyRoleMex#6094851 [Client 9e67a4e6-68dc-420f-be62-5375966fb4a4-1] calling {http://www.intalio.com/bpms/workflow/ib4p_20051115}UserBusinessProcessService.createTask(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@197c173 timed out when waiting for a response! 13:47:05,576 ERROR [org.apache.ode.axis2.SoapExternalService] [ODEServer-4] Error sending message (mex={PartnerRoleMex#6094850 [PID {http://example.com/ControlExchangesDNB_loop/BPMLAYER}BPMLAYER-59] calling
(...)}): Read timed out org.apache.axis2.AxisFault: Read timed out at org.apache.axis2.AxisFault.makeFault(AxisFault.java:417) at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:195) at org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:77) at org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:327) at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:206) at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:396) at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:374) at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:211) at org.apache.axis2.client.OperationClient.execute(OperationClient.java:163) at org.apache.ode.axis2.SoapExternalService$1$1.call(SoapExternalService.java:162) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) at java.lang.Thread.run(Thread.java:619) Caused by: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.BufferedInputStream.fill(BufferedInputStream.java:218) at java.io.BufferedInputStream.read(BufferedInputStream.java:237) at org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:77) at org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:105) at org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1115) at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1373) at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1832) at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1590) at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:995) at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:397) at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:346) at org.apache.axis2.transport.http.AbstractHTTPSender.executeMethod(AbstractHTTPSender.java:520) at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:191) ... 13 more 13:49:47,466 ERROR [org.hibernate.util.JDBCExceptionReporter] [ODEServer-2] A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, BPEL_CORRELATION_SET, (2,23) Waiting XID : {162115, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=? Granted XID : {162118, X} Lock : ROW, BPEL_CORRELATION_SET, (2,24) Waiting XID : {162118, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=? Granted XID : {162115, X} . The selected victim is XID : 162115. 13:49:48,357 ERROR [org.apache.ode.jacob.vpu.JacobVPU] [ODEServer-2] Method "run" in class "org.apache.ode.bpel.runtime.REPLY" threw an unexpected exception. org.hibernate.exception.LockAcquisitionException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:82) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2223) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.apache.ode.daohib.bpel.ScopeDaoImpl.getCorrelationSet(ScopeDaoImpl.java:75) at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.writeCorrelation(BpelRuntimeContextImpl.java:572) at org.apache.ode.bpel.runtime.BpelJacobRunnable.initializeCorrelation(BpelJacobRunnable.java:101) at org.apache.ode.bpel.runtime.REPLY.run(REPLY.java:59) at sun.reflect.GeneratedMethodAccessor263.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:451) at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139) at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntimeContextImpl.java:848) at org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.invokeNewInstance(PartnerLinkMyRoleImpl.java:197) at org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:199) at org.apache.ode.bpel.engine.BpelProcess.handleWorkEvent(BpelProcess.java:367) at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:331) at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:373) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:337) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:336) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:174) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) at java.lang.Thread.run(Thread.java:619) Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, BPEL_CORRELATION_SET, (2,23) Waiting XID : {162115, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=? Granted XID : {162118, X} Lock : ROW, BPEL_CORRELATION_SET, (2,24) Waiting XID : {162118, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=? Granted XID : {162115, X} . The selected victim is XID : 162115. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source) at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source) at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source) at org.tranql.connector.jdbc.ResultSetHandle.next(ResultSetHandle.java:791) at org.hibernate.loader.Loader.doQuery(Loader.java:697) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2220) ... 32 more Caused by: java.sql.SQLException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, BPEL_CORRELATION_SET, (2,23) Waiting XID : {162115, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=? Granted XID : {162118, X} Lock : ROW, BPEL_CORRELATION_SET, (2,24) Waiting XID : {162118, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=? Granted XID : {162115, X} . The selected victim is XID : 162115. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 45 more 13:49:48,388 ERROR [org.intalio.tempo.workflow.fds.core.UserProcessMessageConvertor] [DefaultThreadPool 453] Fault in response: <?xml version="1.0" encoding="UTF-8"?> <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><soapenv:Fault xmlns:axis2ns1="http://incubator.apache.org/ode"><faultcode>axis2ns1:Fault</faultcode><faultstring>Timeout or execution error when waiting for response to MEX {MyRoleMex#6094851 [Client 9e67a4e6-68dc-420f-be62-5375966fb4a4-1] calling {http://www.intalio.com/bpms/workflow/ib4p_20051115}UserBusinessProcessService.createTask(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@197c173 timed out when waiting for a response!</faultstring><detail><Exception>org.apache.ode.axis2.OdeFault: Timeout or execution error when waiting for response to MEX {MyRoleMex#6094851 [Client 9e67a4e6-68dc-420f-be62-5375966fb4a4-1] calling {http://www.intalio.com/bpms/workflow/ib4p_20051115}UserBusinessProcessService.createTask(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@197c173 timed out when waiting for a response! at org.apache.ode.axis2.ODEService.onAxisMessageExchange(ODEService.java:154) at org.apache.ode.axis2.hooks.ODEMessageReceiver.invokeBusinessLogic(ODEMessageReceiver.java:67) at org.apache.ode.axis2.hooks.ODEMessageReceiver.invokeBusinessLogic(ODEMessageReceiver.java:50) at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:96) at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:145) at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275) at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:120) at javax.servlet.http.HttpServlet.service(HttpServlet.java:713) at javax.servlet.http.HttpServlet.service(HttpServlet.java:806) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487) at org.apache.geronimo.jetty6.InternalJettyServletHolder.handle(InternalJettyServletHolder.java:65) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:362) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.apache.geronimo.jetty6.handler.ThreadClassloaderHandler.handle(ThreadClassloaderHandler.java:46) at org.apache.geronimo.jetty6.handler.InstanceContextHandler.handle(InstanceContextHandler.java:58) at org.apache.geronimo.jetty6.handler.UserTransactionHandler.handle(UserTransactionHandler.java:48) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405) at org.apache.geronimo.jetty6.handler.ComponentContextHandler.handle(ComponentContextHandler.java:47) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:211) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139) at org.mortbay.jetty.Server.handle(Server.java:313) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:506) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:844) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:644) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:396) at org.apache.geronimo.pool.ThreadPool$1.run(ThreadPool.java:201) at org.apache.geronimo.pool.ThreadPool$ContextClassLoaderRunnable.run(ThreadPool.java:331) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) at java.lang.Thread.run(Thread.java:619) </Exception></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope> 13:49:48,670 ERROR [org.apache.ode.bpel.engine.BpelEngineImpl] [ODEServer-2] Scheduled job failed; jobDetail={mexid=6094851, pid={http://example.com/TMP/TaskManagementProcess}TaskManagementProcess-3, type=INVOKE_INTERNAL} java.lang.RuntimeException: org.hibernate.exception.LockAcquisitionException: could not execute query at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:464) at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139) at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntimeContextImpl.java:848) at org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.invokeNewInstance(PartnerLinkMyRoleImpl.java:197) at org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:199) at org.apache.ode.bpel.engine.BpelProcess.handleWorkEvent(BpelProcess.java:367) at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:331) at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:373) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:337) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:336) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:174) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) at java.lang.Thread.run(Thread.java:619) Caused by: org.hibernate.exception.LockAcquisitionException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:82) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2223) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.apache.ode.daohib.bpel.ScopeDaoImpl.getCorrelationSet(ScopeDaoImpl.java:75) at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.writeCorrelation(BpelRuntimeContextImpl.java:572) at org.apache.ode.bpel.runtime.BpelJacobRunnable.initializeCorrelation(BpelJacobRunnable.java:101) at org.apache.ode.bpel.runtime.REPLY.run(REPLY.java:59) at sun.reflect.GeneratedMethodAccessor263.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:451) ... 17 more Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, BPEL_CORRELATION_SET, (2,23) Waiting XID : {162115, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=? Granted XID : {162118, X} Lock : ROW, BPEL_CORRELATION_SET, (2,24) Waiting XID : {162118, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=? Granted XID : {162115, X} . The selected victim is XID : 162115. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source) at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source) at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source) at org.tranql.connector.jdbc.ResultSetHandle.next(ResultSetHandle.java:791) at org.hibernate.loader.Loader.doQuery(Loader.java:697) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2220) ... 32 more Caused by: java.sql.SQLException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, BPEL_CORRELATION_SET, (2,23) Waiting XID : {162115, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=? Granted XID : {162118, X} Lock : ROW, BPEL_CORRELATION_SET, (2,24) Waiting XID : {162118, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=? Granted XID : {162115, X} . The selected victim is XID : 162115. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 45 more 13:49:49,263 WARN [Transaction] [ODEServer-2] Error ending association for XAResource org.apache.geronimo.transaction.manager.WrapperNamedXAResource@1ce2c0c; transaction will roll back. XA error code: 102 javax.transaction.xa.XAException at org.apache.derby.jdbc.EmbedXAResource.end(Unknown Source) at org.apache.geronimo.transaction.manager.WrapperNamedXAResource.end(WrapperNamedXAResource.java:51) at org.apache.geronimo.transaction.manager.TransactionImpl.endResources(TransactionImpl.java:563) at org.apache.geronimo.transaction.manager.TransactionImpl.endResources(TransactionImpl.java:542) at org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:473) at org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:250) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:183) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) at java.lang.Thread.run(Thread.java:619) 13:49:49,341 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] [ODEServer-2] Error while processing transaction, retrying. org.apache.ode.bpel.iapi.Scheduler$JobProcessorException: java.lang.RuntimeException: org.hibernate.exception.LockAcquisitionException: could not execute query at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:341) at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:373) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:337) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:336) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:174) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) at java.lang.Thread.run(Thread.java:619) Caused by: java.lang.RuntimeException: org.hibernate.exception.LockAcquisitionException: could not execute query at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:464) at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139) at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntimeContextImpl.java:848) at org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.invokeNewInstance(PartnerLinkMyRoleImpl.java:197) at org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:199) at org.apache.ode.bpel.engine.BpelProcess.handleWorkEvent(BpelProcess.java:367) at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:331) ... 11 more Caused by: org.hibernate.exception.LockAcquisitionException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:82) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2223) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.apache.ode.daohib.bpel.ScopeDaoImpl.getCorrelationSet(ScopeDaoImpl.java:75) at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.writeCorrelation(BpelRuntimeContextImpl.java:572) at org.apache.ode.bpel.runtime.BpelJacobRunnable.initializeCorrelation(BpelJacobRunnable.java:101) at org.apache.ode.bpel.runtime.REPLY.run(REPLY.java:59) at sun.reflect.GeneratedMethodAccessor263.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:451) ... 17 more Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, BPEL_CORRELATION_SET, (2,23) Waiting XID : {162115, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=? Granted XID : {162118, X} Lock : ROW, BPEL_CORRELATION_SET, (2,24) Waiting XID : {162118, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=? Granted XID : {162115, X} . The selected victim is XID : 162115. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source) at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source) at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source) at org.tranql.connector.jdbc.ResultSetHandle.next(ResultSetHandle.java:791) at org.hibernate.loader.Loader.doQuery(Loader.java:697) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2220) ... 32 more Caused by: java.sql.SQLException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, BPEL_CORRELATION_SET, (2,23) Waiting XID : {162115, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=? Granted XID : {162118, X} Lock : ROW, BPEL_CORRELATION_SET, (2,24) Waiting XID : {162118, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=? Granted XID : {162115, X} . The selected victim is XID : 162115. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 45 more
The problem comes from ODE + Derby. Derby doesn't have a transaction engine like InnoDB for Mysql, and ODE does parallel processing, so that ends up in deadlocks. ODE could be handling this in a better way, but that requires some work.
In the mean time, you need to move away from Derby and use Mysql. All instructions related to the change of database are available in the reference guides of the help section.
I did all the step required for installation on MySQL (creation of DB etc etc) and I'm getting this message (underneath)
Is this an error or just a warning?
Thanks a lot for your help. Regards jose ================ // ========================
C:\Intalio\intalio_server_bpms_5_2_0_050\bin>deploy.bat --offline redeploy ..\repository\org\tranql\tranql-connector-ra\1.3\tranql-connector-ra-1 .3.rar ..\databases\MySQL\geronimo-ds.xml Using GERONIMO_BASE: C:\Intalio\intalio_server_bpms_5_2_0_050 Using GERONIMO_HOME: C:\Intalio\intalio_server_bpms_5_2_0_050 Using GERONIMO_TMPDIR: var\temp Using JRE_HOME: C:\Program Files\Java\jdk1.6.0_04\jre No ModuleID or TargetModuleID provided. Attempting to guess based on the content of the plan. Attempting to use ModuleID 'com.intalio.bpms/BPMSDS/1.0/rar' 10:29:17,038 WARN [ConnectorPlanRectifier] Your connector plan has obsolete elements or attributes in it. Please remove version attributes, glo bal-jndi-name elements, and credential-interface elements Uninstalled com.intalio.bpms/BPMSDS/1.0/rar Deployed com.intalio.bpms/BPMSDS/1.0/rar Started com.intalio.bpms/BPMSDS/1.0/rar Redeployed com.intalio.bpms/BPMSDS/1.0/rar [] received stop signal
These are just warning messages, your server is successfully configured with MySQ now you can start your server and execute the processes successfully.
FORUMS 
Post Reply
Favoured: 0
Post Reply
