BUG #15221: Could not open file "pg_subtrans/0013"

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: joanaliang_05(at)126(dot)com
Subject: BUG #15221: Could not open file "pg_subtrans/0013"
Date: 2018-05-31 06:41:28
Message-ID: 152774888851.26724.14798732262740273682@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15221
Logged by: lily liang
Email address: joanaliang_05(at)126(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2018-05-31 13:50:04 Re: BUG #15221: Could not open file "pg_subtrans/0013"
Previous Message Vik Fearing 2018-05-31 05:32:37 Re: BUG #15214: Pg 10.4 windows 64 bit installer is 32 bit