Subject | Re: [firebird-support] Firebird stopped after 190 connections |
---|---|
Author | Hamish Moffatt |
Post date | 2017-11-07T21:53:17Z |
Hi.
Today I had this situation - on CentOS 7 server, while Firebird Superserver was working, suddenly it stopped receiving new connections. First I thought that the server was crashed and not started automatically from the guardian. But ps -aux | greb fb showed that there are 2 firebird processes running - fbguard and fbserver.
So I stopped it manually with systemctl stop firebird-superserver. Then in the log I saw a message that server is shutting down with 190 connections to 19 databases indicating that there were working connections.
Is there a limitations for the number of connections in Superserver or this is a limitation of the OS?
Because the number 190 is strange.
Did it actually refuse new connections, or did new connections attempts just hang indefinitely?
I have problems with new connections to Firebird just hanging. If you have a connection then you can delete the others (delete from MON$ATTACHMENTS) and everything will be good, otherwise you have to disconnect ALL your clients or just restart the server to get it working again. This was supposedly fixed in one of the 2.5 point releases but it is still happening in 2.5.6 for me.
Hamish