<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi Rodrigo,<br>
<br>
I guess the root of your problem is this:<br>
ERROR: db_sqlite:db_sqlite_raw_query: query failed: database is
locked.<br>
<br>
If the DB query gets blocked on sqlite level, then the timer job
will not terminate and the timer will complain on this -> you
will get all the warnings from the timer:<br>
<span>WARNING:core:timer_ticker: timer task <ul-timer>
already scheduled.......<br>
<br>
Regards,<br>
</span>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 17.05.2016 14:57, Rodrigo Pimenta
Carvalho wrote:<br>
</div>
<blockquote
cite="mid:BY2PR02MB165585E5C8990A8E57E0B00DB5480@BY2PR02MB1655.namprd02.prod.outlook.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
<div id="divtagdefaultwrapper"
style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Hi Bogdan-Andrei.</p>
<p><br>
</p>
<p>For usrloc I had used the following configuration until 3
days ago, and having the same problem:</p>
<p><br>
</p>
<p>-----------------------------------------------------------------------------------------------------</p>
<div>modparam("usrloc", "nat_bflag", "NAT")<br>
modparam("usrloc", "db_mode", 1)<br>
modparam("usrloc", "timer_interval",10)<br>
modparam("usrloc", "db_url",<br>
"sqlite:///usr/local/opensips/db/sisc.sqlite") #
CUSTOMIZE ME<br>
</div>
------------------------------------------------------------------------------------------------------
<p><br>
</p>
<p>Since 3 days ago I started to use the following modified
configuration, and the problem disappeared:</p>
<p><br>
</p>
<div>modparam("usrloc", "db_mode", 2)<br>
modparam("usrloc", "timer_interval",3)<br>
<br>
I'm still not sure that such modification in configuration is
the solution, because I still have to test several situations.
Ex: using TLS, TCP. Making calls (until now in my recent tests
I didn't make calls). Using a link to Internet (until know I'm
using a LAN in my recent tests). So, there are some scenarios
that I still have to test before confirming that I have gotten
the solution. Until now I just let 2 clients sending SIP
REGISTER and nothing more.
<br>
<br>
By the way, I'm using SQLite and I know that some times the
log presents the message:<br>
<br>
" ERROR: db_sqlite:db_sqlite_raw_query: query failed: database
is locked."<br>
<br>
That is, sometimes a table can be locked, but it should be
responsibility of the DB_SQLite module to handle this
condition, shouldn't be?<br>
Do you think that SQLite can be causing such issue (<span>delay
in the execution of the ul-timer</span>)?<br>
<br>
Any hint will be very helpful!<br>
<br>
Thanks!<br>
</div>
<br>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper"
style="font-family:Calibri,Arial,Helvetica,sans-serif;
font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">RODRIGO PIMENTA CARVALHO<br>
Inatel Competence Center<br>
Software<br>
Ph: +55 35 3471 9200 RAMAL 979<br>
</div>
</font></div>
</div>
</div>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt"
color="#000000" face="Calibri, sans-serif"><b>De:</b>
Bogdan-Andrei Iancu <a class="moz-txt-link-rfc2396E" href="mailto:bogdan@opensips.org"><bogdan@opensips.org></a><br>
<b>Enviado:</b> terça-feira, 17 de maio de 2016 05:47<br>
<b>Para:</b> Rodrigo Pimenta Carvalho;
<a class="moz-txt-link-abbreviated" href="mailto:users@lists.opensips.org">users@lists.opensips.org</a><br>
<b>Assunto:</b> Re: [OpenSIPS-Users] How to avoid many
warnings about "handle_timer_job".</font>
<div> </div>
</div>
<div>Hi Rodrigo,<br>
<br>
I'm back also. The logs indicate there is a serious delay in
the execution of the ul-timer (user location). According to
your logs, it is almost 15 minutes :O ..... What db_mode do
you use in usrloc module ?<br>
<br>
Regards,<br>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" title="Ctrl+Clique ou toque para seguir o link" id="LPlnk179244" class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div style="margin-bottom: 20px; overflow: auto; width:
100%; text-indent: 0px;"
id="LPBorder_GT_14634853040820.5238367604452187">
<table style="width: 90%; background-color: rgb(255, 255,
255); position: relative; overflow: auto; padding-top:
20px; padding-bottom: 20px; margin-top: 20px;
border-top: 1px dotted rgb(200, 200, 200);
border-bottom: 1px dotted rgb(200, 200, 200);"
id="LPContainer_14634853040780.8931812758822569"
cellspacing="0">
<tbody>
<tr style="border-spacing: 0px;" valign="top">
<td colspan="1" style="width: 250px; position:
relative; display: table-cell; padding-right:
20px;"
id="ImageCell_14634853040790.20753349659969555">
<div style="background-color: rgb(255, 255, 255);
height: 38px; position: relative; margin: auto;
display: table; width: 116px;"
id="LPImageContainer_14634853040790.2053880864289419">
<a moz-do-not-send="true" target="_blank"
href="http://www.opensips-solutions.com/"
style="display: table-cell; text-align:
center;"
id="LPImageAnchor_14634853040790.4075206440722714"><img
moz-do-not-send="true" aria-label="Imagem de
visualização com link selecionado. Toque
duas vezes para abrir o link."
style="display: inline-block; margin-left:
auto; margin-right: auto; max-width: 250px;
max-height: 250px; height: 38px; width:
116px; border-width: 0px; vertical-align:
bottom;"
src="http://www.opensips-solutions.com/imgs/opensips-solutions-logo.gif"
width="116" height="38"></a></div>
</td>
<td colspan="2" style="vertical-align: top;
position: relative; padding: 0px; display:
table-cell;"
id="TextCell_14634853040800.3091700713989979">
<div style="top: 0px; color: rgb(0, 120, 215);
font-weight: 400; font-size: 21px; font-family:
"wf_segoe-ui_light","Segoe UI
Light","Segoe WP
Light","Segoe UI","Segoe
WP",Tahoma,Arial,sans-serif; line-height:
21px;"
id="LPTitle_14634853040800.19510565004942126">
<a moz-do-not-send="true" target="_blank"
href="http://www.opensips-solutions.com/"
style="text-decoration: none;"
id="LPUrlAnchor_14634853040810.7474499274908935">Home
— OpenSIPS Solutions</a></div>
<div style="margin: 10px 0px 16px; color: rgb(102,
102, 102); font-weight: 400; font-family:
"wf_segoe-ui_normal","Segoe
UI","Segoe
WP",Tahoma,Arial,sans-serif; font-size:
14px; line-height: 14px;"
id="LPMetadata_14634853040810.23568811669243217">
<a class="moz-txt-link-abbreviated" href="http://www.opensips-solutions.com">www.opensips-solutions.com</a></div>
<div style="display: block; color: rgb(102, 102,
102); font-weight: 400; font-family:
"wf_segoe-ui_normal","Segoe
UI","Segoe
WP",Tahoma,Arial,sans-serif; font-size:
14px; line-height: 20px; max-height: 100px;
overflow: hidden;"
id="LPDescription_14634853040810.17171563668545986">
OpenSIPS is a mature Open Source implementation
of a SIP server. OpenSIPS is more than a SIP
proxy/router as it includes application-level
functionalities.</div>
</td>
</tr>
</tbody>
</table>
</div>
<div class="moz-cite-prefix">On 11.05.2016 16:29, Rodrigo
Pimenta Carvalho wrote:<br>
</div>
<blockquote type="cite">
<div id="divtagdefaultwrapper" style="font-size:12pt;
color:#000000; background-color:#FFFFFF;
font-family:Calibri,Arial,Helvetica,sans-serif">
<p>Hi. Just one more thing:</p>
<p><br>
</p>
<p>During my tests I have <tt>zero calls per second and
zero parallel calls.</tt></p>
<p><tt>I just let softphones sending SIP REGISTER
messages, 1 at each minute.</tt></p>
<p><tt>And I have just 4 softphones registering.</tt></p>
<p><br>
</p>
<p>After all, we have changed the CPU clock, increasing
it. For example:</p>
<p><br>
</p>
<p>we have used the command "<span>cpufreq-set -f
79200000"</span> to change the clock to 792 MHz.</p>
<p><br>
</p>
<p>Before it, the clock used was less than 400 MHz.</p>
<p><br>
</p>
<p>Do you think it can really help us to avoid such
warning in the log?</p>
<p><br>
</p>
<p>Best regards.<br>
</p>
<p><tt><br>
</tt></p>
<p><tt><br>
</tt></p>
<p><tt>Best regards.</tt><br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper"
style="font-family:Calibri,Arial,Helvetica,sans-serif;
font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">RODRIGO PIMENTA CARVALHO<br>
Inatel Competence Center<br>
Software<br>
Ph: +55 35 3471 9200 RAMAL 979<br>
</div>
</font></div>
</div>
</div>
<br>
<br>
<div style="color:rgb(0,0,0)">
<hr tabindex="-1" style="display:inline-block;
width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font
style="font-size:11pt" color="#000000"
face="Calibri, sans-serif"><b>De:</b> Rodrigo
Pimenta Carvalho<br>
<b>Enviado:</b> quarta-feira, 11 de maio de 2016
09:03<br>
<b>Para:</b> Bogdan-Andrei Iancu<br>
<b>Assunto:</b> Re: [OpenSIPS-Users] How to avoid
many warnings about "handle_timer_job".</font>
<div> </div>
</div>
<div>
<div id="divtagdefaultwrapper"
style="font-size:12pt; color:#000000;
background-color:#FFFFFF;
font-family:Calibri,Arial,Helvetica,sans-serif">
<p>Hi Bogdan-Andrei.</p>
<p><br>
</p>
<p>I'm back.</p>
<p><br>
</p>
<p>After coming back, I didn't see that log
anymore.</p>
<p><br>
However, another log appears every day:</p>
<p><br>
</p>
<p>"</p>
<div>May 11 11:51:48 colibri-imx6-jfl
opensips[2193]: May 11 11:51:48 [2200]
WARNING:core:timer_ticker: timer task
<ul-timer> already schedualed for 940840
ms (now 20647710 ms)...y overlap..<br>
</div>
"
<p><br>
</p>
<p>When it starts to appear, I have to reset the
OpenSIPS to avoid such messages.</p>
<p><br>
</p>
<p>My configurations : <br>
</p>
<p>-------------------------------------------</p>
<div>
<div>debug=3<br>
<br>
log_stderror=yes<br>
log_facility=LOG_LOCAL1<br>
<br>
max_while_loops=200 <br>
sip_warning = 0 <br>
tcp_children=4<br>
<br>
fork=yes # para usar TLS deixe o fork = yes.<br>
children=4<br>
</div>
----------------------------------------------------------<br>
</div>
<br>
<p>Any suggestion?</p>
<p><br>
</p>
<p>Best Regards.<br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper"
style="font-family:Calibri,Arial,Helvetica,sans-serif;
font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">RODRIGO PIMENTA
CARVALHO<br>
Inatel Competence Center<br>
Software<br>
Ph: +55 35 3471 9200 RAMAL 979<br>
</div>
</font></div>
</div>
</div>
<br>
<br>
<div style="color:rgb(0,0,0)">
<hr tabindex="-1" style="display:inline-block;
width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font
style="font-size:11pt" color="#000000"
face="Calibri, sans-serif"><b>De:</b>
Bogdan-Andrei Iancu
<a moz-do-not-send="true"
class="moz-txt-link-rfc2396E"
href="mailto:bogdan@opensips.org"><bogdan@opensips.org></a><br>
<b>Enviado:</b> quarta-feira, 4 de maio de
2016 05:38<br>
<b>Para:</b> OpenSIPS users mailling list;
Rodrigo Pimenta Carvalho<br>
<b>Assunto:</b> Re: [OpenSIPS-Users] How to
avoid many warnings about
"handle_timer_job".</font>
<div> </div>
</div>
<div><tt>Hi Rodrigo,<br>
<br>
How many opensips process you have
configured ?<br>
<br>
Do you have an estimation of the load on
your opensips (in terms of calls per second
and parallel calls) ?<br>
<br>
Best regards<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" id="LPlnk222476" class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div
id="LPBorder_GT_14629678505660.8654336529913591"
style="margin-bottom:20px; overflow:auto;
width:100%; text-indent:0px"
contenteditable="false">
<table
id="LPContainer_14629678505600.886769738605494"
style="width:90%;
background-color:rgb(255,255,255);
overflow:auto; padding-top:20px;
padding-bottom:20px; margin-top:20px;
border-top:1px dotted rgb(200,200,200);
border-bottom:1px dotted rgb(200,200,200)"
cellspacing="0">
<tbody>
<tr style="border-spacing:0px"
valign="top">
<td colspan="1"
id="ImageCell_14629678505610.036553640922308284"
style="width:250px;
display:table-cell;
padding-right:20px">
<div
id="LPImageContainer_14629678505620.37497179524470226"
style="background-color:rgb(255,255,255);
height:38px; margin:auto;
display:table; width:116px">
<a moz-do-not-send="true"
target="_blank"
href="http://www.opensips-solutions.com/"
id="LPImageAnchor_14629678505620.17245225961428012"
style="display:table-cell;
text-align:center"><img
moz-do-not-send="true"
style="display:inline-block;
margin-left:auto;
margin-right:auto;
max-width:250px;
max-height:250px; height:38px;
width:116px; border-width:0px;
vertical-align:bottom"
src="http://www.opensips-solutions.com/imgs/opensips-solutions-logo.gif"
width="116" height="38"></a></div>
</td>
<td colspan="2"
id="TextCell_14629678505630.18663359582963635"
style="vertical-align:top;
padding:0px; display:table-cell">
<div
id="LPTitle_14629678505640.8659191764253138"
style=""><a moz-do-not-send="true"
target="_blank"
href="http://www.opensips-solutions.com/"
id="LPUrlAnchor_14629678505640.5588968404587651"
style="text-decoration:none">Home
— OpenSIPS Solutions</a></div>
<div
id="LPMetadata_14629678505650.15893510896499718"
style=""><a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="http://www.opensips-solutions.com">www.opensips-solutions.com</a></div>
<div
id="LPDescription_14629678505650.08925628137354635"
style="">OpenSIPS is a mature Open
Source implementation of a SIP
server. OpenSIPS is more than a
SIP proxy/router as it includes
application-level functionalities.</div>
</td>
</tr>
</tbody>
</table>
</div>
<div class="moz-cite-prefix">On 14.04.2016
15:06, Rodrigo Pimenta Carvalho wrote:<br>
</div>
<blockquote type="cite">
<div id="divtagdefaultwrapper"
style="font-size:12pt; color:#000000;
background-color:#FFFFFF;
font-family:Calibri,Arial,Helvetica,sans-serif">
<p>Hi.</p>
<p><br>
</p>
<p>Sometimes, the log of my OpenSIPS shows
warnings like this:<br>
</p>
<p><br>
</p>
<p><br>
</p>
<p>Apr 14 00:04:33 colibri-imx6
opensips[6909]: Apr 14 00:04:30 [6918]
WARNING:core:handle_timer_job: timer job
<dlg-timer> has a 520000 us delay
in execution<br>
Apr 14 00:04:36 colibri-imx6
opensips[6909]: Apr 14 00:04:30 [6920]
WARNING:core:handle_timer_job: utimer
job <tm-utimer> has a 520000 us
delay in execution<br>
Apr 14 00:04:39 colibri-imx6
opensips[6909]: Apr 14 00:04:30 [6916]
WARNING:core:utimer_ticker: utimer task
<tm-utimer> already schedualed for
18348330 ms (now 18348960 ms), it may
overlap..<br>
Apr 14 00:04:43 colibri-imx6
opensips[6909]: Apr 14 00:04:30 [6919]
WARNING:core:handle_timer_job: timer job
<tm-timer> has a 520000 us delay
in execution<br>
Apr 14 00:04:53 colibri-imx6
opensips[6909]: Apr 14 00:04:31 [6919]
WARNING:core:handle_timer_job: timer job
<blcore-expire> has a 1070000 us
delay in execution<br>
Apr 14 00:04:57 colibri-imx6
opensips[6909]: Apr 14 00:04:31 [6916]
WARNING:core:utimer_ticker: utimer task
<tm-utimer> already schedualed for
18349200 ms (now 18349400 ms), it may
overlap..<br>
Apr 14 00:04:59 colibri-imx6
opensips[6909]: Apr 14 00:04:31 [6918]
WARNING:core:handle_timer_job: utimer
job <tm-utimer> has a 200000 us
delay in execution<br>
Apr 14 00:05:02 colibri-imx6
opensips[6909]: Apr 14 00:04:31 [6920]
WARNING:core:handle_timer_job: utimer
job <tm-utimer> has a 200000 us
delay in execution<br>
Apr 14 00:05:04 colibri-imx6
opensips[6909]: Apr 14 00:04:33 [6919]
WARNING:core:handle_timer_job: utimer
job <tm-utimer> has a 400000 us
delay in execution<br>
Apr 14 00:05:09 colibri-imx6
opensips[6909]: Apr 14 00:04:33 [6916]
WARNING:core:utimer_ticker: utimer task
<tm-utimer> already schedualed for
18350050 ms (now 18350450 ms), it may
overlap..<br>
Apr 14 00:05:11 colibri-imx6
opensips[6909]: Apr 14 00:04:34 [6920]
WARNING:core:handle_timer_job: utimer
job <tm-utimer> has a 680000 us
delay in execution<br>
Apr 14 00:05:16 colibri-imx6
opensips[6909]: Apr 14 00:04:34 [6918]
WARNING:core:handle_timer_job: utimer
job <tm-utimer> has a 680000 us
delay in execution<br>
Apr 14 00:05:21 colibri-imx6
opensips[6909]: Apr 14 00:04:34 [6916]
WARNING:core:utimer_ticker: utimer task
<tm-utimer> already schedualed for
18350820 ms (now 18351500 ms), it may
overlap..<br>
Apr 14 00:05:26 colibri-imx6
opensips[6909]: Apr 14 00:04:36 [6916]
WARNING:core:utimer_ticker: utimer task
<tm-utimer> already schedualed for
18352100 ms (now 18352300 ms), it may
overlap..<br>
Apr 14 00:05:28 colibri-imx6
opensips[6909]: Apr 14 00:04:36 [6918]
WARNING:core:handle_timer_job: utimer
job <tm-utimer> has a 200000 us
delay in execution<br>
Apr 14 00:05:32 colibri-imx6
opensips[6909]: Apr 14 00:04:36 [6919]
WARNING:core:handle_timer_job: utimer
job <tm-utimer> has a 200000 us
delay in execution<br>
Apr 14 00:05:36 colibri-imx6
opensips[6909]: Apr 14 00:04:37 [6920]
WARNING:core:handle_timer_job: utimer
job <tm-utimer> has a 18352670000
us delay in execution<br>
Apr 14 00:05:38 colibri-imx6
opensips[6909]: Apr 14 00:04:38 [6918]
WARNING:core:handle_timer_job: utimer
job <tm-utimer> has a 680000 us
delay in execution<br>
Apr 14 00:05:41 colibri-imx6
opensips[6909]: Apr 14 00:04:38 [6919]
WARNING:core:handle_timer_job: timer job
<tm-timer> has a 800000 us delay
in execution<br>
Apr 14 00:05:44 colibri-imx6
opensips[6909]: Apr 14 00:04:38 [6920]
WARNING:core:handle_timer_job: timer job
<blcore-expire> has a 800000 us
delay in execution<br>
</p>
<p><br>
</p>
<p><br>
</p>
<p>Any suggestion to avoid this or to use
a specific configuration for TM modules?</p>
<p><br>
</p>
<p>Any hint will be very helpful!</p>
<p><br>
</p>
<p>Best regards.<br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper"
style="font-family:Calibri,Arial,Helvetica,sans-serif;
font-size:; margin:0">
<div class="BodyFragment"><font
size="2">
<div class="PlainText">RODRIGO
PIMENTA CARVALHO<br>
Inatel Competence Center<br>
Software<br>
Ph: +55 35 3471 9200 RAMAL 979<br>
</div>
</font></div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
Users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
<br>
</body>
</html>