--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > I am using firebird on an NT platform. I am using Visual

Basic .Net

> > as the frontend for the application. I am using version

1.5.0.3477-

> > 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
>
> Alan

Hi Alan,

Yes i have tested all sql and there is no problem with that.

My server log is filled with these:
COMP2 Tue Jun 24 18:19:26 2003
INET/inet_error: read errno = 10054

COMP2 Wed Jun 25 09:34:30 2003
INET/inet_error: read errno = 10054

COMP2 Wed Jun 25 09:34:30 2003
Fatal lock manager error: semop failed (acquire), errno: 6


navneet