Re: BUG #3245: PANIC: failed to re-find shared loc k o b j ect

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, "Dorochevsky, Michel" <michel(dot)dorochevsky(at)softcon(dot)de>, pgsql-bugs(at)postgresql(dot)org, Dave Page <dpage(at)postgresql(dot)org>
Subject: Re: BUG #3245: PANIC: failed to re-find shared loc k o b j ect
Date: 2007-04-23 21:44:34
Message-ID: 13895.1177364674@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers pgsql-patches

I wrote:
> Heikki Linnakangas <heikki(at)enterprisedb(dot)com> writes:
>> Dave, would you please create a new binary with the attached patch? And
>> LOCK_DEBUG and assertions and debug enabled.

> Also, it would be worth adding "lockmode" to the set of things printed
> by the panic message in the patch I sent earlier.

Also: as long as we are building a custom-hacked executable to probe
into this, let's hack it to not remove the 2PC state file, so we can
double check what's really in there. I believe what you'd need to
remove is the RemoveTwoPhaseFile calls at twophase.c line 1583 (where
it thinks it's "stale") and xact.c line 4223 (where it's replaying a
XLOG_XACT_COMMIT_PREPARED WAL record).

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2007-04-23 22:15:24 Re: BUG #3245: PANIC: failed to re-find shared loc k o b j ect
Previous Message Tom Lane 2007-04-23 21:34:34 Re: BUG #3245: PANIC: failed to re-find shared loc k o b j ect

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2007-04-23 21:46:45 Re: [HACKERS] Full page writes improvement, code update
Previous Message Tom Lane 2007-04-23 21:38:19 Re: Improving deadlock error messages

Browse pgsql-patches by date

  From Date Subject
Next Message Josh Berkus 2007-04-23 21:46:45 Re: [HACKERS] Full page writes improvement, code update
Previous Message Tom Lane 2007-04-23 21:34:34 Re: BUG #3245: PANIC: failed to re-find shared loc k o b j ect