Subject RE: [firebird-support] 100% Cpu Usage
Author Alan McDonald
> I am using firebird on an NT platform. I am using Visual Basic .Net
> as the frontend for the application. I am using version
> 0.RC3 and 1.0 - .NET Framework 1.0. I am having a few problems
> though. There are about 4 users accessing the database simultaneously.
> 1. After running for a while the firebird server takes up 100% Cpu
> usage. and stop responding to any client request.
> 2. At this point the client application also freezes as a call to the
> database never returns.
> 3. I also have another question, if the client program opens a
> transaction and for some reason lose the connection to the database
> and couldnot comit or rollback the transaction, is there any
> mechanism by which after certain time the server will close the
> transaction and thus release the locks, if not what happens if there
> are open transaction which are never commited or rolledback.
> Can anyone please help.

Sounds like an SQL statement causing the server to go wacky - have you
tested all the SQL?

If the connection is lost the server will rollback