En/na Luca Olivetti ha escrit: >> I don't believe that there is any reason to expect a vacuum to correct a >> corrupt database. > > Ah, ok, I thought that it did (at least it did with 3.3.8).
Side note: it wasn't actually completely corrupted (hard corruption came after), or at least I think these were only minor errors: $ 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 vacuum with 3.3.8 fixed all three, while with 3.5.6 it only fixes the first one. 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
