I forget to say that you must disconnect all clients before run gfix Em 07/01/2014 18:35, "Alexey Kovyazin" <a...@ib-aid.com> escreveu:
> > > Hi Ryan, > > >My understanding is that gbak does a sweep while doing a backup, which > happens nightly, so sweep should be happening then (if I understand it > correctly that is). > > You are wrong. Gbak does not do sweep, it runs snapshot transaction and > reads all records in all tables - and, with some conditions, it can clear > some garbage versions. > > Restart should fix oldest active stuck - if it's a real restart (Classic > processes sometimes remain active). Did you check that all processes are > down? Or did you restart hardware? > > And it also could be another problem, more complex... I can't say more > without detailed investigation. > > Regards, > Alexey Kovyazin > www.ibsurgeon.com > > > > > > This is Classic, so yes, automatic sweep is disabled. My understanding is > that gbak does a sweep while doing a backup, which happens nightly, so > sweep should be happening then (if I understand it correctly that is). > Also, running a manual sweep hangs indefinitely. > > > As for the active transaction, restarting Firebird doesn't fix the > problem. The ONLY thing that fixes the problem is restoring from a backup > file to create a fresh file. According to Sinatica, there are no active > transactions while the problem is being exhibited. I will check the raw > MON tables, but would restarting the Firebird service not terminate any > active transactions? > > > Thanks for all the quick responses! > > > Ryan > > > >