Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackerspgsql-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

pgsql-hackers by date

Next:From: Josh BerkusDate: 2007-04-23 19:24:15
Subject: Wild idea: 9.0?
Previous:From: Gregory StarkDate: 2007-04-23 18:46:52
Subject: Re: TODO idea - implicit constraints across child tables with a common column as primary key (but obviously not a shared index)

pgsql-bugs by date

Next:From: Dave PageDate: 2007-04-23 19:12:59
Subject: Re: BUG #3245: PANIC: failed to re-find shared loc k o b j e ct
Previous:From: Dorochevsky,MichelDate: 2007-04-23 17:28:22
Subject: Re: BUG #3245: PANIC: failed to re-find shared loc k o b ject

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group