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 EUR/Min.)
www.eventim.de & www.getgo.de