[asterisk-dev] sqlite concurrency - queue_log/cel

[marek cervenka]

hi,

first of all, i know sqlite is not designed for concurrency

workarounds are wal - https://www.sqlite.org/wal.html . can be specified 
when creating DB with "pragma journal_mode=wal"

and

busy_timeout https://www.sqlite.org/c3ref/busy_timeout.html . MUST be 
specified per connection


we are using sqlite for cel and queue_log.

https://github.com/asterisk/asterisk/blob/master/res/res_config_sqlite3.c

https://github.com/asterisk/asterisk/blob/master/cel/cel_sqlite3_custom.c

busy_timeout is hardcoded (value is in ms)

sqlite3_busy_timeout(db->handle, 1000);


will you accept patch where busy_timeout will be configurable?


btw our use case is

- central data warehouse

- apache kafka as receiver

- every asterisk has producer (node.js) which analyze sqlite 
cel/queue_log. producer builds call structure and send it to kafka.  
main problem is in updating sqlite cel/queue_log by producer which rows 
was sent (concurrent write access)


Marek



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-dev/attachments/20170522/1b4e32b3/attachment.html>