SQLITE3 VACUUM, “database or disk is full”

by

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):

  1. whatever is set with the PRAGMA temp_store_directory command; or
  2. whatever is set with the SQLITE_TMPDIR environment variable; or
  3. whatever is set with the TMPDIR environment variable; or
  4. /var/tmp; or
  5. /usr/tmp; or
  6. /tmp; or
  7. ., the current working directory

More Related Contents:

  1. near “varchar”: syntax error [closed]
  2. How do I rename a column in a SQLite database table?
  3. How do I check in SQLite whether a table exists?
  4. How to set Sqlite3 to be case insensitive when string comparing?
  5. Accessing an SQLite Database in Swift
  6. Difference between 2 dates in SQLite
  7. Select random row from a sqlite table
  8. Update with Join in SQLite
  9. Can I read and write to a SQLite database concurrently from multiple connections?
  10. How do I store and retrieve a blob from sqlite?
  11. Store boolean value in SQLite
  12. Can SQLite support multiple users?
  13. SQLite add Primary Key
  14. How delete table inner join with other table in Sqlite?
  15. Export from sqlite to csv using shell script
  16. SQLite: How do I save the result of a query as a CSV file?
  17. Create table in SQLite only if it doesn’t exist already
  18. How do DATETIME values work in SQLite?
  19. Add ON DELETE CASCADE behavior to an sqlite3 table after it has been created
  20. sqlite get ROWID
  21. How to have an automatic timestamp in SQLite?
  22. svn cleanup: sqlite: database disk image is malformed
  23. Truncate a SQLite table if it exists?
  24. SELECT INTO statement in sqlite
  25. How to display blob value using x’abc’ binary string literal syntax?
  26. Unable to load DLL sqlite3 in Universal Windows App running on Mobile
  27. Integration Testing Entity Framework code first with in-memory database
  28. DbFunctions.TruncateTime LINQ equivalent in EF CORE
  29. How to get the number of rows of the selected result from sqlite3?
  30. How to get the last index of a substring in SQLite?

Leave a Comment