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

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.

In response to

Responses

Browse pgsql-general by date

  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