Re: [sqlite] WAL checkpoints not working

2011-03-31 Thread Nico Williams
On Thu, Mar 31, 2011 at 3:48 PM, Richard Hipp wrote: > On Thu, Mar 31, 2011 at 4:44 PM, Dave White wrote: >> 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 transaction open.  (It does as much as it >

Re: [sqlite] WAL checkpoints not working

2011-03-31 Thread Richard Hipp
On Thu, Mar 31, 2011 at 4:44 PM, Dave White wrote: > > 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