[jboss-user] [JBossMQ] - Re: JMS Persistence Manager Exception

[usubhash]

Hi Adrian,
         I ran into the same situation where I have load balancer environment and both instances are trying to create entry into JMS_MESSAGES table with the same primary key. The exception that I am getting is :
    org.jboss.mq.SpyJMSException: Could not store message: 4276 msg=4275 hard NOT_STORED PERSISTENT queue=QUEUE.DLQ priority=4 lateClone=false hashCode=10168191; - nested throwable: (com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '4275-QUEUE.DLQ' for key 'PRIMARY')
  | Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '4275-QUEUE.DLQ' for key 'PRIMARY'
  |         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
  |         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)

      I am using JBoss 4.2.3 and MySql to store JMS messages. I could not understand about creating multiple persistence managers. I am also wondering as this is a thread of 5 years old, you might have come across a better solution.
       Please let me know.

Thanks,
Subhash


View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4226686#4226686

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4226686