pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedERROR: could not open file "pg_tblspc
7+ messages / 2 participants
[nested] [flat]
* ERROR: could not open file "pg_tblspc
@ 2021-12-14 16:56 Daulat <daulat.dba@gmail.com>
2021-12-14 16:58 ` Re: ERROR: could not open file "pg_tblspc Daulat <daulat.dba@gmail.com>
2021-12-14 17:10 ` Re: ERROR: could not open file "pg_tblspc Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 2 replies; 7+ messages in thread
From: Daulat @ 2021-12-14 16:56 UTC (permalink / raw)
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: ERROR: could not open file "pg_tblspc
2021-12-14 16:56 ERROR: could not open file "pg_tblspc Daulat <daulat.dba@gmail.com>
@ 2021-12-14 16:58 ` Daulat <daulat.dba@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Daulat @ 2021-12-14 16:58 UTC (permalink / raw)
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
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 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
>
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: ERROR: could not open file "pg_tblspc
2021-12-14 16:56 ERROR: could not open file "pg_tblspc Daulat <daulat.dba@gmail.com>
@ 2021-12-14 17:10 ` Laurenz Albe <laurenz.albe@cybertec.at>
2021-12-14 17:25 ` Re: ERROR: could not open file "pg_tblspc Daulat <daulat.dba@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Laurenz Albe @ 2021-12-14 17:10 UTC (permalink / raw)
To: Daulat <daulat.dba@gmail.com>; pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: ERROR: could not open file "pg_tblspc
2021-12-14 16:56 ERROR: could not open file "pg_tblspc Daulat <daulat.dba@gmail.com>
2021-12-14 17:10 ` Re: ERROR: could not open file "pg_tblspc Laurenz Albe <laurenz.albe@cybertec.at>
@ 2021-12-14 17:25 ` Daulat <daulat.dba@gmail.com>
2021-12-14 17:42 ` Re: ERROR: could not open file "pg_tblspc Daulat <daulat.dba@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Daulat @ 2021-12-14 17:25 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-admin <pgsql-admin@lists.postgresql.org>
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
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
>
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: ERROR: could not open file "pg_tblspc
2021-12-14 16:56 ERROR: could not open file "pg_tblspc Daulat <daulat.dba@gmail.com>
2021-12-14 17:10 ` Re: ERROR: could not open file "pg_tblspc Laurenz Albe <laurenz.albe@cybertec.at>
2021-12-14 17:25 ` Re: ERROR: could not open file "pg_tblspc Daulat <daulat.dba@gmail.com>
@ 2021-12-14 17:42 ` Daulat <daulat.dba@gmail.com>
2021-12-15 08:27 ` Re: ERROR: could not open file "pg_tblspc Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 7+ messages in thread
From: Daulat @ 2021-12-14 17:42 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-admin <pgsql-admin@lists.postgresql.org>
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
>
>
> 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
>>
>>
>>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: ERROR: could not open file "pg_tblspc
2021-12-14 16:56 ERROR: could not open file "pg_tblspc Daulat <daulat.dba@gmail.com>
2021-12-14 17:10 ` Re: ERROR: could not open file "pg_tblspc Laurenz Albe <laurenz.albe@cybertec.at>
2021-12-14 17:25 ` Re: ERROR: could not open file "pg_tblspc Daulat <daulat.dba@gmail.com>
2021-12-14 17:42 ` Re: ERROR: could not open file "pg_tblspc Daulat <daulat.dba@gmail.com>
@ 2021-12-15 08:27 ` Laurenz Albe <laurenz.albe@cybertec.at>
2021-12-15 11:58 ` Re: ERROR: could not open file "pg_tblspc Daulat <daulat.dba@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Laurenz Albe @ 2021-12-15 08:27 UTC (permalink / raw)
To: Daulat <daulat.dba@gmail.com>; pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: ERROR: could not open file "pg_tblspc
2021-12-14 16:56 ERROR: could not open file "pg_tblspc Daulat <daulat.dba@gmail.com>
2021-12-14 17:10 ` Re: ERROR: could not open file "pg_tblspc Laurenz Albe <laurenz.albe@cybertec.at>
2021-12-14 17:25 ` Re: ERROR: could not open file "pg_tblspc Daulat <daulat.dba@gmail.com>
2021-12-14 17:42 ` Re: ERROR: could not open file "pg_tblspc Daulat <daulat.dba@gmail.com>
2021-12-15 08:27 ` Re: ERROR: could not open file "pg_tblspc Laurenz Albe <laurenz.albe@cybertec.at>
@ 2021-12-15 11:58 ` Daulat <daulat.dba@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Daulat @ 2021-12-15 11:58 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
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
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2021-12-15 11:58 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-12-14 16:56 ERROR: could not open file "pg_tblspc Daulat <daulat.dba@gmail.com>
2021-12-14 16:58 ` Daulat <daulat.dba@gmail.com>
2021-12-14 17:10 ` Laurenz Albe <laurenz.albe@cybertec.at>
2021-12-14 17:25 ` Daulat <daulat.dba@gmail.com>
2021-12-14 17:42 ` Daulat <daulat.dba@gmail.com>
2021-12-15 08:27 ` Laurenz Albe <laurenz.albe@cybertec.at>
2021-12-15 11:58 ` Daulat <daulat.dba@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox