Could not remove file messages

From: Mija Lee <mija(at)scharp(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Could not remove file messages
Date: 2007-08-30 17:15:22
Message-ID: 200708301715.l7UHFLka013163@brood2.pc.scharp.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi:

We've been getting a message in our logs on a semi-regular basis in response to a cron job that drops
and recreates a number of databases using the dropdb command. The message indicates that a directory
cannot be removed, and sure enough, when I look in the file system, the 11210840 directory exists,
although it's empty. When I check the oids of my databases, 11210840 doesn't exist which is not
surprising given the successful drop database message at the end.

I was wondering why this might be happening and if there is an easy, safe way to clean up those
directories.

We're running 8.1.4. Relevant log messages below:

01:45:59 PDT WARNING: could not remove file or directory "base/11210840": File exists
01:45:59 PDT WARNING: could not remove database directory "base/11210840"
01:45:59 PDT LOG: transaction ID wrap limit is 2147484146, limited by database "postgres"
01:46:00 PDT LOG: duration: 3754.761 ms statement: DROP DATABASE cdstest;

Thanks!
Mija

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2007-08-30 19:07:43 Re: Could not remove file messages
Previous Message Tom Lane 2007-08-30 16:01:14 Re: Querying a parent table's child schemas