INET/inet_error: read errno = 10054

[Tomasz Dubiel]

Hello.

Some customers using our ERP system report problems with loosing connection to the database. The situation is random - one time the message "Connection to the database has been lost" appears after system inactivity, sometimes it happens during the work with the system. One time it happens for a few users, sometimes almost for all users.

Customer claims there is no problem with network connectivity, every setting with network card related to energy saving is off. The antivirus and firewall also seems not to have an impact.

How can we dive into this problem and find its cause?

There is Firebird 2.5.9 Classic Server installed.

Looking at the logs, we can see plenty of this:

INET/inet_error: read errno = 10054, client address = ****/****, user = ******

Best regards.

[Dimitry Sibiryakov]

Tomasz Dubiel wrote 02.11.2021 12:23:
> Customer claims there is no problem with network connectivity, every setting
> with network card related to energy saving is off. The antivirus and firewall
> also seems not to have an impact.
> How can we dive into this problem and find its cause?

You can trace source of RST packet (which ends up as 10054 error) using
WireShark.

https://medium.com/@shriramsharma/analyze-tcp-connection-resets-with-wireshark-30af498d04fa
https://portal.nutanix.com/page/documents/kbs/details?targetId=kA00e000000LTA6CAO

--
WBR, SD.

[Tomasz Dubiel]

Thanks, I will try to analyze it. What is weird, in log I can see even entries about my Windows user I'm currently logged in, on different ports, even if I dont do any database related activities.

[Stefan Heymann]

> Some customers using our ERP system report problems with loosing connection
> to the database. The situation is random - one time the message "Connection
> to the database has been lost" appears after system inactivity, sometimes
> it happens during the work with the system. One time it happens for a few
> users, sometimes almost for all users.

A typical cause for this are energy setting that put the PC to sleep (energy saving mode) after a certain time of user inactivity (e.g. 20 minutes). After it is powered on again, all TCP connections are lost (half-open). If your client driver doesn't do an automatic reconnect (fbclient.dll itself doesn't), then you will have to take other measures to re-establish the connection.


Regards

Stefan

[Tomasz Dubiel]

Is it possible that not properly closing the connection by some processes can affect other processes so they disconnect with database with the same error?