| Subject | RE: [firebird-support] Re: 450 active transactions after database restore, is it normal? |
|---|---|
| Author | Leyne, Sean |
| Post date | 2015-07-03T14:20:01Z |
Dmitry,
Gstat like gfix do not use standard database transactions/operations for their functionality, so while they connect to the database, they do not always use transactions -- which would update the header page details.
Sean
> 02.07.2015 19:36, 'Leyne, Sean' wrote:Right!
> >
> >>> Oldest transaction 1
> >>> Oldest active 2
> >>> Oldest snapshot 2
> >>> Next transaction 492
> >
> > Even it that switch was used, why would the transactions appear to active?
>
> They're not active, the header page is just out-of-date. Transaction counters
> are updated when some transaction is started. When nobody is connected,
> OAT does not make any sense.
Gstat like gfix do not use standard database transactions/operations for their functionality, so while they connect to the database, they do not always use transactions -- which would update the header page details.
Sean