Subject Re: [firebird-support] Network errors in production and local FB database
Author Mark Rotteveel
On Tue, 13 Sep 2011 12:40:44 -0000, "diegodelafuente"
<diegodelafuente@...> wrote:
> My IbExpert manager is closing very often without any error message.
> Checking the FB log I can see these alerts (see below)
> I can see this explanation regarding the alerts:
> INET/inet_error: read errno = 10054 or 10038 or 10093
>
> Error showings
> Multiple entries in firebird.log or interbase.log with errors 10054,
> 10038, 10093, etc.
> Reason
> These errors are caused by network problems - check your hubs, network
> adapters, etc. It is not an Firebird/InterBase error itself, but it may
> impact Firebird/InterBase.
> Recovery process
> We offer FBScanner tool to solve "10054 errors" problem (among other
> issues). See details here.
> Recovery chances:
> Not applicable.
>
> The strange thing here is that my FB database could be one in production
> or my local DB (for development). In this case the log is from my local
DB.
>
> I'm using FB 2.5, windows XP all in a virtual machine (using Virtual
Box)

10054 is a connection reset by peer and is a symptom of the problem you
are experiencing with IB expert, not a cause (if IB expert crashes or
something else, the socket is not closed correctly, which results in 10054.

http://msdn.microsoft.com/en-us/library/ms740668%28VS.85%29.aspx :
An existing connection was forcibly closed by the remote host. This
normally results if the peer application on the remote host is suddenly
stopped, the host is rebooted, the host or remote network interface is
disabled, or the remote host uses a hard close (see setsockopt for more
information on the SO_LINGER option on the remote socket). This error may
also result if a connection was broken due to keep-alive activity detecting
a failure while one or more operations are in progress. Operations that
were in progress fail with WSAENETRESET. Subsequent operations fail with
WSAECONNRESET.

Mark