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 <mico...@gmail.com> wrote: > 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 logs before > the one with the table locked? > > Cheers, > Daniel > > > On 30/03/16 14:28, Kristian Kielhofner wrote: > > Hi Daniel, > > First call. > > Thanks! > > On Wednesday, March 30, 2016, Daniel-Constantin Mierla <mico...@gmail.com> > 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 and at some point it breaks? >> >> Cheers, >> Daniel >> >> On 30/03/16 02:50, Kristian Kielhofner wrote: >> > 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/xVijj98H >> > >> > BLF is then broken at this point. >> > >> > kamailio -v >> > version: kamailio 4.3.5 (x86_64/linux) 950657 >> > flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, >> > USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MEM, >> > SHM_MMAP, PKG_MALLOC, DBG_QM_MALLOC, USE_FUTEX, >> > FAST_LOCK-ADAPTIVE_WAIT, USE_PTHREAD_MUTEX, USE_DNS_CACHE, >> > USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLACKLIST, HAVE_RESOLV_RES >> > ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, >> > MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB >> > poll method support: poll, epoll_lt, epoll_et, sigio_rt, select. >> > id: 950657 >> > compiled on 01:33:01 Mar 29 2016 with x86_64-openwrt-linux-gnu-gcc 4.8.3 >> > >> > Has anyone ever seen this before? >> > >> > Thanks! >> > >> >> -- >> Daniel-Constantin Mierla >> http://www.asipto.com >> http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda >> Kamailio World Conference, Berlin, May 18-20, 2016 - >> http://www.kamailioworld.com >> >> >> _______________________________________________ >> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list >> sr-users@lists.sip-router.org >> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > > > > -- > Sent from mobile device > > > -- > Daniel-Constantin Mierla > http://www.asipto.com > http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda > Kamailio World Conference, Berlin, May 18-20, 2016 - > http://www.kamailioworld.com -- Kristian Kielhofner _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
