Re: ERROR: could not open file "pg_tblspc

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