From: Tom Lane <tgl@sss.pgh.pa.us>
To: Matthew Wakeling <matthew@flymine.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Disc space usage
Date: Wed, 08 Oct 2008 11:51:27 -0400
Message-ID: <8827.1223481087@sss.pgh.pa.us> (raw)
In-Reply-To: <alpine.DEB.1.10.0810081629460.15851@aragorn.flymine.org>
References: <alpine.DEB.1.10.0810081238380.15851@aragorn.flymine.org>
<27956.1223471810@sss.pgh.pa.us>
<alpine.DEB.1.10.0810081455070.15851@aragorn.flymine.org>
<29539.1223476681@sss.pgh.pa.us>
<alpine.DEB.1.10.0810081629460.15851@aragorn.flymine.org>
Matthew Wakeling <matthew@flymine.org> writes:
> The oid in the error message is of a database that no longer exists, which
> indicates that it is *probably* referring to the template database.
> Unfortunately my colleagues just wrote the script so that it retries, so
> we don't have a decent log of the failures, which were a while back.
> However, I have now altered the script so that it fails with a message
> saying "Report this to Matthew", so if it happens again I'll be able to
> give you some more detail.
One other bit of possibly useful data would be to eyeball the file mod
times in the orphaned subdirectories. If they were from failed CREATE
DATABASEs then I'd expect every file in a given directory to have the
same mod time (modulo the amount of time it takes to copy the DB, which
is probably not trivial for the DB sizes you're dealing with). If you
could also correlate that to the times you saw CREATE failures then it'd
be pretty convincing that we know failed CREATEs are the issue.
Also, I would definitely urge you to update to 8.3.4. Although I'm not
seeing a mechanism for CREATE to fail to clean up like this, I'm looking
at the 8.3 branch tip code, not 8.3.0 ...
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, matthew@flymine.org
Subject: Re: Disc space usage
In-Reply-To: <8827.1223481087@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox