[asterisk-bugs] [JIRA] (ASTERISK-27014) configurable busy_timeout in sqlite backends

[Rusty Newton (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-27014?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rusty Newton updated ASTERISK-27014:
------------------------------------

    Affects Version/s: GIT
                       13.15.0
                       14.4.0

> configurable busy_timeout in sqlite backends
> --------------------------------------------
>
>                 Key: ASTERISK-27014
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-27014
>             Project: Asterisk
>          Issue Type: Improvement
>      Security Level: None
>    Affects Versions: 13.15.0, 14.4.0, GIT
>            Reporter: Marek Cervenka
>
> 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
> busy_timeout is hardcoded in queue_log and cel sqlite backends
> sqlite3_busy_timeout(db->handle, 1000);
> we prepared patch where this parameter can be configured



--
This message was sent by Atlassian JIRA
(v6.2#6252)