Re: Timing problem in DROP TABLESPACE?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Timing problem in DROP TABLESPACE?
Дата
Msg-id 20081106150730.GB5520@alvh.no-ip.org
обсуждение исходный текст
Ответ на Timing problem in DROP TABLESPACE?  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Timing problem in DROP TABLESPACE?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: [PATCH] EnableDisableTrigger Cleanup & Questions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH] EnableDisableTrigger Cleanup & Questions