Hello everyone!
I am a VB Developer, and my office currently uses Firebird 2.0 DB
system. I have a recurring problem that I cannot seem to pinpoint.
My current setup is the following:
VB.Net 2005
Firebird .Net provider 2.1.0
Firebird 2.0 DB
IBExpert 2009 version
Legacy software using Firebird ODBC Data Provider 1.2.0.69

Heres the problem I experience. I have written several "patchwork"
type windows applications that interface with the Firebird DB for my
shop. Our shop also has legacy software that is constantly running
in the background (24/7/365). Intermittently, my software
will "hang" on a relatively simple SQL query. My code successfully
connects to the DB with connection string, but "hangs" when it
reaches the first query within the code. This "hang" does not
trigger any errors within the code, and it does not return any
values, it will simply just sit there forever if I allowed it (I let
it run once for 8 hours before killing the program). This seems to
occur once per week up to once every other week. This problem
requires a reboot to the DB Server in order to clear up. I can
physically place the query into SQL Editor in IBExpert, and the query
will process just fine. Likewise, the legacy software seems to be
unaffected. I have tried to alter DB settings, and I have been
monitoring users/transactions within the DB, and there doesn't appear
to be much of any rhyme or reason for the disruption, although,
typically, there is about a 20k - 50k transaction gap between OAT and
next transaction. The DB processes apx. 200k transactions per day.
I have tried to find info on how to release a limbo transaction, but
there doesn't seem to be a manual way to do this, and a sweep of the
system does not change anything. Can anybody help?? Getting
desperate here!