Re: [sqlite] Persisting Database Lock Issue

2019-12-15 Thread Rowan Worth
On Fri, 13 Dec 2019 at 23:50, 고예찬 wrote: > Hello, I am experiencing `database is locked` error. I wonder if anyone has > gone through or resolved similar issue. > > To illustrate, I have a .db file with below settings: > ``` > PRAGMA journal_mode=WAL; > PRAGMA wal_autocheckpoint=128; > PRAGMA

[sqlite] Persisting Database Lock Issue

2019-12-13 Thread 고예찬
Hello, I am experiencing `database is locked` error. I wonder if anyone has gone through or resolved similar issue. To illustrate, I have a .db file with below settings: ``` PRAGMA journal_mode=WAL; PRAGMA wal_autocheckpoint=128; PRAGMA journal_size_limit=0; ``` and I run two programs in python -