[jboss-user] [JBossMQ] - Re: JMS Persistence Manager Exception
do-not-reply at jboss.com
Fri Apr 24 14:32:24 EDT 2009
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.
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
More information about the jboss-user