|
From: Henri H. <he...@or...> - 2010-03-16 16:58:26
|
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 |