In Linux (kernel 2.6.16.21) INET/inet_error: read errno = 104 [CORE1192] #1617

firebird-automations · 2007-04-04T19:43:00Z

Submitted by: Alexander Galilov (al-gali)

From time to time (not in maximal load periods!) I see "INET/inet_error: read errno = 104" in firebird.log file.
The server machine works uninterruptable and firebird process has about 60 TCP concurrent connection from local network (fast ethernet). Each connection exists about few hours or whole day. Many transactions executes over each connection. The clients connects to the firebird using Firebird .Net Provider 2.0.1. Typicaly transaction has options READ COMMITED || NO WAIT || REC VERSION. And about 70% transactions are read only. The server executes about 500 000 transactions per day. Maximum load about 100 000 transactions from 6:00 pm to 8:00 pm.
All options in firebird.conf have its default values.

Log file:

firebird (Server) Tue Apr 3 23:45:25 2007
INET/inet_error: read errno = 104

firebird (Server) Wed Apr 4 05:57:12 2007
INET/inet_error: read errno = 104

firebird (Server) Wed Apr 4 07:51:39 2007
INET/inet_error: read errno = 104

firebird (Server) Wed Apr 4 21:26:27 2007
INET/inet_error: read errno = 104

firebird-automations · 2007-04-05T04:01:55Z

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

firebird-automations · 2007-04-05T04:05:44Z

Commented by: @AlexPeshkoff

errno=104: Connection reset by peer

This is not firebird error. Firebird just reports about lost connections with clients (i.e. when client did not disconnect, but OS detected lost TCP connection). This may happen due to LAN problems or (very often) due to client plugged of computer without normal shutdown.

firebird-automations · 2007-04-05T04:05:44Z

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Won't Fix [ 2 ]

firebird-automations · 2007-04-05T05:39:14Z

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

firebird-automations · 2008-01-28T15:23:18Z

Modified by: @pcisar

Workflow: jira [ 11740 ] => Firebird [ 15531 ]

firebird-automations · 2014-04-14T06:15:19Z

Commented by: Franz J Fortuny (frafor49)

Well, the problem is still there, somewhere. As you can see here, the server STOPPED responding to connections requests. I didn't notice for 5 hours that no connections were possible. This is the error log file. The server NEVER EVER responded to the localhost or to the external connections. The above problem was published in 2007. This 2014, 7 years later. The server is version 2.5:

ISQL Version: LI-V2.5.1.26351 Firebird 2.5
Server version:
Firebird/linux Intel (access method), version "LI-V2.5.1.26351 Firebird 2.5"
Firebird/linux Intel (remote server), version "LI-V2.5.1.26351 Firebird 2.5/tcp (D19020)/P12"
Firebird/linux Intel (remote interface), version "LI-V2.5.1.26351 Firebird 2.5/tcp (D19020)/P12"
on disk structure version 11.2

The same server machine was also being used to host a mysql database which continued to work without flaws during the same hours that FirebirdSQL had the log reported errno(s) 104 (cliente) and 98 (Server). All connections were via Localhost, just like they were made to the mySQL hosted in the same machine.

If this is NOT a FirebirdSQL Bug, then it has to do with some network failure than only affects Firebird (and not the other servers connecting via Localhost). There must be a way to avoid this; is there?

D19020 (Client) Sun Apr 13 12:56:53 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 12:56:56 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 12:57:54 2014
INET/inet_error: read errno = 104

... (like this for, about 1000 errors)

D19020 (Client) Sun Apr 13 13:02:41 2014
INET/inet_error: read errno = 104
D19020 (Client) Sun Apr 13 17:54:31 2014
fbguard: guardian starting /usr/sbin/fbserver
D19020 (Client) Sun Apr 13 17:54:33 2014
fbguard: guardian starting /usr/sbin/fbserver

Here the error changes to 98 and is a Server error:

D19020 (Server) Sun Apr 13 17:55:21 2014
INET/inet_error: bind errno = 98
D19020 (Client) Sun Apr 13 17:55:21 2014
fbguard: /usr/sbin/fbserver terminated due to startup error (2)

D19020 (Client) Sun Apr 13 17:55:21 2014
fbguard: /usr/sbin/fbserver terminated due to startup error (2)

D19020 (Server) Sun Apr 13 17:55:23 2014
INET/inet_error: bind errno = 98

D19020 (Client) Sun Apr 13 17:55:23 2014
fbguard: /usr/sbin/fbserver terminated due to startup error (2)

D19020 (Client) Sun Apr 13 17:55:37 2014
fbguard: guardian starting /usr/sbin/fbserver

D19020 (Server) Sun Apr 13 17:56:27 2014
INET/inet_error: bind errno = 98

D19020 (Client) Sun Apr 13 17:56:27 2014
fbguard: /usr/sbin/fbserver terminated due to startup error (2)

D19020 (Client) Sun Apr 13 18:01:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:02:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:03:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:03:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:04:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:04:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:05:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:05:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:06:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:06:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:07:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:07:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:08:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:08:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:09:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:09:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:10:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:10:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:11:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:11:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:12:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:12:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:13:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:13:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:14:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:14:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:15:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:15:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:16:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:16:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:17:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:17:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:18:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:18:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:19:41 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:19:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:20:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:20:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:21:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:21:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:22:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:22:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:23:41 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:23:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:24:42 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:24:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:25:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:25:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:26:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:26:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:27:38 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:27:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:28:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:28:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:29:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:29:47 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:30:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:30:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:31:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:31:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:32:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:32:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:33:41 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:33:52 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:34:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:34:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:35:42 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:35:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:36:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:36:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:37:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:37:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:38:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:38:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:39:42 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:39:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:40:41 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:40:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:41:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:41:52 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:42:43 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:42:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:43:43 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:43:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:44:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:44:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:45:41 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:45:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:46:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:46:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:47:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:47:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:48:41 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:48:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:49:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:49:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:50:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:50:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:51:41 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:51:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:52:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:52:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:53:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:53:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:54:43 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:54:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:55:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:55:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:56:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:56:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:57:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:57:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:58:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:58:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:59:41 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 18:59:49 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 19:00:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 19:00:50 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 19:01:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 19:02:40 2014
INET/inet_error: read errno = 104

D19020 (Client) Sun Apr 13 19:31:07 2014
fbguard: guardian starting /usr/sbin/fbserver

D19020 (Server) Sun Apr 13 19:31:57 2014
INET/inet_error: bind errno = 98

D19020 (Client) Sun Apr 13 19:31:57 2014
fbguard: /usr/sbin/fbserver terminated due to startup error (2)

Then it started, just like that, after one more intent:

D19020 (Client) Sun Apr 13 20:04:57 2014
/usr/sbin/fbguard: guardian starting /usr/sbin/fbserver

kazan417 · 2021-10-24T12:39:12Z

For fixing this issue you should write in [socket] section MaxConnections=4096 to file firebird-classic.socket

kazan417 · 2021-10-24T13:12:16Z

solved with 114885e

firebird-automations closed this as completed Apr 5, 2007

firebird-automations added affect-version: 2.0.0 resolution: wontfix priority: minor component: engine type: bug labels Apr 25, 2021

firebird-automations assigned AlexPeshkoff Apr 25, 2021

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

In Linux (kernel 2.6.16.21) INET/inet_error: read errno = 104 [CORE1192] #1617

In Linux (kernel 2.6.16.21) INET/inet_error: read errno = 104 [CORE1192] #1617

firebird-automations commented Apr 4, 2007

firebird-automations commented Apr 5, 2007

firebird-automations commented Apr 5, 2007

firebird-automations commented Apr 5, 2007

firebird-automations commented Apr 5, 2007

firebird-automations commented Jan 28, 2008

firebird-automations commented Apr 14, 2014

kazan417 commented Oct 24, 2021

kazan417 commented Oct 24, 2021

In Linux (kernel 2.6.16.21) INET/inet_error: read errno = 104 [CORE1192] #1617

In Linux (kernel 2.6.16.21) INET/inet_error: read errno = 104 [CORE1192] #1617

Comments

firebird-automations commented Apr 4, 2007

firebird-automations commented Apr 5, 2007

firebird-automations commented Apr 5, 2007

firebird-automations commented Apr 5, 2007

firebird-automations commented Apr 5, 2007

firebird-automations commented Jan 28, 2008

firebird-automations commented Apr 14, 2014

kazan417 commented Oct 24, 2021

kazan417 commented Oct 24, 2021