Re: Timing problem in DROP TABLESPACE?

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.