On Feb 16, 2012 7:52 PM, "Rick Curtis" <curti...@gmail.com> wrote:
>
> > Duplicate entry '508051' for key 'PRIMARY'
>
> It looks like you tried to insert the same row twice?
Its quite unlikely. This is an auto generated id in the db table.
But I was able to fix this by incleasing the value in
OPENJPA_SEQUENCE_TABLE
Any idea, what could have gone wrong?
Thanks
Waruna
>
> On Thu, Feb 16, 2012 at 3:06 AM, Waruna Ranasinghe <waruna...@gmail.com
>wrote:
>
> > Hi all,
> >
> > I get the following exception. Does anyone know how to recover.
> >
> > <openjpa-2.0.0-wso2v1-r52033:64539M fatal general error>
> > org.apache.openjpa.persistence.PersistenceException: The transaction has
> > been rolled back. See the nested exceptions for details on the errors
that
> > occurred.
> > at
> >
> >
org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2273)
> > at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2115)
> > at
org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2013)
> > at
> >
org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1931)
> > at
> >
> >
org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:514)
> > at
> >
> >
org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:498)
> > at
> >
> >
org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(TransactionImpl.java:400)
> > at
> >
> >
org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:257)
> > at
> >
> >
org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:238)
> > at
> >
> >
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:291)
> > at
> >
> >
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:239)
> > at
> >
> >
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:531)
> > at
> >
> >
org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:515)
> > 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:662)
> > Caused by: <openjpa-2.0.0-wso2v1-r52033:64539M fatal store error>
> > org.apache.openjpa.persistence.EntityExistsException: Duplicate entry
> > '508051' for key 'PRIMARY' {prepstmnt 1635524010 INSERT INTO ODE_EVENT
> > (EVENT_ID, DETAIL, DATA, SCOPE_ID, TSTAMP, TYPE, INSTANCE_ID,
PROCESS_ID)
> > VALUES (?, ?, ?, ?, ?, ?, ?, ?) [params=(long) 508051, (String)
> >
> >
> > Thanks in advance,
> > Waruna
> >
> > --
> > -----------------------------------------------------
> > Regards,
> > Waruna Ranasinghe
> >
> > www.wso2.com - "Lean . Enterprise . Middleware"
> >
> > blog: http://warunapw.blogspot.com
> > twitter: http://twitter.com/warunapww
> > http://lk.linkedin.com/in/waruna
> > www.facebook.com/waruna.ranasinghe
> >
>
>
>
> --
> *Rick Curtis*
