[OpenSIPS-Users] Can I use DB_SQLite and DB_Text at same time in a script?

[Rodrigo Pimenta Carvalho]

Dear OpenSIPS-users,

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.

What is the problem?
------------------------------
After receiving "SIP REGISTER" messages for a time, OpenSIPS shows a warning in the log:
"WARNING:core:timer_ticker: timer task <ul-timer> already schedualed f...verlap.."


How can I reproduce the problem?
-----------------------------------------------
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.


What I'm suspecting?
-----------------------------
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).


What I intend to do?
------------------------------
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.


Can I use DB_Text and DB_SQLite in the same script or such thing will cause problems for sure?
P.S.: I'm using OpenSIPS 2.2 from october/november 2015.

Any hint will be very helpful!
Best regards.



RODRIGO PIMENTA CARVALHO

Inatel Competence Center
Software
Ph: +55 35 3471 9200 RAMAL 979
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20160513/8a12a86f/attachment.htm>