Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux