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

"Dorochevsky,Michel" <michel(dot)dorochevsky(at)softcon(dot)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