I seem to have a result now running with the -G -L -IG options selected.
The gbak completed without complaint.

Thanks
Terry


Ricardo Uzcategui wrote:

>
> Subject: Re: [firebird-support] Very slow writes, gbak hangs, but
> database valid?
> To: firebird-support@yahoogroups.com
> <mailto:firebird-support@yahoogroups.com>
>
>
> *Hi. Maybe you need some index to improve trigger acction that only
> will be apreciate later when it grow...*
>
>
>
> 2008/11/11 Terry Johnson <terry.johnson@...
> <mailto:terry.johnson@...>>
>
> 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.
> <http://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]
>
>
>
>
>
>
> --
> Ricardo...
>
>
>
> --
> Ricardo...
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com
> Version: 8.0.175 / Virus Database: 270.9.0/1779 - Release Date: 10/11/2008 7:53 a.m.
>
>

--
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]