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