I wrote an application which runs continuously in the background on my
machine. It logs information to my firebird database using firebird library
calls every 60 seconds. When I first wrote the application I held an open
connection to the database for a long time which made my firebird server hog
lots of memory and never release it back to the operating system. To solve
the memory problem, I now connect to and release from the firebird server
every 60 seconds, when I want to query or update the database.

My problem now is that after running successfully for precisely 4 hours and
47 minutes (really... I did this three times and got the same results) my
application stops updating the database successfully. It is able to attach
to the database, but fails at the isc_start_transaction function call. Once
I get the error, it keeps happening consistently. My application is no
longer able to interact with the firebird server. If I kill my application
and immediately restart it, it works fine for another 4 hours and 47
minutes.

Anyone have a clue how to debug this? Anyone experience similar behavior?

Regards,
Marlena Miller