Subject Re: [firebird-support] Re: Oldest transaction far behind...
Author Ann Harrison
Kjell,

> Problem is that the DB is 52 Gbyte so a sweep will take several hours,
> 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.


gfix -list will tell you if you've got a transaction stuck in limbo. If so,
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