Last week, in a system running JBoss 4.2.3/EJB 2/JMS, I had four HeuristicMixedExceptions. These were around transactions where a message is added to a JMS queue and the same message stored in a database. It's not immediately clear from the database state and the messages that were retrieved from the queue, what resources were committed and what were rolledback, let alone what the cause may have been.
Are there a standard set of steps that should be followed when receiving one of these, to diagnose the cause?
Thanks in advance
What stack traces were in your log? I haven't checked the 4.2.3 version yet but I know in most current versions of JBTM if an XAResource returns a heuristic it will be logged with the XAResource::toString()
Which resources and versions of those are you using? Are you using any framework intermediaries?