Subject Re: [firebird-support] Re: Drop table safe when other users are active?
Author Kjell Rilbe
Den 2019-05-26 kl. 13:28, skrev hvlad@...
[firebird-support]:
>
> > A few years ago we suffered Firebird corruption and got it fixed with
> > the help of IB Surgeon. I was told at the time that dropping tables
> > while other users were connected was the probable cause, and that this
> > was a bug in FIrebird that had been around for a long time. I think
> this
> > would be for Firebird 2.5.
>
> What bug ? Is it registered at the tracker ? Do you have a test case ?
>
> > Now I'm wondering if this is a bug that is known to have been fixed
> > since then? In other words: Is it now (version 3.0.4) safe to drop
> > tables when the database is in use by multiple users?
>
> I physically can't answer if some unknown bug is fixed or not. There
> was a lot
> of changes and refactorings during FB3 release circle. It is
> impossible to make
> any kind of correct answer on such a question, sorry.
>
> Regards,
> Vlad
>

I realize that it's difficult. I was under the impression that this is a
well-known problem, since it appears to be well-known to the guys at
IBSurgeon. Apparently not. It's probably highly intermittent,
considering I have dropped a lot of tables in non-exclusive mode through
the years, before I got a corruption and learned about this problem. A
test case? Yeah, well, I could try... But I think it would be better if
the dev team were to communicate with those who know the problem a lot
better, i.e. please talk to IBSurgeon.

Regards,
Kjell



[Non-text portions of this message have been removed]