From: | Andrus <kobruleht2(at)hot(dot)ee> |
---|---|
To: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
Cc: | Niels Jespersen <NJN(at)dst(dot)dk>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Paquier <michael(at)paquier(dot)xyz>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: SV: Log files polluted with permission denied error messages after every 10 seconds |
Date: | 2021-03-09 16:24:59 |
Message-ID: | 2586bd2e-77d4-e3e2-2f30-d5c83f52f001@hot.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!
Maybe this does the reverse?
> https://docs.microsoft.com/en-us/sysinternals/downloads/handle
Examined todays logs in other windows 2019 server with Postgres 13.1
Permission denied occurs single file but permanently . Last entry is 6
minutes ago:
2021-03-09 00:02:23.915 EET [11328] LOG: could not rename file
"pg_wal/000000010000004C00000034": Permission denied
2021-03-09 00:07:24.430 EET [11328] LOG: could not rename file
"pg_wal/000000010000004C00000034": Permission denied
2021-03-09 00:12:34.392 EET [11328] LOG: could not rename file
"pg_wal/000000010000004C00000034": Permission denied
2021-03-09 00:17:24.270 EET [11328] LOG: could not rename file
"pg_wal/000000010000004C00000034": Permission denied
2021-03-09 00:22:23.780 EET [11328] LOG: could not rename file
"pg_wal/000000010000004C00000034": Permission denied
..
2021-03-09 17:59:04 EET checkpointerLOG: could not rename file
"pg_wal/000000010000004C00000034": Permission denied
Used Resource Monitor / CPU / Associated Handles and searched for
"000000010000004C00000034". Resource Monitor shows that process 11336 is
using that file
pg_stat_activity shows that this is "background writer" waiting for
event BgWriterMain or BgWriterHibernate
Permisson denied exception occurs accoring to log above in process
11328 which is listed as checkpointer.
So Background writer has locked the file permanently. Checkpointer tries
to write into it and gets permission denied error all the time.
How to fix this ?
Andrus.
From | Date | Subject | |
---|---|---|---|
Next Message | Radoslav Nedyalkov | 2021-03-09 16:32:46 | Re: how to limit statement memory allocation |
Previous Message | Tom Lane | 2021-03-09 16:03:40 | Re: how to limit statement memory allocation |