On 01/05/2015 06:22 PM, Simon Slavin wrote:
I have a database file which is 120GB in size. It consists of two huge tables
and an index.
Its journal_mode is DELETE.
It is on a partition with 803GB of free space. By my calculations I have 6.7
times the amount of free space as the database is taking up.
I use the SQLite shell tool version 3.7.9 to run VACUUM on it. The Shell tool
bails out reporting
CPU Time: user 2113.596836 sys 437.660032
Error: near line 5 : database or disk full.
My understanding is that VACUUM can't take more than three times the current
size of the database file. What does the above error mean under these
circumstances ?
Probably running out of space wherever temp files are created.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
