ERROR: could not open file "pg_tblspc

From: Daulat <daulat(dot)dba(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: ERROR: could not open file "pg_tblspc
Date: 2021-12-14 16:56:47
Message-ID: CALfOM6+JoapGQOvB1+HjMqWHYSyn5Jy-a8LUm-xTunTK_gRiuA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Daulat 2021-12-14 16:58:10 Re: ERROR: could not open file "pg_tblspc
Previous Message Godfrin, Philippe E 2021-12-14 16:41:31 RE: [EXTERNAL] Re: Limits user connection in pgbouncer