Hi,

At November 3, 2003, 08:39, Nemesis wrote:

> Sometimes the database has problems answering requests in an
> appropriate time (5-10 minutes for requests normally taking less than
> a second). When I take a look at the TOP I see a load average at
> about 0.5 to 1.5, wich isn't a problem normally. But there are
> hundreds of ibserver-processes in the list without causing CPU-load
> or memory-workload. A restart of the server removes the problem only
> temporarily. There seems to be no particular reason for it though.
> Sometimes it works perfectly for day, sometimes it occurs again after
> a few hours and seems to be independet from the traffic on the
> system. We also tried to move the file to another server but the
> problem occured there also, so the problem seems to lie inside the
> database-file. gfix didn't help anything either.

> Any ideas?

What are the statistics of the database when it happens? Use gstat to
retrieve the information, just show the header of the database(namely
the transaction information and the sweep interval). Also, are forced
writes on or off(this is also found in the header)?

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)