Subject RE: [firebird-support] Re: 450 active transactions after database restore, is it normal?
Author
Sean,

> > > Oldest transaction 1
> > > Oldest active 2
>
> > Oldest snapshot 2
> >
> Next transaction 492

> > > Gstat was started right after the restore. Is it normal to have so
>
> > many active transactions right after the database restore?
>
>
> > Yes. I suppose you used the -verbose switch, right? In this case each index is
>
> created in a separate transaction.

> Even it that switch was used, why would the transactions appear to active?

  I could understand if you think that tx 2 is still active, but why do you think
that tx 3, tx 4 ... tx 491 is also active ??? What make you think so ?

Regards,
Vlad