Subject | Re: ibserver with high CPU, after a system reboot |
---|---|
Author | Alexander V.Nevsky |
Post date | 2004-02-12T16:53:43Z |
--- In firebird-support@yahoogroups.com, "Menashe Sulkies"
<msulkies@c...> wrote:
commands.
Perhaps it will be more convenient for you to set sweep intreval to
0 and perform it manually in suitable for this time?
Are you sure no unprintable characters (such as #0) can be in the
string?
which is performed on entire database during sweep. Perhaps this is
source of problems with inserts in this time.
Best regards,
Alexander
<msulkies@c...> wrote:
> You're right. The high CPU activity starts when we first connect tothe 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 thefollowing error:
>database)
> 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
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