Subject Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend
Author Mark Rotteveel
On 11-1-2018 09:14, jonatan.lauritsen@... [firebird-support] wrote:
> We have observed, that Firebird 3.0.1 freezes on one specific table for
> some 10-20 minutes during backup. This freezing happens only in the case
> when gfix/mend had been performed before backup. Backup runs smoothly
> when no gfix/mend had been performed previously. There are no significat
> error messages or warning in Firebird log (even gfix/mend do not produce
> them). It is know that this one specific table is updated frequently
> during production time and this table can experience long-running
> transactions (and maybe even unreported deadlock exceptions). Maybe
> frequent updates create lot of back-versions of Firebird records and
> these backversions are processed during backup.
> Are there any ideas what happens and how to prevent it?

My first suggestion would be to update to 3.0.2, which was released in
March last year. It fixes a security vulnerability, several hangs,
server crashes and some performance issues.

But you really should describe why you have used gfix -mend.

Mark Rotteveel