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 15:16:16
Message-ID: 972f1f26-05fa-a284-c382-2a0e8ff4d179@hot.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!
> Doesn't look like these are error messages.
>
> There should be error messages that correspond to the error messages you see in the PostgreSQL log.

I excluded SUCCESS and DELETE PENDING results and included pg_wal path
and postgres.exe process.

Log file contains only few entries, BUFFER OVERFLOW and NAME NOT FOUND

17:07:09,9618758    postgres.exe    11800 QueryAllInformationFile   
C:\Program Files\PostgreSQL\13\data\pg_wal\000000010000001300000021   
BUFFER OVERFLOW    CreationTime: 16.03.2021 20:04:57, LastAccessTime:
17.03.2021 16:58:43, LastWriteTime: 17.03.2021 16:58:43, ChangeTime:
17.03.2021 16:58:43, FileAttributes: A, AllocationSize: 16 777 216,
EndOfFile: 16 777 216, NumberOfLinks: 1, DeletePending: False,
Directory: False, IndexNumber: 0x38100000009ffb4, EaSize: 0, Access:
Read Attributes, Synchronize, Position: 0, Mode: Synchronous IO
Non-Alert, AlignmentRequirement: Byte
17:07:09,9624993    postgres.exe    11800 QueryAllInformationFile   
C:\Program Files\PostgreSQL\13\data\pg_wal\000000010000001300000023   
BUFFER OVERFLOW    CreationTime: 16.03.2021 20:04:57, LastAccessTime:
17.03.2021 17:07:09, LastWriteTime: 17.03.2021 17:07:09, ChangeTime:
17.03.2021 17:07:09, FileAttributes: A, AllocationSize: 16 777 216,
EndOfFile: 16 777 216, NumberOfLinks: 1, DeletePending: False,
Directory: False, IndexNumber: 0x20000000a010c, EaSize: 0, Access: Read
Attributes, Synchronize, Position: 0, Mode: Synchronous IO Non-Alert,
AlignmentRequirement: Byte
17:07:09,9630741    postgres.exe    11800 QueryAllInformationFile   
C:\Program Files\PostgreSQL\13\data\pg_wal\000000010000001300000024   
BUFFER OVERFLOW    CreationTime: 16.03.2021 20:04:57, LastAccessTime:
16.03.2021 20:05:12, LastWriteTime: 16.03.2021 20:05:12, ChangeTime:
16.03.2021 20:15:24, FileAttributes: A, AllocationSize: 16 777 216,
EndOfFile: 16 777 216, NumberOfLinks: 1, DeletePending: False,
Directory: False, IndexNumber: 0x20000000a010d, EaSize: 0, Access: Read
Attributes, Synchronize, Position: 0, Mode: Synchronous IO Non-Alert,
AlignmentRequirement: Byte
17:07:09,9636100    postgres.exe    11800 QueryAllInformationFile   
C:\Program Files\PostgreSQL\13\data\pg_wal\000000010000001300000025   
BUFFER OVERFLOW    CreationTime: 16.03.2021 20:04:57, LastAccessTime:
16.03.2021 20:05:12, LastWriteTime: 16.03.2021 20:05:12, ChangeTime:
16.03.2021 20:15:24, FileAttributes: A, AllocationSize: 16 777 216,
EndOfFile: 16 777 216, NumberOfLinks: 1, DeletePending: False,
Directory: False, IndexNumber: 0x20000000a010e, EaSize: 0, Access: Read
Attributes, Synchronize, Position: 0, Mode: Synchronous IO Non-Alert,
AlignmentRequirement: Byte
17:07:09,9641594    postgres.exe    11800 QueryAllInformationFile   
C:\Program Files\PostgreSQL\13\data\pg_wal\000000010000001300000026   
BUFFER OVERFLOW    CreationTime: 16.03.2021 20:04:57, LastAccessTime:
16.03.2021 20:05:13, LastWriteTime: 16.03.2021 20:05:13, ChangeTime:
16.03.2021 20:15:24, FileAttributes: A, AllocationSize: 16 777 216,
EndOfFile: 16 777 216, NumberOfLinks: 1, DeletePending: False,
Directory: False, IndexNumber: 0x20000000a010f, EaSize: 0, Access: Read
Attributes, Synchronize, Position: 0, Mode: Synchronous IO Non-Alert,
AlignmentRequirement: Byte
17:07:09,9659048    postgres.exe    11800    CreateFile C:\Program
Files\PostgreSQL\13\data\pg_wal    IS DIRECTORY Desired Access: Generic
Read, Disposition: Open, Options: Synchronous IO Non-Alert,
Non-Directory File, Attributes: N, ShareMode: Read, Write, Delete,
AllocationSize: n/a
17:07:09,9661026    postgres.exe    11800 QueryAllInformationFile   
C:\Program Files\PostgreSQL\13\data\pg_wal    BUFFER OVERFLOW
CreationTime: 10.02.2021 14:07:18, LastAccessTime: 17.03.2021 17:07:09,
LastWriteTime: 17.03.2021 17:07:09, ChangeTime: 17.03.2021 17:07:09,
FileAttributes: D, AllocationSize: 196 608, EndOfFile: 196 608,
NumberOfLinks: 1, DeletePending: False, Directory: True, IndexNumber:
0x1000000055e2b, EaSize: 0, Access: Read Attributes, Synchronize,
Position: 0, Mode: Synchronous IO Non-Alert, AlignmentRequirement: Byte
17:07:09,9666396    postgres.exe    11800    CreateFile C:\Program
Files\PostgreSQL\13\data\pg_wal\archive_status\000000010000001300000021.done
NAME NOT FOUND    Desired Access: Read Attributes, Delete, Disposition:
Open, Options: Non-Directory File, Open Reparse Point, Attributes: n/a,
ShareMode: Read, Write, Delete, AllocationSize: n/a
17:07:09,9667813    postgres.exe    11800    CreateFile C:\Program
Files\PostgreSQL\13\data\pg_wal\archive_status\000000010000001300000021.ready
NAME NOT FOUND    Desired Access: Read Attributes, Delete, Disposition:
Open, Options: Non-Directory File, Open Reparse Point, Attributes: n/a,
ShareMode: Read, Write, Delete, AllocationSize: n/a
17:07:09,9668956    postgres.exe    11800    QueryDirectory C:\Program
Files\PostgreSQL\13\data\pg_wal    NO MORE FILES FileInformationClass:
FileBothDirectoryInformation

Andrus.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2021-03-17 15:24:42 Re: SV: Log files polluted with permission denied error messages after every 10 seconds
Previous Message Fabrízio de Royes Mello 2021-03-17 15:02:32 Re: Getting Involved