Subject Re: [firebird-support] Re: Firebird: "Connection forci bly closed"
Author Bogusław Brandys
Adomas Urbanavicius wrote:
> 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
>>
>>

Only guessing...but it look like some OS library problem ,maybe standard
C++ library (libstdc++ if I remember) incorrect version ? Also : do you
use Firebird NTPL version ?

Regards
Boguslaw Brandys