[Info-ingres] What does XA_END mean in the SC930 log?

[Karl and Betty Schendel]

On Dec 21, 2017, at 4:31 PM, Roy Hann <roy.hann at rationalcommerce.com> wrote:
> 
> Hmmm.
> 
> The reason I was asking is because I am seeing stuff like this:
> 
> EQY:1513854718/299769010:1::50:(232:0):0:1
> XA_END:1513854718/620735450:XID(00020005:29:36:00000000:00000000:0000FFFF:0AD01E32:BD045DF2:5A3A5A00:00008CD9:31000000:00000000:000000FF:FF0AD01E:32BD045D:F25A3A5A:0000008C:DC00000
> 0:00000000:00000000:XA):00000000:0
> EQY:1513854718/620833715:-1::50:(232:0):0:0
> XA_PREP:1513854718/655271335:XID(00020005:29:36:00000000:00000000:0000FFFF:0AD01E32:BD045DF2:5A3A5A00:00008CD9:31000000:00000000:000000FF:FF0AD01E:32BD045D:F25A3A5A:0000008C:DC0000
> 00:00000000:00000000:XA):00000000:0
> EQY:1513854718/655330225:-1::50:(232:31):0:0
> XA_COMM:1513854718/659405680:XID(00020005:29:36:00000000:00000000:0000FFFF:0AD01E32:BD045DF2:5A3A5A00:00008CD9:31000000:00000000:000000FF:FF0AD01E:32BD045D:F25A3A5A:0000008C:DC0000
> 00:00000000:00000000:XA):00000000:0
> EQY:1513854718/659471260:-1::50:(232:31):0:0
> 
> The thing I'm focussing on is the last field of the EQY record, which
> is the transaction state indicator (something I added at one of the
> sprints a couple of years ago).
> 
> The first EQY shows there is a transaction in progress; the indicator
> is 1. We then see an XA_END--as a result of who-knows-what (I don't do
> JDBC)--then the following EQY record shows the transaction has
> ended because the state indicator is 0.

The EQY transaction state indicator comes from QEF, not DMF.  It seems
that XA_END ends the transaction as far as QEF is concerned, but DMF must still
know about it, since the XA_PREP and XA_COMMIT functions go more or less
directly to DMF. 

It's hard for me to say for sure, since I know very little about XA transactions,
but my guess is that the application is doing what it's supposed to do.

Karl