| From: | Andrus <kobruleht2(at)hot(dot)ee> |
|---|---|
| To: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
| Cc: | Niels Jespersen <NJN(at)dst(dot)dk>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Paquier <michael(at)paquier(dot)xyz>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, 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-10 13:20:47 |
| Message-ID: | 22ec98b1-cc2f-8e6a-f1d7-ee528237f2fb@hot.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi!
After re-starting postgres service problem persists.
Log file contains permission denied errors exactly after every 10 seconds:
...
2021-03-10 15:15:45 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A00000030": Permission denied
2021-03-10 15:15:55 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A00000031": Permission denied
2021-03-10 15:16:06 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A00000032": Permission denied
2021-03-10 15:16:16 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A00000033": Permission denied
2021-03-10 15:16:26 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A00000034": Permission denied
2021-03-10 15:16:36 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A00000037": Permission denied
2021-03-10 15:16:46 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A00000038": Permission denied
2021-03-10 15:16:56 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A00000039": Permission denied
2021-03-10 15:17:06 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A0000003B": Permission denied
2021-03-10 15:17:16 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A0000003E": Permission denied
2021-03-10 15:17:26 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A0000003F": Permission denied
2021-03-10 15:17:36 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A00000041": Permission denied
2021-03-10 15:17:46 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A00000044": Permission denied
2021-03-10 15:17:56 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A00000045": Permission denied
2021-03-10 15:18:06 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A00000046": Permission denied
2021-03-10 15:18:16 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A00000047": Permission denied
2021-03-10 15:18:26 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A00000048": Permission denied
2021-03-10 15:18:36 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A00000049": Permission denied
2021-03-10 15:18:46 EET checkpointer LOG: could not rename file
"pg_wal/000000010000000A0000004B": Permission denied
Windows Resource manger shows that wal files are used by large number of
postgres processes:
postgres.exe 22656 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000075
postgres.exe 30788 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000075
postgres.exe 14144 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000074
postgres.exe 20360 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000073
postgres.exe 25356 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000073
postgres.exe 4136 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000075
postgres.exe 7712 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000073
postgres.exe 7020 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000073
postgres.exe 26128 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000073
postgres.exe 13740 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000073
postgres.exe 25660 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000073
postgres.exe 19120 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000073
postgres.exe 30152 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000073
postgres.exe 12140 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000072
postgres.exe 500 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000072
postgres.exe 17616 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000072
postgres.exe 8552 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000072
postgres.exe 23764 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000074
postgres.exe 28400 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000072
postgres.exe 30172 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000072
postgres.exe 28004 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000071
postgres.exe 28236 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000071
postgres.exe 25840 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000072
postgres.exe 20048 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000071
postgres.exe 30156 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000071
postgres.exe 26976 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000071
postgres.exe 26312 File C:\Program
Files\PostgreSQL\13\data\pg_wal\000000010000000A00000074
...
Many wal files are used by multiple processes.
Andrus.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Radoslav Nedyalkov | 2021-03-10 13:41:40 | Re: how to limit statement memory allocation |
| Previous Message | Alvaro Herrera | 2021-03-10 12:58:20 | Re: unexpected character used as group separator by to_char |