Обсуждение: ERROR: could not open file "pg_tblspc
Hi Team
I am getting the below error while opening some tab/menus options in the application for a specific database.
Caused by: org.postgresql.util.PSQLException: ERROR: could not open file "pg_tblspc/859888/PG_10_201707211/859890/876783": No such file or directory
I see, this directory exists till pg_tblspc/859888/PG_10_201707211/859890/
Also I am able to select/create/drop the table on that database from psql.
Any suggestions? Is that database corrupt?
Postgres version is 10.
Thanks
There is no error while performing select/create/drop the table on that database from psql.
On Tue, Dec 14, 2021 at 10:26 PM Daulat <daulat.dba@gmail.com> wrote:
Hi Team
I am getting the below error while opening some tab/menus options in the application for a specific database.
Caused by: org.postgresql.util.PSQLException: ERROR: could not open file "pg_tblspc/859888/PG_10_201707211/859890/876783": No such file or directoryI see, this directory exists till pg_tblspc/859888/PG_10_201707211/859890/Also I am able to select/create/drop the table on that database from psql.Any suggestions? Is that database corrupt?Postgres version is 10.Thanks
On Tue, 2021-12-14 at 22:26 +0530, Daulat wrote: > I am getting the below error while opening some tab/menus options in the application for a specific database. > > Caused by: org.postgresql.util.PSQLException: ERROR: could not open file "pg_tblspc/859888/PG_10_201707211/859890/876783":No such file or directory > > I see, this directory exists till pg_tblspc/859888/PG_10_201707211/859890/ > Also I am able to select/create/drop the table on that database from psql. > > Any suggestions? Is that database corrupt? > Postgres version is 10. Yes, your database is corrupt. What do you get if you connect to that database and run SELECT oid::regclass, relkind FROM pg_class WHERE relfilenode = 876783; If you can, run a pg_dump of that database *now*. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
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
oid | relkind
----------------------------+---------
grc.masterdata_code_unique | i
On Tue, Dec 14, 2021 at 10:53 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Tue, 2021-12-14 at 22:47 +0530, Daulat wrote:
> Thanks !
> The output of query is
Please reply to the mailing list.
Yours,
Laurenz Albe
--
+43-670-6056265
CYBERTEC PostgreSQL International GmbH
Römerstraße 19, 2752 Wöllersdorf
Web: https://www.cybertec-postgresql.com
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 isSELECT oid::regclass, relkind FROM pg_class WHERE relfilenode = 876783;
oid | relkind
----------------------------+---------
grc.masterdata_code_unique | iOn Tue, Dec 14, 2021 at 10:53 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:On Tue, 2021-12-14 at 22:47 +0530, Daulat wrote:
> Thanks !
> The output of query is
Please reply to the mailing list.
Yours,
Laurenz Albe
--
+43-670-6056265
CYBERTEC PostgreSQL International GmbH
Römerstraße 19, 2752 Wöllersdorf
Web: https://www.cybertec-postgresql.com
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
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