Re: Problem with committing in XA mode

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vlastimil Havranek <vlastimil(dot)havranek(at)xitee(dot)com>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problem with committing in XA mode
Date: 2009-01-15 17:33:07
Message-ID: 8187.1232040787@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Heikki Linnakangas 2009-01-15 17:49:26 Re: Problem with committing in XA mode
Previous Message Vlastimil Havranek 2009-01-15 16:57:44 Re: Problem with committing in XA mode