Problems with JBoss 4.2, MySQL, and XAResources

[jdecarvalho]

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

[nzhiv]

Hi,

It looks like your transaction was aborted by timeout.
Check you timeout settings and how long your transaction was.

Nikolay