| Subject | Re: [firebird-support] Re: Oldest transaction far behind... | 
|---|---|
| Author | Ann Harrison | 
| Post date | 2011-03-22T15:42:22Z | 
Kjell,
fix it because it's changes will block other updates. If not, you can
sweep the database and get rid of the old non-committed transaction,
or you can ignore it as a simple waste of a few kb of memory.
Cheers,
Ann
            > Problem is that the DB is 52 Gbyte so a sweep will take several hours,gfix -list will tell you if you've got a transaction stuck in limbo. If so,
> and a gbak takes about 5-6 hours. A simple file copy (when DB is ensured
> to have no connections) using fastcopy.exe at top speed, very close to
> hardware limits, takes almost half an hour.
fix it because it's changes will block other updates. If not, you can
sweep the database and get rid of the old non-committed transaction,
or you can ignore it as a simple waste of a few kb of memory.
Cheers,
Ann