Re: pg_stat warnings keep on printing in postgres log

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: pg_stat warnings keep on printing in postgres log
Дата
Msg-id CADK3HHKffLEXC65FtD0ZXrkTV2CyAOqg6hP433=Lo=QLHsg-bA@mail.gmail.com
обсуждение исходный текст
Ответ на pg_stat warnings keep on printing in postgres log  ("Naomi's strings" <nidhin.lazer@gmail.com>)
Список pgsql-bugs


On Fri, 6 Aug 2021 at 08:28, Naomi's strings <nidhin.lazer@gmail.com> wrote:

Hi Team,

One of our customer is getting the below warning's and log statements in the postgres logs, the postgres version is 12.2. Because of which the log size is increasing quickly.

Is there any solution/workaround for this ? We have tried to turn off the "track_activities" settings in postgres.conf file but it is not helping.

Could you please also let us know, in what circumstances the stat collector will run ? So that we can do that activity to reproduce the issue in our setup.


LOG: could not rename temporary statistics file "pg_stat_tmp/db_0.tmp" to "pg_stat_tmp/db_0.stat": No such file or directory

WARNING: corrupted statistics file "pg_stat_tmp/global.stat"


I would suggest you fix the underlying problem instead of trying to make the logs go away.

Dave 

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Naomi's strings"
Дата:
Сообщение: pg_stat warnings keep on printing in postgres log
Следующее
От: Andrey Borodin
Дата:
Сообщение: Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data