Hi Nandika
After updates to bps.xml and datasource.properties I still get same errors
on the BPS cluster. My TPS is 2.5
Are there any additional changes for performance improvements
Worker 1
TID: [0] [BPS] [2014-12-09 06:07:45,210] ERROR
{org.wso2.carbon.bpel.core.ode.integration.BPELProcessProxy} - Timeout or
execution error when waiting for response to MEX
{MyRoleMex#hqejbhcnphr9tmcvrogb33 [Client null] calling null.null(...)}
java.util.concurrent.TimeoutException: Message exchange
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@3943d385
timed out(120000 ms) when waiting for a response!
{org.wso2.carbon.bpel.core.ode.integration.BPELProcessProxy}
java.util.concurrent.TimeoutException: Message exchange
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@3943d385
timed out(120000 ms) when waiting for a response!
at
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture.get(MyRoleMessageExchangeImpl.java:274)
at
org.wso2.carbon.bpel.core.ode.integration.BPELProcessProxy.waitForTheResponse(BPELProcessProxy.java:359)
at
org.wso2.carbon.bpel.core.ode.integration.BPELProcessProxy.onAxisServiceInvoke(BPELProcessProxy.java:170)
at
org.wso2.carbon.bpel.core.ode.integration.axis2.receivers.BPELMessageReceiver.handleInOutOperation(BPELMessageReceiver.java:156)
at
org.wso2.carbon.bpel.core.ode.integration.axis2.receivers.BPELMessageReceiver.invokeBusinessLogic(BPELMessageReceiver.java:129)
at
org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:110)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180)
at
org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:172)
at
org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:146)
at
org.wso2.carbon.core.transports.CarbonServlet.doPost(CarbonServlet.java:231)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at
org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
at
org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128)
at
org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at
org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.wso2.carbon.tomcat.ext.filter.CharacterSetFilter.doFilter(CharacterSetFilter.java:61)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at
org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(CompositeValve.java:178)
at
org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:49)
at
org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:141)
at
org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:156)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
at
org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:52)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdaphttp://
www.ramadbk.com/ter.java:407)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1653)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
-------------------------------------------------------
Worker 2
TID: [0] [BPS] [2014-12-09 06:12:19,342] ERROR
{org.apache.ode.scheduler.simple.SimpleScheduler} - Error while processing
a persisted job: Job hqejbhcnphr9tmcxgfbvia time: 2014-12-09 06:03:51 UTC
transacted: true persisted: true details: JobDetails( instanceId: null
mexId: hqejbhcnphr9tmcxgfbvi8 processId: {
http://ode/bpel/unit-test}HelloWorld2-64 type: INVOKE_INTERNAL channel:
null correlatorId: null correlationKeySet: null retryCount: null inMem:
false detailsExt: {}) {org.apache.ode.scheduler.simple.SimpleScheduler}
org.apache.ode.scheduler.simple.DatabaseException:
org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060: deadlock
detected while waiting for resource
{prepstmnt 325238093 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:186)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:533)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:280)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:235)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:514)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060:
deadlock detected while waiting for resource
{prepstmnt 325238093 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:223)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1162)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1741)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:184)
... 10 more
TID: [0] [BPS] [2014-12-09 06:12:21,780] ERROR
{org.apache.ode.scheduler.simple.SimpleScheduler} - Error while processing
a persisted job: Job hqejbhcnphr9tmcxgfbvkm time: 2014-12-09 06:03:52 UTC
transacted: true persisted: true details: JobDetails( instanceId: null
mexId: hqejbhcnphr9tmcxgfbvkl processId: {
http://ode/bpel/unit-test}HelloWorld2-64 type: INVOKE_INTERNAL channel:
null correlatorId: null correlationKeySet: null retryCount: null inMem:
false detailsExt: {}) {org.apache.ode.scheduler.simple.SimpleScheduler}
org.apache.ode.scheduler.simple.DatabaseException:
org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060: deadlock
detected while waiting for resource
{prepstmnt 801272104 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:186)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:533)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:280)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:235)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:514)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060:
deadlock detected while waiting for resource
{prepstmnt 801272104 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:223)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1162)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1741)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:184)
... 10 more
TID: [0] [BPS] [2014-12-09 06:13:05,738] ERROR
{org.apache.ode.scheduler.simple.SimpleScheduler} - Error while processing
a persisted job: Job hqejbhcnphr9tmcxgfbvkt time: 2014-12-09 06:03:52 UTC
transacted: true persisted: true details: JobDetails( instanceId: null
mexId: hqejbhcnphr9tmcxgfbvks processId: {
http://ode/bpel/unit-test}HelloWorld2-64 type: INVOKE_INTERNAL channel:
null correlatorId: null correlationKeySet: null retryCount: null inMem:
false detailsExt: {}) {org.apache.ode.scheduler.simple.SimpleScheduler}
org.apache.ode.scheduler.simple.DatabaseException:
org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060: deadlock
detected while waiting for resource
{prepstmnt 546776892 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:186)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:533)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:280)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:235)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:514)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060:
deadlock detected while waiting for resource
{prepstmnt 546776892 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:223)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1162)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1741)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:184)
... 10 more
TID: [0] [BPS] [2014-12-09 06:13:14,293] ERROR
{org.apache.ode.scheduler.simple.SimpleScheduler} - Error while processing
a persisted job: Job hqejbhcnphr9tmcxgfbvn9 time: 2014-12-09 06:03:52 UTC
transacted: true persisted: true details: JobDetails( instanceId: null
mexId: hqejbhcnphr9tmcxgfbvn8 processId: {
http://ode/bpel/unit-test}HelloWorld2-64 type: INVOKE_INTERNAL channel:
null correlatorId: null correlationKeySet: null retryCount: null inMem:
false detailsExt: {}) {org.apache.ode.scheduler.simple.SimpleScheduler}
org.apache.ode.scheduler.simple.DatabaseException:
org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060: deadlock
detected while waiting for resource
{prepstmnt 1437012220 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:186)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:533)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:280)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:235)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:514)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060:
deadlock detected while waiting for resource
{prepstmnt 1437012220 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:223)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1162)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1741)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:184)
... 10 more
TID: [0] [BPS] [2014-12-09 06:13:41,420] ERROR
{org.apache.ode.scheduler.simple.SimpleScheduler} - Error while processing
a persisted job: Job hqejbhcnphr9tmcxgfbvn0 time: 2014-12-09 06:03:52 UTC
transacted: true persisted: true details: JobDetails( instanceId: null
mexId: hqejbhcnphr9tmcxgfbvmw processId: {
http://ode/bpel/unit-test}HelloWorld2-64 type: INVOKE_INTERNAL channel:
null correlatorId: null correlationKeySet: null retryCount: null inMem:
false detailsExt: {}) {org.apache.ode.scheduler.simple.SimpleScheduler}
org.apache.ode.scheduler.simple.DatabaseException:
org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060: deadlock
detected while waiting for resource
{prepstmnt 659279647 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:186)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:533)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:280)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:235)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:514)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060:
deadlock detected while waiting for resource
{prepstmnt 659279647 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:223)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1162)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1741)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:184)
... 10 more
TID: [0] [BPS] [2014-12-09 06:13:46,221] ERROR
{org.apache.ode.scheduler.simple.SimpleScheduler} - Error while processing
a persisted job: Job hqejbhcnphr9tmcxgfbvni time: 2014-12-09 06:03:52 UTC
transacted: true persisted: true details: JobDetails( instanceId: null
mexId: hqejbhcnphr9tmcxgfbvng processId: {
http://ode/bpel/unit-test}HelloWorld2-64 type: INVOKE_INTERNAL channel:
null correlatorId: null correlationKeySet: null retryCount: null inMem:
false detailsExt: {}) {org.apache.ode.scheduler.simple.SimpleScheduler}
org.apache.ode.scheduler.simple.DatabaseException:
org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060: deadlock
detected while waiting for resource
{prepstmnt 1392278963 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:186)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:533)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:280)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:235)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:514)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060:
deadlock detected while waiting for resource
{prepstmnt 1392278963 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:223)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1162)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1741)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:184)
... 10 more
TID: [0] [BPS] [2014-12-09 06:14:36,808] ERROR
{org.apache.ode.scheduler.simple.SimpleScheduler} - Error while processing
a persisted job: Job hqejbhcnphr9tmcxgfbvob time: 2014-12-09 06:03:52 UTC
transacted: true persisted: true details: JobDetails( instanceId: null
mexId: hqejbhcnphr9tmcxgfbvoa processId: {
http://ode/bpel/unit-test}HelloWorld2-64 type: INVOKE_INTERNAL channel:
null correlatorId: null correlationKeySet: null retryCount: null inMem:
false detailsExt: {}) {org.apache.ode.scheduler.simple.SimpleScheduler}
org.apache.ode.scheduler.simple.DatabaseException:
org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060: deadlock
detected while waiting for resource
{prepstmnt 1750777159 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:186)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:533)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:280)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:235)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:514)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060:
deadlock detected while waiting for resource
{prepstmnt 1750777159 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:223)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1162)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1741)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:184)
... 10 more
TID: [0] [BPS] [2014-12-09 06:14:41,736] ERROR
{org.apache.ode.scheduler.simple.SimpleScheduler} - Error while processing
a persisted job: Job hqejbhcnphr9tmcxgfbvp1 time: 2014-12-09 06:03:52 UTC
transacted: true persisted: true details: JobDetails( instanceId: null
mexId: hqejbhcnphr9tmcxgfbvp0 processId: {
http://ode/bpel/unit-test}HelloWorld2-64 type: INVOKE_INTERNAL channel:
null correlatorId: null correlationKeySet: null retryCount: null inMem:
false detailsExt: {}) {org.apache.ode.scheduler.simple.SimpleScheduler}
org.apache.ode.scheduler.simple.DatabaseException:
org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060: deadlock
detected while waiting for resource
{prepstmnt 56771906 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:186)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:533)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:280)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:235)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:514)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060:
deadlock detected while waiting for resource
{prepstmnt 56771906 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:223)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1162)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1741)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:184)
... 10 more
TID: [0] [BPS] [2014-12-09 06:14:58,107] ERROR
{org.apache.ode.scheduler.simple.SimpleScheduler} - Error while processing
a persisted job: Job hqejbhcnphr9tmcxgfbvp4 time: 2014-12-09 06:03:52 UTC
transacted: true persisted: true details: JobDetails( instanceId: null
mexId: hqejbhcnphr9tmcxgfbvp3 processId: {
http://ode/bpel/unit-test}HelloWorld2-64 type: INVOKE_INTERNAL channel:
null correlatorId: null correlationKeySet: null retryCount: null inMem:
false detailsExt: {}) {org.apache.ode.scheduler.simple.SimpleScheduler}
org.apache.ode.scheduler.simple.DatabaseException:
org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060: deadlock
detected while waiting for resource
{prepstmnt 1254572135 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:186)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:533)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:280)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:235)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:514)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060:
deadlock detected while waiting for resource
{prepstmnt 1254572135 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:223)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1162)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1741)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:184)
... 10 more
TID: [0] [BPS] [2014-12-09 06:15:23,139] ERROR
{org.apache.ode.scheduler.simple.SimpleScheduler} - Error while processing
a persisted job: Job hqejbhcnphr9tmcxgfbvp7 time: 2014-12-09 06:03:52 UTC
transacted: true persisted: true details: JobDetails( instanceId: null
mexId: hqejbhcnphr9tmcxgfbvp6 processId: {
http://ode/bpel/unit-test}HelloWorld2-64 type: INVOKE_INTERNAL channel:
null correlatorId: null correlationKeySet: null retryCount: null inMem:
false detailsExt: {}) {org.apache.ode.scheduler.simple.SimpleScheduler}
org.apache.ode.scheduler.simple.DatabaseException:
org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060: deadlock
detected while waiting for resource
{prepstmnt 1362078629 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:186)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:533)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:280)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:235)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:530)
at
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:514)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00060:
deadlock detected while waiting for resource
{prepstmnt 1362078629 delete from ODE_JOB where jobid = ? and nodeid = ?
[params=?, ?]} [code=60, state=61000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:223)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1162)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1741)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:184)
... 10 more
Regards,
Shavantha Weerasinghe
Senior Software Engineer QA
WSO2, Inc.
lean.enterprise.middleware.
http://wso2.com
http://wso2.org
Tel : 94 11 214 5345
Fax :94 11 2145300
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
