SQLite VACUUM: database or disk is full

I was trying to run VACUUM against a large SQLite database file (~7GB) using sqlite-utils vacuum data.db and I got this error:

sqlite3.OperationalError: database or disk is full

The /data volume that the database lived in was 20GB in size, so there should have been enough room to run the operation.

I realized that this was because VACUUM uses the /tmp directory, and on this machine that was on a separate volume that did not have enough space.

The fix was to set the SQLITE_TMPDIR environment variable to the current directory (or any directory on a volume with enough space):

SQLITE_TMPDIR=/data sqlite-utils vacuum data.db

Related

• sqlite Saving an in-memory SQLite database to a file in Python - 2023-04-08
• sqlite Compile a new sqlite3 binary on Ubuntu - 2020-04-30
• sqlite Calculating the size of a SQLite database file using SQL - 2023-08-21
• sqlite Importing CSV data into SQLite with .import - 2021-07-13
• sqlite Enabling WAL mode for SQLite database files - 2020-08-09
• homebrew Running the latest SQLite in Datasette using Homebrew - 2022-02-28
• python Running PyPy on macOS using Homebrew - 2022-09-14
• sqlite Copy tables between SQLite databases - 2023-04-03
• sqlite Counting SQLite virtual machine operations - 2022-03-20
• sqlite Loading SQLite extensions in Python on macOS - 2023-01-07

Created 2022-08-29T11:15:03-07:00 · Edit