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.
