Subject Re: [firebird-support] FB 2.1.1 server crashing randomlly
Author Anderson Farias
Hi,


>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.)

realy don't think so. fb clients (and servers) are very compatible between
different versions. Anyway, make sure you use same version for client and
server as much as possible.

> 2) incompatibility of UDFs (i.e.: rfunc)

if you does use some UDF, than yes, you better check on it

>3) Network disconnection of some clients (errors 104, 32, etc. in thelog).

No. really don't think it may couse a server crash. Those 104/110 net errors
are pretty normal

> 4) Incompatibility of components used in the source code (Zeos,Intersol,
> IProvider, etc.)

Very unlike (not to say impossible)... You could be executing some SQL that
hits some fb bug... but that's another story...

> 5) Queries that are restricted from FB 2.0 (table alias, etc.)

no. not really

> 6) Linux rights over some files or folders? (errors while writing to FDB
> datafiles).

did you check for TEMP space (folder rights/available space)? also check for
server memory use on hi loads...

> 7) Any other I forget?
>As you can see the problem is "where to begin?". Firebird.log is not
>a help, certainly.

Others may came up with an explanation about the error you see on
firebird.log... and, if that info is not enougth, than running a debug
version of FB may help further on getting more info about what it's going
on...


Regards,
Anderson Farias