The following bug has been logged online:
Bug reference: 5139
Logged by: Thomas Kotzian
Email address: thomas.kotzian@repromedia.at
PostgreSQL version: 8.4.1
Operating system: Linux
Description: 2pc behaves differently on 8.3 and 8.4
Details:
i upgraded from 8.3 -> 8.4. we develop an application in java with jboss
4.2.3 and use the XA features. with 8.3 everything works, with 8.4 not.i
have tested the jdbc driver 8.3 and 8.4 (make no difference in any
combination). only downgrading to 8.3 works.
snapshot of the error messages:
20:37:17,535 WARN [loggerI18N]
[com.arjuna.ats.internal.jta.resources.arjunacore.preparefailed]
[com.arjuna.ats.internal.jta.resources.arjunacore.preparefailed]
XAResourceRecord.prepare - prepare failed with exception
XAException.XAER_RMERR
20:37:17,538 WARN [arjLoggerI18N]
[com.arjuna.ats.arjuna.coordinator.BasicAction_50] - Prepare phase of
action 7f000101:abe6:4ae0a618:41 received heuristic decision:
TwoPhaseOutcome.HEURISTIC_HAZARD
20:37:17,538 WARN [arjLoggerI18N]
[com.arjuna.ats.arjuna.coordinator.BasicAction_36] - BasicAction.End() -
prepare phase of action-id 7f000101:abe6:4ae0a618:41 failed.
20:37:17,538 WARN [arjLoggerI18N]
[com.arjuna.ats.arjuna.coordinator.BasicAction_37] - Received heuristic:
TwoPhaseOutcome.HEURISTIC_HAZARD .
20:37:17,538 WARN [arjLoggerI18N]
[com.arjuna.ats.arjuna.coordinator.BasicAction_38] - Action Aborting
20:37:17,586 ERROR [[haltestellen]] Servlet.service() for servlet
haltestellen threw exception
javax.transaction.HeuristicMixedException
at
com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAn
dDisassociate(TransactionImple.java:1397)
at
com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(Ba
seTransaction.java:135)
at
com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactio
nManagerDelegate.java:87)
at
org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClie
ntUserTransaction.java:140)
at
org.springframework.transaction.jta.JtaTransactionManager.doCommit(JtaTransa
ctionManager.java:1028)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.p
rocessCommit(AbstractPlatformTransactionManager.java:732)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.c
ommit(AbstractPlatformTransactionManager.java:701)
what changes from 8.3 -> 8.4 could have caused this behaviour?
some issues are reported:
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4242404#4242404
http://www.jpox.org/servlet/forum/viewthread_thread,5816
http://www.nuxeo.org/discussions/message.jspa?messageID=8560
thank you!
