Re: [Oreka-user] Duplicate Key error

This seems to be reported by multiple users. Let us investigate this.

Henri

 

  _____  

From: Scott M. Grim [mailto:sg...@al...] 
Sent: 08 March 2010 13:08
To: ore...@li...
Subject: [Oreka-user] Duplicate Key error

 

CentOS release 5.4 (Final) 2.6.18-164.el5 #1 SMP

mysqld  Ver 5.0.77 for redhat-linux-gnu on x86_64 (Source distribution)

orkaudio-1.2-671-os-i386.centos5

orkweb-1.2-669-os-linux

 

Calls are recorded fine and stored on disk.  The first call appears in the
database but after that any subsequent insert attempt gets a Duplicate Key
error.

I have tried removing the database and recreating it with the installer
script and even tried completely reinstalling to a clean OS install but
continue to get this error.  It appears that either orktrack is expecting
the database to handle incrementation of the id field or it should be
finding MAX(id) and inserting appropriate id but is always sending '0'.  I
tried changing the field to auto_increment in mysql but that did not solve
the issue.

 

I'm not the only one receiving this but so far no solution has been
forthcoming:

http://sourceforge.net/mailarchive/forum.php?thread_name=54.08.25030.BEDF68B
4%40cm-omr6
<http://sourceforge.net/mailarchive/forum.php?thread_name=54.08.25030.BEDF68
B4%40cm-omr6&forum_name=oreka-user> &forum_name=oreka-user

http://sourceforge.net/projects/oreka/forums/forum/504176/topic/3553485

 

Here's a log excerpt:

 

2010-03-04 11:41:13,144 net.sf.oreka.orktrack.messages.TapeMessage ERROR -
TapeMessage.process: 
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC
batch update
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java
:43)
        at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
        at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
        at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
        at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.jav
a:222)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntity
Persister.java:2229)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntity
Persister.java:2665)
        at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:60)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(Abst
ractFlushingEventListener.java:298)
        at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventL
istener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
        at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
        at
net.sf.oreka.orktrack.messages.TapeMessage.process(TapeMessage.java:94)
        at
net.sf.oreka.orktrack.CommandServlet.doGet(CommandServlet.java:49)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:252)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:178)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126
)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105
)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:107)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processC
onnection(Http11BaseProtocol.java:664)
        at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:527)
        at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:80)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:684)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.BatchUpdateException: Duplicate entry '0' for key 1
        at
com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.
java:647)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at
org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)
        at
org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$a6a49ea6.ex
ecuteBatch(<generated>)
        at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
        at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
        ... 32 more