Horton
Menu

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

Andrus <kobruleht2@hot.ee>

View thread
From: Andrus <kobruleht2@hot.ee>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Niels Jespersen <NJN@dst.dk>, Tom Lane <tgl@sss.pgh.pa.us>, Michael Paquier <michael@paquier.xyz>, Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-general <pgsql-general@postgresql.org>
Date: 2021-03-10T09:10:14Z
Lists: pgsql-general 
Today log file contains

2021-03-10 11:01:58 EET     checkpointer LOG:  could not rename file 
"pg_wal/000000010000000A0000003B": Permission denied

messages. Resource Manager shows that 000000010000000A0000003B is is 
locked by process 30376


According to pg_stat_activity this is regular postgres process which is 
in idle state and waiting for ClientRead event. It has executed last 
query  an hour ago.

It looks like wal files are not released after usage.

Andrus.

Commits

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

  1. Fix concurrency issues with WAL segment recycling on Windows