Subject | Re: [firebird-support] Re: OAT stuck after backup |
---|---|
Author | Helen Borrie |
Post date | 2006-03-23T22:12:29Z |
At 08:10 AM 24/03/2006, you wrote:
This could be from one of two causes:
1. You have set NoGarbageCollect in your backup options.
2. NoGarbageCollect was off, but GC had nothing to work on during
gbak, i.e. there is already a stuck transaction.
Consider also the possibility that you're looking at the stats before
the backup is finished. If gbak is able to collect any garbage, it
won't show up until gbak's transaction commits.
./heLen
>My apologies, it should say that the "next transaction" increases by 1Of course it does. Backup runs in a transaction.
>and the OAT will never move afterwards. To summarize, after a backup
>the next transaction goes up by 1
>and the oldest active transaction freezes.The oldest transaction *stays* frozen?
This could be from one of two causes:
1. You have set NoGarbageCollect in your backup options.
2. NoGarbageCollect was off, but GC had nothing to work on during
gbak, i.e. there is already a stuck transaction.
Consider also the possibility that you're looking at the stats before
the backup is finished. If gbak is able to collect any garbage, it
won't show up until gbak's transaction commits.
./heLen