[SR-Users] SQlite DB Lock with Presence

[Kristian Kielhofner]

Hi Daniel,

 First call.

Thanks!

On Wednesday, March 30, 2016, Daniel-Constantin Mierla <miconda at 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 at lists.sip-router.org <javascript:;>
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>


-- 
Sent from mobile device
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160330/274c7252/attachment.html>