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: "Dorochevsky,Michel" <michel(dot)dorochevsky(at)softcon(dot)de>
Cc: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, 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 18:51:51
Message-ID: 11864.1177354311@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers pgsql-patches

"Dorochevsky,Michel" <michel(dot)dorochevsky(at)softcon(dot)de> writes:
> I am not used to the command line tools. So I made a backup
> using the pgadmin GUI. I selected options 'PLAIN format', 'with OIDs' and
> 'schema only'. See
> www.dorochevsky.de/infos/TestSchema.txt
> I hope that is what you needed.

Yeah, this is great, particularly since it includes the OIDs. However,
the OIDs don't seem to entirely match up with the LOCK_DEBUG output.
I'm wondering if somehow we're locking the wrong OIDs? Hard to believe
a bug like that could've escaped detection though. Still trying to
trace through it to see where things first go wrong. (If anyone else is
looking at this, note that a constraint's index will generally have an
OID one less than the constraint, so you can infer the OIDs of indexes
that aren't explicitly given in the dump.)

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2007-04-23 19:12:59 Re: BUG #3245: PANIC: failed to re-find shared loc k o b j e ct
Previous Message Dorochevsky,Michel 2007-04-23 17:28:22 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 19:24:15 Wild idea: 9.0?
Previous Message Gregory Stark 2007-04-23 18:46:52 Re: TODO idea - implicit constraints across child tables with a common column as primary key (but obviously not a shared index)

Browse pgsql-patches by date

  From Date Subject
Next Message Heikki Linnakangas 2007-04-23 19:30:44 Re: BUG #3245: PANIC: failed to re-find shared loc k o b j ect
Previous Message Dorochevsky,Michel 2007-04-23 17:28:22 Re: BUG #3245: PANIC: failed to re-find shared loc k o b j ect