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

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

From: "Dave Page" <dpage(at)postgresql(dot)org>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Dorochevsky,Michel" <michel(dot)dorochevsky(at)softcon(dot)de>, "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3245: PANIC: failed to re-find shared loc k o b j e ct
Date: 2007-04-23 19:12:59
Message-ID: 200704232012590000@76099659 (view raw or flat)
Thread:
Lists: pgsql-bugs

> ------- Original Message -------
> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> To: "Dorochevsky,Michel" <michel(dot)dorochevsky(at)softcon(dot)de>
> Sent: 23/04/07, 19:51:51
> Subject: Re: [BUGS] BUG #3245: PANIC: failed to re-find shared loc k o b j ect
> 
> "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.)

For Michel's benefit; pgAdmin 1.6.3 and below incorrectly display the index OID for unique/pkey constraints, not the constraint OID. Hope this doesn't confuse!

The next version will correct the bug and display the index OID as well for good measure.

/D

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-04-23 19:18:15
Subject: Re: BUG #3245: PANIC: failed to re-find shared loc k o b j e ct
Previous:From: Tom LaneDate: 2007-04-23 18:51:51
Subject: Re: BUG #3245: PANIC: failed to re-find shared loc k o b j ect

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