| Subject | RE: Garbage collection / sweep not happening on super classic |
|---|---|
| Author | |
| Post date | 2014-01-07T20:54:25Z |
Last time I tried it, the gfix process hung and sat at 0% CPU for hours. I had to terminate it. A backup only takes about 20 minutes, so I figured gfix should take several hours.
I will try to run it again and get more detailed information to report back here (with everyone logged out).
Ryan
---In firebird-support@yahoogroups.com, <fabianoaspro@...> wrote:
Are you sure gfix hangs? Maybe is a hdd slowdown in the process.
We had this same issue. Gbak does not clean all the mess on only one of our clients.
The sollution is run a gfix and wait.
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