Strange behavior - Server stop responding incoming connections

[Roberto Vieweg]

My client has a linux ubuntu server 20.04. 

It has Firebird 2.5.7 classic (via xinetd) installed.

It also has 2 WAN connections for backup purposes (if one goes offline the other one assumes).

Well, when the primary WAN goes DOWN, the firebird server stops to provide new connections. All requests to my connection pool freezes waiting the network response to adquire the new connection... 

The connection string that I'm using is "127.0.0.1/3050:/path/to/fdb" and this is the other strange point about why this is happening.

If I just restart my java application, everything comes back to normal...

Can someone give me a light?

[Mark Rotteveel]

Which version of Jaybird are you using?

To be honest though, this sounds more like a low-level issue with the
network stack or xinetd, and I'm not sure anything in Firebird or
Jaybird itself would be responsible for this.

However, I would recommend that you upgrade to Firebird 2.5.9 as several
server hangs and crashes were fixed in 2.5.8 and 2.5.9.

When this problem happens, are you able to connect to Firebird with
other tools? If so, the problem is definitely not Jaybird related, and
it might be better to ask on firebird-support.

Also, does this Firebird server only need to accept localhost
connections? If so, try to restrict the bind to only 127.0.0.1 (instead
of 0.0.0.0), and see what happens.

Mark
--
Mark Rotteveel

[Roberto Vieweg]

Which version of Jaybird are you using?

=  3.0.1

However, I would recommend that you upgrade to Firebird 2.5.9 as several
server hangs and crashes were fixed in 2.5.8 and 2.5.9.

= The correct version I'm using is LI-V2.5.8.27089

When this problem happens, are you able to connect to Firebird with
other tools? If so, the problem is definitely not Jaybird related, and
it might be better to ask on firebird-support.

= Yes, if I just restart my application everything comes to normal  

 
Also, does this Firebird server only need to accept localhost
connections? If so, try to restrict the bind to only 127.0.0.1 (instead
of 0.0.0.0), and see what happens.  

= Not possible, we use tools for remote control this firebird server

[Mark Rotteveel]

On 18-11-2020 12:06, Roberto Vieweg wrote:
> Which version of Jaybird are you using?
> =  3.0.1

Jaybird 3.0.1 is three years old, and there have been 8 point releases
since 3.0.1. I recommend updating to 3.0.9. Although it is unlikely the
problem here, I fixed an issue in 3.0.8 that could cause connection
hangs under certain conditions (though only for Firebird 3 or higher,
with wire encryption).

[..]

> When this problem happens, are you able to connect to Firebird with
> other tools? If so, the problem is definitely not Jaybird related, and
> it might be better to ask on firebird-support.
> = Yes, if I just restart my application everything comes to normal

Does that mean you also can't connect with other tools? If so, the
problem is far more likely in xinetd or Firebird, and likely not Jaybird
related. I recommend asking your question on firebird-support.

Mark
--
Mark Rotteveel