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

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: SV: Log files polluted with permission denied error messages after every 10 seconds
Дата
Msg-id f699c3d4-8516-5b38-5ef3-587e11072980@hot.ee
обсуждение исходный текст
Ответ на Re: SV: Log files polluted with permission denied error messages after every 10 seconds  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: SV: Log files polluted with permission denied error messages after every 10 seconds
Список pgsql-general

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 по дате отправления:

Предыдущее
От: Shubham Mittal
Дата:
Сообщение: Need help on query optimization
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: SV: Log files polluted with permission denied error messages after every 10 seconds