Subject | Re: [firebird-support] Online DDL |
---|---|
Author | Kjell Rilbe |
Post date | 2014-03-23T14:35:07Z |
Den 2014-03-23 09:37 skrev Jesus Garcia såhär:
IBSurgeon gave me that impression, although he didn't state it
explicitly. That's how it was repaired, by the way. The affected table
was not necessary for me, so he "simply" used their tools to create
empty metadat for it, losing all old/existing data content. After that I
did a gbak backup/restore to make sure everything was nice and clean.
Kjell
>Running FB 2.5, but I thought it was a know issue. At least the guy at
>> 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 concern
>> dropping tables.
> What version of firebird are you using? If it is one of the latest,
> would be helpful to open a ticket in the tracker in order to be solved.
> I think is a serious bug corrupt a database, and more serious if it
> happens executing DDL statements.
>
IBSurgeon gave me that impression, although he didn't state it
explicitly. That's how it was repaired, by the way. The affected table
was not necessary for me, so he "simply" used their tools to create
empty metadat for it, losing all old/existing data content. After that I
did a gbak backup/restore to make sure everything was nice and clean.
Kjell