On Tue, 2021-12-14 at 23:12 +0530, Daulat wrote: > Will it work if we rebuild that index ? Looks like it is an issue with the index. > > On Tue, Dec 14, 2021 at 10:55 PM Daulat <daulat.dba@gmail.com> wrote: > > Sorry I missed it ! > > > > The output of query is > > > > SELECT oid::regclass, relkind FROM pg_class WHERE relfilenode = 876783; > > oid | relkind > > ----------------------------+--------- > > grc.masterdata_code_unique | i
Yes, the index file is missing. If you are lucky, REINDEX INDEX will help.
You should figure out who or what goes around deleting files in your data directory.