Re: [HACKERS] "pg_stat_tmp/pgstat.stat": Stale NFS file handle

2010-04-04 Thread Jaime Casanova
On Sun, Apr 4, 2010 at 11:57 AM, Tom Lane 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,

Re: [HACKERS] "pg_stat_tmp/pgstat.stat": Stale NFS file handle

2010-04-04 Thread Tom Lane
Jaime Casanova 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,

[HACKERS] "pg_stat_tmp/pgstat.stat": Stale NFS file handle

2010-04-03 Thread Jaime Casanova
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: """ postg...@