| From: | Andrus <kobruleht2(at)hot(dot)ee> |
|---|---|
| To: | Michael Paquier <michael(at)paquier(dot)xyz> |
| Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Log files polluted with permission denied error messages after every 10 seconds |
| Date: | 2021-03-06 17:53:11 |
| Message-ID: | c3541c40-00d9-aeb6-1a97-43d6c4e37d94@hot.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2021-03-07 09:27:57 | Re: Log files polluted with permission denied error messages after every 10 seconds |
| Previous Message | dba consultant | 2021-03-06 14:24:40 | Problematic read queries |