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

[Andrus <kobruleht2@xxxxxx>]

    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.