Subject Re: [firebird-support] Online DDL
Author Aldo Caruso
Excuse me but what does GTT mean ?
Can you please tell us how did you solve the issue. Could you mend the database using gfix ?


El 23/03/14 04:39, Kjell Rilbe escribió:

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.