From: | Michel Pelletier <pelletier(dot)michel(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(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:40:46 |
Message-ID: | CACxu=v+aj55jQvozUfrDwvLjbBcUnyG0uRa19sWQ0MNsHvXt7w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Jul 9, 2020 at 5:32 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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.
>
Unfortunately still no refs there:
dev=> set enable_indexscan = off;
SET
dev=> set enable_bitmapscan = off;
SET
dev=> select * from pg_depend \g | grep 297108
dev=> select * from pg_depend where classid = 297108::oid or refclassid =
297108::oid;
classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype
---------+-------+----------+------------+----------+-------------+---------
(0 rows)
dev=> explain select * from pg_depend where classid = 297108::oid or
refclassid = 297108::oid;
QUERY PLAN
-----------------------------------------------------------------------
Seq Scan on pg_depend (cost=0.00..336.87 rows=2 width=25)
Filter: ((classid = '297108'::oid) OR (refclassid = '297108'::oid))
(2 rows)
-Michel
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michel Pelletier | 2020-07-10 04:31:40 | Re: invalid non-zero objectSubId for object class |
Previous Message | Michel Pelletier | 2020-07-10 00:37:25 | Re: invalid non-zero objectSubId for object class |