invalid non-zero objectSubId for object class

From: Michel Pelletier <pelletier(dot)michel(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: invalid non-zero objectSubId for object class
Date: 2020-07-09 23:10:27
Message-ID: CACxu=vLUD4WRwbFEGXTTdqqAiYTDn5JZ+R9cxJnsvQPpPffm=w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On a 12.3 AWS RDS instance, I get the following error when trying to drop
either of two tables:

dev=> drop table current_flight;
ERROR: invalid non-zero objectSubId for object class 297108
dev=> drop table flight;
ERROR: invalid non-zero objectSubId for object class 297108

I can create and drop new tables, but these two I cannot drop.

Both tables were at one point replicated using pglogical, but I've removed
them from their replication sets and nothing depends on them that I can
see. The replication of other tables is still proceeding normally.

Anyone have any thoughts on this? The db was also upgraded seemingly
successfully from 12.2 a couple of days ago and otherwise seems to be
working fine.

Thanks for any pointers!

-Michel

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-07-09 23:18:00 Re: invalid non-zero objectSubId for object class
Previous Message Tim Cross 2020-07-09 23:07:51 Re: Efficiently advancing a sequence without risking it going backwards.