31 Aug
2018
31 Aug
'18
8:31 a.m.
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")
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
31 Aug
31 Aug
1:23 p.m.
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")
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
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference -- www.kamailioworld.com
Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com
12 Nov
12 Nov
3:07 p.m.
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 <miconda(a)gmail.com>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/>
2232
days inactive
2305
days old
2 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
Roman Dissauer