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

From PG Bug reporting form
Subject BUG #15221: Could not open file "pg_subtrans/0013"
Date
Msg-id 152774888851.26724.14798732262740273682@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #15221: Could not open file "pg_subtrans/0013"
Re: BUG #15221: Could not open file "pg_subtrans/0013"
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15221
Logged by:          lily liang
Email address:      joanaliang_05@126.com
PostgreSQL version: 10.2
Operating system:   Redhat
Description:

hi,

we're using postgresql 10.2, postgresql is deployed in a docker image. it
works well for some time. but one day we met errors when we test with load.
In logs, we found below errors:

2018-05-28T10:08:38.487336192Z 2018-05-28 10:08:38.487 UTC [110] ERROR:
could not access status of transaction 0
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.
2018-05-28T10:08:38.509453008Z 2018-05-28 10:08:38.509 UTC [110] STATEMENT:
INSERT INTO schemas VALUES ('abc1', '{"schema": {"$schema":
"http://json-schema.org/schema#", "required": ["color"], "type": "object",
"properties": {"color": {"type": "string"}}}, "format": "json", "title":
"abc schema"}')


after we restart and re-run the test, the error disppears. 

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

Cheers and thanks.


pgsql-bugs by date:

Previous
From: Vik Fearing
Date:
Subject: Re: BUG #15214: Pg 10.4 windows 64 bit installer is 32 bit
Next
From: Tom Lane
Date:
Subject: Re: BUG #15221: Could not open file "pg_subtrans/0013"