<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Hi Tomas,<div class=""><br class=""></div><div class="">That query should not take 10 seconds. Here it completes in 0.02s according to mysql. The query is used to determine the flow of the calls. After the query is executed in CDRTool, more logic follows. It can easily be that the delay is in there. </div><div class=""><br class=""></div><div class="">If web normalizing is enabled and the call is not normalized, it will also try to normalize and rate the calls while searching. This can be disabled if you don’t need/want it. Perhaps you can disable this to check if this causes the delay. </div><div class=""><br class=""></div><div class="">To disable it add to the opensips datasource in global.inc: "skipNormalizeOnPageLoad" => 1</div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Best regards,</div><div class=""><br class=""></div><div class="">Tijmen de Mes</div><div class="">—</div><div class="">AG Projects</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><div><blockquote type="cite" class=""><div class="">On 30 nov. 2015, at 10:26, Tomas Andersen <<a href="mailto:tomas.andersen@ipco.no" class="">tomas.andersen@ipco.no</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" class="">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; font-size: 14px; font-family: Calibri, sans-serif;" class="">
<div class="">
<div class="">Hi again.</div>
<div class=""><br class="">
</div>
<div class="">I have set up wireshark to check why the CDR rating engine uses so much time.</div>
<div class=""><br class="">
</div>
<div class="">The following SQL queries are run from CDRTool to my OpenSIPS server:</div>
<div class="">select * from domain;</div>
<div class="">select * from trusted_peers;</div>
<div class="">Select rpid from subscriber where username = ‘+47xxxxxxxx’ and domain = ‘<a href="http://example.sip.com" class="">example.sip.com</a>’</div>
<div class=""><br class="">
</div>
<div class="">(with username and domain scrambled here)</div>
<div class=""><br class="">
</div>
<div class="">The rpid select statement is run for each caller in the search period. What is strange is that these selects are only run each 10 second, and if I am searching</div>
<div class="">Within a period of time and there has been 7 different callers, it will take 70 seconds. After this the GUI is “released” and updated with the maching CDR list.</div>
<div class=""><br class="">
</div>
<div class="">My subscriber table in open sips is empty. Why does this take so long?</div>
<div class=""><br class="">
</div>
<div class="">Regards,</div>
<div class="">Tomas Andersen</div>
<div class=""><br class="">
</div>
<div class="">
<div id="MAC_OUTLOOK_SIGNATURE" class=""></div>
</div>
</div>
<div class=""><br class="">
</div>
<span id="OLK_SRC_BODY_SECTION" class="">
<div style="font-family: Calibri; font-size: 12pt; text-align: left; border-width: 1pt medium medium; border-style: solid none none; padding: 3pt 0in 0in; border-top-color: rgb(181, 196, 223);" class="">
<span style="font-weight:bold" class="">From: </span>Tomas Andersen<br class="">
<span style="font-weight:bold" class="">Date: </span>Friday 27 November 2015 at 09:10<br class="">
<span style="font-weight:bold" class="">To: </span>"<a href="mailto:users@lists.opensips.org" class="">users@lists.opensips.org</a>"<br class="">
<span style="font-weight:bold" class="">Subject: </span>CDR search slow in CDRTool<br class="">
</div>
<div class=""><br class="">
</div>
<div class="">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; font-size: 14px; font-family: Calibri, sans-serif;" class="">
<div class="">Hi</div>
<div class=""><br class="">
</div>
<div class="">I have set up CDRTool to read CDRs from my radius database for OpenSIP calls. I am successfully rating calls, but everytime I search for CDR records using the </div>
<div class="">CDRTool GUI it takes 1-3 minutes before the search result window is shown.</div>
<div class=""><br class="">
</div>
<div class="">If there are no matching records the result window is shown immediately. Does anyone else have any experience with this? I suspect that there might be a database lock,</div>
<div class="">Database connection pool problems or just some configuration error somewhere.</div>
<div class=""><br class="">
</div>
<div class="">In my browser I get the following in my developer console / network (note the huge duration for the HTTP POST):</div>
<div class=""><br class="">
</div>
<div class="">200 POST<span class="Apple-tab-span" style="white-space:pre"> </span>callsearch.pthml<span class="Apple-tab-span" style="white-space:pre"></span><destip><span class="Apple-tab-span" style="white-space:pre">
</span>html<span class="Apple-tab-span" style="white-space:pre"></span>105.41 kb<span class="Apple-tab-span" style="white-space:pre">
</span>150212 ms</div>
<div class="">200 GET<span class="Apple-tab-span" style="white-space:pre"> </span>date picker.css<span class="Apple-tab-span" style="white-space:pre"></span><destip><span class="Apple-tab-span" style="white-space:pre">
</span>css<span class="Apple-tab-span" style="white-space:pre"></span>9.96 kb<span class="Apple-tab-span" style="white-space:pre">
</span>14 ms</div>
<div class=""><br class="">
</div>
<div class="">Followed by several lines of </div>
<div class="">304 GETs</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">When checking with Wireshark I notice that after the HTTP POST to callsearch, I get several TCP Keep-Alive messages as the server is slow..</div>
<div class="">After 2m 38 seconds everything is suddenly released and some HTTP GETs make the page to update.</div>
<div class=""><br class="">
</div>
<div class="">I see nothing in syslog (from cdrtool) but some mysql connection statements.. No lock/unlock or similar statements..</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">I appreciate if anyone could enlighten me on this subject.</div>
<div class=""><br class="">
</div>
</div>
<div class=""><br class="">
</div>
<div class="">Best Regards,</div>
<div class="">Tomas Andersen</div>
<div class=""> </div>
<div class="">
<div id="" class=""></div>
</div>
</div>
</div>
</span>
</div>
_______________________________________________<br class="">Users mailing list<br class=""><a href="mailto:Users@lists.opensips.org" class="">Users@lists.opensips.org</a><br class="">http://lists.opensips.org/cgi-bin/mailman/listinfo/users<br class=""></div></blockquote></div><br class=""></div></body></html>