<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p></p>
<div> <br>
Dear OpenSIPS-users,<br>
<br>
In my project I'm using SQLite as database for OpenSIPS, Everything is going well for several tables. That is, OpenSIPS works very well to handle several tables from my SQLite data base. Except for table location, as I suspect.<br>
<br>
What is the problem?<br>
------------------------------<br>
After receiving "SIP REGISTER" messages for a time, OpenSIPS shows a warning in the log:<br>
"<span>WARNING:core:timer_ticker: timer task <ul-timer> already schedualed f...verlap..</span>"<br>
<br>
<br>
How can I reproduce the problem?<br>
-----------------------------------------------<br>
I just let only one softphone (client) online sending SIP REGISTER to my OpenSIPS, one message at each minute. Only one client is enough to cause the problem. And there is no calls at all.<br>
<br>
<br>
What I'm suspecting?<br>
-----------------------------<br>
I suspect that when OpenSIPS receives the SIP REGISTER it has to handle the table location. And then the proxy does it successfully for a number of SIP REGISTER. But, after a time, probably there is some error while handling the location via SQLite, and it
causes the issue. I suspect that if I stop using DB_SQLite for keep users locations, the problem will disappear (finish).
<br>
<br>
<br>
What I intend to do?<br>
------------------------------<br>
I intend to use DB_Text every time OpenSIPS will need to save user locations. But I still want to continue using DB_SQLite for other data.<br>
<br>
<br>
Can I use DB_Text and DB_SQLite in the same script or such thing will cause problems for sure?<br>
P.S.: I'm using OpenSIPS 2.2 from october/november 2015.<br>
<br>
Any hint will be very helpful!<br>
Best regards.<br>
<br>
<br>
<br>
</div>
RODRIGO PIMENTA CARVALHO<br>
<p></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">Inatel Competence Center<br>
Software<br>
Ph: +55 35 3471 9200 RAMAL 979<br>
</div>
</font></div>
</div>
</div>
</div>
</body>
</html>