Testsuite fails with `SQLITE_BUSY: database is locked`

[marph91]

Recently, the testsuite of the server API fails occasionally with SQLITE_BUSY: database is locked. For example https://github.com/marph91/joppy/actions/runs/26368668504/job/77616776399

======================================================================
ERROR [0.633s]: test_get_notebook (test.test_server_api.Notebook)
Get a specific notebook.
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/home/runner/work/joppy/joppy/test/test_server_api.py", line 36, in setUp
    super().setUp()
  File "/home/runner/work/joppy/joppy/test/common.py", line 48, in setUp
    self.api.delete_all_notebooks()
  File "/home/runner/work/joppy/joppy/joppy/server_api.py", line 627, in delete_all_notebooks
    self.delete_notebook(notebook.id)
  File "/home/runner/work/joppy/joppy/joppy/server_api.py", line 412, in delete_notebook
    self.delete(f"/api/items/root:/{add_suffix(id_)}:")
  File "/home/runner/work/joppy/joppy/joppy/server_api.py", line 221, in delete
    return self._request("delete", path, query=query)
  File "/home/runner/work/joppy/joppy/joppy/server_api.py", line 211, in _request
    response.raise_for_status()
  File "/opt/hostedtoolcache/Python/3.10.20/x64/lib/python3.10/site-packages/requests/models.py", line 1028, in raise_for_status
    raise HTTPError(http_error_msg, response=self)
requests.exceptions.HTTPError: ('500 Server Error: Internal Server Error for url: http://localhost:22300/api/items/root:/ed060687c17841df8538f97cf4a485a0.md:', '{"error":"insert into `changes_2` (`created_time`, `id`, `item_id`, `item_name`, `item_type`, `previous_share_id`, `type`, `updated_time`, `user_id`) values (1779645984909, \'r7FA81wNdZXVnl01NOrZF7\', \'WgXFgJjDD5qt6ALVCreI0l\', \'ed060687c17841df8538f97cf4a485a0.md\', 2, \'\', 3, 1779645984909, \'SPXxeidVw8yrzH6e58L9Mv\') - SQLITE_BUSY: database is locked","code":"SQLITE_BUSY"}')

Might be related to laurent22/joplin#15226.

Error Overview

Job	Date	Test	Method
link	2026-05-24	test.test_server_api.Notebook.test_get_notebook	self.delete_notebook(notebook.id)
link	2026-05-24	test.test_server_api.Notebook.test_get_notebook	self.delete_notebook(notebook.id)
link	2026-05-24	test.test_server_api.Resource.test_get_resource	self.delete_resource(resource.id)
link	2026-05-24	test.test_server_api.Note.test_get_all_notes	self.api.add_note(parent_id)
link	2026-05-24	test.test_server_api.Notebook.test_get_notebook	self.delete_notebook(notebook.id)

Until 2026-05-03, this error didn't occur.