Hey, I'm new to this forum and I hope someone can help me.
The problem is with Bonita 7.10.5 on PostgreSQL 11 (also 12) and it was not present in earlier versions of Bonita. When I restart only the PostgreSQL service without restarting Bonita, the following exception is logged into the Cataline log approximately every 2 minutes:
WARN: com.arjuna.ats.jta ARJUNA016027: Local XARecoveryModule.xaRecovery got XA exception XAException.XAER_RMERR
org.postgresql.xa.PGXAException: Error during recover
at org.postgresql.xa.PGXAConnection.recover(PGXAConnection.java:416)
at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.xaRecoveryFirstPass(XARecoveryModule.java:634)
at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:226)
at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:171)
at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:770)
at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:382)
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:783)
at org.postgresql.jdbc.PgConnection.createStatement(PgConnection.java:1673)
at org.postgresql.jdbc.PgConnection.createStatement(PgConnection.java:366)
at org.postgresql.xa.PGXAConnection.recover(PGXAConnection.java:393)
... 5 more
There is no information about the error in the other log files. The error disappears only after Bonita is restarted.
The text of the error points to Narayana in the Bonita Tomcat bundle. I found only threads about the error:
https://developer.jboss.org/thread/145545
https://developer.jboss.org/thread/175369
But these are very old threads and the bug they describe has probably been fixed long ago.