Thread: BUG #5271: pg_dump: schema with OID 22519 does not exist

BUG #5271: pg_dump: schema with OID 22519 does not exist

From
"Michael Tenenbaum"
Date:
The following bug has been logged online:

Bug reference:      5271
Logged by:          Michael Tenenbaum
Email address:      michael@strategic-techs.com
PostgreSQL version: 8.3.9
Operating system:   Gentoo Linux
Description:        pg_dump: schema with OID 22519 does not exist
Details:

According to the posts I picked up from a Google search, this is a bug that
never seems to get fixed.

I followed Tom's advice and deleted entries in

pg_type and pg_class

and pg_dump is working ok.

The object was a table in a development system with only a few entries.
hardly anything was written to the table in the past few weeks, but the
daily pg_dump was working fine until this evening.

Re: BUG #5271: pg_dump: schema with OID 22519 does not exist

From
Robert Haas
Date:
On Mon, Jan 11, 2010 at 2:00 AM, Michael Tenenbaum
<michael@strategic-techs.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05271
> Logged by: =A0 =A0 =A0 =A0 =A0Michael Tenenbaum
> Email address: =A0 =A0 =A0michael@strategic-techs.com
> PostgreSQL version: 8.3.9
> Operating system: =A0 Gentoo Linux
> Description: =A0 =A0 =A0 =A0pg_dump: schema with OID 22519 does not exist
> Details:
>
> According to the posts I picked up from a Google search, this is a bug th=
at
> never seems to get fixed.
>
> I followed Tom's advice and deleted entries in
>
> pg_type and pg_class
>
> and pg_dump is working ok.
>
> The object was a table in a development system with only a few entries.
> hardly anything was written to the table in the past few weeks, but the
> daily pg_dump was working fine until this evening.

Maybe I should be smarter than I am, but when you say that "this" is a
bug that never seems to get fixed, I'm not sure what "this" is.  It
sounds like you're talking about system catalog corruption of some
sort, but without more details it's hard to speculate as to what might
have happened.

Unfortunately, it also sounds like you've destroyed all the
evidence... I don't suppose you have a copy of a version of the
database where this is still broken?

...Robert