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

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 09:10:14
Message-ID: 2b675d25-e86c-ea29-b02e-6bad5d55fbe3@hot.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Today log file contains

2021-03-10 11:01:58 EET     checkpointer LOG:  could not rename file
"pg_wal/000000010000000A0000003B": Permission denied

messages. Resource Manager shows that 000000010000000A0000003B is is
locked by process 30376

According to pg_stat_activity this is regular postgres process which is
in idle state and waiting for ClientRead event. It has executed last
query  an hour ago.

It looks like wal files are not released after usage.

Andrus.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gavan Schneider 2021-03-10 09:38:59 Re: unexpected character used as group separator by to_char
Previous Message Laurenz Albe 2021-03-10 08:41:19 Re: unexpected character used as group separator by to_char