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
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 |
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) |
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 |