Re: BUG #15221: Could not open file "pg_subtrans/0013" - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15221: Could not open file "pg_subtrans/0013"
Date
Msg-id 3852.1527774604@sss.pgh.pa.us
Whole thread Raw
In response to BUG #15221: Could not open file "pg_subtrans/0013"  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
=?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:
> 2018-05-28T10:08:38.487348231Z 2018-05-28 10:08:38.487 UTC [110] DETAIL: 
> Could not open file "pg_subtrans/0013": Invalid argument.

EINVAL on a file open is pretty uncommon ...

> the database data is mounted and stored to a NFS folder.

... but I've heard of it happening with unstable NFS setups.

You might check for NFS version compatibility, firewalls blocking
some of the ports NFS uses, etc.

But really my advice would be "don't access your database over NFS".
It's just not reliable enough.

            regards, tom lane


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15221: Could not open file "pg_subtrans/0013"
Next
From: PG Bug reporting form
Date:
Subject: BUG #15222: pg_isready fails connection after previous pg_isreadyclaims success