ORA-02051 from 4 independent processes using XA
Hello,
I am infrequently encountering errors in starting a transaction (tpbegin). In the latest case I observed the following.
1) The XA log reported "ORA-02051: another session in same transaction failed" and "xaosterr: OCITransStart rtn 2051" from 4 independent processes (servers). The processes are in the same GROUP, but otherwise unrelated.
2) Based on the Tuxedo and Application logs I conlude:
- One process was calling tpbegin(), which returned error 14
- One process was starting an AUTOTRAN transaction. The process itself did not report any errors, but the client reported error 14 from tpcall().
- Two processes were starting a new transaction branch. The processes themselves did not report any errors, but the calling servers reported error 10 from tpcall(). In both cases the transaction was started by a TMQFORWARD, an intermediary process reported the tpcall error, and the final process logged the XA error.
I am looking for some hints on how to investigate this further. Because it happens infrequently, turning on more logging (for extended periods) is not a practical option.
Thanks...
Roger