Duplicate key in JMS_MESSAGES
kevindaly Apr 22, 2004 6:04 AMHi,
We are experiencing the below exception on our JBoss 3.2.1 Server. Other messages in the forum have attributed this exception to having
more than one JBoss instance interacting with the JMS_Messages file, this
is not the case on our production server.
Could someone articulate what the .-2147483616 (see exception trace) in TOPIC.GPRS.KermitMessageClient.-2147483616 refers to. We have
a KermitMessageClient destination configured within JMS but the
"temporary" destinations are continually appearing in the messages file
and are the source of the exception. We have never seen any contention
on the actual KermitMessageClient destination.
The message
http://www.jboss.org/index.html?module=bb&op=viewtopic&t=48760
seems very like the problem we are experiencing, could it be the same
bug.
We are considering deleting the temporary destination from the production
database but are reluctant to do so until we know what these destinations
refer to.
The system has been in production for several months now and the error is getting increasingly frequent which again is somethinh we don't understand, the application code has been very stable in that time.
Regards.
- Kevin.
2004-04-21 10:03:35,968 [MessageListenerThread - GPRS] ERROR com.celtrak.jms.Publisher - org.jboss.mq.SpyJMSException: Could not store message: 142010 msg=78714 hard NOT_STORED PERSISTENT queue=TOPIC.GPRS.KermitMessageClient.-2147483616 priority=4 hashCode=12204633; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK__JMS_MESSAGES__095F58DF'. Cannot insert duplicate key in object 'JMS_MESSAGES'.)
2004-04-21 10:03:35,968 [MessageListenerThread - GPRS] ERROR com.celtrak.jms.Publisher - org.jboss.mq.pm.jdbc2.PersistenceManager.saveToStorage(PersistenceManager.java:1164)
org.jboss.mq.server.MessageCache.saveToStorage(MessageCache.java:411)
org.jboss.mq.server.MessageReference.makeSoft(MessageReference.java:229)
org.jboss.mq.server.MessageCache.validateSoftReferenceDepth(MessageCache.java:354)
org.jboss.mq.server.MessageCache.addInternal(MessageCache.java:133)
org.jboss.mq.server.MessageCache.add(MessageCache.java:102)
org.jboss.mq.server.JMSTopic.addMessage(JMSTopic.java:282)
org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:404)
org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:384)
org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:135)
org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:162)
org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:234)
org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:137)
org.jboss.mq.il.uil2.ServerSocketManagerHandler.handleMsg(ServerSocketManagerHandler.java:86)
org.jboss.mq.il.uil2.SocketManager$ReadTask.handleMsg(SocketManager.java:355)
org.jboss.mq.il.uil2.msgs.BaseMsg.run(BaseMsg.java:377)
EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:732)
java.lang.Thread.run(Thread.java:536)
2