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