Hi

I have a FB 2.0.1 db (superserver) that is a back end to a web service
application. There are two programs accessing the DB. One is an Apache
web service (CGI), the other is a std windows app that runs on the same
machine that pumps data back and forth between the web service db and
another FB db.

We have had very slow performance with the DB and discovered that it was
corrupt, both times we have used GFix adn backup retore to mend the DB
and restore performance. The only other time we have ever had problems
with a FB DB has been a hardware issue. However we have just moved the
system to a newer and faster machine and have the same problem (after
half a days use).

The interface app (not web service) logged the following error ...

Failed to update SOAP DB, table : StockLevel. Error : ISC ERROR
CODE:335544333

ISC ERROR MESSAGE:
internal gds software consistency check (can't continue after bugcheck)

STATEMENT:
TIBOInternalDataset: "<TApplication>.MainForm.zMainDM.CheckSOAPGe


The query being used is a read only select statement running in a read
only transaction.

The only thing that is different to other DBs we have done is that this
one uses many more triggers. Could these be causing the problem?

I plan to try running just the Web side of the app for a time to see if
this app is the culprit.

Does anybody have pointers for where to start looking?

Thanks
Rob