Hello, due to my recent problem http://thread.gmane.org/gmane.comp.db.sqlite.general/35992
I tried to download 3.5.6 and compiled it with --enable-threadsafe. While with 3.3.8 a vacuum cleared all errors reported by "PRAGMA integrity_check", 3.5.6 doesn't: $ sqlite3 almacen.db.malo SQLite version 3.5.6 Enter ".help" for instructions sqlite> pragma integrity_check; *** in database main *** Main freelist: 1 of 1 pages missing from overflow list starting at 0 wrong # of entries in index fifo_referencias wrong # of entries in index sqlite_autoindex_fifo_fis_1 sqlite> vacuum; sqlite> pragma integrity_check; wrong # of entries in index fifo_referencias wrong # of entries in index sqlite_autoindex_fifo_fis_1 Is this expected? If so, how can I fix these errors? (yes, I know that I could dump and restore, but I need something more automated). Bye -- Luca Olivetti Wetron Automatización S.A. http://www.wetron.es/ Tel. +34 93 5883004 Fax +34 93 5883007 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
