On Wed, 8 Oct 2008, Tom Lane wrote:
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).
Yes, I did that, and the file modification times were in such a pattern.
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.
Can't do that until next time it happens, because we don't have the logs from when it did happen any more.
Matthew -- Jadzia: Don't forget the 34th rule of acquisition: Peace is good for business. Quark: That's the 35th. Jadzia: Oh yes, that's right. What's the 34th again? Quark: War is good for business. It's easy to get them mixed up. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
