You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by Waruna Ranasinghe <wa...@gmail.com> on 2012/02/16 10:06:58 UTC
Duplicate entry exception
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
Re: Duplicate entry exception
Posted by Waruna Ranasinghe <wa...@gmail.com>.
On Feb 16, 2012 7:52 PM, "Rick Curtis" <cu...@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 <warunapww@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*
Re: Duplicate entry exception
Posted by Rick Curtis <cu...@gmail.com>.
> Duplicate entry '508051' for key 'PRIMARY'
It looks like you tried to insert the same row twice?
On Thu, Feb 16, 2012 at 3:06 AM, Waruna Ranasinghe <wa...@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*