Re: invalid non-zero objectSubId for object class - Mailing list pgsql-general

From Michel Pelletier
Subject Re: invalid non-zero objectSubId for object class
Date
Msg-id CACxu=vLp67TETPvqFknqw1dFwLKuaSEssGueqD4BousFY0hGwA@mail.gmail.com
Whole thread Raw
In response to Re: invalid non-zero objectSubId for object class  (Michel Pelletier <pelletier.michel@gmail.com>)
Responses Re: invalid non-zero objectSubId for object class
List pgsql-general


I restored a snapshot and I can drop the tables there, so we'll likely proceed  to swap the replicas over tomorrow.  I have this corrupted instance i can continue to debug on if necessary.  There seem to be some other issues now that we're investigating, like a max(timestamp) query on the old instance is doing a seqscan on all the partitions instead of using an index that's there, the new instance from the snapshot correctly uses the index, so I suspect further corruption.

Thanks for your help!

-Michel

pgsql-general by date:

Previous
From: Michel Pelletier
Date:
Subject: Re: invalid non-zero objectSubId for object class
Next
From: Brajendra Pratap Singh
Date:
Subject: Postgresql Backup Encryption