Postgresql 'main/pg_notify/0000': Stale NFS file handle

919 views Asked by At

I have a Debian Wheezy computer running a Postgresql Server and NO NFS filesystems.

After rebooting the computer, the following error has appeared:

ls: cannot access 0000: Stale NFS file handle
516439 drwx------ 2 postgres postgres    8 Nov 12 20:25 .
516480 drwx------ 3 postgres postgres 4096 Nov 17 17:08 ..
? ?????????? ? ?        ?           ?            ? 0000

The "/var/lib/postgresql/9.1/main/pg_notify/0000" file is STALE and I cannot remove it or do anything at all with it. In order to get rid of that file, I tried the following options:

  1. Rebooting the computer in order to unmount the filesystem (as suggested in several forums) did not work.
  2. Removing postgresql (apt-get -purge) did not do anything at all either.
  3. Trying to manually remove that file does not work either (Stale NFS file handle).

This directory is part of a JFS partition over a ciphered volume managed by LVM.

The output for the fsck:

fsck.jfs version 1.1.15, 04-Mar-2011
processing started: 11/17/2014 20:22:30
Using default parameter: -p
The current device is:  /
ujfs_rw_diskblocks: read 0 of 4096 bytes at offset 32768
ujfs_rw_diskblocks: read 0 of 4096 bytes at offset 61440
Superblock is corrupt and cannot be repaired 
since both primary and secondary copies are corrupt.

Output for ls -l:

ls -l /var/lib/postgresql/9.1/main/pg_notify/0000

I would like to know...

  1. Why do I have a problem with a NFS handle in a non-NFS partition?
  2. Is there anyway in which I can get rid of that file (workarounds are more than welcome as well)?
0

There are 0 answers