On Mon, May 22, 2006 at 04:34:34PM +0900, SODA Noriyuki wrote:
> These two "tablespace not empty" results both came from NFS mounts.
> (I should have said that explicitly, sorry.)
> So, this means the REMOVE RPC sometimes may overtake other RPCs?
> Hmm...
Maybe an explicit fsync() is needed on the directory before trying to
remove it. Still, this seems like something the protocol should deal
with.
There is one possibility, considering it's NFS. On normal unix
filesystems, if you delete a file which is still open, the directory
entry goes away and you can rmdir the directory. However, due to the
way NFS works, the file can't really be deleted on the server because
NFS is stateless, the connection and all open files should in principle
survive a server restart.
Perhaps another postgresql process has a file open still, and that is
preventing the rmdir from suceeding. In this case, the issue should
manifest itself on windows also, since it also does not permit the
deletion of an open file (or maybe it does now).
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.