subject:"\[sqlite\] WAL checkpoints not working"

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

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 >

[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