[jboss-user] [Messaging, JMS & JBossMQ] - Unique Constraint Error sending JMS Messages
Every couple of weeks I start getting this error message in my Java software and I have to
restart the whole JBoss application.
I am running 4.0.3 on Solaris 9. Has anyone seen this before or have any ideas on why it
keeps happening. I checked the logs but there seems to be a gap from the 7th to the 10th
Oct ???
Thanks
org.jboss.mq.SpyJMSException: Could not store message: 16948513 msg=67670 hard NOT_STORED
PERSISTENT queue=TOPIC.DBEvent.ID:3763.-2147483648 priority=4 lateClone=false
hashCode=3993794; - nested throwable: (java.sql.SQLException: Unique constraint violation:
in statement [INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP)
VALUES(?,?,?,?,?)])
at
org.jboss.mq.pm.jdbc2.PersistenceManager.saveToStorage(PersistenceManager.java:1349)
at org.jboss.mq.server.MessageCache.saveToStorage(MessageCache.java:407)
at org.jboss.mq.server.MessageReference.makeSoft(MessageReference.java:297)
at
org.jboss.mq.server.MessageCache.validateSoftReferenceDepth(MessageCache.java:354)
at org.jboss.mq.server.MessageCache.addInternal(MessageCache.java:145)
at org.jboss.mq.server.MessageCache.add(MessageCache.java:115)
at org.jboss.mq.server.JMSTopic.addMessage(JMSTopic.java:393)
at
org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:397)
at
org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:373)
at
org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:136)
at
org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.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(ServerSocketManagerHandler.java:92)
at org.jboss.mq.il.uil2.SocketManager$ReadTask.handleMsg(SocketManager.java:369)
at org.jboss.mq.il.uil2.msgs.BaseMsg.run(BaseMsg.java:377)
at
EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:748)
at java.lang.Thread.run(Thread.java:536)
Caused by: java.sql.SQLException: Unique constraint violation: in statement [INSERT INTO
JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?)]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:227)
at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:904)
at
org.jboss.mq.pm.jdbc2.PersistenceManager.saveToStorage(PersistenceManager.java:1335)
... 17 more
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3976927#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...