13 Replies Latest reply on Jun 3, 2011 1:57 AM by jeff.yuchang

    Ode JOBID - Unique index or primary key violation Error

    fedcecca

      I have a bpel process when I invoke the process the following error come any idea?

       

      2011-04-28 09:25:08,256 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-8) Error while processing a persisted job: org.apache.ode.dao.jpa.scheduler.JobDAOImpl@1e438f7

      org.apache.ode.bpel.iapi.Scheduler$JobProcessorException

          at org.apache.ode.bpel.engine.BpelEngineImpl.acquireInstanceLock(BpelEngineImpl.java:396)

          at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:405)

          at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:450)

          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable$1.call(SimpleScheduler.java:566)

          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable$1.call(SimpleScheduler.java:556)

          at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:289)

          at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:246)

          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.processInTransactionContext(SimpleScheduler.java:556)

          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:541)

          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:528)

          at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

          at java.util.concurrent.FutureTask.run(Unknown Source)

          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

          at java.lang.Thread.run(Unknown Source)

      2011-04-28 09:25:08,288 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-8) Error while processing job, retrying in 5s

      2011-04-28 09:25:08,295 WARN  [org.hibernate.util.JDBCExceptionReporter] (ODEServer-8) SQL Error: 23001, SQLState: 23001

      2011-04-28 09:25:08,297 ERROR [org.hibernate.util.JDBCExceptionReporter] (ODEServer-8) Unique index or primary key violation: "PRIMARY_KEY_C ON PUBLIC.ODE_JOB(JOBID)"; SQL statement:

      insert into ODE_JOB (channel, correlationKeySet, correlatorId, detailsExt, inMem, instanceId, mexId, nodeid, processId, retryCount, scheduled, ts, transacted, type, jobid) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23001-124]

      2011-04-28 09:25:08,304 WARN  [org.hibernate.util.JDBCExceptionReporter] (ODEServer-8) SQL Error: 23001, SQLState: 23001

      2011-04-28 09:25:08,305 ERROR [org.hibernate.util.JDBCExceptionReporter] (ODEServer-8) Unique index or primary key violation: "PRIMARY_KEY_C ON PUBLIC.ODE_JOB(JOBID)"; SQL statement:

      insert into ODE_JOB (channel, correlationKeySet, correlatorId, detailsExt, inMem, instanceId, mexId, nodeid, processId, retryCount, scheduled, ts, transacted, type, jobid) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23001-124]

      2011-04-28 09:25:08,313 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] (ODEServer-8) Could not synchronize database state with session

      org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

          at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)

          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)

          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)

          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)

          at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

          at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)

          at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)

          at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)

          at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:504)

          at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:101)

          at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:269)

          at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:89)

          at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)

          at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1423)

          at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:137)

          at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

          at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:298)

          at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:246)

          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.processInTransactionContext(SimpleScheduler.java:601)

          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:541)

          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:528)

          at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

          at java.util.concurrent.FutureTask.run(Unknown Source)

          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

          at java.lang.Thread.run(Unknown Source)

      Caused by: org.h2.jdbc.JdbcBatchUpdateException: Unique index or primary key violation: "PRIMARY_KEY_C ON PUBLIC.ODE_JOB(JOBID)"; SQL statement:

      insert into ODE_JOB (channel, correlationKeySet, correlatorId, detailsExt, inMem, instanceId, mexId, nodeid, processId, retryCount, scheduled, ts, transacted, type, jobid) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23001-124]

          at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1082)

          at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeBatch(CachedPreparedStatement.java:476)

          at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774)

          at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

          ... 24 more

      2011-04-28 09:25:08,404 WARN  [com.arjuna.ats.arjuna.logging.arjLoggerI18N] (ODEServer-8) [com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator_2] TwoPhaseCoordinator.beforeCompletion - failed for com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple@f0bea7

      javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

          at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)

          at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:513)

          at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:101)

          at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:269)

          at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:89)

          at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)

          at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1423)

          at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:137)

          at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

          at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:298)

          at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:246)

          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.processInTransactionContext(SimpleScheduler.java:601)

          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:541)

          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:528)

          at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

          at java.util.concurrent.FutureTask.run(Unknown Source)

          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

          at java.lang.Thread.run(Unknown Source)

      Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

          at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)

          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)

          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)

          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)

          at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

          at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)

          at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)

          at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)

          at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:504)

          ... 17 more

      Caused by: org.h2.jdbc.JdbcBatchUpdateException: Unique index or primary key violation: "PRIMARY_KEY_C ON PUBLIC.ODE_JOB(JOBID)"; SQL statement:

      insert into ODE_JOB (channel, correlationKeySet, correlatorId, detailsExt, inMem, instanceId, mexId, nodeid, processId, retryCount, scheduled, ts, transacted, type, jobid) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23001-124]

          at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1082)

          at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeBatch(CachedPreparedStatement.java:476)

          at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774)

          at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

          ... 24 more

        • 1. Ode JOBID - Unique index or primary key violation Error
          jeff.yuchang

          could you please let me know which riftsaw version did you use?

          • 2. Ode JOBID - Unique index or primary key violation Error
            jeff.yuchang

            also, could you please ask questions at the user forum instead of dev forum next time. http://community.jboss.org/en/riftsaw?view=discussions

            • 3. Ode JOBID - Unique index or primary key violation Error
              fedcecca

              I'm using riftsaw-2.2.0.Final.

               

              I give you another information. I have this problem only when I use the correlation functionality, but I haven't got error about the correlation explicitly.

              • 4. Ode JOBID - Unique index or primary key violation Error
                jeff.yuchang

                Could you please try this against more reliable database, mysql for example, to see if you see the same exception?

                • 5. Ode JOBID - Unique index or primary key violation Error
                  fedcecca

                  how I can change the DB? I have to uninstall riftsaw and reinstall specifing mysql as DB or I can use a more easy way?

                  • 6. Ode JOBID - Unique index or primary key violation Error
                    jeff.yuchang

                    The simplest approach is to undeploy the riftsaw, and then update the $db/jdbc/mysql.properties file, then run 'ant deploy -Ddatabase=mysql'.

                     

                    Detailed info please refer to the Getting Started Guide. http://docs.jboss.org/riftsaw/releases/2.2.0.Final/gettingstartedguide/html_single/#d0e153

                     

                    If you really don't want to reinstall the riftsaw, you need to configure the mysql data source (take a look at the $riftsaw-2.2.0.Final/db/datasource/bpel-mysql-ds.xml) properly, and then copy it over to the $jboss/server/default/deploy/riftsaw.sar/META-INF/bpel-ds.xml. Also copy the mysql driver into the $jboss/server/default/deploy/riftsaw.sar/lib

                     

                    And then restart the riftsaw, you should be ready to go.

                     

                    Note, you will need to create a mysql database instance for this.

                     

                    Thanks

                    Jeff

                    • 7. Ode JOBID - Unique index or primary key violation Error
                      fedcecca

                      hi,

                      I try mysql DB but the problem come back.

                      I attach the trace:

                       

                      2011-04-28 15:29:21,619 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-5) Error while processing a persisted job: org.apache.ode.dao.jpa.scheduler.JobDAOImpl@10e874a

                      org.apache.ode.bpel.iapi.Scheduler$JobProcessorException

                          at org.apache.ode.bpel.engine.BpelEngineImpl.acquireInstanceLock(BpelEngineImpl.java:396)

                          at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:405)

                          at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:450)

                          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable$1.call(SimpleScheduler.java:566)

                          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable$1.call(SimpleScheduler.java:556)

                          at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:289)

                          at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:246)

                          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.processInTransactionContext(SimpleScheduler.java:556)

                          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:541)

                          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:528)

                          at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

                          at java.util.concurrent.FutureTask.run(Unknown Source)

                          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

                          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

                          at java.lang.Thread.run(Unknown Source)

                      2011-04-28 15:29:21,722 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-5) Error while processing job, retrying in 5s

                      2011-04-28 15:29:21,749 WARN  [org.hibernate.util.JDBCExceptionReporter] (ODEServer-5) SQL Error: 1062, SQLState: 23000

                      2011-04-28 15:29:21,752 ERROR [org.hibernate.util.JDBCExceptionReporter] (ODEServer-5) Duplicate entry 'hqejbhcnphr68grivn8wew' for key 1

                      2011-04-28 15:29:21,755 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] (ODEServer-5) Could not synchronize database state with session

                      org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

                          at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)

                          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

                          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)

                          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)

                          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)

                          at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

                          at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)

                          at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)

                          at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)

                          at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:504)

                          at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:101)

                          at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:269)

                          at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:89)

                          at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)

                          at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1423)

                          at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:137)

                          at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

                          at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:298)

                          at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:246)

                          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.processInTransactionContext(SimpleScheduler.java:601)

                          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:541)

                          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:528)

                          at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

                          at java.util.concurrent.FutureTask.run(Unknown Source)

                          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

                          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

                          at java.lang.Thread.run(Unknown Source)

                      Caused by: java.sql.BatchUpdateException: Duplicate entry 'hqejbhcnphr68grivn8wew' for key 1

                          at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1269)

                          at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:955)

                          at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774)

                          at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

                          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

                          ... 24 more

                      2011-04-28 15:29:21,822 WARN  [com.arjuna.ats.arjuna.logging.arjLoggerI18N] (ODEServer-5) [com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator_2] TwoPhaseCoordinator.beforeCompletion - failed for com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple@154690e

                      javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

                          at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)

                          at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:513)

                          at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:101)

                          at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:269)

                          at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:89)

                          at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)

                          at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1423)

                          at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:137)

                          at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

                          at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:298)

                          at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:246)

                          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.processInTransactionContext(SimpleScheduler.java:601)

                          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:541)

                          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:528)

                          at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

                          at java.util.concurrent.FutureTask.run(Unknown Source)

                          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

                          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

                          at java.lang.Thread.run(Unknown Source)

                      Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

                          at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)

                          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

                          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)

                          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)

                          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)

                          at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

                          at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)

                          at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)

                          at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)

                          at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:504)

                          ... 17 more

                      Caused by: java.sql.BatchUpdateException: Duplicate entry 'hqejbhcnphr68grivn8wew' for key 1

                          at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1269)

                          at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:955)

                          at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774)

                          at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

                          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

                          ... 24 more

                      2011-04-28 15:29:21,881 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-5) error in commiting transaction

                      javax.transaction.RollbackException: [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] Could not commit transaction.

                          at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1435)

                          at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:137)

                          at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

                          at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:298)

                          at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:246)

                          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.processInTransactionContext(SimpleScheduler.java:601)

                          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:541)

                          at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:528)

                          at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

                          at java.util.concurrent.FutureTask.run(Unknown Source)

                          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

                          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

                          at java.lang.Thread.run(Unknown Source)

                      Caused by: java.lang.Throwable: setRollbackOnly called from:

                          at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.setRollbackOnly(TransactionImple.java:392)

                          at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.setRollbackOnly(BaseTransaction.java:195)

                          at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.setRollbackOnly(BaseTransactionManagerDelegate.java:123)

                          at org.hibernate.ejb.AbstractEntityManagerImpl.markAsRollback(AbstractEntityManagerImpl.java:421)

                          at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:576)

                          at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)

                          at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:513)

                          at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:101)

                          at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:269)

                          at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:89)

                          at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)

                          at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1423)

                          ... 12 more

                      • 8. Ode JOBID - Unique index or primary key violation Error
                        jeff.yuchang

                        Firstly, thanks for trying this out.

                         

                        This is strange. Could you please create a jira over here: https://issues.jboss.org/browse/RIFTSAW, and then give us detail information on the description. If you couldn't create an example to reproduce this error, could you please try the $riftsaw/samples/quickstart/simple_correlation example to see if you can still see this error? if it is not, what difference between your process with simple_correlation example?

                         

                        And it would be great that you can specify following information:

                         

                        1. JDK version

                        2. JBoss WS version

                        3. Did you have JBoss ESB installed? if it did, which version?

                         

                        Thanks

                        Jeff

                        • 9. Ode JOBID - Unique index or primary key violation Error
                          fedcecca

                          sorry I'm new in JBoss Community. You sugest me to create a new issue?

                          • 10. Ode JOBID - Unique index or primary key violation Error
                            objectiser

                            Hi Federico

                             

                            Yes, if you could create a bug report in our jira system with the information Jeff has requested, that would be great.

                             

                            Regards

                            Gary

                            • 11. Ode JOBID - Unique index or primary key violation Error
                              fedcecca

                              hi,

                              I have proposed the RIFTSAW-382 and I have attach the BPEL project. I hope the information delivered will help to resolve the problem.

                               

                              Regards

                              Federico

                              • 12. Ode JOBID - Unique index or primary key violation Error
                                jeff.yuchang

                                Thanks Federico, I am looking into this issue now.

                                 

                                Regards

                                Jeff

                                • 13. Re: Ode JOBID - Unique index or primary key violation Error
                                  jeff.yuchang

                                  The fix has been included in this snapshot distro. http://hudson.jboss.org/hudson/job/RiftSaw/371/

                                   

                                  Regards

                                  Jeff