MIME-Version: 1.0
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>
 <28049bf6e24b9138f1484ce5716c692b19845ceb.camel@cybertec.at>
In-Reply-To: <28049bf6e24b9138f1484ce5716c692b19845ceb.camel@cybertec.at>
From: Daulat <daulat.dba@gmail.com>
Date: Wed, 15 Dec 2021 17:28:23 +0530
Message-ID: 
 <CALfOM6JbA1rVptN9pgV2O2jej==O5hdXHATxHVuNOjY1+phmaQ@mail.gmail.com>
Subject: Re: ERROR: could not open file "pg_tblspc
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000082039f05d32e063c"
Archived-At: 
 <https://www.postgresql.org/message-id/CALfOM6JbA1rVptN9pgV2O2jej%3D%3DO5hdXHATxHVuNOjY1%2BphmaQ%40mail.gmail.com>
Precedence: bulk

--00000000000082039f05d32e063c
Content-Type: text/plain; charset="UTF-8"

Thanks a lot. It is working after rebuilding the index.


On Wed, Dec 15, 2021 at 1:57 PM Laurenz Albe <laurenz.albe@cybertec.at>
wrote:

> 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
>
>

--00000000000082039f05d32e063c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thanks a lot. It is working after rebuilding the index.=C2=
=A0<br><div><br></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr"=
 class=3D"gmail_attr">On Wed, Dec 15, 2021 at 1:57 PM Laurenz Albe &lt;<a h=
ref=3D"mailto:laurenz.albe@cybertec.at">laurenz.albe@cybertec.at</a>&gt; wr=
ote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px=
 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Tue, 202=
1-12-14 at 23:12 +0530, Daulat wrote:<br>
&gt; Will it work if we rebuild that index ? Looks like it is an issue with=
 the index.<br>
&gt; <br>
&gt; On Tue, Dec 14, 2021 at 10:55 PM Daulat &lt;<a href=3D"mailto:daulat.d=
ba@gmail.com" target=3D"_blank">daulat.dba@gmail.com</a>&gt; wrote:<br>
&gt; &gt; Sorry I missed it=C2=A0 !=C2=A0<br>
&gt; &gt; <br>
&gt; &gt; The output of query is=C2=A0<br>
&gt; &gt; <br>
&gt; &gt; SELECT oid::regclass, relkind FROM pg_class WHERE relfilenode =3D=
 876783;<br>
&gt; &gt; =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 oid =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 | relkind<br>
&gt; &gt; ----------------------------+---------<br>
&gt; &gt; =C2=A0grc.masterdata_code_unique | i<br>
<br>
Yes, the index file is missing.=C2=A0 If you are lucky, REINDEX INDEX will =
help.<br>
<br>
You should figure out who or what goes around deleting files in your<br>
data directory.<br>
<br>
Yours,<br>
Laurenz Albe<br>
-- <br>
Cybertec | <a href=3D"https://www.cybertec-postgresql.com" rel=3D"noreferre=
r" target=3D"_blank">https://www.cybertec-postgresql.com</a><br>
<br>
</blockquote></div>

--00000000000082039f05d32e063c--