[jboss-user] Problems with JBoss 4.2, MySQL and XAResources

[Juliano DeCarvalho]

Hello all,

I apologize if this is not the correct place to ask this question, and if
not please let me know where I can submit this instead. We are having some
intermittent problems with JBoss 4.2, MySQL and XAResources. Every few
days our servers crash because the application is unable to get new MySQL
connections. Here is a portion of the exception:

-------------------
2014-04-09 06:26:16,640 ERROR
[com.linebuster.server.ServiceTransactionManagerBean] (http-[OMITTED])
System exception
java.lang.RuntimeException: javax.transaction.RollbackException:
[com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted]
[com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted]
Can't commit because the transaction is in aborted state
at
org.jboss.aspects.tx.TxPolicy.handleEndTransactionException(TxPolicy.java:198)
at org.jboss.aspects.tx.TxPolicy.endTransaction(TxPolicy.java:180)

[SNIP]

Caused by: javax.transaction.RollbackException:
[com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted]
[com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted]
Can't commit because the transaction is in aborted state
at
com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1401)
at
com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:135)

[SNIP]

2014-04-09 06:26:33,470 WARN [com.arjuna.ats.jta.logging.loggerI18N]
(http-[OMITTED])
[com.arjuna.ats.internal.jta.transaction.arjunacore.enliststarterror]
[com.arjuna.ats.internal.jta.transaction.arjunacore.enliststarterror]
TransactionImple.enlistResource - XAResource.start returned:
[com.arjuna.ats.jta.utils.unknownerrorcode] Unknown error code:0 for <
131075, 31, 29, 1-2e147705:aea1:534531a3:119ac42e147705:aea1:534531a3:119ac9

[SNIP]
-------------------

To me at least, this seems to occur because the DB connections we have
pooled go into the ABORT state, but I 'm not sure as to why. I don't see
any problems prior to these exceptions that would lead me to the root of
the problem. It's worth noting that this particular server does not have
heavy user loads.

I have attached a snippet of the stack trace, as well as our datasource
configurations. I tried to research the error messages, but only found a
handful of people having similar issues, and no response or replies to
their posts. We are running the following software versions:

OS: Ubuntu Linux 2.6.32-41-server (x86_64)
Java: 1.6.0_24-b07
JBoss: 4.2.3.GA
MYSQL: 5.1.63 (x86_64)

I would really appreciate any insight someone may have on this issue.
Please let me know if there's any other information you guys need at this
time. Thank you,

-Juliano DeCarvalho