Horton
Menu

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

Andrus <kobruleht2@hot.ee>

View thread
From: Andrus <kobruleht2@hot.ee>
To: Michael Paquier <michael@paquier.xyz>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-general <pgsql-general@postgresql.org>
Date: 2021-03-06T17:53:11Z
Lists: pgsql-general 
Hi!

These are generated on Windows when removing a past WAL segment, where 
the process involves a rename followed by durable_unlink() that would
> generate some LOG entries in the logs if the internal unlink() failed
> (see RemoveXlogFile() in xlog.c).

I changed wal_recycle to off. So checkpointer should no more try to 
rename wal files. Iit still tries to rename files. No idea way it does 
not use this setting:

2021-03-06 19:44:28 EET     checkpointer LOG:  could not rename file 
"pg_wal/0000000100000006000000EB": Permission denied

2021-03-06 19:44:38 EET     checkpointer LOG:  could not rename file 
"pg_wal/0000000100000006000000F0": Permission denied
2021-03-06 19:44:48 EET     checkpointer LOG:  could not rename file 
"pg_wal/0000000100000006000000F7": Permission denied
2021-03-06 19:44:58 EET     checkpointer LOG:  could not rename file 
"pg_wal/0000000100000006000000FB": Permission denied
2021-03-06 19:45:08 EET     postmaster LOG:  received SIGHUP, reloading 
configuration files
2021-03-06 19:45:08 EET     postmaster LOG:  parameter "wal_recycle" 
changed to "off"
2021-03-06 19:45:08 EET     checkpointer LOG:  could not rename file 
"pg_wal/0000000100000006000000FE": Permission denied
2021-03-06 19:45:18 EET     checkpointer LOG:  could not rename file 
"pg_wal/0000000100000006000000FF": Permission denied
2021-03-06 19:45:28 EET     checkpointer LOG:  could not rename file 
"pg_wal/000000010000000700000000": Permission denied
2021-03-06 19:45:38 EET     checkpointer LOG:  could not rename file 
"pg_wal/000000010000000700000002": Permission denied
2021-03-06 19:45:48 EET     checkpointer LOG:  could not rename file 
"pg_wal/000000010000000700000011": Permission denied
2021-03-06 19:45:59 EET     checkpointer LOG:  could not rename file 
"pg_wal/000000010000000700000012": Permission denied

2021-03-06 19:46:09 EET     checkpointer LOG:  could not rename file 
"pg_wal/000000010000000700000015": Permission denied

2021-03-06 19:46:19 EET     checkpointer LOG:  could not rename file 
"pg_wal/000000010000000700000016": Permission denied

Should chekpointer process terminated to force it to use new setting. Is 
it safe to kill it during database 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