[SR-Users] SQlite DB Lock with Presence

[Daniel-Constantin Mierla]

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