Possible application freeze with IBDAC / Firebird embedded

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
primarypower
Posts: 2
Joined: Mon 22 Nov 2010 16:56

Possible application freeze with IBDAC / Firebird embedded

Post by primarypower » Mon 22 Nov 2010 17:17

Hi

We are facing a strage issue on our software that we believe that is caused by IBDAC + Firebird embedded database, we are using latest version of both IBDAC and Firebird.

We have a service application that has access to a simple database, using firebird embedded, our app is a very complex remote security video management system.

Randomly when we start the service or even when the application is idle, it freezes the main thread for more than 15 seconds, before freezing the main thread the whole computer will freeze for 1 to 2 seconds, applications like windows media player will freeze, then, the main thread freezes...

Is there any condition that can make it freeze?

We thought on a possibility but since we don´t know how IBDAC and firebird works internally we are not sure:

Firebird embedded server for some reason freezes for some seconds, while it is freezed, IBDAC connection component also freezes (We thought this because we believe the connection to local embedded database is made over TCP as well? Please confirm...). Since the IBDAC component is managed by the main thread, it will freeze main thread, waiting for a response of firebird server?

Could this happen? If yes, is there anything we can do?

Thanks

AndreyZ

Post by AndreyZ » Wed 24 Nov 2010 09:25

Hello,

Please try using not embedded Firebird version.
(We thought this because we believe the connection to local embedded database is made over TCP as well? Please confirm...)
Firebird embedded server supports access only via the local protocol.

Post Reply