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 ? I'm currently running "PRAGMA integrity_check" but I have no reason to believe that the database is corrupt, I'm just desperate. If nobody comes up with any suggestions my next tactic is to DROP the index, do the VACUUM, then rebuild the index. I suspect that all three of those operations will be overnight runs so again I'll write a script which does all three and use the shell tool's ".read" function. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
