Uploaded image for project: 'RiftSaw'
  1. RiftSaw
  2. RIFTSAW-184

H2 Concurrent update exception

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 2.1.0.CR1
    • None
    • None
    • None

    Description

      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

      Attachments

        Activity

          People

            gary@brownuk.com Gary Brown
            gary@brownuk.com Gary Brown
            Archiver:
            rhn-support-adandapa Aitik Dandapat

            Dates

              Created:
              Updated:
              Resolved:
              Archived:

              PagerDuty