On 2016/01/14 6:46 PM, R Smith wrote: > ...// Out-of-memory and out-of-diskspace type errors are reported//....
Also note here that there is a case where SQLite will report DISK_FULL errors where the disks are seemingly fine - when you start a transaction that requires large amounts of space, and your DB file is on a drive with oodles of space, but the TEMP folder is on a drive that is nearly full, then the transaction might not complete and report DISK_FULL. (I understand this can only happen in /some/ journal modes [WAL mode should be ok for instance], but I am not exactly sure). This is especially true for running VACUUM on a rather large database. I myself have my TEMP folder set to a RAM-drive that is only 6GB big, so trying to VACUUM anything larger than 6GB might fail with DISK_FULL - for which I usually need to temporarily set another temp folder.
