unique contraint violation when writing messages to DB
srose Oct 27, 2005 9:26 AMIm having the same problem posted in this forum:
http://www.jboss.com/index.html?module=bb&op=viewtopic&t=70467
Just curious if this is a bug or a configuration issue?
Here is my full stack trace ....
14:23:22,562 ERROR [JmsMsgSenderBean] JMSException while sending the message to the QUEUE org.jboss.mq.SpyJMSException: Could not store message: 7 msg=4 hard NOT_STORED P ERSISTENT queue=QUEUE.Q1 priority=4 lateClone=false hashCode=3239651; - nested t hrowable: (java.sql.SQLException: ORA-00001: unique constraint (FIDSDB.SYS_C0079 01) violated ) at org.jboss.mq.pm.jdbc3.PersistenceManager.add(PersistenceManager.java: 449) at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:4 3) at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:164) at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationMa nager.java:397) at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationMa nager.java:373) at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerI nterceptorSupport.java:136) at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecu rityInterceptor.java:153) at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor. java:256) at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java :136) at org.jboss.mq.il.uil2.ServerSocketManagerHandler.handleMsg(ServerSocke tManagerHandler.java:92) at org.jboss.mq.il.uil2.SocketManager$ReadTask.handleMsg(SocketManager.j ava:369) at org.jboss.mq.il.uil2.msgs.BaseMsg.run(BaseMsg.java:377) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExec utor.java:748) at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.SQLException: ORA-00001: unique constraint (FIDSDB.SYS_C0079 01) violated at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement. java:216) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedSta tement.java:955) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:1168) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep aredStatement.java:3285) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar edStatement.java:3368) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdat e(WrappedPreparedStatement.java:227) at org.jboss.mq.pm.jdbc3.PersistenceManager.addMessage(PersistenceManage r.java:1446) at org.jboss.mq.pm.jdbc3.PersistenceManager.add(PersistenceManager.java: 433) ... 13 more 14:23:22,578 WARN [JmsMsgDistributorBean] JMSException while sending message to the Q : queue/Q1 org.jboss.mq.SpyJMSException: Could not store message: 7 msg=4 hard NOT_STORED P ERSISTENT queue=QUEUE.Q1 priority=4 lateClone=false hashCode=3239651; - nested t hrowable: (java.sql.SQLException: ORA-00001: unique constraint (FIDSDB.SYS_C0079 01) violated ) at org.jboss.mq.pm.jdbc3.PersistenceManager.add(PersistenceManager.java: 449) at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:4 3) at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:164) at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationMa nager.java:397) at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationMa nager.java:373) at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerI nterceptorSupport.java:136) at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecu rityInterceptor.java:153) at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor. java:256) at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java :136) at org.jboss.mq.il.uil2.ServerSocketManagerHandler.handleMsg(ServerSocke tManagerHandler.java:92) at org.jboss.mq.il.uil2.SocketManager$ReadTask.handleMsg(SocketManager.j ava:369) at org.jboss.mq.il.uil2.msgs.BaseMsg.run(BaseMsg.java:377) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExec utor.java:748) at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.SQLException: ORA-00001: unique constraint (FIDSDB.SYS_C0079 01) violated at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement. java:216) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedSta tement.java:955) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:1168) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep aredStatement.java:3285) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar edStatement.java:3368) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdat e(WrappedPreparedStatement.java:227) at org.jboss.mq.pm.jdbc3.PersistenceManager.addMessage(PersistenceManage r.java:1446) at org.jboss.mq.pm.jdbc3.PersistenceManager.add(PersistenceManager.java: 433) ... 13 more