13 Replies Latest reply: Jun 3, 2011 1:57 AM by Jeff Yu RSS

Ode JOBID - Unique index or primary key violation Error

Federico Ceccarini Newbie

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 Yu Master

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

  • 2. Ode JOBID - Unique index or primary key violation Error
    Jeff Yu Master

    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
    Federico Ceccarini Newbie

    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 Yu Master

    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
    Federico Ceccarini Newbie

    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 Yu Master

    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
    Federico Ceccarini Newbie

    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 Yu Master

    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
    Federico Ceccarini Newbie

    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
    Gary Brown Master

    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
    Federico Ceccarini Newbie

    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 Yu Master

    Thanks Federico, I am looking into this issue now.

     

    Regards

    Jeff

  • 13. Re: Ode JOBID - Unique index or primary key violation Error
    Jeff Yu Master

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

     

    Regards

    Jeff