From: | Prakash Itnal <prakash074(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [ISSUE] pg_dump: schema with OID 0 does not exist |
Date: | 2014-03-11 04:23:26 |
Message-ID: | CAHC5u7_+DXejgPVV_-VYqbO9FCxow6Q0UDpNeK82seGHn91EdQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
Can someone confirm is this really an issue? or any reasons for missing
rows?
On Tue, Feb 25, 2014 at 3:51 PM, Prakash Itnal <prakash074(at)gmail(dot)com> wrote:
> Hi,
>
> Recently we observed below errors while taking dump after upgrading from
> 9.0.13 to 9.1.9.
>
> pg_dump: schema with OID 0 does not exist
>
> I referred similar issues reported previously (
> http://www.postgresql.org/message-id/CAGWYGjXRJj=zuGEJV0ckVn4Zf9Hb92Q+7e3aQFCVbGBMb9Z+ZQ@mail.gmail.com)
> and get issue resolved after identifying and inserting some of the missing
> rows from *pg_opclass* table. Below are the rows that are missed after
> upgrade (from *pg_opclass *table):
>
> 405 | aclitem_ops | 11 | 10 | 2235
> | 1033 | t | 0
>
> 783 | box_ops | 11 | 10 | 2593
> | 603 | t | 0
>
> 783 | point_ops | 11 | 10 | 1029
> | 600 | t | 603
>
> 783 | poly_ops | 11 | 10 | 2594
> | 604 | t | 603
>
> 783 | circle_ops | 11 | 10 | 2595
> | 718 | t | 603
>
> 2742 | _int4_ops | 11 | 10 | 2745
> | 1007 | t | 23
>
> 2742 | _text_ops | 11 | 10 | 2745
> | 1009 | t | 25
>
> 2742 | _abstime_ops | 11 | 10 | 2745
> | 1023 | t | 702
>
>
> Can some one help me to understand whether it is an issue? If not how and
> why these rows got disappeared after upgrade?
>
> Since we have an fully automated environment we do not encourage manual
> intervention. So I am trying to understand how can we handle these issues.
>
> --
> Cheers,
> Prakash
>
--
Cheers,
Prakash
From | Date | Subject | |
---|---|---|---|
Next Message | KONDO Mitsumasa | 2014-03-11 04:49:38 | Re: gaussian distribution pgbench |
Previous Message | Amit Kapila | 2014-03-11 03:59:40 | Re: issue log message to suggest VACUUM FULL if a table is nearly empty |