Postgres Pro
Downloads
Home   >   mailing lists

Re: SV: Log files polluted with permission denied error messages after every 10 seconds - Mailing list pgsql-general

From Andrus
Subject Re: SV: Log files polluted with permission denied error messages after every 10 seconds
Date
Msg-id f699c3d4-8516-5b38-5ef3-587e11072980@hot.ee
Whole thread Raw
In response to Re: SV: Log files polluted with permission denied error messages after every 10 seconds  (Michael Paquier <michael@paquier.xyz>)
Responses Re: SV: Log files polluted with permission denied error messages after every 10 seconds
List pgsql-general
Tree view

Hi!

Errors in pg_wal directory seems not to occur in patched version. Errors in pg_stat_tmp still occur. Yesterdays log introduces new error message

using stale statistics instead of current ones because stats collector is not responding

2021-03-21 03:02:23 EET     stats collector LOG:  could not rename temporary statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat": Permission denied
2021-03-21 13:31:00 EET     stats collector LOG:  could not rename temporary statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat": Permission denied
2021-03-21 15:15:52 EET     stats collector LOG:  could not rename temporary statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat": Permission denied
2021-03-21 23:51:20 EET     stats collector LOG:  could not rename temporary statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat": Permission denied
2021-03-21 23:51:25 EET     autovacuum worker LOG:  using stale statistics instead of current ones because stats collector is not responding

Andrus.

pgsql-general by date:

Previous
From: Shubham Mittal
Date:
Subject: Need help on query optimization
Next
From: Michael Paquier
Date:
Subject: Re: SV: Log files polluted with permission denied error messages after every 10 seconds