Message-ID: <28049bf6e24b9138f1484ce5716c692b19845ceb.camel@cybertec.at>
Subject: Re: ERROR: could not open file "pg_tblspc
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Daulat <daulat.dba@gmail.com>, pgsql-admin
	 <pgsql-admin@lists.postgresql.org>
Date: Wed, 15 Dec 2021 09:27:43 +0100
In-Reply-To: 
 <CALfOM6+jCmMKyvGVH14PSrZT73Cgpfgm1zyOga2J90_t7+Okrg@mail.gmail.com>
References: 
	<CALfOM6+JoapGQOvB1+HjMqWHYSyn5Jy-a8LUm-xTunTK_gRiuA@mail.gmail.com>
	 <5f137253b6b055b7f2ae5b02ebf67f0ea5419cde.camel@cybertec.at>
	 <CALfOM6LQv_fdMBb3VfdesKA-+b6VKHKgvMbUJ18r=hoDmMwTWw@mail.gmail.com>
	 <a05464c620321192dc321637e142b35f14bf76f6.camel@cybertec.at>
	 <CALfOM6LLkD+FcuD33MVe==x5BgG9ucZq9JTu+ATQbnobWZSOkg@mail.gmail.com>
	 <CALfOM6+jCmMKyvGVH14PSrZT73Cgpfgm1zyOga2J90_t7+Okrg@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.40.4 (3.40.4-2.fc34) 
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/28049bf6e24b9138f1484ce5716c692b19845ceb.camel%40cybertec.at>
Precedence: bulk

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.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com