From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | Michel Pelletier <pelletier(dot)michel(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: invalid non-zero objectSubId for object class |
Date: | 2020-07-10 00:32:37 |
Message-ID: | 2016431.1594341157@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
> On 2020-Jul-09, Michel Pelletier wrote:
>> I don't seem to have either:
>>
>> dev=> select * from pg_depend where classid = 297108 or refclassid = 297108;
>> classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype
>> ---------+-------+----------+------------+----------+-------------+---------
>> (0 rows)
> Maybe try looking in pg_shdepend? Or pg_description?
I think it has to be pg_depend, because there'd be no reason to
be calling getObjectClass() on a entry from one of those other
catalogs during a DROP TABLE.
So my thoughts are now turning towards there being corruption
in pg_depend's indexes as well as the heap. Try doing the above
query after turning enable_indexscan and enable_bitmapscan off.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Michel Pelletier | 2020-07-10 00:37:25 | Re: invalid non-zero objectSubId for object class |
Previous Message | Jeremy Schneider | 2020-07-10 00:27:33 | Re: Efficiently advancing a sequence without risking it going backwards. |