<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
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?<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 30/03/16 14:28, Kristian Kielhofner
wrote:<br>
</div>
<blockquote
cite="mid:CAKDfjge1Y=5uDqrHMZXj5RWS6Ww2__U_J18PDRBXi2+LpDuz6Q@mail.gmail.com"
type="cite">Hi Daniel,
<div><br>
</div>
<div> First call. </div>
<div><br>
</div>
<div>Thanks!<span></span><br>
<div><br>
On Wednesday, March 30, 2016, Daniel-Constantin Mierla <<a
moz-do-not-send="true" href="mailto:miconda@gmail.com"><a class="moz-txt-link-abbreviated" href="mailto:miconda@gmail.com">miconda@gmail.com</a></a>>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Hello,<br>
<br>
not using sqlite here, but could be related to presence
modules doing db<br>
transactions and not releasing the locks. Do you get the
issue after the<br>
first call, or it runs for a while and at some point it
breaks?<br>
<br>
Cheers,<br>
Daniel<br>
<br>
On 30/03/16 02:50, Kristian Kielhofner wrote:<br>
> Hello everyone,<br>
><br>
> I'm trying to use BLF with the config here (except
with SQlite):<br>
><br>
> <a moz-do-not-send="true"
href="http://kb.asipto.com/kamailio:presence:k43-blf"
target="_blank">http://kb.asipto.com/kamailio:presence:k43-blf</a><br>
><br>
> BLF seems to work perfectly except after the call is
ended I get<br>
> "sqlite commit failed: database is locked" error
messages as seen<br>
> here:<br>
><br>
> <a moz-do-not-send="true"
href="http://pastebin.com/xVijj98H" target="_blank">http://pastebin.com/xVijj98H</a><br>
><br>
> BLF is then broken at this point.<br>
><br>
> kamailio -v<br>
> version: kamailio 4.3.5 (x86_64/linux) 950657<br>
> flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP,
TLS_HOOKS,<br>
> USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK,
SHM_MEM,<br>
> SHM_MMAP, PKG_MALLOC, DBG_QM_MALLOC, USE_FUTEX,<br>
> FAST_LOCK-ADAPTIVE_WAIT, USE_PTHREAD_MUTEX,
USE_DNS_CACHE,<br>
> USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLACKLIST,
HAVE_RESOLV_RES<br>
> ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144,
MAX_LISTEN 16,<br>
> MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB<br>
> poll method support: poll, epoll_lt, epoll_et,
sigio_rt, select.<br>
> id: 950657<br>
> compiled on 01:33:01 Mar 29 2016 with
x86_64-openwrt-linux-gnu-gcc 4.8.3<br>
><br>
> Has anyone ever seen this before?<br>
><br>
> Thanks!<br>
><br>
<br>
--<br>
Daniel-Constantin Mierla<br>
<a moz-do-not-send="true" href="http://www.asipto.com"
target="_blank">http://www.asipto.com</a><br>
<a moz-do-not-send="true"
href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a>
- <a moz-do-not-send="true"
href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a><br>
Kamailio World Conference, Berlin, May 18-20, 2016 - <a
moz-do-not-send="true" href="http://www.kamailioworld.com"
target="_blank"><a class="moz-txt-link-freetext" href="http://www.kamailioworld.com">http://www.kamailioworld.com</a></a><br>
<br>
<br>
_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
mailing list<br>
<a moz-do-not-send="true" href="javascript:;"
onclick="_e(event, 'cvml',
'sr-users@lists.sip-router.org')">sr-users@lists.sip-router.org</a><br>
<a moz-do-not-send="true"
href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users"
target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</blockquote>
</div>
</div>
<br>
<br>
-- <br>
Sent from mobile device<br>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, Berlin, May 18-20, 2016 - <a class="moz-txt-link-freetext" href="http://www.kamailioworld.com">http://www.kamailioworld.com</a></pre>
</body>
</html>