[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