From: | Andrus <kobruleht2(at)hot(dot)ee> |
---|---|
To: | Michael Paquier <michael(at)paquier(dot)xyz> |
Cc: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Niels Jespersen <NJN(at)dst(dot)dk>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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-16 11:59:07 |
Message-ID: | 78e6daee-0323-752d-c142-263a80154e18@hot.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
> Where you getting the Postgres binaries from?
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
> If we provide a patch, could you test it?
Yes
> This would require that you do your own build,
> unfortunately, but having an environment where this is easily
> reproducible is a key thing.
I used C last time many years ago. I'm working in C# with Visual Studio
2019.
I have two Windows 2019 servers. In Intel Xeon Cold 6226R server it
occurs after every 10 seconds. Last logs:
2021-03-16 13:48:12 EET checkpointer LOG: could not rename file
"pg_wal/000000010000001100000097": Permission denied
2021-03-16 13:48:22 EET checkpointer LOG: could not rename file
"pg_wal/000000010000001100000098": Permission denied
2021-03-16 13:48:32 EET checkpointer LOG: could not rename file
"pg_wal/000000010000001100000099": Permission denied
2021-03-16 13:48:42 EET checkpointer LOG: could not rename file
"pg_wal/00000001000000110000009A": Permission denied
2021-03-16 13:48:52 EET checkpointer LOG: could not rename file
"pg_wal/00000001000000110000009D": Permission denied
2021-03-16 13:49:02 EET checkpointer LOG: could not rename file
"pg_wal/0000000100000011000000A0": Permission denied
In AMD Ryzen 3970X Threadripper 32 core processor server in also occurs
many times per day day but less frequently. Last logs:
2021-03-16 13:45:20 EET checkpointerLOG: could not rename file
"pg_wal/000000010000004E000000FB": Permission denied
2021-03-16 13:50:02 EET checkpointerLOG: could not rename file
"pg_wal/000000010000004E000000FB": Permission denied
2021-03-16 13:50:13 EET checkpointerLOG: could not rename file
"pg_wal/000000010000004F00000082": Permission denied
So It should be probably reproducible in any Windows 2019 server.
Andrus.
From | Date | Subject | |
---|---|---|---|
Next Message | Avinash Kumar | 2021-03-16 12:01:29 | Re: Postgres crashes at memcopy() after upgrade to PG 13. |
Previous Message | Michael Paquier | 2021-03-16 10:26:47 | Re: SV: Log files polluted with permission denied error messages after every 10 seconds |