10 Replies Latest reply on Apr 9, 2014 3:32 AM by xkylex

    (Periodic Recovery) ARJUNA016027 occurs on long-running jbatch job

    xkylex

      I have a long-running jbatch job and this exception occurs several times.

       

      What is the cause of this exception?

      Or I didn't found any side-effects so can I just ignore this?

       

      Environment:

      • WildFly 8.0.0.Final
      • jBeret-1.0.1.CR2-SNAPSHOT
      • PostgreSQL 9.2.6
      • postgresql-9.3-1100.jdbc41.jar

       

      I had setup XA datasources that both of application and jberet job repository. they have their own database on the same PostgreSQL instance. also "max_prepared_transactions = 100" (same number to max_connections) of postgresql.conf but it didn't help.

       

      2014-03-17 20:34:09,090 WARN  [com.arjuna.ats.jta] (Periodic Recovery) ARJUNA016027: Local XARecoveryModule.xaRecovery got XA exception XAException.XAER_NOTA: org.postgresql.xa.PGXAException: 準備トランザクションのロールバックエラー

              at org.postgresql.xa.PGXAConnection.rollback(PGXAConnection.java:418)

              at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.rollback(XAManagedConnection.java:346)

              at org.jboss.jca.core.tx.jbossts.XAResourceWrapperImpl.rollback(XAResourceWrapperImpl.java:186)

              at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.handleOrphan(XARecoveryModule.java:786) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]

              at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.xaRecoverySecondPass(XARecoveryModule.java:692) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]

              at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.bottomUpRecovery(XARecoveryModule.java:431) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]

              at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkSecondPass(XARecoveryModule.java:212) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]

              at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:789) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]

              at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:371) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]

      Caused by: org.postgresql.util.PSQLException: ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//CgABCECroNhTJq/xAAWSZzE=_AAAAAAAAAAAAAP//CgABCECroNhTJq/xAAWS4wAAAAEAAAAA" does not exist

              at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)

              at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)

              at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

              at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)

              at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)

              at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:331)

              at org.postgresql.xa.PGXAConnection.rollback(PGXAConnection.java:406)

              ... 8 more