Re: Timing problem in DROP TABLESPACE? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Timing problem in DROP TABLESPACE?
Date
Msg-id 20081106150730.GB5520@alvh.no-ip.org
Whole thread Raw
In response to Timing problem in DROP TABLESPACE?  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Timing problem in DROP TABLESPACE?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Simon Riggs wrote:
> I've run regression tests many, many times recently, usually in the form
> of a looping installcheck, rather than just make check.
> 
> On a recent test the last command of the last test has failed:
> DROP TABLESPACE testspace;
> ERROR:  tablespace "testspace" is not empty
> 
> The directory was confirmed as non-empty, though when running the
> command again it worked successfully.

Maybe it is failing due to files that are scheduled to be deleted by
next checkpoint?  If it runs a checkpoint internally, perhaps there's a
race condition in the code that waits until the files are gone.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: [PATCH] EnableDisableTrigger Cleanup & Questions
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] EnableDisableTrigger Cleanup & Questions