org.apache.ode.scheduler.simple.DatabaseException: org.h2.jdbc.JdbcSQLException: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68]

JBoss Issue Tracker | Gary Brown | 7 years ago
  1. 0

    This occurred as part of hudson job riftsaw #143. The specific test that failed was BluePrint5TestCase.testSendBookAll. 2010-03-17 18:46:46,528 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (Thread-20) deploy, ctxPath=/HotelServiceLocation 2010-03-17 18:46:46,550 WARNING [javax.enterprise.resource.webcontainer.jsf.config] (Thread-20) Unable to process deployment descriptor for context '/HotelServiceLocation' 2010-03-17 18:46:46,550 INFO [javax.enterprise.resource.webcontainer.jsf.config] (Thread-20) Initializing Mojarra (1.2_12-b01-FCS) for context '/HotelServiceLocation' 2010-03-17 18:46:46,593 INFO [org.apache.juddi.v3.client.config.UDDIClerk] (Thread-20) Registering service HotelService with key uddi:esb.jboss.org:bpel-services-HotelService 2010-03-17 18:46:46,603 INFO [org.apache.juddi.v3.client.config.UDDIClerk] (Thread-20) Registering service HotelService completed. 2010-03-17 18:46:46,637 INFO [STDOUT] (Thread-20) Retrieving document at 'file:/qa/hudson_ws/workspace/RiftSaw/riftsaw-2.0-SNAPSHOT/jboss-5.1.0.GA/server/default/tmp/ag2g4g-jufl11-g6wprm6r-1-g6wq2249-c1/BluePrint5-1.jar/AirlineReservation.wsdl'. 2010-03-17 18:46:46,640 INFO [STDOUT] (Thread-20) Retrieving schema at 'reservation.xsd', relative to 'file:/qa/hudson_ws/workspace/RiftSaw/riftsaw-2.0-SNAPSHOT/jboss-5.1.0.GA/server/default/tmp/ag2g4g-jufl11-g6wprm6r-1-g6wq2249-c1/BluePrint5-1.jar/AirlineReservation.wsdl'. 2010-03-17 18:46:46,643 INFO [STDOUT] (Thread-20) Retrieving document at 'file:/qa/hudson_ws/workspace/RiftSaw/riftsaw-2.0-SNAPSHOT/jboss-5.1.0.GA/server/default/tmp/ag2g4g-jufl11-g6wprm6r-1-g6wq2249-c1/BluePrint5-1.jar/CarReservation.wsdl'. 2010-03-17 18:46:46,646 INFO [STDOUT] (Thread-20) Retrieving schema at 'reservation.xsd', relative to 'file:/qa/hudson_ws/workspace/RiftSaw/riftsaw-2.0-SNAPSHOT/jboss-5.1.0.GA/server/default/tmp/ag2g4g-jufl11-g6wprm6r-1-g6wq2249-c1/BluePrint5-1.jar/CarReservation.wsdl'. 2010-03-17 18:46:46,650 INFO [STDOUT] (Thread-20) Retrieving document at 'file:/qa/hudson_ws/workspace/RiftSaw/riftsaw-2.0-SNAPSHOT/jboss-5.1.0.GA/server/default/tmp/ag2g4g-jufl11-g6wprm6r-1-g6wq2249-c1/BluePrint5-1.jar/HotelReservation.wsdl'. 2010-03-17 18:46:46,653 INFO [STDOUT] (Thread-20) Retrieving schema at 'reservation.xsd', relative to 'file:/qa/hudson_ws/workspace/RiftSaw/riftsaw-2.0-SNAPSHOT/jboss-5.1.0.GA/server/default/tmp/ag2g4g-jufl11-g6wprm6r-1-g6wq2249-c1/BluePrint5-1.jar/HotelReservation.wsdl'. 2010-03-17 18:46:46,660 INFO [org.apache.ode.bpel.engine.BpelProcess] (Thread-20) Created new process DAO for {http://www.seebeyond.com/eInsight/hotelReservation}hotelReservation-1 (guid=hqejbhcnphr54ji49ktkup) 2010-03-17 18:46:46,660 INFO [org.apache.ode.bpel.engine.BpelProcess] (Thread-20) Created new process DAO for {http://www.seebeyond.com/eInsight/hotelReservation}hotelReservation-1 (guid=hqejbhcnphr54ji49ktkup). 2010-03-17 18:46:46,661 INFO [org.apache.ode.bpel.engine.BpelServerImpl] (Thread-20) Registered process {http://www.seebeyond.com/eInsight/hotelReservation}hotelReservation-1. 2010-03-17 18:46:46,661 INFO [org.apache.ode.bpel.engine.cron.CronScheduler] (Thread-20) Cancelling PROCESS CRON jobs for: {http://www.seebeyond.com/eInsight/hotelReservation}hotelReservation-1 2010-03-17 18:46:46,661 INFO [org.apache.ode.bpel.engine.cron.CronScheduler] (Thread-20) Scheduling PROCESS CRON jobs for: {http://www.seebeyond.com/eInsight/hotelReservation}hotelReservation-1 2010-03-17 18:46:54,210 INFO [STDOUT] (http-127.0.0.1-8080-2) Retrieving document at 'file:/qa/hudson_ws/workspace/RiftSaw/riftsaw-2.0-SNAPSHOT/jboss-5.1.0.GA/server/default/tmp/ag2g4g-jufl11-g6wprm6r-1-g6wq2249-c1/BluePrint5-1.jar/Reservation.wsdl'. 2010-03-17 18:46:54,213 INFO [STDOUT] (http-127.0.0.1-8080-2) Retrieving schema at 'reservation.xsd', relative to 'file:/qa/hudson_ws/workspace/RiftSaw/riftsaw-2.0-SNAPSHOT/jboss-5.1.0.GA/server/default/tmp/ag2g4g-jufl11-g6wprm6r-1-g6wq2249-c1/BluePrint5-1.jar/Reservation.wsdl'. 2010-03-17 18:46:54,227 INFO [org.apache.ode.utils.WatchDog] (http-127.0.0.1-8080-2) [Endpoint files for {DeploymentUnit BluePrint5-1.jar}] updated 2010-03-17 18:46:58,227 WARN [org.hibernate.util.JDBCExceptionReporter] (ODEServer-5) SQL Error: 90131, SQLState: 90131 2010-03-17 18:46:58,227 ERROR [org.hibernate.util.JDBCExceptionReporter] (ODEServer-5) Concurrent update in table BPEL_INSTANCE: another transaction has updated or deleted the same row [90131-68] 2010-03-17 18:46:58,228 ERROR [org.apache.ode.bpel.engine.BpelEngineImpl] (ODEServer-5) Scheduled job failed; jobDetail={mexid=59, pid={http://www.seebeyond.com/eInsight/ReservationSystem}ReservationSystem-1, type=INVOKE_INTERNAL} 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.MessageRouteDaoImpl.getTargetInstance(MessageRouteDaoImpl.java:57) at org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.invokeInstance(PartnerLinkMyRoleImpl.java:216) at org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:245) at org.apache.ode.bpel.engine.BpelProcess.handleWorkEvent(BpelProcess.java:412) at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:439) at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:441) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:411) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:405) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:404) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:401) 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: Concurrent update in table BPEL_INSTANCE: another transaction has updated or deleted the same row [90131-68] at org.h2.message.Message.getSQLException(Message.java:91) at org.h2.message.Message.getSQLException(Message.java:95) at org.h2.message.Message.getSQLException(Message.java:73) at org.h2.table.TableData.removeRow(TableData.java:275) at org.h2.table.Table.updateRows(Table.java:308) at org.h2.command.dml.Update.update(Update.java:125) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:197) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:132) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:121) 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) ... 20 more 2010-03-17 18:46:58,229 ERROR [org.apache.ode.bpel.engine.BpelEngineImpl] (ODEServer-5) Job could not be completed after 0 retries: hqejbhcnphr54ji49ktkxg[0]: {mexid=59, pid={http://www.seebeyond.com/eInsight/ReservationSystem}ReservationSystem-1, type=INVOKE_INTERNAL} 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.MessageRouteDaoImpl.getTargetInstance(MessageRouteDaoImpl.java:57) at org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.invokeInstance(PartnerLinkMyRoleImpl.java:216) at org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:245) at org.apache.ode.bpel.engine.BpelProcess.handleWorkEvent(BpelProcess.java:412) at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:439) at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:441) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:411) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:405) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:404) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:401) 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: Concurrent update in table BPEL_INSTANCE: another transaction has updated or deleted the same row [90131-68] at org.h2.message.Message.getSQLException(Message.java:91) at org.h2.message.Message.getSQLException(Message.java:95) at org.h2.message.Message.getSQLException(Message.java:73) at org.h2.table.TableData.removeRow(TableData.java:275) at org.h2.table.Table.updateRows(Table.java:308) at org.h2.command.dml.Update.update(Update.java:125) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:197) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:132) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:121) 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) ... 20 more 2010-03-17 18:46:58,231 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-5) Error while processing transaction, retrying in 1s 2010-03-17 18:46:58,232 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-5) Error while executing transaction org.apache.ode.bpel.iapi.Scheduler$JobProcessorException: org.hibernate.exception.GenericJDBCException: could not execute update query at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:452) at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:441) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:411) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:405) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:404) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:401) 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.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.MessageRouteDaoImpl.getTargetInstance(MessageRouteDaoImpl.java:57) at org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.invokeInstance(PartnerLinkMyRoleImpl.java:216) at org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:245) at org.apache.ode.bpel.engine.BpelProcess.handleWorkEvent(BpelProcess.java:412) at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:439) ... 11 more Caused by: org.h2.jdbc.JdbcSQLException: Concurrent update in table BPEL_INSTANCE: another transaction has updated or deleted the same row [90131-68] at org.h2.message.Message.getSQLException(Message.java:91) at org.h2.message.Message.getSQLException(Message.java:95) at org.h2.message.Message.getSQLException(Message.java:73) at org.h2.table.TableData.removeRow(TableData.java:275) at org.h2.table.Table.updateRows(Table.java:308) at org.h2.command.dml.Update.update(Update.java:125) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:197) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:132) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:121) 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) ... 20 more 2010-03-17 18:47:16,400 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-3) Error while executing transaction org.apache.ode.scheduler.simple.DatabaseException: org.h2.jdbc.JdbcSQLException: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68] at org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:100) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:407) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:405) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:404) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:401) 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: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68] at org.h2.message.Message.getSQLException(Message.java:91) at org.h2.message.Message.getSQLException(Message.java:95) at org.h2.message.Message.getSQLException(Message.java:73) at org.h2.table.TableData.removeRow(TableData.java:282) at org.h2.command.dml.Delete.update(Delete.java:68) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:197) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:132) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:121) at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:96) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365) at org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:98) ... 10 more 2010-03-17 18:47:43,403 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-3) Error while executing transaction org.apache.ode.scheduler.simple.DatabaseException: org.h2.jdbc.JdbcSQLException: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68] at org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:100) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:407) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:405) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:404) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:401) 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: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68] at org.h2.message.Message.getSQLException(Message.java:91) at org.h2.message.Message.getSQLException(Message.java:95) at org.h2.message.Message.getSQLException(Message.java:73) at org.h2.table.TableData.removeRow(TableData.java:282) at org.h2.command.dml.Delete.update(Delete.java:68) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:197) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:132) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:121) at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:96) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365) at org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:98) ... 10 more 2010-03-17 18:48:10,406 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-3) Error while executing transaction org.apache.ode.scheduler.simple.DatabaseException: org.h2.jdbc.JdbcSQLException: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68] at org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:100) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:407) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:405) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:404) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:401) 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: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68] at org.h2.message.Message.getSQLException(Message.java:91) at org.h2.message.Message.getSQLException(Message.java:95) at org.h2.message.Message.getSQLException(Message.java:73) at org.h2.table.TableData.removeRow(TableData.java:282) at org.h2.command.dml.Delete.update(Delete.java:68) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:197) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:132) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:121) at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:96) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365) at org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:98) ... 10 more 2010-03-17 18:48:37,415 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-3) Error while executing transaction org.apache.ode.scheduler.simple.DatabaseException: org.h2.jdbc.JdbcSQLException: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68] at org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:100) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:407) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:405) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:404) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:401) 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: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68] at org.h2.message.Message.getSQLException(Message.java:91) at org.h2.message.Message.getSQLException(Message.java:95) at org.h2.message.Message.getSQLException(Message.java:73) at org.h2.table.TableData.removeRow(TableData.java:282) at org.h2.command.dml.Delete.update(Delete.java:68) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:197) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:132) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:121) at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:96) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365) at org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:98) ... 10 more 2010-03-17 18:48:57,762 ERROR [org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl] (http-127.0.0.1-8080-4) Timeout or execution error when waiting for response to MEX {MyRoleMex#49 [Client hqejbhcnphr54ji49ktkwt] calling {http://localhost/BluePrint5/Reservation}reservationService.reserve(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@16df9d0 timed out(120000 ms) when waiting for a response! java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@16df9d0 timed out(120000 ms) when waiting for a response! at org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture.get(MyRoleMessageExchangeImpl.java:245) at org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl.invoke(BPELEngineImpl.java:158) 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-03-17 18:48:57,763 ERROR [org.jboss.wsf.common.invocation.InvocationHandlerJAXWS] (http-127.0.0.1-8080-4) 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#49 [Client hqejbhcnphr54ji49ktkwt] calling {http://localhost/BluePrint5/Reservation}reservationService.reserve(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@16df9d0 timed out(120000 ms) when waiting for a response! at org.jboss.soa.bpel.runtime.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:126) 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#49 [Client hqejbhcnphr54ji49ktkwt] calling {http://localhost/BluePrint5/Reservation}reservationService.reserve(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@16df9d0 timed out(120000 ms) when waiting for a response! at org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl.invoke(BPELEngineImpl.java:163) at org.jboss.soa.bpel.runtime.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:106) ... 33 more 2010-03-17 18:48:57,771 ERROR [org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS] (http-127.0.0.1-8080-4) SOAP request exception java.lang.RuntimeException: Failed to invoke BPEL process: Timeout or execution error when waiting for response to MEX {MyRoleMex#49 [Client hqejbhcnphr54ji49ktkwt] calling {http://localhost/BluePrint5/Reservation}reservationService.reserve(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@16df9d0 timed out(120000 ms) when waiting for a response! at org.jboss.soa.bpel.runtime.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:126) 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#49 [Client hqejbhcnphr54ji49ktkwt] calling {http://localhost/BluePrint5/Reservation}reservationService.reserve(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@16df9d0 timed out(120000 ms) when waiting for a response! at org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl.invoke(BPELEngineImpl.java:163) at org.jboss.soa.bpel.runtime.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:106) ... 33 more 2010-03-17 18:48:58,241 INFO [org.jboss.soa.bpel.deployer.BPELDeployer] (RMI TCP Connection(9)-127.0.0.1) Undeploy: BluePrint5-1.jar relativePath=bpel-deploy.xml 2010-03-17 18:48:58,253 INFO [org.jboss.soa.bpel.runtime.engine.ode.JAXWSBindingContext] (RMI TCP Connection(9)-127.0.0.1) Deactivate my role endpoint: {http://localhost/BluePrint5/AirlineReservation}AirlineService:AirlineServicePort 2010-03-17 18:48:58,255 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (RMI TCP Connection(9)-127.0.0.1) undeploy, ctxPath=/AirlineServiceLocation 2010-03-17 18:48:58,268 INFO [org.jboss.wsf.framework.management.DefaultEndpointRegistry] (RMI TCP Connection(9)-127.0.0.1) remove: jboss.ws:context=AirlineServiceLocation,endpoint=Endpoint-48ad6c57-7ca7-4e9b-9022-bace79e92c61 2010-03-17 18:48:58,280 INFO [org.apache.juddi.v3.client.config.UDDIClerk] (RMI TCP Connection(9)-127.0.0.1) UnRegistering binding for service AirlineService 2010-03-17 18:48:58,285 INFO [org.apache.ode.bpel.engine.BpelServerImpl] (RMI TCP Connection(9)-127.0.0.1) Unregistered process {http://www.seebeyond.com/eInsight/airlineReservation}airlineReservation-1. 2010-03-17 18:48:58,296 INFO [org.apache.ode.bpel.engine.BpelServerImpl] (RMI TCP Connection(9)-127.0.0.1) Deleted only the process {http://www.seebeyond.com/eInsight/airlineReservation}airlineReservation-1. 2010-03-17 18:48:58,297 INFO [org.apache.ode.bpel.engine.cron.CronScheduler] (RMI TCP Connection(9)-127.0.0.1) Cancelling PROCESS CRON jobs for: {http://www.seebeyond.com/eInsight/airlineReservation}airlineReservation-1 2010-03-17 18:48:58,298 INFO [org.apache.ode.store.ProcessStoreImpl] (RMI TCP Connection(9)-127.0.0.1) Process {http://www.seebeyond.com/eInsight/airlineReservation}airlineReservation-1 has been undeployed. 2010-03-17 18:48:58,298 INFO [org.jboss.soa.bpel.runtime.engine.ode.JAXWSBindingContext] (RMI TCP Connection(9)-127.0.0.1) Deactivate my role endpoint: {http://localhost/BluePrint5/CarReservation}CarService:CarServicePort 2010-03-17 18:48:58,333 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (RMI TCP Connection(9)-127.0.0.1) undeploy, ctxPath=/CarServiceLocation 2010-03-17 18:48:58,345 INFO [org.jboss.wsf.framework.management.DefaultEndpointRegistry] (RMI TCP Connection(9)-127.0.0.1) remove: jboss.ws:context=CarServiceLocation,endpoint=Endpoint-3f3f9567-0b2a-4224-8664-06a3b9dd92a3

    JBoss Issue Tracker | 7 years ago | Gary Brown
    org.apache.ode.scheduler.simple.DatabaseException: org.h2.jdbc.JdbcSQLException: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68]
  2. 0

    This occurred as part of hudson job riftsaw #143. The specific test that failed was BluePrint5TestCase.testSendBookAll. 2010-03-17 18:46:46,528 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (Thread-20) deploy, ctxPath=/HotelServiceLocation 2010-03-17 18:46:46,550 WARNING [javax.enterprise.resource.webcontainer.jsf.config] (Thread-20) Unable to process deployment descriptor for context '/HotelServiceLocation' 2010-03-17 18:46:46,550 INFO [javax.enterprise.resource.webcontainer.jsf.config] (Thread-20) Initializing Mojarra (1.2_12-b01-FCS) for context '/HotelServiceLocation' 2010-03-17 18:46:46,593 INFO [org.apache.juddi.v3.client.config.UDDIClerk] (Thread-20) Registering service HotelService with key uddi:esb.jboss.org:bpel-services-HotelService 2010-03-17 18:46:46,603 INFO [org.apache.juddi.v3.client.config.UDDIClerk] (Thread-20) Registering service HotelService completed. 2010-03-17 18:46:46,637 INFO [STDOUT] (Thread-20) Retrieving document at 'file:/qa/hudson_ws/workspace/RiftSaw/riftsaw-2.0-SNAPSHOT/jboss-5.1.0.GA/server/default/tmp/ag2g4g-jufl11-g6wprm6r-1-g6wq2249-c1/BluePrint5-1.jar/AirlineReservation.wsdl'. 2010-03-17 18:46:46,640 INFO [STDOUT] (Thread-20) Retrieving schema at 'reservation.xsd', relative to 'file:/qa/hudson_ws/workspace/RiftSaw/riftsaw-2.0-SNAPSHOT/jboss-5.1.0.GA/server/default/tmp/ag2g4g-jufl11-g6wprm6r-1-g6wq2249-c1/BluePrint5-1.jar/AirlineReservation.wsdl'. 2010-03-17 18:46:46,643 INFO [STDOUT] (Thread-20) Retrieving document at 'file:/qa/hudson_ws/workspace/RiftSaw/riftsaw-2.0-SNAPSHOT/jboss-5.1.0.GA/server/default/tmp/ag2g4g-jufl11-g6wprm6r-1-g6wq2249-c1/BluePrint5-1.jar/CarReservation.wsdl'. 2010-03-17 18:46:46,646 INFO [STDOUT] (Thread-20) Retrieving schema at 'reservation.xsd', relative to 'file:/qa/hudson_ws/workspace/RiftSaw/riftsaw-2.0-SNAPSHOT/jboss-5.1.0.GA/server/default/tmp/ag2g4g-jufl11-g6wprm6r-1-g6wq2249-c1/BluePrint5-1.jar/CarReservation.wsdl'. 2010-03-17 18:46:46,650 INFO [STDOUT] (Thread-20) Retrieving document at 'file:/qa/hudson_ws/workspace/RiftSaw/riftsaw-2.0-SNAPSHOT/jboss-5.1.0.GA/server/default/tmp/ag2g4g-jufl11-g6wprm6r-1-g6wq2249-c1/BluePrint5-1.jar/HotelReservation.wsdl'. 2010-03-17 18:46:46,653 INFO [STDOUT] (Thread-20) Retrieving schema at 'reservation.xsd', relative to 'file:/qa/hudson_ws/workspace/RiftSaw/riftsaw-2.0-SNAPSHOT/jboss-5.1.0.GA/server/default/tmp/ag2g4g-jufl11-g6wprm6r-1-g6wq2249-c1/BluePrint5-1.jar/HotelReservation.wsdl'. 2010-03-17 18:46:46,660 INFO [org.apache.ode.bpel.engine.BpelProcess] (Thread-20) Created new process DAO for {http://www.seebeyond.com/eInsight/hotelReservation}hotelReservation-1 (guid=hqejbhcnphr54ji49ktkup) 2010-03-17 18:46:46,660 INFO [org.apache.ode.bpel.engine.BpelProcess] (Thread-20) Created new process DAO for {http://www.seebeyond.com/eInsight/hotelReservation}hotelReservation-1 (guid=hqejbhcnphr54ji49ktkup). 2010-03-17 18:46:46,661 INFO [org.apache.ode.bpel.engine.BpelServerImpl] (Thread-20) Registered process {http://www.seebeyond.com/eInsight/hotelReservation}hotelReservation-1. 2010-03-17 18:46:46,661 INFO [org.apache.ode.bpel.engine.cron.CronScheduler] (Thread-20) Cancelling PROCESS CRON jobs for: {http://www.seebeyond.com/eInsight/hotelReservation}hotelReservation-1 2010-03-17 18:46:46,661 INFO [org.apache.ode.bpel.engine.cron.CronScheduler] (Thread-20) Scheduling PROCESS CRON jobs for: {http://www.seebeyond.com/eInsight/hotelReservation}hotelReservation-1 2010-03-17 18:46:54,210 INFO [STDOUT] (http-127.0.0.1-8080-2) Retrieving document at 'file:/qa/hudson_ws/workspace/RiftSaw/riftsaw-2.0-SNAPSHOT/jboss-5.1.0.GA/server/default/tmp/ag2g4g-jufl11-g6wprm6r-1-g6wq2249-c1/BluePrint5-1.jar/Reservation.wsdl'. 2010-03-17 18:46:54,213 INFO [STDOUT] (http-127.0.0.1-8080-2) Retrieving schema at 'reservation.xsd', relative to 'file:/qa/hudson_ws/workspace/RiftSaw/riftsaw-2.0-SNAPSHOT/jboss-5.1.0.GA/server/default/tmp/ag2g4g-jufl11-g6wprm6r-1-g6wq2249-c1/BluePrint5-1.jar/Reservation.wsdl'. 2010-03-17 18:46:54,227 INFO [org.apache.ode.utils.WatchDog] (http-127.0.0.1-8080-2) [Endpoint files for {DeploymentUnit BluePrint5-1.jar}] updated 2010-03-17 18:46:58,227 WARN [org.hibernate.util.JDBCExceptionReporter] (ODEServer-5) SQL Error: 90131, SQLState: 90131 2010-03-17 18:46:58,227 ERROR [org.hibernate.util.JDBCExceptionReporter] (ODEServer-5) Concurrent update in table BPEL_INSTANCE: another transaction has updated or deleted the same row [90131-68] 2010-03-17 18:46:58,228 ERROR [org.apache.ode.bpel.engine.BpelEngineImpl] (ODEServer-5) Scheduled job failed; jobDetail={mexid=59, pid={http://www.seebeyond.com/eInsight/ReservationSystem}ReservationSystem-1, type=INVOKE_INTERNAL} 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.MessageRouteDaoImpl.getTargetInstance(MessageRouteDaoImpl.java:57) at org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.invokeInstance(PartnerLinkMyRoleImpl.java:216) at org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:245) at org.apache.ode.bpel.engine.BpelProcess.handleWorkEvent(BpelProcess.java:412) at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:439) at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:441) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:411) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:405) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:404) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:401) 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: Concurrent update in table BPEL_INSTANCE: another transaction has updated or deleted the same row [90131-68] at org.h2.message.Message.getSQLException(Message.java:91) at org.h2.message.Message.getSQLException(Message.java:95) at org.h2.message.Message.getSQLException(Message.java:73) at org.h2.table.TableData.removeRow(TableData.java:275) at org.h2.table.Table.updateRows(Table.java:308) at org.h2.command.dml.Update.update(Update.java:125) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:197) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:132) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:121) 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) ... 20 more 2010-03-17 18:46:58,229 ERROR [org.apache.ode.bpel.engine.BpelEngineImpl] (ODEServer-5) Job could not be completed after 0 retries: hqejbhcnphr54ji49ktkxg[0]: {mexid=59, pid={http://www.seebeyond.com/eInsight/ReservationSystem}ReservationSystem-1, type=INVOKE_INTERNAL} 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.MessageRouteDaoImpl.getTargetInstance(MessageRouteDaoImpl.java:57) at org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.invokeInstance(PartnerLinkMyRoleImpl.java:216) at org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:245) at org.apache.ode.bpel.engine.BpelProcess.handleWorkEvent(BpelProcess.java:412) at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:439) at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:441) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:411) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:405) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:404) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:401) 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: Concurrent update in table BPEL_INSTANCE: another transaction has updated or deleted the same row [90131-68] at org.h2.message.Message.getSQLException(Message.java:91) at org.h2.message.Message.getSQLException(Message.java:95) at org.h2.message.Message.getSQLException(Message.java:73) at org.h2.table.TableData.removeRow(TableData.java:275) at org.h2.table.Table.updateRows(Table.java:308) at org.h2.command.dml.Update.update(Update.java:125) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:197) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:132) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:121) 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) ... 20 more 2010-03-17 18:46:58,231 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-5) Error while processing transaction, retrying in 1s 2010-03-17 18:46:58,232 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-5) Error while executing transaction org.apache.ode.bpel.iapi.Scheduler$JobProcessorException: org.hibernate.exception.GenericJDBCException: could not execute update query at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:452) at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:441) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:411) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:405) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:404) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:401) 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.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.MessageRouteDaoImpl.getTargetInstance(MessageRouteDaoImpl.java:57) at org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.invokeInstance(PartnerLinkMyRoleImpl.java:216) at org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:245) at org.apache.ode.bpel.engine.BpelProcess.handleWorkEvent(BpelProcess.java:412) at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:439) ... 11 more Caused by: org.h2.jdbc.JdbcSQLException: Concurrent update in table BPEL_INSTANCE: another transaction has updated or deleted the same row [90131-68] at org.h2.message.Message.getSQLException(Message.java:91) at org.h2.message.Message.getSQLException(Message.java:95) at org.h2.message.Message.getSQLException(Message.java:73) at org.h2.table.TableData.removeRow(TableData.java:275) at org.h2.table.Table.updateRows(Table.java:308) at org.h2.command.dml.Update.update(Update.java:125) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:197) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:132) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:121) 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) ... 20 more 2010-03-17 18:47:16,400 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-3) Error while executing transaction org.apache.ode.scheduler.simple.DatabaseException: org.h2.jdbc.JdbcSQLException: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68] at org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:100) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:407) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:405) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:404) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:401) 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: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68] at org.h2.message.Message.getSQLException(Message.java:91) at org.h2.message.Message.getSQLException(Message.java:95) at org.h2.message.Message.getSQLException(Message.java:73) at org.h2.table.TableData.removeRow(TableData.java:282) at org.h2.command.dml.Delete.update(Delete.java:68) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:197) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:132) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:121) at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:96) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365) at org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:98) ... 10 more 2010-03-17 18:47:43,403 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-3) Error while executing transaction org.apache.ode.scheduler.simple.DatabaseException: org.h2.jdbc.JdbcSQLException: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68] at org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:100) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:407) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:405) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:404) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:401) 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: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68] at org.h2.message.Message.getSQLException(Message.java:91) at org.h2.message.Message.getSQLException(Message.java:95) at org.h2.message.Message.getSQLException(Message.java:73) at org.h2.table.TableData.removeRow(TableData.java:282) at org.h2.command.dml.Delete.update(Delete.java:68) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:197) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:132) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:121) at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:96) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365) at org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:98) ... 10 more 2010-03-17 18:48:10,406 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-3) Error while executing transaction org.apache.ode.scheduler.simple.DatabaseException: org.h2.jdbc.JdbcSQLException: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68] at org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:100) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:407) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:405) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:404) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:401) 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: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68] at org.h2.message.Message.getSQLException(Message.java:91) at org.h2.message.Message.getSQLException(Message.java:95) at org.h2.message.Message.getSQLException(Message.java:73) at org.h2.table.TableData.removeRow(TableData.java:282) at org.h2.command.dml.Delete.update(Delete.java:68) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:197) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:132) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:121) at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:96) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365) at org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:98) ... 10 more 2010-03-17 18:48:37,415 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-3) Error while executing transaction org.apache.ode.scheduler.simple.DatabaseException: org.h2.jdbc.JdbcSQLException: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68] at org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:100) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:407) at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:405) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:404) at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:401) 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: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68] at org.h2.message.Message.getSQLException(Message.java:91) at org.h2.message.Message.getSQLException(Message.java:95) at org.h2.message.Message.getSQLException(Message.java:73) at org.h2.table.TableData.removeRow(TableData.java:282) at org.h2.command.dml.Delete.update(Delete.java:68) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:197) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:132) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:121) at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:96) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365) at org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:98) ... 10 more 2010-03-17 18:48:57,762 ERROR [org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl] (http-127.0.0.1-8080-4) Timeout or execution error when waiting for response to MEX {MyRoleMex#49 [Client hqejbhcnphr54ji49ktkwt] calling {http://localhost/BluePrint5/Reservation}reservationService.reserve(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@16df9d0 timed out(120000 ms) when waiting for a response! java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@16df9d0 timed out(120000 ms) when waiting for a response! at org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture.get(MyRoleMessageExchangeImpl.java:245) at org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl.invoke(BPELEngineImpl.java:158) 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-03-17 18:48:57,763 ERROR [org.jboss.wsf.common.invocation.InvocationHandlerJAXWS] (http-127.0.0.1-8080-4) 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#49 [Client hqejbhcnphr54ji49ktkwt] calling {http://localhost/BluePrint5/Reservation}reservationService.reserve(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@16df9d0 timed out(120000 ms) when waiting for a response! at org.jboss.soa.bpel.runtime.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:126) 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#49 [Client hqejbhcnphr54ji49ktkwt] calling {http://localhost/BluePrint5/Reservation}reservationService.reserve(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@16df9d0 timed out(120000 ms) when waiting for a response! at org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl.invoke(BPELEngineImpl.java:163) at org.jboss.soa.bpel.runtime.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:106) ... 33 more 2010-03-17 18:48:57,771 ERROR [org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS] (http-127.0.0.1-8080-4) SOAP request exception java.lang.RuntimeException: Failed to invoke BPEL process: Timeout or execution error when waiting for response to MEX {MyRoleMex#49 [Client hqejbhcnphr54ji49ktkwt] calling {http://localhost/BluePrint5/Reservation}reservationService.reserve(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@16df9d0 timed out(120000 ms) when waiting for a response! at org.jboss.soa.bpel.runtime.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:126) 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#49 [Client hqejbhcnphr54ji49ktkwt] calling {http://localhost/BluePrint5/Reservation}reservationService.reserve(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@16df9d0 timed out(120000 ms) when waiting for a response! at org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl.invoke(BPELEngineImpl.java:163) at org.jboss.soa.bpel.runtime.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:106) ... 33 more 2010-03-17 18:48:58,241 INFO [org.jboss.soa.bpel.deployer.BPELDeployer] (RMI TCP Connection(9)-127.0.0.1) Undeploy: BluePrint5-1.jar relativePath=bpel-deploy.xml 2010-03-17 18:48:58,253 INFO [org.jboss.soa.bpel.runtime.engine.ode.JAXWSBindingContext] (RMI TCP Connection(9)-127.0.0.1) Deactivate my role endpoint: {http://localhost/BluePrint5/AirlineReservation}AirlineService:AirlineServicePort 2010-03-17 18:48:58,255 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (RMI TCP Connection(9)-127.0.0.1) undeploy, ctxPath=/AirlineServiceLocation 2010-03-17 18:48:58,268 INFO [org.jboss.wsf.framework.management.DefaultEndpointRegistry] (RMI TCP Connection(9)-127.0.0.1) remove: jboss.ws:context=AirlineServiceLocation,endpoint=Endpoint-48ad6c57-7ca7-4e9b-9022-bace79e92c61 2010-03-17 18:48:58,280 INFO [org.apache.juddi.v3.client.config.UDDIClerk] (RMI TCP Connection(9)-127.0.0.1) UnRegistering binding for service AirlineService 2010-03-17 18:48:58,285 INFO [org.apache.ode.bpel.engine.BpelServerImpl] (RMI TCP Connection(9)-127.0.0.1) Unregistered process {http://www.seebeyond.com/eInsight/airlineReservation}airlineReservation-1. 2010-03-17 18:48:58,296 INFO [org.apache.ode.bpel.engine.BpelServerImpl] (RMI TCP Connection(9)-127.0.0.1) Deleted only the process {http://www.seebeyond.com/eInsight/airlineReservation}airlineReservation-1. 2010-03-17 18:48:58,297 INFO [org.apache.ode.bpel.engine.cron.CronScheduler] (RMI TCP Connection(9)-127.0.0.1) Cancelling PROCESS CRON jobs for: {http://www.seebeyond.com/eInsight/airlineReservation}airlineReservation-1 2010-03-17 18:48:58,298 INFO [org.apache.ode.store.ProcessStoreImpl] (RMI TCP Connection(9)-127.0.0.1) Process {http://www.seebeyond.com/eInsight/airlineReservation}airlineReservation-1 has been undeployed. 2010-03-17 18:48:58,298 INFO [org.jboss.soa.bpel.runtime.engine.ode.JAXWSBindingContext] (RMI TCP Connection(9)-127.0.0.1) Deactivate my role endpoint: {http://localhost/BluePrint5/CarReservation}CarService:CarServicePort 2010-03-17 18:48:58,333 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (RMI TCP Connection(9)-127.0.0.1) undeploy, ctxPath=/CarServiceLocation 2010-03-17 18:48:58,345 INFO [org.jboss.wsf.framework.management.DefaultEndpointRegistry] (RMI TCP Connection(9)-127.0.0.1) remove: jboss.ws:context=CarServiceLocation,endpoint=Endpoint-3f3f9567-0b2a-4224-8664-06a3b9dd92a3

    JBoss Issue Tracker | 7 years ago | Gary Brown
    org.apache.ode.scheduler.simple.DatabaseException: org.h2.jdbc.JdbcSQLException: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68]
  3. 0

    [RIFTSAW-184] H2 Concurrent update exception - JBoss Issue Tracker

    jboss.org | 1 year ago
    org.apache.ode.scheduler.simple.DatabaseException: org.h2.jdbc.JdbcSQLException: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [RIFTSAW-184] H2 Concurrent update exception - JBoss Issue Tracker

    jboss.org | 1 year ago
    org.apache.ode.scheduler.simple.DatabaseException: org.h2.jdbc.JdbcSQLException: Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row
  6. 0

    java.lang.IllegalArgumentException using H2 in JBoss Messaging

    Google Groups | 6 years ago | Borja
    org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalArgumentException"; SQL statement: INSERT INTO JBM_MSG_REF_GNQ (CHANNEL_ID, MESSAGE_ID, TRANSACTION_ID, STATE, ORD, PAGE_ORD, DELIVERY_COUNT, SCHED_DELIVERY) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [50000-128]
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.h2.jdbc.JdbcSQLException

    Concurrent update in table ODE_JOB: another transaction has updated or deleted the same row [90131-68]

    at org.h2.message.Message.getSQLException()
  2. H2 Database Engine
    JdbcPreparedStatement.executeUpdate
    1. org.h2.message.Message.getSQLException(Message.java:91)
    2. org.h2.message.Message.getSQLException(Message.java:95)
    3. org.h2.message.Message.getSQLException(Message.java:73)
    4. org.h2.table.TableData.removeRow(TableData.java:282)
    5. org.h2.command.dml.Delete.update(Delete.java:68)
    6. org.h2.command.CommandContainer.update(CommandContainer.java:69)
    7. org.h2.command.Command.executeUpdate(Command.java:197)
    8. org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:132)
    9. org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:121)
    9 frames
  3. JBoss Application Server Connector
    WrappedPreparedStatement.executeUpdate
    1. org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:96)
    2. org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
    2 frames
  4. org.apache.ode
    SimpleScheduler$4.call
    1. org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:98)
    2. org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:407)
    3. org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:405)
    4. org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218)
    5. org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:404)
    6. org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:401)
    6 frames
  5. Java RT
    Thread.run
    1. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    2. java.util.concurrent.FutureTask.run(FutureTask.java:138)
    3. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    4. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    5. java.lang.Thread.run(Thread.java:619)
    5 frames