How would you recommend to approach this problem: I want to determine how much disk space a certain insert will take before actually executing it so I can fail insert before doing it rather than trying to insert, then receive SQLite Disk I/O error when the disk is filled.
So I would determine first how much disk space is left, then determine approximately how much next query will take on disk and if there is not enough space fail before even trying to write. Is there any way to do this? Also, another problem is that once disk space is low and query fails with I/O error it leaves journal file. Apparently the database is not corrupted as it seems to do auto-rollback and on next access of database the journal file is gone. But why is it there when write fails due to low disk space? The process goes like this 1. BEGIN EXCLUSIVE 2. some INSERT 3. sqlite3_step() (fails to low disk space) 4. journal file is not deleted even if I do manual ROLLBACK... However, after closing database and reopening it journal is deleted and apparently database can be accessed normally and it doesn't seem to be corrupted although its size is not truncated to previous size before INSERT. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
