Subject Re: ibserver with high CPU, after a system reboot
Author Alexander V.Nevsky
--- In firebird-support@yahoogroups.com, "Menashe Sulkies"
<msulkies@c...> wrote:
> You're right. The high CPU activity starts when we first connect to
the database (remotely) and then, we perform some initial 100 SQL
commands.

Perhaps it will be more convenient for you to set sweep intreval to
0 and perform it manually in suitable for this time?

> In some cases, during this problematic scenario, we receive the
following error:
>
> GDS Exception. conversion error from string "545"
>
> when performing the following command:
>
> INSERT INTO volume (name, vol_id) VALUES ('test', '545');
>
> where 'vol_id' is numeric (The same command succeeds for a local
database)

Are you sure no unprintable characters (such as #0) can be in the
string?

> If we then, reboot again the system, the problem vanishes.

IIRC in FB1.5 there were fixed some bugs around garbage collection
which is performed on entire database during sweep. Perhaps this is
source of problems with inserts in this time.

Best regards,
Alexander