Re: [SR-Users] SQlite DB Lock with Presence

Say if I'm working on a Debian system, and would like to assist the project... 1) Is there a script-able means to build .deb packages directly from the git repo? Or are the generic Debian instructions suitable such as pbuilder or git-buildpackage? https://www.debian.org/doc/manuals/maint-guide/

Re: [SR-Users] SQlite DB Lock with Presence

>From these errors: Apr 2 06:30:12 pbx kamailio[9532]: ERROR: db_sqlite [dbase.c:489]: db_sqlite_commit(): sqlite commit failed: NOT NULL constraint failed: pua.call_id Apr 2 06:30:12 pbx kamailio[9532]: ERROR: db_sqlite [dbase.c:138]: db_sqlite_cleanup_query(): finalize failed: NOT NULL cons

Re: [SR-Users] SQlite DB Lock with Presence

I tried this method and seem to have exchanged one set of errors for another: Apr 2 06:30:06 pbx kamailio[9526]: INFO: pua_dialoginfo [dialog_publish.c:386]: dialog_publish_multi(): CALLING dialog_publish for URI sip:9197@192.168.111.216;transport=UDP Apr 2 06:30:06 pbx kamailio[9519]: INFO: pre

Re: [SR-Users] SQlite DB Lock with Presence

On 31/03/16 21:05, David Holl wrote: > I'm curious why the kamailio sqlite module doesn't export a > transaction API, especially since the native sqlite API does support > transactions according to https://www.sqlite.org/transactional.html > Maybe someday, I'd get time to dig into the kamailio

Re: [SR-Users] SQlite DB Lock with Presence

I'm curious why the kamailio sqlite module doesn't export a transaction API, especially since the native sqlite API does support transactions according to https://www.sqlite.org/transactional.html Maybe someday, I'd get time to dig into the kamailio module myself to try lending a hand... Anyhow,

Re: [SR-Users] SQlite DB Lock with Presence

Hi Daniel, I switched to mysql and haven't looked back but I will take another look with sqlite because it *should* work. Thanks! On Thu, Mar 31, 2016 at 12:11 PM, Daniel-Constantin Mierla wrote: > Hello, > > I looked quickly at sqlite and the module doesn't export db transaction API, > so

Re: [SR-Users] SQlite DB Lock with Presence

Hello, I looked quickly at sqlite and the module doesn't export db transaction API, so it is not what I thought in the first place (some presence operations try to use db transactions if supported by db module). So it is something in sqlite that locks the table. Do you see any error message in the

Re: [SR-Users] SQlite DB Lock with Presence

Hi Daniel, First call. Thanks! On Wednesday, March 30, 2016, Daniel-Constantin Mierla wrote: > Hello, > > not using sqlite here, but could be related to presence modules doing db > transactions and not releasing the locks. Do you get the issue after the > first call, or it runs for a while an

Re: [SR-Users] SQlite DB Lock with Presence

Hello, not using sqlite here, but could be related to presence modules doing db transactions and not releasing the locks. Do you get the issue after the first call, or it runs for a while and at some point it breaks? Cheers, Daniel On 30/03/16 02:50, Kristian Kielhofner wrote: > Hello everyone,

[SR-Users] SQlite DB Lock with Presence

Hello everyone, I'm trying to use BLF with the config here (except with SQlite): http://kb.asipto.com/kamailio:presence:k43-blf BLF seems to work perfectly except after the call is ended I get "sqlite commit failed: database is locked" error messages as seen here: http://pastebin.com/xVijj9