Message-ID: <5f137253b6b055b7f2ae5b02ebf67f0ea5419cde.camel@cybertec.at>
Subject: Re: ERROR: could not open file "pg_tblspc
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Daulat <daulat.dba@gmail.com>, pgsql-admin
	 <pgsql-admin@lists.postgresql.org>
Date: Tue, 14 Dec 2021 18:10:59 +0100
In-Reply-To: 
 <CALfOM6+JoapGQOvB1+HjMqWHYSyn5Jy-a8LUm-xTunTK_gRiuA@mail.gmail.com>
References: 
	<CALfOM6+JoapGQOvB1+HjMqWHYSyn5Jy-a8LUm-xTunTK_gRiuA@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.40.4 (3.40.4-2.fc34) 
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/5f137253b6b055b7f2ae5b02ebf67f0ea5419cde.camel%40cybertec.at>
Precedence: bulk

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