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

From: Andrus <kobruleht2(at)hot(dot)ee>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Log files polluted with permission denied error messages after every 10 seconds
Date: 2021-03-05 10:13:27
Message-ID: 3861ff1e-0923-7838-e826-094cc9bef737@hot.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

Postgres 13.1 is installed in windows server. There are about 100 users.

Log files contain huge number of permisson denied error messages in
every day like :

2021-03-04 01:38:49.818 EET [4580] LOG:  could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 01:48:42.725 EET [4580] LOG:  could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 01:53:22.427 EET [4580] LOG:  could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 01:58:19.623 EET [4580] LOG:  could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 02:03:24.080 EET [4580] LOG:  could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 02:43:17.983 EET [7764] LOG:  invalid length of startup packet
2021-03-04 02:43:21.634 EET [4580] LOG:  could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 02:48:25.048 EET [4580] LOG:  could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 02:53:19.229 EET [4580] LOG:  could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 02:58:19.176 EET [4580] LOG:  could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 03:03:19.136 EET [4580] LOG:  could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 03:29:33.926 EET [2460] FATAL:  expected SASL response, got
message type 0
2021-03-04 03:36:04.995 EET [4816] LOG:  could not rename temporary
statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat":
Permission denied
2021-03-04 03:36:09.666 EET [10340] LOG:  using stale statistics instead
of current ones because stats collector is not responding
2021-03-04 03:53:20.036 EET [4580] LOG:  could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 04:03:19.001 EET [4580] LOG:  could not rename file
"pg_wal/00000001000000050000001B": Permission denied

On middle of day where usage is intensive those appear exactly after
every 10 seconds:

2021-03-05 12:08:40.001 EET [4580] LOG:  could not rename file
"pg_wal/000000010000000500000078": Permission denied
2021-03-05 12:08:50.059 EET [4580] LOG:  could not rename file
"pg_wal/00000001000000050000007D": Permission denied
2021-03-05 12:09:00.115 EET [4580] LOG:  could not rename file
"pg_wal/000000010000000500000082": Permission denied
2021-03-05 12:09:10.171 EET [4580] LOG:  could not rename file
"pg_wal/000000010000000500000088": Permission denied
2021-03-05 12:09:20.224 EET [4580] LOG:  could not rename file
"pg_wal/0000000100000005000000A4": Permission denied
2021-03-05 12:09:30.281 EET [4580] LOG:  could not rename file
"pg_wal/0000000100000005000000A8": Permission denied
2021-03-05 12:09:40.339 EET [4580] LOG:  could not rename file
"pg_wal/0000000100000005000000B0": Permission denied
2021-03-05 12:09:50.397 EET [4580] LOG:  could not rename file
"pg_wal/0000000100000005000000E7": Permission denied
2021-03-05 12:10:00.456 EET [4580] LOG:  could not rename file
"pg_wal/0000000100000005000000E8": Permission denied
2021-03-05 12:10:10.514 EET [4580] LOG:  could not rename file
"pg_wal/0000000100000005000000E9": Permission denied
2021-03-05 12:10:20.570 EET [4580] LOG:  could not rename file
"pg_wal/0000000100000005000000EB": Permission denied
2021-03-05 12:10:30.626 EET [4580] LOG:  could not rename file
"pg_wal/0000000100000005000000EC": Permission denied

How to fix this ?

It looks like database is working normally, users havent reported any
issues.

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2021-03-05 13:50:07 Re: Log files polluted with permission denied error messages after every 10 seconds
Previous Message Andrus 2021-03-04 19:46:32 Re: Duplicate key error