It's needed specifically when setting WAL, because on module loading, each child creates its own DB connection and sets the WAL (or other options you might set), and it all happens roughly at the same time. Without setting the busy-timeout, starting of kamailio will fail due to locking issues with sqlite.
<!-- Kamailio Pull Request Template -->
<!-- IMPORTANT: - for detailed contributing guidelines, read: https://github.com/kamailio/kamailio/blob/master/.github/CONTRIBUTING.md - pull requests must be done to master branch, unless they are backports of fixes from master branch to a stable branch - backports to stable branches must be done with 'git cherry-pick -x ...' - code is contributed under BSD for core and main components (tm, sl, auth, tls) - code is contributed GPLv2 or a compatible license for the other components - GPL code is contributed with OpenSSL licensing exception -->
#### Pre-Submission Checklist <!-- Go over all points below, and after creating the PR, tick all the checkboxes that apply --> <!-- All points should be verified, otherwise, read the CONTRIBUTING guidelines from above--> <!-- If you're unsure about any of these, don't hesitate to ask on sr-dev mailing list --> - [x] Commit message has the format required by CONTRIBUTING guide - [x] Commits are split per component (core, individual modules, libs, utils, ...) - [x] Each component has a single commit (if not, squash them into one commit) - [x] No commits to README files for modules (changes must be done to docbook files in `doc/` subfolder, the README file is autogenerated)
#### Type Of Change - [ ] Small bug fix (non-breaking change which fixes an issue) - [x] New feature (non-breaking change which adds new functionality) - [ ] Breaking change (fix or feature that would change existing functionality)
#### Checklist: <!-- Go over all points below, and after creating the PR, tick the checkboxes that apply --> - [ ] PR should be backported to stable branches - [x] Tested changes locally - [ ] Related to issue #XXXX (replace XXXX with an open issue number)
#### Description <!-- Describe your changes in detail --> You can view, comment on, or merge this pull request online at:
https://github.com/kamailio/kamailio/pull/4028
-- Commit Summary --
* db_sqlite: Add busy timeout param to improve concurrency.
-- File Changes --
M src/modules/db_sqlite/db_sqlite.c (52) M src/modules/db_sqlite/db_sqlite.h (1) M src/modules/db_sqlite/dbase.c (13) M src/modules/db_sqlite/doc/db_sqlite_admin.xml (48)
-- Patch Links --
https://github.com/kamailio/kamailio/pull/4028.patch https://github.com/kamailio/kamailio/pull/4028.diff
@agranig pushed 1 commit.
eb95b731b9a5b237520540ee7e9038bd2ecd9f08 sqlite: Add author to readme
@agranig pushed 1 commit.
05f5daa3cb3bbf2f245b27223b377054fd9f2c2c db_sqlite: fix code formatting
@agranig pushed 1 commit.
2b201054bb40a32344db975c9ef865e9f5c44444 sqlite: fix code format
@agranig pushed 1 commit.
09ac80e50d0b0a240191d90138562d2db2c67f88 db_sqlite: fix code formatting
Closed #4028.