> On Jan 31, 2017, at 3:54 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 31 Jan 2017, at 10:40pm, Warren Young <war...@etr-usa.com> wrote: > >> 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. >> >> 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. > > It’s possible to do a DELETE in chunks, like you would use LIMIT on a SELECT. >
Thanks for taking the time to provide the great tips and technical explanation by DRH. Our architecture is well suited to some kind of chunked and/or recursing delete so I will do some experiments today to find some reasonable bounding parameters and push ahead. (I have another simple question related to this, but I'll start a new thread so it is not buried here.) -- Ward _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
