Thread: "pg_stat_tmp/pgstat.stat": Stale NFS file handle

Hi,

i was running installcheck on a 9.0 installation and get 6 failed
tests, but when reading the regression.diff i found a lot of this
messages:
"""
+ WARNING:  could not open statistics file "pg_stat_tmp/pgstat.stat":
Stale NFS file handle
"""

and when listing the file i get this:
"""
postgres@casanova1:/usr/local/pgsql/9.0$ ls -lh data/pg_stat_tmp/
ls: no se puede acceder a data/pg_stat_tmp/pgstat.stat: `handle' de
fichero NFS en desuso
total 0
-????????? ? ? ? ?            ? pgstat.stat
"""

this is an ext2 filesystem in an external hard drive, could be fs corruption?
any ideas?
anything i could do to fix this without dropping my 90Gb test env?

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

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

On Sun, Apr 4, 2010 at 11:57 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>> anything i could do to fix this without dropping my 90Gb test env?
>
> Did you try rebooting the machine?
>

yes. i started it a few minutes ago since yesterday... so i think this
is on-disk state, i will checked the disk...


--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157