Hi Rodrigo,
Of course you can use any combination of SQL backends - when you define
the db_url for a module, just select the db backend you want for it.
Now, the timer error you get here is related to the SQLite - I noticed
in one of your more recent posts that you get an error from sqlite on
locking the location table - this blocking of the table may prevent
opensips to write into the table - and the writing in the location table
is timer based. So, the timer complains on getting blocked.
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 13.05.2016 15:53, Rodrigo Pimenta Carvalho wrote:
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
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
