Re: "pg_stat_tmp/pgstat.stat": Stale NFS file handle - Mailing list pgsql-hackers

From Tom Lane
Subject Re: "pg_stat_tmp/pgstat.stat": Stale NFS file handle
Date
Msg-id 12306.1270396648@sss.pgh.pa.us
Whole thread Raw
In response to "pg_stat_tmp/pgstat.stat": Stale NFS file handle  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Responses Re: "pg_stat_tmp/pgstat.stat": Stale NFS file handle
List pgsql-hackers
Jaime Casanova <jcasanov@systemguards.com.ec> writes:
> + WARNING:  could not open statistics file "pg_stat_tmp/pgstat.stat":
> Stale NFS file handle

> this is an ext2 filesystem in an external hard drive, could be fs corruption?

Evidently the kernel is confused.  It seems more like busted in-memory
state than on-disk state, but that's just a guess.

> anything i could do to fix this without dropping my 90Gb test env?

Did you try rebooting the machine?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Hitoshi Harada
Date:
Subject: make check hangs in alpha5
Next
From: David Fetter
Date:
Subject: Re: [RFC] nodeToString format and exporting the SQL parser