Hello all, to increase the poor insert speed of sqlite on my system I set the PRAGMA journal_mode=PERSIST on all my databases.
Now I have two problems: 1. Sometimes master journal files are not deleted. All databases are healthy, the journal files are empty and in the remaining master journal files all my database-journals are listet. There seem to be no problem. What may be the reason for not deleting? 2. This only happend once. (I still have the databases + journals here and could send them) On an insert I got "database disk image is malformed". I run integrity check and got also only this message. Then I made a .dump and tested the new database and all was well. Afterwards I renamed the new database to the right name and started the application again. Now I got malformed again. I had a look at the journal file and it was not empty (Binary data). Also the journal files of the other databases are not empty. (I tested this also with the original database which I saved before and got the same) Then I deleted the corrupt journal file on the system and restarted the application again. Now it worked and all journal files are empty again. We use QNX as operating system, a SiliconDisk Flash IDE and Sqlite 3.6.11 Thank you in advance for you reply Best regards / Mit freundlichen Gruessen Stefan Breitholz ----------------------------------------------------------------------------------------------------------- Staeubli GmbH - Theodor-Schmidt-Str. 19 DE - 95448 Bayreuth Phone: +49(0)921/883-126 Fax: +49(0)921/883-58126 mailto:s.breith...@staubli.com http://www.staubli.com Registered under HRB 175 - Local Court Bayreuth - Managing Director: Karl Kirschner ----------------------------------------------------------------------------------------------------------- This e-mail and any attachment (the 'message') are confidential and privileged and intended solely for the person or the entity to which it is adressed. If you have received it in error, please advise the sender by return e-mail and delete it immediately. Any use not in accordance with its purpose, any dissemination or reproduction, either whole or partial, by entities other than the intended recipient is strictly prohibited. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
