0 Replies Latest reply on Oct 27, 2005 9:26 AM by srose

    unique contraint violation when writing messages to DB

    srose

      Im 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