Subject | Re: [firebird-support] RE: Garbage collection / sweep not happening on super classic |
---|---|
Author | |
Post date | 2014-01-07T20:52:10Z |
>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.
Ah I see - the documentation simply mentioned something like "garbage collection maybe done during backup" - now I see that doesn't mean the same thing as a sweep.
>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?
It is super classic (with only the one process), so I shut it down, verified processes were no longer running, and verified that the file was no longer "in use". On top of that, the server hardware reboots each week. Nothing, so far, has released the oldest transaction.
I will try gfix making sure no one is attached to the database and see what happens, then report here.
Ryan