Question: do you have any leftover files in $PGDATA/pg_twophase ?
I'm wondering why the log contains no warning messages about stale
two-phase state files. It looks to me like the system should have
found the two-phase file still there upon restart, but the transaction
should have been marked already committed.
BTW, can you tell whether the failing transactions actually were committed
--- are their effects still visible in the database?
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Dorochevsky,Michel||Date: 2007-04-21 19:38:35|
|Subject: Re: BUG #3245: PANIC: failed to re-find shared lock ob ject |
|Previous:||From: Dorochevsky,Michel||Date: 2007-04-21 16:30:02|
|Subject: Re: BUG #3245: PANIC: failed to re-find shared lock object |