Re: [Firebird-devel] database terminated abnormally

[Alex P. <pe...@in...>]

lmf wrote:
>   My reply has sent for nearly two days, but I still cannot see it, maybe
> because I am not registered user and cannot send my message directly.
> 
>   Now I repeat it as follows:
>   OS:Windows2000 advanced server
>   FB version:FB1.52 SuperServer
>   Machine:IBM 7100, 2CPU 1GRAM
>   Database:four database file, one file size is larger than 4G
> 
>   Who can help me? Everyday include today the FB server terminated
> abnormally. There are more than one hundred client connected, I don not know
> which database file is relative to the disaster.
>   Please help me!!

I don't know who asked for specific CPU/RAM values. Anyway - such box 
must be able to serve 4G database w/o problems.
1. Try to run: gfix -v -f for all 4 databases (users must be 
disconnected for this to be done). You must fix any errors if they present.
2. Sometimes problems like described by you happen due to buggy UDFs. Do 
you use UDFs? Standard or your own?
3. Try Classic instead of Super. This will be useful at least because 
this will not drop all users connection (only one that causes firebird 
to AV) when single process dies, and help you troubleshoot which 
database causes problems and at what particular place in your client 
software.
4. Try linux instead of w2k.

A.