Postgres Pro
Downloads
Home   >   mailing lists

pg_stat warnings keep on printing in postgres log - Mailing list pgsql-bugs

From Naomi's strings
Subject pg_stat warnings keep on printing in postgres log
Date
Msg-id CAC7Rw0fY5R7MyQe9nQ5bZcoBdioJqNcw+F0XRM5PT5m2=kEaog@mail.gmail.com
Whole thread Raw
Responses Re: pg_stat warnings keep on printing in postgres log  (Dave Cramer <davecramer@postgres.rocks>)
List pgsql-bugs
Tree view

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"


Regards,
Nidhin Lazar

pgsql-bugs by date:

Previous
From: Andrey Lepikhov
Date:
Subject: SEGFAULT on a concurrent UPDATE of mix of local and foreign partitions
Next
From: Dave Cramer
Date:
Subject: Re: pg_stat warnings keep on printing in postgres log