[jboss-user] [Messaging, JMS & JBossMQ] - Re: JMS error with SQLServer
marney
do-not-reply at jboss.com
Wed May 14 17:04:30 EDT 2008
I am seeing this issue on a production server running JBoss 4.2.2 (again, MS SQL Server database). I looked in JBoss JIRA and did not see anything addressing this issue. Portion of our app's trace:
anonymous wrote :
| 14 May 2008 14:58:08,352 DEBUG [TMMessagingProxy http-0.0.0.0-8082-1] Sending an asynch JMS message: LogStoreHandler.createAuditEntry
| 14 May 2008 14:58:08,352 INFO [JNDIObjectFactory http-0.0.0.0-8082-1] Looking up queue/AuditQueue
| 14 May 2008 14:58:08,352 INFO [JNDIObjectFactory http-0.0.0.0-8082-1] About to add the following object to the JNDI reference cache: queue/AuditQueue
| 14 May 2008 14:58:08,352 ERROR [TMMessagingProxy http-0.0.0.0-8082-1] Error sending aynch message
| org.jboss.mq.SpyJMSException: Could not store message: 3606 msg=0 hard NOT_STORED NON_PERSISTENT queue=TOPIC.ecJobTopic.ID:2.-2147483648 priority=4 lateClone=false hashCode=4669730; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key row in object 'dbo.JMS_MESSAGES' with unique index 'JMS_MESSAGES_IDX'.)
| at org.jboss.mq.pm.jdbc2.PersistenceManager.saveToStorage(PersistenceManager.java:1638)
| at org.jboss.mq.server.MessageCache.saveToStorage(MessageCache.java:420)
| at org.jboss.mq.server.MessageReference.makeSoft(MessageReference.java:312)
| at org.jboss.mq.server.MessageCache.validateSoftReferenceDepth(MessageCache.java:367)
| at org.jboss.mq.server.MessageCache.addInternal(MessageCache.java:158)
| at org.jboss.mq.server.MessageCache.add(MessageCache.java:128)
| at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:179)
| at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:415)
| at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:399)
| at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:106)
| at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:168)
| at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:226)
| at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:112)
| at org.jboss.mq.il.jvm.JVMServerIL.addMessage(JVMServerIL.java:101)
| at org.jboss.mq.Connection.sendToServer(Connection.java:920)
| at org.jboss.mq.SpySession.sendMessage(SpySession.java:924)
| at org.jboss.mq.SpyMessageProducer.send(SpyMessageProducer.java:272)
| at org.jboss.mq.SpyMessageProducer.send(SpyMessageProducer.java:219)
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4150886#4150886
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4150886
More information about the jboss-user
mailing list