On Jan 31, 2017, at 2:03 PM, Ward WIllats <sqlite-us...@wardco.com> wrote:
> 
> the delete sometimes (very rarely) fails with a 13 "disk or database full" 
> error. I assume because the purger is late to the party and it needs pages in 
> the WAL to be able to rollback if necessary.

Is there an especially good reason you have to do this in a single shot?

If you get this error, shrink the date range or pages-to-free value by half and 
try again.  Repeat until it works, then repeat at that size until you’ve 
deleted as much as you need to.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to