Embedded Firebird unload delay

Question

After I close my application fbclient.dll remains in memory for about 3 seconds. So it locks the database file and prevents my application from unloading. I'm using Firebird embedded.

The problem is related to events. I signup to events using isc_que_events. If I don't signup to events dll unloads instantly.

I faced this problem in previous FB versions and now in 2.1.3 it's still the same.

The same issue is described here http://tracker.firebirdsql.org/browse/CORE-15, but it's resolved as "Cannot Reproduce".

Is anybody facing this problem or there's something wrong with my code?

Answer 1

Are you using the .NET Provider? This one keeps connections open in a pool, maybe this is the problem. Try clearing the connection pool before exiting your application:

FbConnection.ClearAllPools();

Answer 2

I've rewritten my logic and now I don't need to subscribe to local events. So it's not a problem for me anymore. But the issue still remains.