[sqlite] WAL checkpoints not working

2011-03-31 Thread Dave White
I can't get WAL checkpoints to work, automatically or forced. The WAL file seems to grow forever until the database is shutdown. I have tried: sqlite3_wal_checkpoint() and PRAGMA wal_checkpoint (with all different options) My 84MB data file is now paired with a

Re: [sqlite] WAL checkpoints not working

2011-03-31 Thread Richard Hipp
On Thu, Mar 31, 2011 at 4:44 PM, Dave White dwh...@companioncorp.comwrote: I can't get WAL checkpoints to work, automatically or forced. The WAL file seems to grow forever until the database is shutdown. I have tried: sqlite3_wal_checkpoint() and PRAGMA

Re: [sqlite] WAL checkpoints not working

2011-03-31 Thread Nico Williams
On Thu, Mar 31, 2011 at 3:48 PM, Richard Hipp d...@sqlite.org wrote: On Thu, Mar 31, 2011 at 4:44 PM, Dave White dwh...@companioncorp.comwrote: Any ideas why this would happen? You have a read transaction being held open.  The checkpoint cannot run to completion when there is a read