Re: SV: Log files polluted with permission denied error messages after every 10 seconds

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>

To: Andrus <kobruleht2@hot.ee>

Cc: Thomas Munro <thomas.munro@gmail.com>, Niels Jespersen <NJN@dst.dk>, Tom Lane <tgl@sss.pgh.pa.us>, Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-general <pgsql-general@postgresql.org>

Date: 2021-03-22T07:44:52Z

Lists: pgsql-general

On Mon, Mar 22, 2021 at 09:25:26AM +0200, Andrus wrote:
> Errors in pg_wal directory seems not to occur in patched version. Errors in
> pg_stat_tmp still occur. Yesterdays log introduces new error message
> 
> using stale statistics instead of current ones because stats collector is
> not responding
> 
> 2021-03-21 23:51:25 EET     autovacuum worker LOG:  using stale statistics
> instead of current ones because stats collector is not responding

The renaming of stats files involves just pgrename(), which is a
completely separate code path than the one of the WAL segments.  This
requires a separate investigation.
--
Michael

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix concurrency issues with WAL segment recycling on Windows
- 78c24e97dd18 13.3 landed
- 909b449e00fc 14.0 landed