Try to map each connection to a process and then check which process has extra connections and what type of process that is. It may shed some light on this.
-ovidiu
On Jul 13, 2017 5:17 PM, "Alex Balashov" abalashov@evaristesys.com wrote:
Hello,
Sorry for the delay in following up on this.
On Tue, Jul 11, 2017 at 09:20:23AM +0200, Daniel-Constantin Mierla wrote:
There are some rpc commands that open database connection, do the operation, and then close it. Normally, it still should reuse an existing connection, as the "open connection" should search for existing one first.
I do not think I am using any such RPC commands, however. I have a number of RPC commands that I run for routine monitoring and stats collection, but they all relate to dialogs, and I use runtime memory-only backing for that.
Can you see if all the connections are in open state or some are pending close? Is the number of connections stable or fluctuates over the time?
It appears to be a stable number and they are all established.
From your summary, I noticed that the tcp workers (which handle also http) had two db connections, not sure it was only because of what you selected to put in the mail or that's the rule.
It does appear to be the rule, from a cursory examination.
So, what I guess I am trying to figure out is whether this is normal, and what exactly is the driver of the greater-than-expected number of connections.
-- Alex
-- Alex Balashov | Principal | Evariste Systems LLC
Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free) Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users