"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