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

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Andrus <kobruleht2(at)hot(dot)ee>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Log files polluted with permission denied error messages after every 10 seconds
Date: 2021-03-06 01:36:39
Message-ID: YELcpyM5Nc1H7L2m@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Mar 05, 2021 at 07:36:37PM +0200, Andrus wrote:
> Then turned real-time protection off:
>
> Problem persists. New entry is written after every 10 seconds.

On which files are those complaints? It seems to me that you may have
more going on in this system that interacts with your data folder than
you think.

> pg_wal also contains files with .deleted extension like
>
> 0000000100000005000000B2.deleted

These are generated on Windows when removing a past WAL segment, where
the process involves a rename followed by durable_unlink() that would
generate some LOG entries in the logs if the internal unlink() failed
(see RemoveXlogFile() in xlog.c).
--
Michael

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2021-03-06 08:47:00 Re: Log files polluted with permission denied error messages after every 10 seconds
Previous Message Alvaro Herrera 2021-03-06 00:43:18 Re: libpq pipelineing