The error is due to a full disk. You should not be deleting files associated with an SQLite db file.
Have you tried running pragma integrity_check(); before the disk actually becomes full? Other than corruption of the file, the two candidates are internal fragmentation (doing lots of INSERT and DELETE operations), which would be remedied by running VACUUM (NOTE: may require up to double the current file size); or just the sheer volume of data (doing lots of INSERTS and never DELETEing outdated rows), which you would need to handle in your application. The fact that "backing up" (how? Export/import or the SQLite backup API?) the db file helps would indicate either fragmentation or corruption. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:[email protected]] Im Auftrag von bhandari_nikhil Gesendet: Donnerstag, 01. August 2019 10:48 An: [email protected] Betreff: Re: [sqlite] [EXTERNAL] Error in recover sqlite3 database This is my table, I just wanted to show the error that it is throwing. Is the error due to /tmp being full on my device ? Further debugging at our end showed that one way to replicate the problem is to remove the hot journal file in the middle of an insert transaction but we are not sure if that is the actual cause of the problem or not. In the application, we have a logic to check the db file size and if it grows beyond a certain threshold, we would take a backup of the db file. But once we do the delete-the journal-in-the middle-of-a-transaction operation, this size check never passes and the db size keeps on growing. Why could that be ? -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
