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