[jboss-user] [Messaging, JMS & JBossMQ] - Unique Constraint PK_JMS_TRANSACTIONS with 2 JBoss MQ instan

[fgarsombke]

We are setting up a clustered JBoss environment. HA JMS is not an option for us. Each JBoss instance has unique queue names. The two JBoss iinstances are using one Oracle database. When we place a certain amount of load on the systems (like 6-8 msgs/sec) with the two JBoss vms writing to the same database tables we can produce this error:

Thoughts? Using JBoss 4.0.4.GA

TP-Processor33] TransactionImpl.logXAException 2007-06-08 08:24:16,436 
WARN  XAException: tx=TransactionImpl:XidImpl[FormatId=257, 
GlobalId=ngtest1.f4tech.com/78237, 
BranchQual=, localId=78237] errorCode=XAER_RMERR 
org.jboss.mq.SpyXAException: - nested throwable: 
(org.jboss.mq.SpyTransactionRolledBackException: Transaction was rolled back.; - nested 
throwable: (org.jboss.mq.SpyJM
SException: Could not create tx: 26635; - nested throwable: 
(java.sql.SQLException: ORA-00001: unique constraint (NGTEST.PK_JMS_TRANSACTIONS) 
violated
)))
        at org.jboss.mq.SpyXAResource.prepare(SpyXAResource.java:149)
        at 
org.jboss.tm.TransactionImpl$Resource.prepare(TransactionImpl.java:2212)
        at 
org.jboss.tm.TransactionImpl.prepareResources(TransactionImpl.java:1660)
        at 
org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:347)
        at org.jboss.tm.TxManager.commit(TxManager.java:240)
        at 


Thanks in advance.

Franz

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

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