Horton
Menu

Re: SV: 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: Thomas Munro <thomas.munro@gmail.com>, Niels Jespersen <NJN@dst.dk>, Tom Lane <tgl@sss.pgh.pa.us>, Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-general <pgsql-general@postgresql.org>
Date: 2021-03-16T11:59:07Z
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.

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