Re: Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers
От | Nikhil Sontakke |
---|---|
Тема | Re: Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers |
Дата | |
Msg-id | CABamaqPf=pMPp0ZJ-kfq3F6hTvth48juFhNepFr1g6K1DysqBQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers (Daniel Farina <daniel@heroku.com>) |
Список | pgsql-hackers |
> Continuing in gdb, also completes the creation of c2 table without anyHmm. Does this break pg_dump? I have reported a bug whereby dangling
> errors. We are now left with a dangling entry in pg_class along with all the
> corresponding data files in our data directory. The problem becomes worse if
> c2 was created using a TABLESPACE. Now dropping of that tablespace does not
> work at all. Am sure we can come up with myriad such other issues.
pg_class entries point to a namespace that has since been dropped in
the past (and has been reported many times before that, even).
Sure does! I just tried it and got:
pg_dump: schema with OID 16384 does not exist
The bug report is here, whereby I also aggregate other similar bug
reports that have taken place over a very long period of time:
http://archives.postgresql.org/pgsql-bugs/2011-02/msg00185.php
I guess we DO need to pay attention to fix this properly now as there are some reports with 9.x too. And I have just provided a way to reproduce this reliably too.
Regards,
Nikhils
В списке pgsql-hackers по дате отправления: