From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Michel Pelletier <pelletier(dot)michel(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: invalid non-zero objectSubId for object class |
Date: | 2020-07-09 23:18:00 |
Message-ID: | 2012735.1594336680@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Michel Pelletier <pelletier(dot)michel(at)gmail(dot)com> writes:
> 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
This looks like corrupt data in pg_depend, specifically an entry or
entries with classid or refclassid = 297108, which should not happen
(the classid should always be the OID of one of a short list of system
catalogs). You could try poking around in pg_depend to see if you
can identify any obviously-bogus rows.
No idea how it got that way. Have you had any database crashes or the
like?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | James Sewell | 2020-07-10 00:05:52 | Safe switchover |
Previous Message | Michel Pelletier | 2020-07-09 23:10:27 | invalid non-zero objectSubId for object class |