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

From: Andrus <kobruleht2(at)hot(dot)ee>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, 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>, 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-17 13:26:56
Message-ID: 843d2c8b-2e7a-8d4f-940a-2e3283690026@hot.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Πανος Κοροβεσης 2021-03-17 13:27:32 Getting Involved
Previous Message Laurenz Albe 2021-03-17 12:46:28 Re: SV: Log files polluted with permission denied error messages after every 10 seconds