<div dir="ltr"><div dir="ltr"><div dir="ltr">Hi Bogdan,<div><br></div><div>I don't think so its translating to DB query on run time, instead its caching the blacklist.</div><div>I am saying so because opensips response is quick, where as when I query manually from DB, it take some time even prefix col. is indexed.<br><div>Moreover, while opensips restart i get following warnings in syslog: </div><div><br></div><div><div><div class="hljs cs" style="display:block;overflow-x:auto;padding:0.5em;color:rgb(51,51,51);background:rgb(248,248,248);font-family:monospace"><div>Oct <span class="hljs-number" style="color:rgb(136,0,0)">2</span> <span class="hljs-number" style="color:rgb(136,0,0)">12</span>:<span class="hljs-number" style="color:rgb(136,0,0)">35</span>:<span class="hljs-number" style="color:rgb(136,0,0)">28</span> srouter<span class="hljs-number" style="color:rgb(136,0,0)">-215</span> SIPSrv[<span class="hljs-number" style="color:rgb(136,0,0)">20876</span>]: WARNING:core:timer_ticker: timer task <nh-timer> already scheduled <span class="hljs-keyword" style="font-weight:bold">for</span> <span class="hljs-number" style="color:rgb(136,0,0)">990</span> ms (now <span class="hljs-number" style="color:rgb(136,0,0)">17920</span> ms), it may overlap.. <br></div><div>Oct <span class="hljs-number" style="color:rgb(136,0,0)">2</span> <span class="hljs-number" style="color:rgb(136,0,0)">12</span>:<span class="hljs-number" style="color:rgb(136,0,0)">35</span>:<span class="hljs-number" style="color:rgb(136,0,0)">28</span> srouter<span class="hljs-number" style="color:rgb(136,0,0)">-215</span> SIPSrv[<span class="hljs-number" style="color:rgb(136,0,0)">20876</span>]: WARNING:core:timer_ticker: timer task <dlg-reinvite-pinger> already scheduled <span class="hljs-keyword" style="font-weight:bold">for</span> <span class="hljs-number" style="color:rgb(136,0,0)">990</span> ms (now <span class="hljs-number" style="color:rgb(136,0,0)">17920</span> ms), it may overlap.. </div><div>Oct <span class="hljs-number" style="color:rgb(136,0,0)">2</span> <span class="hljs-number" style="color:rgb(136,0,0)">12</span>:<span class="hljs-number" style="color:rgb(136,0,0)">35</span>:<span class="hljs-number" style="color:rgb(136,0,0)">28</span> srouter<span class="hljs-number" style="color:rgb(136,0,0)">-215</span> SIPSrv[<span class="hljs-number" style="color:rgb(136,0,0)">20876</span>]: WARNING:core:timer_ticker: timer task <dlg-options-pinger> already scheduled <span class="hljs-keyword" style="font-weight:bold">for</span> <span class="hljs-number" style="color:rgb(136,0,0)">990</span> ms (now <span class="hljs-number" style="color:rgb(136,0,0)">17920</span> ms), it may overlap.. </div><div>Oct <span class="hljs-number" style="color:rgb(136,0,0)">2</span> <span class="hljs-number" style="color:rgb(136,0,0)">12</span>:<span class="hljs-number" style="color:rgb(136,0,0)">35</span>:<span class="hljs-number" style="color:rgb(136,0,0)">28</span> srouter<span class="hljs-number" style="color:rgb(136,0,0)">-215</span> SIPSrv[<span class="hljs-number" style="color:rgb(136,0,0)">20876</span>]: WARNING:core:timer_ticker: timer task <dlg-timer> already scheduled <span class="hljs-keyword" style="font-weight:bold">for</span> <span class="hljs-number" style="color:rgb(136,0,0)">990</span> ms (now <span class="hljs-number" style="color:rgb(136,0,0)">17920</span> ms), it may overlap.. </div><div>Oct <span class="hljs-number" style="color:rgb(136,0,0)">2</span> <span class="hljs-number" style="color:rgb(136,0,0)">12</span>:<span class="hljs-number" style="color:rgb(136,0,0)">35</span>:<span class="hljs-number" style="color:rgb(136,0,0)">28</span> srouter<span class="hljs-number" style="color:rgb(136,0,0)">-215</span> SIPSrv[<span class="hljs-number" style="color:rgb(136,0,0)">20876</span>]: WARNING:core:timer_ticker: timer task <tm-timer> already scheduled <span class="hljs-keyword" style="font-weight:bold">for</span> <span class="hljs-number" style="color:rgb(136,0,0)">990</span> ms (now <span class="hljs-number" style="color:rgb(136,0,0)">17920</span> ms), it may overlap.. </div><div>Oct <span class="hljs-number" style="color:rgb(136,0,0)">2</span> <span class="hljs-number" style="color:rgb(136,0,0)">12</span>:<span class="hljs-number" style="color:rgb(136,0,0)">35</span>:<span class="hljs-number" style="color:rgb(136,0,0)">28</span> srouter<span class="hljs-number" style="color:rgb(136,0,0)">-215</span> SIPSrv[<span class="hljs-number" style="color:rgb(136,0,0)">20876</span>]: WARNING:core:timer_ticker: timer task <blcore-expire> already scheduled <span class="hljs-keyword" style="font-weight:bold">for</span> <span class="hljs-number" style="color:rgb(136,0,0)">990</span> ms (now <span class="hljs-number" style="color:rgb(136,0,0)">17920</span> ms), it may overlap.. </div><div>Oct <span class="hljs-number" style="color:rgb(136,0,0)">2</span> <span class="hljs-number" style="color:rgb(136,0,0)">12</span>:<span class="hljs-number" style="color:rgb(136,0,0)">35</span>:<span class="hljs-number" style="color:rgb(136,0,0)">28</span> srouter<span class="hljs-number" style="color:rgb(136,0,0)">-215</span> SIPSrv[<span class="hljs-number" style="color:rgb(136,0,0)">20876</span>]: WARNING:core:utimer_ticker: utimer task <tm-utimer> already scheduled <span class="hljs-keyword" style="font-weight:bold">for</span> <span class="hljs-number" style="color:rgb(136,0,0)">100</span> ms (now <span class="hljs-number" style="color:rgb(136,0,0)">18020</span> ms), it may overlap.. </div><div>Oct <span class="hljs-number" style="color:rgb(136,0,0)">2</span> <span class="hljs-number" style="color:rgb(136,0,0)">12</span>:<span class="hljs-number" style="color:rgb(136,0,0)">35</span>:<span class="hljs-number" style="color:rgb(136,0,0)">28</span> srouter<span class="hljs-number" style="color:rgb(136,0,0)">-215</span> SIPSrv[<span class="hljs-number" style="color:rgb(136,0,0)">20876</span>]: WARNING:core:utimer_ticker: utimer task <tm-utimer> already scheduled <span class="hljs-keyword" style="font-weight:bold">for</span> <span class="hljs-number" style="color:rgb(136,0,0)">100</span> ms (now <span class="hljs-number" style="color:rgb(136,0,0)">18120</span> ms), it may overlap.. </div><div>Oct <span class="hljs-number" style="color:rgb(136,0,0)">2</span> <span class="hljs-number" style="color:rgb(136,0,0)">12</span>:<span class="hljs-number" style="color:rgb(136,0,0)">35</span>:<span class="hljs-number" style="color:rgb(136,0,0)">28</span> srouter<span class="hljs-number" style="color:rgb(136,0,0)">-215</span> SIPSrv[<span class="hljs-number" style="color:rgb(136,0,0)">20876</span>]: WARNING:core:utimer_ticker: utimer task <tm-utimer> already scheduled <span class="hljs-keyword" style="font-weight:bold">for</span> <span class="hljs-number" style="color:rgb(136,0,0)">100</span> ms (now <span class="hljs-number" style="color:rgb(136,0,0)">18220</span> ms), it may overlap.. </div><div><b>Oct <span class="hljs-number" style="color:rgb(136,0,0)">2</span> <span class="hljs-number" style="color:rgb(136,0,0)">12</span>:<span class="hljs-number" style="color:rgb(136,0,0)">35</span>:<span class="hljs-number" style="color:rgb(136,0,0)">28</span> srouter<span class="hljs-number" style="color:rgb(136,0,0)">-215</span> SIPSrv[<span class="hljs-number" style="color:rgb(136,0,0)">20882</span>]: INFO:userblacklist:reload_sources: got <span class="hljs-number" style="color:rgb(136,0,0)">1386901</span> entries <span class="hljs-keyword" style="font-weight:bold">from</span> <span class="hljs-string" style="color:rgb(136,0,0)">'globalblacklist'</span> </b></div><div>Oct <span class="hljs-number" style="color:rgb(136,0,0)">2</span> <span class="hljs-number" style="color:rgb(136,0,0)">12</span>:<span class="hljs-number" style="color:rgb(136,0,0)">35</span>:<span class="hljs-number" style="color:rgb(136,0,0)">28</span> srouter<span class="hljs-number" style="color:rgb(136,0,0)">-215</span> SIPSrv[<span class="hljs-number" style="color:rgb(136,0,0)">20882</span>]: WARNING:core:handle_timer_job: utimer job <tm-utimer> has a <span class="hljs-number" style="color:rgb(136,0,0)">18170000</span> us delay <span class="hljs-keyword" style="font-weight:bold">in</span> execution </div><div>Oct <span class="hljs-number" style="color:rgb(136,0,0)">2</span> <span class="hljs-number" style="color:rgb(136,0,0)">12</span>:<span class="hljs-number" style="color:rgb(136,0,0)">35</span>:<span class="hljs-number" style="color:rgb(136,0,0)">28</span> srouter<span class="hljs-number" style="color:rgb(136,0,0)">-215</span> SIPSrv[<span class="hljs-number" style="color:rgb(136,0,0)">20882</span>]: WARNING:core:handle_timer_job: timer job <nh-timer> has a <span class="hljs-number" style="color:rgb(136,0,0)">17280000</span> us delay <span class="hljs-keyword" style="font-weight:bold">in</span> execution </div><div>Oct <span class="hljs-number" style="color:rgb(136,0,0)">2</span> <span class="hljs-number" style="color:rgb(136,0,0)">12</span>:<span class="hljs-number" style="color:rgb(136,0,0)">35</span>:<span class="hljs-number" style="color:rgb(136,0,0)">28</span> srouter<span class="hljs-number" style="color:rgb(136,0,0)">-215</span> SIPSrv[<span class="hljs-number" style="color:rgb(136,0,0)">20882</span>]: WARNING:core:handle_timer_job: timer job <dlg-reinvite-pinger> has a <span class="hljs-number" style="color:rgb(136,0,0)">17280000</span> us delay <span class="hljs-keyword" style="font-weight:bold">in</span> execution </div></div></div><br><div></div></div><div>Once globalblacklist loaded <b style="color:rgb(51,51,51);font-family:monospace;background-color:rgb(248,248,248)"><span class="gmail-hljs-number" style="color:rgb(136,0,0)">1386901</span> entries</b> , opensips behave normally. </div><div>When I will add more records to globalblacklist, opensips wouldn't start due to service timeout.</div><div>One way might be to increase service timeout to allow opensips keep loading the entries but it may take ages. </div><div><br></div><div><div><div dir="ltr" class="gmail_signature"><div><font size="2"><span style="font-family:verdana,sans-serif"><span style="color:rgb(39,78,19)">--<br>regards,</span></span></font></div><font size="2"><span style="font-family:verdana,sans-serif"><span style="color:rgb(39,78,19)"><br>abdul basit</span></span></font></div></div></div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr">On Tue, 2 Oct 2018 at 13:19, Bogdan-Andrei Iancu <<a href="mailto:bogdan@opensips.org">bogdan@opensips.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<tt>Hi Abdul,<br>
<br>
OK, but what is the blacklist related operation you do in startup
route ?? As far as I know, the blacklist module is not doing any
kind of caching, so any check you do against the blacklists will
translate into a DB query, right ?<br>
<br>
Regards,<br>
</tt>
<pre class="m_7591727934642041896moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="m_7591727934642041896moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a>
OpenSIPS Bootcamp 2018
<a class="m_7591727934642041896moz-txt-link-freetext" href="http://opensips.org/training/OpenSIPS_Bootcamp_2018/" target="_blank">http://opensips.org/training/OpenSIPS_Bootcamp_2018/</a>
</pre>
<div class="m_7591727934642041896moz-cite-prefix">On 10/01/2018 06:58 PM, Abdul Basit
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">Yes. That's right.</div>
<div dir="ltr">The code I am using is as below. <span style="background-color:rgb(254,254,238);color:rgb(102,102,102);font-family:"Lucida Console","Andale Mono","Courier New",Courier;font-size:11.7072px;white-space:pre-wrap">globalblacklist</span> table
has complete number as <span style="background-color:rgb(254,254,238);color:rgb(102,102,102);font-family:"Lucida Console","Andale Mono","Courier New",Courier;font-size:11.7072px;white-space:pre-wrap">prefix</span><span style="background-color:rgb(254,254,238);color:rgb(102,102,102);font-family:"Lucida Console","Andale Mono","Courier New",Courier;font-size:11.7072px;white-space:pre-wrap"> </span>with
and <span style="background-color:rgb(245,245,245);color:rgb(102,102,102);font-family:"Lucida Console","Andale Mono","Courier New",Courier;font-size:11.7072px;white-space:pre-wrap">whitelist</span> status.
</div>
<div dir="ltr">
<div>
<div><br>
</div>
<div>
<div>
<div class="m_7591727934642041896hljs m_7591727934642041896bash" style="display:block;overflow-x:auto;padding:0.5em;color:rgb(51,51,51);background:rgb(248,248,248);font-family:monospace">
<div>route {</div>
<div><span style="white-space:pre-wrap"> </span>.....</div>
<div><span style="white-space:pre-wrap"> </span><span class="m_7591727934642041896hljs-keyword" style="font-weight:bold">if</span> (
!check_blacklist(<span class="m_7591727934642041896hljs-string" style="color:rgb(136,0,0)">"globalblacklist"</span>)
) {</div>
<div><span style="white-space:pre-wrap"> </span>xlog(<span class="m_7591727934642041896hljs-string" style="color:rgb(136,0,0)">"L_NOTICE"</span>,<span class="m_7591727934642041896hljs-string" style="color:rgb(136,0,0)">"[<span class="m_7591727934642041896hljs-variable" style="color:rgb(188,96,96)">$fU</span>/<span class="m_7591727934642041896hljs-variable" style="color:rgb(188,96,96)">$tU</span>/<span class="m_7591727934642041896hljs-variable" style="color:rgb(188,96,96)">$ci</span>] [<span class="m_7591727934642041896hljs-variable" style="color:rgb(188,96,96)">$rm</span>]
Destination [<span class="m_7591727934642041896hljs-variable" style="color:rgb(188,96,96)">$rU</span>]
is not Allowed. Dropping call.\n"</span>);</div>
<div><span style="white-space:pre-wrap"> </span>sl_send_reply(<span class="m_7591727934642041896hljs-string" style="color:rgb(136,0,0)">"403"</span>, <span class="m_7591727934642041896hljs-string" style="color:rgb(136,0,0)">"Forbidden"</span>);</div>
<div><span style="white-space:pre-wrap"> </span><span class="m_7591727934642041896hljs-built_in" style="color:rgb(57,115,0)">exit</span>;</div>
<div><span style="white-space:pre-wrap"> </span>}</div>
<div><span style="white-space:pre-wrap"> </span><span class="m_7591727934642041896hljs-keyword" style="font-weight:bold">else</span> {</div>
<div><span style="white-space:pre-wrap"> </span>xlog(<span class="m_7591727934642041896hljs-string" style="color:rgb(136,0,0)">"L_INFO"</span>,
<span class="m_7591727934642041896hljs-string" style="color:rgb(136,0,0)">"[<span class="m_7591727934642041896hljs-variable" style="color:rgb(188,96,96)">$fU</span>/<span class="m_7591727934642041896hljs-variable" style="color:rgb(188,96,96)">$tU</span>/<span class="m_7591727934642041896hljs-variable" style="color:rgb(188,96,96)">$ci</span>] [<span class="m_7591727934642041896hljs-variable" style="color:rgb(188,96,96)">$rm</span>]
INBOUND CALL for [<span class="m_7591727934642041896hljs-variable" style="color:rgb(188,96,96)">$ru</span>]"</span>);</div>
<div><span style="white-space:pre-wrap"> </span>route(10);</div>
<div><span style="white-space:pre-wrap"> </span><span class="m_7591727934642041896hljs-built_in" style="color:rgb(57,115,0)">exit</span>;</div>
<div><span style="white-space:pre-wrap"> </span>}</div>
<div><span style="white-space:pre-wrap"> </span>.....</div>
<div>}</div>
</div>
</div>
<br>
</div>
<div><br clear="all">
<div>
<div dir="ltr" class="m_7591727934642041896gmail_signature">
<div><font size="2"><span style="font-family:verdana,sans-serif"><span style="color:rgb(39,78,19)">--<br>
regards,</span></span></font></div>
<font size="2"><span style="font-family:verdana,sans-serif"><span style="color:rgb(39,78,19)"><br>
abdul basit</span></span></font></div>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr">On Mon, 1 Oct 2018 at 19:07, Bogdan-Andrei Iancu
<<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> <tt>Hi Abdul,<br>
<br>
IF I understand correctly, you use startup route to load
(from DB?) some blacklists into localcache ?<br>
<br>
Regards,<br>
</tt>
<pre class="m_7591727934642041896m_2718947286626188160moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="m_7591727934642041896m_2718947286626188160moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a>
OpenSIPS Bootcamp 2018
<a class="m_7591727934642041896m_2718947286626188160moz-txt-link-freetext" href="http://opensips.org/training/OpenSIPS_Bootcamp_2018/" target="_blank">http://opensips.org/training/OpenSIPS_Bootcamp_2018/</a>
</pre>
<div class="m_7591727934642041896m_2718947286626188160moz-cite-prefix">On
09/28/2018 04:10 AM, Abdul Basit wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>Hi team,</div>
<div><br>
</div>
<div>I have a opensips 2.4 deployed having 4 children
and with mysql configured for loading user blacklist
to opensips local cache on opensips startup.<br>
</div>
<div>Opensips work fine on filtering the call based on
user blacklist records loaded into local cache. </div>
<div><br>
</div>
<div>While blacklist was growing upto 1.3m records,
opensips startup was taking ~60 sec on VM of 16GB RAM
and 6 CPU.<br>
</div>
<div>I increased shared memory to <b>6144</b> and
package memory to <b>256.</b><br>
</div>
<div>Filter works fine here yet. Call load is not that
much only blacklist entries are growing.</div>
<div><br>
</div>
<div>But now blacklist has grown to very huge number, up
to 10m records in mysql. Opensips is not starting
successfully and service startup requests timeout
after huge CPU spikes while trying to populate local
cache from mysql. <br>
</div>
<div>I increased shared memory to <b>12288</b> and
package memory to <b>1024</b> but no success yet.</div>
<div><br>
</div>
<div>I indexed mysql blacklist table but no luck.</div>
<div><br>
</div>
<div>Please advise what settings I should add to
opensips for successful startup. </div>
<div><br>
</div>
<div>
<div dir="ltr" class="m_7591727934642041896m_2718947286626188160gmail_signature" data-smartmail="gmail_signature">
<div><font size="2"><span style="font-family:verdana,sans-serif"><span style="color:rgb(39,78,19)">--<br>
regards,</span></span></font></div>
<font size="2"><span style="font-family:verdana,sans-serif"><span style="color:rgb(39,78,19)"><br>
abdul basit</span></span></font></div>
</div>
</div>
<br>
<fieldset class="m_7591727934642041896m_2718947286626188160mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
Users mailing list
<a class="m_7591727934642041896m_2718947286626188160moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a class="m_7591727934642041896m_2718947286626188160moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</blockquote>
</div>
</blockquote>
<br>
</div>
</blockquote></div>