Hi,

A database we have is several GB and has been functioning well for
years. Until recently. The first symptom was that writes to the database
have become very slow (taking a minute or two to commit a simple
transaction). So we first tried the usual trick of a backup/recover.
gbak writes a file 1.4MB long and then sits apparently doing nothing,
yet the fbserver process is consuming 50% cpu (with no other users).
Tried running gfix -v and got a similar behaviour, several hours later
still running with no output whatsoever to the console. So then I
downloaded IBSurgeon and ran that. It ran 'diagnose' happily and told me
the DB was fine.

The system in use is a Win 2003 dual core server running FB 1.5.2. Is
this a known problem? Should we just upgrade to 2.1.2?

Regards
Terry

--
Terry Johnson
S4 Technology
Ph +64 9 6254167
Mb +64 21 2596891
Click for current Time & Date in New Zealand
<http://www.timeanddate.com/worldclock/city.html?n=22>




[Non-text portions of this message have been removed]