To allow the VACUUM command to run, change the directory for temporary files to one that has enough free space.
SQLite’s documentation says the temporary directory is (in order):
- whatever is set with the PRAGMA temp_store_directory command; or
- whatever is set with the
SQLITE_TMPDIRenvironment variable; or - whatever is set with the
TMPDIRenvironment variable; or /var/tmp; or/usr/tmp; or/tmp; or., the current working directory