Subject Re: [firebird-support] Online DDL
Author Kjell Rilbe
Den 2014-03-23 03:46 skrev Aldo Caruso såhär:

My concern was about logical or business rules issues, not about database corruption, which I didn't know could happen.

Why does corruption happen mixing DDL and DML in the same transaction ?


I had a database corruption recently and was told that it may have been caused by dropping tables while the database was online with other users connected. Apparently there is some kind of race condition in the page allocation that can cause the same page to be allocated to different "things" when doing that. It ONLY concernc dropping tables. Dropping indices, constraints and columns is fine. GTT:s are fine. Adding stuff is fine.