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

[Bogdan-Andrei Iancu]

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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20160517/2ccd98cc/attachment.htm>