ramiro.barreca wrote:

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

Do you maybe run with version 2.1.1.17910 or below? If yes, it has bug
with COALESCE that make it crash. Apparently, the bug has been fixed,
but all the binary packages on FB website are still 17910. :(

I reported this bug at 8th of October 2008. in firebird-devel. The
message subject is "Firebird 2.1.1 crashes on simple select". This
crashes the server for example:

select 1 from rdb$database
where current_date >
COALESCE(current_date, cast('2001-01-01' as timestamp));


Adriano said it is fixed:

> Tried it on V2.1.0.17798 (v2.0), V2.1.1.18036 (latest v2.1 branch) and
> T2.5.0.21114 (HEAD) and all say "Datatypes are not comparable in
> expression COALESCE".

In Firebird 1.5 such query would actually work, but sometimes produce
bad results. In newer versions it correctly reports: "Datatypes are not
comparable in expression COALESCE". However, version 2.1.1.17190 crashes
instead. I did the test with 32bit CS on Linux.

Try searching for such COALESCE constructs in your code or compiling FB
yourself to see if it helps.

--
Milan Babuskov
http://www.firebirdfaq.org
http://www.guacosoft.com