From: | Guy Burgess <guy(at)burgess(dot)co(dot)nz> |
---|---|
To: | Andrus <kobruleht2(at)hot(dot)ee>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Michael Paquier <michael(at)paquier(dot)xyz>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
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> |
Subject: | Re: SV: Log files polluted with permission denied error messages after every 10 seconds |
Date: | 2021-03-17 23:25:45 |
Message-ID: | 2bb3003a-757f-45ae-7766-a3a601f8e26f@burgess.co.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
FWIW, this looks the same issue I am getting (reported last month:
https://www.postgresql.org/message-id/f444a84e-2d29-55f9-51a6-a5dcea3bc253%40burgess.co.nz)
I get the same Process Monitor output, including BUFFER OVERFLOW
entries. No sign of any process other than postgres.exe touching the
WAL files.
Regards,
Guy
On 18/03/2021 2:26 am, Andrus wrote:
>
> Hi!
>
>
>> I think what it would be most helpful to run "process monitor", so that you get
>> a log of the system calls and errors; perhaps that shows some details that
>> we cannot get from the error message.
>>
> Process monitor shows huge number of DELETE PENDING results from
> CreateFile operation:
>
> 15:22:35,1708187 postgres.exe 11800 CreateFile C:\Program
> Files\PostgreSQL\13\data\pg_wal\00000001000000110000003B DELETE
> PENDING Desired Access: Read Attributes, Delete, Synchronize,
> Disposition: Open, Options: Synchronous IO Non-Alert, Open Reparse
> Point, Attributes: n/a, ShareMode: Read, Write, Delete,
> AllocationSize: n/a
>
> 15:22:35,2713856 postgres.exe 11800 CreateFile C:\Program
> Files\PostgreSQL\13\data\pg_wal\00000001000000110000003B DELETE
> PENDING Desired Access: Read Attributes, Delete, Synchronize,
> Disposition: Open, Options: Synchronous IO Non-Alert, Open Reparse
> Point, Attributes: n/a, ShareMode: Read, Write, Delete,
> AllocationSize: n/a
>
> 15:22:35,3719483 postgres.exe 11800 CreateFile C:\Program
> Files\PostgreSQL\13\data\pg_wal\00000001000000110000003B DELETE
> PENDING Desired Access: Read Attributes, Delete, Synchronize,
> Disposition: Open, Options: Synchronous IO Non-Alert, Open Reparse
> Point, Attributes: n/a, ShareMode: Read, Write, Delete,
> AllocationSize: n/a
>
> 15:22:35,4723624 postgres.exe 11800 CreateFile C:\Program
> Files\PostgreSQL\13\data\pg_wal\00000001000000110000003B DELETE
> PENDING Desired Access: Read Attributes, Delete, Synchronize,
> Disposition: Open, Options: Synchronous IO Non-Alert, Open Reparse
> Point, Attributes: n/a, ShareMode: Read, Write, Delete,
> AllocationSize: n/a
>
> Andrus.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2021-03-17 23:53:29 | Re: SV: Log files polluted with permission denied error messages after every 10 seconds |
Previous Message | Diego | 2021-03-17 21:32:22 | Re: how to troubleshoot: FATAL: canceling authentication due to timeout |