On Sun, 07 Nov 2010 08:47:56 Nando Dessena wrote:

> Tom,
>
> > I now have some evidence of what is causing the problem. A Delphi
> > client application used a thread to create a connection to the
> > database and run a query. Something caused an access violation in the
> > thread at the point when it opened the query. The exception was
> > handled and the thread will have terminated but the database is still
> > showing a connection in the MON$ATTACHMENTS table and this has
> > blocked garbage collection. Nothing was logged to firebird.log.
>
> is the exception handling code rolling back the transaction and closing
> the connection?

I *think* the transaction is being rolled back and the connection terminated
but there are a lot of permutations in the client code so it's possible that
in some situations this isn't happening. Is there a mechanism with Firebird
for timing out a transaction or connection that is inactive for a long period
of time?

Tom