Re: BUG #3245: PANIC: failed to re-find shared loc k ob je ct

From: "Dorochevsky,Michel" <michel(dot)dorochevsky(at)softcon(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Dave Page <dpage(at)postgresql(dot)org>, 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 ob je ct
Date: 2007-04-23 14:28:03
Message-ID: C12B71B21705A04C9B9C3E9300430CAFA970EA@jupiter.softcon-its.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> Von: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> So, which of your tables has OID 417227? Easiest way to check is
> select 417227::regclass
>
Tom,

Currently a table with name
requireditemtypes_mill7b7c7621
has the object id 417227.

I did restart the DB server in the meantime several times.
I assume that will not change OIDs of existing tables.

I am not 100 percent sure whether I dropped and recreated all tables in the
meantime. Would dropping and recreating the tables reuse old OIDs that
became free? If so the OID might got assigned to another table.

I certainly did not drop the schema in the meantime.

Shall we send you the database?

Best Regards
-- Michel

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-04-23 14:42:42 Re: BUG #3245: PANIC: failed to re-find shared loc k ob je ct
Previous Message Tom Lane 2007-04-23 14:11:53 Re: BUG #3245: PANIC: failed to re-find shared loc k ob je ct