Timeout trying to lock table "BPEL_SELECTORS" in BluePrint5 example.

2010-05-10 08:42:06,651 INFO [org.apache.ode.bpel.engine.cron.CronScheduler] (Thread-20) Scheduling PROCESS CRON jobs for:

{http://www.seebeyond.com/eInsight/hotelReservation}

hotelReservation-5
2010-05-10 08:44:02,831 ERROR [org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl] (http-127.0.0.1-8080-1) Timeout or execution error when waiting for response to MEX {MyRoleMex#311 [Client hqejbhcnphr59je9mqcph0] calling

{http://localhost/BluePrint5/Reservation}

reservationService.reserve(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@b2ee254 timed out(120000 ms) when waiting for a response!
java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@b2ee254 timed out(120000 ms) when waiting for a response!
at org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture.get(MyRoleMessageExchangeImpl.java:248)
at org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl.invoke(BPELEngineImpl.java:159)
at org.jboss.soa.bpel.runtime.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:106)
at org.jboss.soa.bpel.runtime.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:51)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.wsf.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:129)
at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:222)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHandlerImpl.java:502)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:299)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl.java:206)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:131)
at org.jboss.wsf.common.servlet.AbstractEndpointServlet.service(AbstractEndpointServlet.java:87)
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.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
2010-05-10 08:44:02,833 ERROR [org.jboss.wsf.common.invocation.InvocationHandlerJAXWS] (http-127.0.0.1-8080-1) Method invocation failed with exception: null
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.wsf.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:129)
at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:222)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHandlerImpl.java:502)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:299)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl.java:206)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:131)
at org.jboss.wsf.common.servlet.AbstractEndpointServlet.service(AbstractEndpointServlet.java:87)
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.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.RuntimeException: Failed to invoke BPEL process: Timeout or execution error when waiting for response to MEX {MyRoleMex#311 [Client hqejbhcnphr59je9mqcph0] calling

{http://localhost/BluePrint5/Reservation}

reservationService.reserve(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@b2ee254 timed out(120000 ms) when waiting for a response!
at org.jboss.soa.bpel.runtime.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:133)
at org.jboss.soa.bpel.runtime.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:51)
... 32 more
Caused by: java.lang.Exception: Timeout or execution error when waiting for response to MEX {MyRoleMex#311 [Client hqejbhcnphr59je9mqcph0] calling

{http://localhost/BluePrint5/Reservation}

reservationService.reserve(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@b2ee254 timed out(120000 ms) when waiting for a response!
at org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl.invoke(BPELEngineImpl.java:164)
at org.jboss.soa.bpel.runtime.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:106)
... 33 more
2010-05-10 08:44:02,835 ERROR [org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS] (http-127.0.0.1-8080-1) SOAP request exception
java.lang.RuntimeException: Failed to invoke BPEL process: Timeout or execution error when waiting for response to MEX {MyRoleMex#311 [Client hqejbhcnphr59je9mqcph0] calling

{http://localhost/BluePrint5/Reservation}

reservationService.reserve(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@b2ee254 timed out(120000 ms) when waiting for a response!
at org.jboss.soa.bpel.runtime.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:133)
at org.jboss.soa.bpel.runtime.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:51)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.wsf.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:129)
at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:222)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHandlerImpl.java:502)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:299)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl.java:206)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:131)
at org.jboss.wsf.common.servlet.AbstractEndpointServlet.service(AbstractEndpointServlet.java:87)
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.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.Exception: Timeout or execution error when waiting for response to MEX {MyRoleMex#311 [Client hqejbhcnphr59je9mqcph0] calling

{http://localhost/BluePrint5/Reservation}

reservationService.reserve(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@b2ee254 timed out(120000 ms) when waiting for a response!
at org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl.invoke(BPELEngineImpl.java:164)
at org.jboss.soa.bpel.runtime.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:106)
... 33 more
2010-05-10 08:44:10,283 WARN [org.hibernate.util.JDBCExceptionReporter] (ODEServer-15) SQL Error: 50200, SQLState: HYT00
2010-05-10 08:44:10,284 ERROR [org.hibernate.util.JDBCExceptionReporter] (ODEServer-15) Timeout trying to lock table "BPEL_SELECTORS"; SQL statement:
delete from BPEL_SELECTORS where SELGRPID=? and PIID=? [50200-124]
2010-05-10 08:44:10,287 ERROR [org.apache.ode.bpel.engine.BpelEngineImpl] (ODEServer-15) Scheduled job failed; jobDetail=

{iid=506, inmem=false, type=TIMER, channel=52}

org.hibernate.exception.GenericJDBCException: could not execute update query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:107)
at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:419)
at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:283)
at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1168)
at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:117)
at org.apache.ode.daohib.bpel.CorrelatorDaoImpl.removeRoutes(CorrelatorDaoImpl.java:255)
at org.apache.ode.daohib.bpel.ProcessDaoImpl.removeRoutes(ProcessDaoImpl.java:115)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.timerEvent(BpelRuntimeContextImpl.java:1027)
at org.apache.ode.bpel.engine.BpelProcess.handleWorkEvent(BpelProcess.java:444)
at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:453)
at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:450)
at org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:515)
at org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:510)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:281)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:236)
at org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:509)
at org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:493)
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:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "BPEL_SELECTORS"; SQL statement:
delete from BPEL_SELECTORS where SELGRPID=? and PIID=? [50200-124]
at org.h2.message.Message.getSQLException(Message.java:111)
at org.h2.message.Message.getSQLException(Message.java:122)
at org.h2.message.Message.getSQLException(Message.java:75)
at org.h2.table.TableData.doLock(TableData.java:495)
at org.h2.table.TableData.lock(TableData.java:433)
at org.h2.command.dml.Delete.update(Delete.java:51)
at org.h2.command.CommandContainer.update(CommandContainer.java:72)
at org.h2.command.Command.executeUpdate(Command.java:209)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:139)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:128)
at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:96)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:98)
... 21 more
2010-05-10 08:44:12,998 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-14) Error while processing a persisted job: Job hqejbhcnphr59je9mqcpha time: 2010-05-10 08:44:04 EDT transacted: true persisted: true details:

{iid=506, inmem=false, type=TIMER, channel=50}

org.apache.ode.bpel.iapi.Scheduler$JobProcessorException
at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:396)
at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:450)
at org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:515)
at org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:510)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:281)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:236)
at org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:509)
at org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:493)
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:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
2010-05-10 08:44:13,006 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-14) Error while processing job, retrying in 1s
2010-05-10 08:44:15,732 WARN [org.hibernate.util.JDBCExceptionReporter] (ODEServer-14) SQL Error: 50200, SQLState: HYT00
2010-05-10 08:44:15,733 ERROR [org.hibernate.util.JDBCExceptionReporter] (ODEServer-14) Timeout trying to lock table "BPEL_SELECTORS"; SQL statement:
select hcorrelato0_.ID as ID189_, hcorrelato0_.PIID as PIID189_, hcorrelato0_.SELGRPID as SELGRPID189_, hcorrelato0_.IDX as IDX189_, hcorrelato0_.CORRELATION_KEY as CORRELAT5_189_, hcorrelato0_.PROC_TYPE as PROC6_189_, hcorrelato0_.ROUTE_POLICY as ROUTE7_189_, hcorrelato0_.CORRELATOR as CORRELATOR189_, hcorrelato0_.INSERT_TIME as INSERT9_189_, hcorrelato0_.MLOCK as MLOCK189_ from BPEL_SELECTORS hcorrelato0_, BPEL_CORRELATOR hcorrelato1_ where hcorrelato0_.CORRELATOR=hcorrelato1_.ID and hcorrelato0_.PROC_TYPE=? and hcorrelato1_.CID=? and hcorrelato0_.CORRELATION_KEY=? for update [50200-124]
2010-05-10 08:44:15,733 ERROR [org.apache.ode.bpel.engine.BpelEngineImpl] (ODEServer-14) Scheduled job failed; jobDetail={mexid=355, inmem=false, pid=

{http://www.seebeyond.com/eInsight/ReservationSystem}

ReservationSystem-5, type=INVOKE_INTERNAL}
org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2231)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.apache.ode.daohib.bpel.CorrelatorDaoImpl.findRoute(CorrelatorDaoImpl.java:125)
at org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.findRoute(PartnerLinkMyRoleImpl.java:140)
at org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:235)
at org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:281)
at org.apache.ode.bpel.engine.BpelProcess.handleWorkEvent(BpelProcess.java:427)
at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:453)
at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:450)
at org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:515)
at org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:510)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:281)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:236)
at org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:509)
at org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:493)
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:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "BPEL_SELECTORS"; SQL statement:
select hcorrelato0_.ID as ID189_, hcorrelato0_.PIID as PIID189_, hcorrelato0_.SELGRPID as SELGRPID189_, hcorrelato0_.IDX as IDX189_, hcorrelato0_.CORRELATION_KEY as CORRELAT5_189_, hcorrelato0_.PROC_TYPE as PROC6_189_, hcorrelato0_.ROUTE_POLICY as ROUTE7_189_, hcorrelato0_.CORRELATOR as CORRELATOR189_, hcorrelato0_.INSERT_TIME as INSERT9_189_, hcorrelato0_.MLOCK as MLOCK189_ from BPEL_SELECTORS hcorrelato0_, BPEL_CORRELATOR hcorrelato1_ where hcorrelato0_.CORRELATOR=hcorrelato1_.ID and hcorrelato0_.PROC_TYPE=? and hcorrelato1_.CID=? and hcorrelato0_.CORRELATION_KEY=? for update [50200-124]
at org.h2.message.Message.getSQLException(Message.java:111)
at org.h2.message.Message.getSQLException(Message.java:122)
at org.h2.message.Message.getSQLException(Message.java:75)
at org.h2.table.TableData.doLock(TableData.java:495)
at org.h2.table.TableData.lock(TableData.java:433)
at org.h2.table.TableFilter.lock(TableFilter.java:119)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:544)
at org.h2.command.dml.Query.query(Query.java:236)
at org.h2.command.CommandContainer.query(CommandContainer.java:82)
at org.h2.command.Command.executeQueryLocal(Command.java:142)
at org.h2.command.Command.executeQuery(Command.java:123)
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:98)
at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:91)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
... 25 more