Hi,
We have same problem on gentoo linux (AMD64).We have identified the
problem but, dont know how to solve it (now just try to avoid :) ) :
Any overflow exception (arith_except : gds : 335544321, isc : -802)
causes server to forcibly close down all current connections. (Other
servers, like debian or win or whatever throw out expection to client app)
As I said we dont know why this is happenning, but try to avoid it with
clear programming with no overflows :), ( it is human mistake anyway :) )

Adomas

Dennis McFall wrote:

>Adam wrote:
>
>
>
>>--- In firebird-support@yahoogroups.com, Dennis McFall <dennis@a...>
>>wrote:
>>
>>
>>
>>
>>>We have the same Windows application running at about a dozen
>>>completely independent sites, with a variety of hardware. Client
>>>workstations (from 5 to 25 workstations) connect to the Firebird server
>>>at the site; some are on Windows servers, some on Linux. The app is
>>>running on Windows and Novell networks. Some of the sites have been
>>>
>>>
>>>
>>>
>>very
>>
>>
>>
>>
>>>active for 5 years. We use IP addresses in the connection string, not
>>>server names.
>>>
>>>Now we have a new installation site, with the database on Linux;
>>>
>>>
>>>
>>>
>>Windows
>>
>>
>>
>>
>>>network. In every (client) case, after about ten minutes of inactivity,
>>>the next attempt to access the database (query, update, etc.)
>>>
>>>
>>>
>>>
>>results in
>>
>>
>>
>>
>>>this error message:
>>>---------------------------------
>>>ISC ERROR CODE: 335544721
>>>
>>>ISC ERROR MESSAGE:
>>>Unable to complete network request to host "222.111.44.55". [This
>>>
>>>
>>>
>>>
>>isn't
>>
>>
>>
>>
>>>a real IP address for us; edited for privacy]
>>>Error reading data from the connection.
>>>An existing connection was forcibly closed by the remote host.
>>>---------------------------------
>>>
>>>
>>>
>>>
>>>
>>As you correctly identified, the connection has been broken. IIRC,
>>there is no timeout parameter specific to Firebird, so it is either a
>>network issue, or some UDF call is crashing the server. Check the
>>Firebird log to see if it has been restarting itself. It would not
>>surprise me if this is the case considering it is your first Linux
>>install. Might be obvious, but make sure there is no "power save"
>>setting that could be doing this.
>>
>>Adam
>>
>>
>>
>>
>
>Adam:
>Thanks for the reply. Actually, we have the app running on Linux servers
>(FC3 and FC4) elsewhere with no problem. And we use no Firebird UDFs at
>all, so I think that is not involved. I will have the Firebird log
>checked: thanks for that tip, and also the one about "power save." I
>wonder what "network issues" might include? I have suggested that they
>check/replace the NIC, although the specifically "OK-for-10-minutes"
>part of it kind of rules that out.
>
>I really appreciate your responding. Have some nice days....
>
>Dennis McFall
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>