Re: BUG #16927: Postgres can`t access WAL files - Mailing list pgsql-bugs

From Ярослав Пашинский
Subject Re: BUG #16927: Postgres can`t access WAL files
Date
Msg-id CADLmToLOHv6OqYO_Aj+T+uDFfgs5eLa4frF=eqM_KmrAAtF6tw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16927: Postgres can`t access WAL files  (Michael Paquier <michael@paquier.xyz>)
List pgsql-bugs
I don`t know the dependencies of appearances of this issue (Honestly, I tried to find them before mailing psql-bugs). For example, yesterday log file was full of this messages but today I was waiting to get this error back to check wal file linking via FindLinks program. At least I`m confident that this issue could destroy replication and this issue not only on one machine. Anyway, I`m happy that your patch seems to be key to solve this problem.

пт, 19 мар. 2021 г. в 13:36, Michael Paquier <michael@paquier.xyz>:
On Fri, Mar 19, 2021 at 11:04:14AM +0200, Ярослав Пашинский wrote:
> I didn't quite understand you here, is " aaaef7a " stands for patch name?

There was a typo in one of my previous messages.  What I was referring
to is aaa3aedd.  That's a commit of the Postgres code tree, if you are
not familiar with git, here is a link to the code change:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=aaa3aedd

>> " How much did you test the unpatched builds by the way?  "
> On cluster where load was caused by pgbench I met wal file access error
> after about 1 hour, but on developer server with real load (usually up to
> 100 connections) the error occurred after 2.5-3 hours.

OK, thanks.  My environments are not that sensitive to the issue,
unfortunately.
--
Michael

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #16927: Postgres can`t access WAL files
Next
From: Tom Lane
Date:
Subject: Re: BUG #16927: Postgres can`t access WAL files