pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Daulat <daulat.dba@gmail.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: ERROR: could not open file "pg_tblspc
Date: Wed, 15 Dec 2021 17:28:23 +0530
Message-ID: <CALfOM6JbA1rVptN9pgV2O2jej==O5hdXHATxHVuNOjY1+phmaQ@mail.gmail.com> (raw)
In-Reply-To: <28049bf6e24b9138f1484ce5716c692b19845ceb.camel@cybertec.at>
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>

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

view thread (7+ messages)

Message-ID: <CALfOM6JbA1rVptN9pgV2O2jej==O5hdXHATxHVuNOjY1+phmaQ@mail.gmail.com>
Permalink:  ../CALfOM6JbA1rVptN9pgV2O2jej==O5hdXHATxHVuNOjY1+phmaQ@mail.gmail.com/
Also on:    postgresql.org/message-id/CALfOM6JbA1rVptN9pgV2O2jej==O5hdXHATxHVuNOjY1+phmaQ@mail.gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: daulat.dba@gmail.com, laurenz.albe@cybertec.at, pgsql-admin@lists.postgresql.org
  Subject: Re: ERROR: could not open file "pg_tblspc
  In-Reply-To: <CALfOM6JbA1rVptN9pgV2O2jej==O5hdXHATxHVuNOjY1+phmaQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox