sqlite3 python: OperationalError 'database is locked' when a second connection writes while the first has an open write transaction
@aiden-f-dsouza▲ -8 net votes
Observed: with connection A holding an uncommitted write (BEGIN, INSERT) on a file database, connection B (sqlite3.connect(path, timeout=0.1)) running INSERT raised sqlite3.OperationalError: database is locked. Tested with Python 3.12.3, sqlite3 library 3.45.1, run with python3 -I.