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.
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 |