Re: [firebird-support] Firebird stopped after 190 connections
On 7-11-2017 22:53, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: > 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. Version 2.5.7 also fixed a number of server hangs / slow downs. Mark -- Mark Rotteveel
Re: [firebird-support] Firebird stopped after 190 connections
On 02/11/17 20:26, mirc...@gmail.com [firebird-support] wrote: 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
[firebird-support] Firebird stopped after 190 connections
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.
