<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi,<div class=""><br class=""></div><div class="">it seems that siptrace module doesn’t close db connections.</div><div class=""><br class=""></div><div class="">I’m on Kamailio 5.1.4 from official debian stretch repository with postgresql db module enabled.</div><div class="">siptrace config:</div><div class=""><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Courier; color: rgb(77, 47, 45); background-color: rgb(223, 219, 195);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">modparam("siptrace", "db_url", DBURL)</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Courier; color: rgb(77, 47, 45); background-color: rgb(223, 219, 195);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">modparam("siptrace", "duplicate_uri", "<a href="sip:193.32.51.189:9060" class="">sip:193.32.51.189:9060</a>")</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Courier; color: rgb(77, 47, 45); background-color: rgb(223, 219, 195);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">modparam("siptrace", "hep_mode_on", 1)</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Courier; color: rgb(77, 47, 45); background-color: rgb(223, 219, 195);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">modparam("siptrace", "hep_version", 3)</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Courier; color: rgb(77, 47, 45); background-color: rgb(223, 219, 195);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">modparam</span><span style="font-variant-ligatures: no-common-ligatures; background-color: #00e6e6" class="">(</span><span style="font-variant-ligatures: no-common-ligatures" class="">"siptrace", "hep_capture_id", 1001</span><span style="font-variant-ligatures: no-common-ligatures; background-color: #00e6e6" class="">)</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Courier; color: rgb(77, 47, 45); background-color: rgb(223, 219, 195);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">modparam("siptrace", "trace_mode", 1)</span></div></div><div class=""><br class=""></div><div class="">Here you can see the open connections from the kamailio host:</div><div class=""><br class=""></div><div class=""><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Courier; color: rgb(77, 47, 45); background-color: rgb(223, 219, 195);" class=""><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""># select client_addr, state, query from pg_stat_activity where client_addr = '10.23.101.61';</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> client_addr | state | query </span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">--------------+-------+----------------------------------------------------------------</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.101.61 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">(31 Zeilen)</span></div></div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">another example, other installation with same kamailio version 5.1.4:</div><div class=""><br class=""></div><div class=""><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Courier; color: rgb(77, 47, 45); background-color: rgb(223, 219, 195);" class=""><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""># select client_addr, state, query from pg_stat_activity where client_addr = '10.23.102.1';</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> client_addr | state | query </span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">-------------+-------+----------------------------------------------------------------</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> 10.23.102.1 | idle | select table_version from version where table_name='sip_trace'</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">(39 Zeilen)</span></div></div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Thanks Roman</div><div class=""><br class=""></div><div class=""><br class=""></div></body></html>