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

Re-deploying bpel script leads to continuous stream of error messages in server log

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 2.0-CR1
    • Fix Version/s: 2.0-CR2
    • Component/s: Integration
    • Labels:
      None
    • Environment:

      Windows XP, Hypersonic db for Riftsaw, JBoss 5.1.0GA with ESB 4.7

      Description

      This one isn't as serious as defect 152 in that it shows up "only" once every 10 seconds rather than every second. Starts happening when I do multiple deploy/re-deploy cycles to my server - I'm debugging my script. Deleting the h2 directory makes the problem go away but that's clearly not a good workaround.

      16:02:14,972 ERROR [SimpleScheduler] 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$5$1.call(SimpleScheduler.java:476) at org.apache.ode.scheduler.simple.SimpleScheduler$5$1.call(SimpleScheduler.java:475) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218) at org.apache.ode.scheduler.simple.SimpleScheduler$5.call(SimpleScheduler.java:474) at org.apache.ode.scheduler.simple.SimpleScheduler$5.call(SimpleScheduler.java:472) 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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                jeff.yuchang Jeff Yu
                Reporter:
                steeqs4 Martin Sarabura
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: