Subject Re: [firebird-support] Error reading data from the connection
Author Helen Borrie
At 12:42 AM 29/11/2005 +0000, you wrote:
>We're using Delphi with FIBPlus components and a Linux Firebird 1.52
>server with about 150 connections from Windows XP clients. Recently,
>we've started getting intermittent "Error reading data from the
>connection" exceptions in our client programs, usually from the same
>place in the Delphi code. There are no corresponding problems in the
>Firebird server log (there are lots of 104 errors but we seem to get
>these most days with or without the "Error reading data from the
>connection" on the clients.) Does anyone have any ideas on what might
>be going on here?

Well, it's due to a network error - the client has lost contact with the
server, one way or another. Either you have a dicey NIC; or, more likely
in this case, the server crashed, given that it's consistently happening at
the same place in the Delphi code. HIghest on the suspect list therefore
would be a call to home-grown UDF that has a crash scenario somewhere in
some execution branch.

That said, you don't say anything about the server, either which model or
what kind of configuration you are running it on. It might just be that
150 concurrent connections saps the server resources anyway, and you have
one particularly humongous query that is habitually the last straw....