Debian Question posted in
The oficial documentation can be found here.

WARNING: could not open statistics file "pg_stat_tmp/global.stat": Stale file handle – Debian

I am running postgres in Kubernetes cluster and seeing this warning.

What kind of problem/warning it is? How can I fix this?

Here is full log on container startup:

 .. PostgreSQL Database directory appears to contain a database; Skipping initialization
 .. UTC [1] LOG:  starting PostgreSQL 13.0 (Debian 13.0-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
... UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
... UTC [1] LOG:  listening on IPv6 address "::", port 5432
... UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
... UTC [24] LOG:  database system was shut down at 2020-11-02 10:16:05 UTC
... UTC [1] LOG:  database system is ready to accept connections
... UTC [28] WARNING:  could not open statistics file "pg_stat_tmp/global.stat": Stale file handle

Here the volume is mounted by glusterfs from three replica

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    Update: This problem comes from gluserfs and issue is not yet resolved by glusterfs https://github.com/gluster/glusterfs/issues/502


  2. 0

    If that problem occurs only occasionally, it can be a sign of I/O overload, but is harmless as such.

    If you get that message all the time, something is wrong with your statistics collector, and you should find and fix the problem, because statistics are important for the health of your database (autovacuum).

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search