Re: Problem with committing in XA mode

Vlastimil Havranek <vlastimil(dot)havranek(at)xitee(dot)com> writes:
> Here is the log with the settings zou have suggested:

[ extracted... ]

> database_A SID:496f4f4d.454 16:12:27.953 LOG: duration: 0.000 ms
> parse <unnamed>: PREPARE TRANSACTION
> '48801_AOiMyUwnZ6MjBA==_Q3ZoYXZyYW5la2pkYmNEU0xpdmU='
> database_A SID:496f4f4d.454 16:12:27.953 LOG: duration: 0.000 ms bind
> <unnamed>: PREPARE TRANSACTION
> '48801_AOiMyUwnZ6MjBA==_Q3ZoYXZyYW5la2pkYmNEU0xpdmU='
> database_A SID:496f4f4d.454 16:12:27.953 LOG: execute <unnamed>:
> PREPARE TRANSACTION '48801_AOiMyUwnZ6MjBA==_Q3ZoYXZyYW5la2pkYmNEU0xpdmU='
> database_A SID:496f4f4d.454 16:12:27.953 LOG: duration: 0.000 ms
> database_A SID:496f4f4d.454 16:12:28.000 LOG: duration: 0.000 ms
> parse <unnamed>: COMMIT PREPARED
> '48801_AOiMyUwnZ6MjBA==_Q3ZoYXZyYW5la2pkYmNEU0xpdmU='
> database_A SID:496f4f4d.454 16:12:28.000 LOG: duration: 0.000 ms bind
> <unnamed>: COMMIT PREPARED
> '48801_AOiMyUwnZ6MjBA==_Q3ZoYXZyYW5la2pkYmNEU0xpdmU='
> database_A SID:496f4f4d.454 16:12:28.000 LOG: execute <unnamed>:
> COMMIT PREPARED '48801_AOiMyUwnZ6MjBA==_Q3ZoYXZyYW5la2pkYmNEU0xpdmU='
> database_A SID:496f4f4d.454 16:12:28.000 ERROR: prepared transaction
> with identifier "48801_AOiMyUwnZ6MjBA==_Q3ZoYXZyYW5la2pkYmNEU0xpdmU="
> does not exist

Well, this clearly shows the same GID being committed twice --- and by
the same session, so my early thoughts about a race condition are out.

So either Weblogic is broken, or there's a bug in the JDBC driver that
somehow causes this, or we've misread the spec and should allow this.

regards, tom lane