CREATE DATABASE/DROP DATABASE race conditions
От | Florian Weimer |
---|---|
Тема | CREATE DATABASE/DROP DATABASE race conditions |
Дата | |
Msg-id | 87r8i6jstv.fsf@CERT.Uni-Stuttgart.DE обсуждение исходный текст |
Ответы |
Re: CREATE DATABASE/DROP DATABASE race conditions
|
Список | pgsql-bugs |
I'm observing weird behavior with CREATE DATABASE/DROP DATABASE and PostgreSQL 7.2.1 (on Debian/unstable): There seems to be a short time period after the 'Z' response of the backend during which the database continues to exist (e.g. subsequent CREATE DATABASE operations with the same name fail) or does not exist yet (e.g. it is not possible to connect to the database). You cannot reproduce this with "psql" or "createdb"/"dropdb". In the first case, the operations appear to be properly serialized, in the second case, the process creation overhead prevents triggering this race condition. (I observe these with a test suite for a client interface library.) This might be a kernel or file system quirk (I'm using XFS 1.1). Is this a known issue, or shall I try to come up with a C test case? -- Florian Weimer Weimer@CERT.Uni-Stuttgart.DE University of Stuttgart http://CERT.Uni-Stuttgart.DE/people/fw/ RUS-CERT fax +49-711-685-5898
В списке pgsql-bugs по дате отправления: