Re: BUG #3245: PANIC: failed to re-find shared loc k ob ject - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3245: PANIC: failed to re-find shared loc k ob ject
Date
Msg-id 16389.1177208610@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #3245: PANIC: failed to re-find shared loc k ob ject  ("Dorochevsky,Michel" <michel.dorochevsky@softcon.de>)
Responses Re: BUG #3245: PANIC: failed to re-find shared loc k ob ject
List pgsql-bugs
"Dorochevsky,Michel" <michel.dorochevsky@softcon.de> writes:
> The failing transaction is visible in the database after restart, I have
> checked three of the last inserts, e.g.

Good, at least we're not losing data ;-).  But I expected that because
this PANIC must be occurring after the RecordTransactionCommitPrepared
step.

> I have no leftover file in $PGDATA/pg_twophase, it is empty.

[ digs in code some more... ]  Oh, I see how that happens: the 2PC
state file is removed when the XLOG_XACT_COMMIT_PREPARED xlog entry
is replayed, so the various code paths that might emit a warning
won't be reached.

Heikki, have you been paying attention to this thread?  You have any
idea what's happening?  The whole thing seems pretty unexplainable
to me, especially since Michel's log shows this happening without any
concurrent activity that might confuse matters.  I confess bafflement.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Marcin Waldowski
Date:
Subject: Re: BUG #3242: FATAL: could not unlock semaphore: error code 298
Next
From: Magnus Hagander
Date:
Subject: Re: BUG #3242: FATAL: could not unlock semaphore: error code 298