Hello Everybody,
we have a Database running on SuSE-Linux 8.2, with Firebird 1.0.3
SuperServer in a Dell 2650 with HT Prozessor Intel Xeon 1.8 GHz, 1GB
RAM

The database is used as backend for order- and customerdata of an
eCommerce-Site.

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?

Desperately
Jan Turner
----------------------------------------------------------------------
-----------------
CTS EVENTIM AG
Jan Turner
[mailto:jan.turner@...]
head of softwaredevelopment
Süderstraße 79
D-20097 Hamburg

Fon: +49-40-2374-1590
Fax: +49-421-223119-490
Mobil: +49-179-7571128

Tickets über
EVENTIM-Vorverkaufsstellen
Hotline: 01805 - 570 000 (0,12 €/Min.)
www.eventim.de & www.getgo.de