SQLITE_BUSY: database is locked

I'm seeing this error after increasing the amount of concurrent write operations I was performing.

Has anyone else had to deal with this?

(better-sqlite3 on node.js)

Mozart's_Ghost•6/19/24, 5:26 AM

I ran into this a while back. Nearly pulled my hair out. It happened to me when I had a READ as the first action in the body of the transaction call back. It is an thing. Here is the documentation that was relevant to my issue

"If the first statement after BEGIN DEFERRED is a SELECT, then a read transaction is started. Subsequent write statements will upgrade the transaction to a write transaction if possible, or return SQLITE_BUSY"

https://www.sqlite.org/lang_transaction.html#deferred_immediate_and_exclusive_transactions

Mozart's_Ghost•6/19/24, 5:26 AM

It will probably help a lot if you read that whole page