Subject Tips on troubleshooting Firebird crashes
Author unclejung
I have been using Interbase and now Firebird since 1997, by choice. I
am very comfortable with the performance and reliability of Firebird
overall, and I love the simplicity of it.

Over the year, I have face many problems all of which I was able to
solve except for this one: how to troubleshoot a Firebird server
crash. In this particular case the log entry looks like:

DB9 (Client) Tue Aug 07 21:35:38 2007
C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe: terminated
abnormally (4294967295)

Which is not at all useful except for the time of the crash.

What I used to do to troubleshoot crashes was to use the process of
elimination: eliminate processes on the servers until the server stop
crashing, which is time consuming, and can be unpractical. I fixed the
last crash by eliminate a bad udf which I presume has some memory
access issues, and it took a while to track that down because I
couldn't not reproduce the problem by calling that udf millions of
time using a test stored procedure.

So, I would appreciate anyone having tips on how to troubleshoot
Firebird crashes in general. For example, "eliminate all udf's"

- Jung