Re: [SR-Users] siptrace module doesn't close db connections

12 Nov 2018

Hi Daniel,

I found the reason why there were so many open db connections. The parameter
„trace_to_database“ was on so kamailio opened many additional connections.
With following parameter the db connections were normal again:
modparam("siptrace", "trace_to_database", 0)

Thanks! Roman

...
  Am 31.08.2018 um 12:23 schrieb Daniel-Constantin
Mierla &lt;miconda(a)gmail.com&gt;om>:

 Hello,

 in most of the cases, kamailio keeps the connections open for the entire duration of
running. A connection is shared between modules for the same kamailio process, so if you
have auth_db and siptrace, both will use same connection. How many kamailio processes (and
thus number of db connections) are there is a matter of children and listen parameters, as
well as couple of extra special processes (timers, rpc servers, ...).

 Keeping the connection open is done mainly for performance reasons.

 Cheers,
 Daniel

 On 31.08.18 07:31, Roman Dissauer wrote:
  Hi,

 it seems that siptrace module doesn’t close db connections.

 I’m on Kamailio 5.1.4 from official debian stretch repository with postgresql db module
enabled.
 siptrace config:
 modparam("siptrace", "db_url", DBURL)
 modparam("siptrace", "duplicate_uri", "sip:193.32.51.189:9060
<sip:193.32.51.189:9060>")
 modparam("siptrace", "hep_mode_on", 1)
 modparam("siptrace", "hep_version", 3)
 modparam("siptrace", "hep_capture_id", 1001)
 modparam("siptrace", "trace_mode", 1)

 Here you can see the open connections from the kamailio host:

 # select client_addr, state, query from pg_stat_activity where client_addr =
'10.23.101.61';
  client_addr  | state |                             query                              
 --------------+-------+----------------------------------------------------------------
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.101.61 | idle  | select table_version from version where
table_name='sip_trace'
 (31 Zeilen)

 another example, other installation with same kamailio version 5.1.4:

 # select client_addr, state, query from pg_stat_activity where client_addr =
'10.23.102.1';
  client_addr | state |                             query                              
 -------------+-------+----------------------------------------------------------------
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
  10.23.102.1 | idle  | select table_version from version where
table_name='sip_trace'
 (39 Zeilen)

 Thanks Roman

 _______________________________________________
 Kamailio (SER) - Users Mailing List
 sr-users(a)lists.kamailio.org <mailto:sr-users@lists.kamailio.org>
 https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
<https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>  
 -- 
 Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com/>
 www.twitter.com/miconda <http://www.twitter.com/miconda> --
www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
 Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com/>
 Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com
<http://www.asipto.com/> 

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

Re: [SR-Users] siptrace module doesn't close db connections