We have a pool of more than 600 users accessing some FB 2.1.1
databases on a Open SUSE Linux server from different win32 apps
(Delphi 7 and VB6).
We have migrated those databases from FB 1.5 since there was a
performance problem with large DB sql queries and stored procedures
(one of this DBs has a single file of more than 9 GB with a table of
more than 25 millions of records).
After the migration, the server begins with random crashes
("terminated abnormally (-1)" message on firebird.log).
Unfortunatelly, this log is not enough to detect what is the problem.
After some surfing through several forums we detected that problems
could be among:
1) incompatibility of clients (gds32.dll, fbclient.dll, etc.)
2) incompatibility of UDFs (i.e.: rfunc)
3) Network disconnection of some clients (errors 104, 32, etc. in the
log).
4) Incompatibility of components used in the source code (Zeos,
Intersol, IProvider, etc.)
5) Queries that are restricted from FB 2.0 (table alias, etc.)
6) Linux rights over some files or folders? (errors while writing to
FDB datafiles).
7) Any other I forget?
As you can see the problem is "where to begin?". Firebird.log is not
a help, certainly.