[SR-Users] SQlite DB Lock with Presence

[Kristian Kielhofner]

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
<miconda at 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 <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
>> 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