Subject Re: [firebird-support] Long running gfix - safe to kill?
Author Ann W. Harrison
Dave McNeill wrote:
>
> I am watching a gfix -sweep which has been running for nearly two
> hours. It's coming up to 6am and I need to bring the site back up. Is
> it safe to kill this process?

Sure. You won't get all the benefit of the sweep, but whatever clean-up
it has done will stay done. Sweep does two things. First, it reads
every record in the database, forcing garbage collection on old versions
and deleted records. Second, when it's done, it changes the state of
transactions that had rolled back before the sweep started to committed.
That' safe because all the changes made by rolled back transactions
have been removed from the database.

The second step can't happen until the first one completes, so if you
kill the sweep, you won't get that benefit. But, as I said, any garbage
its already removed will stay gone.

Regards,


Ann