Hello, for a few months we have been occasionally getting corrupted databases in the field. So far we were unable to acquire any of them from our customers, but this week I finally got hold of one. Output from "pragma integrity_check" is included below.
The schema is the following: CREATE VIRTUAL TABLE "LocalMailsIndex3" USING fts3 (id INTEGER, partName TEXT, content TEXT); CREATE TABLE LocalMailsIndex3_content( docid INTEGER PRIMARY KEY,c0id, c1partName, c2content); CREATE TABLE LocalMailsIndex3_segdir( level integer, idx integer, start_block integer, leaves_end_block integer, end_block integer, root blob, primary key(level, idx)); CREATE TABLE LocalMailsIndex3_segments( blockid INTEGER PRIMARY KEY, block blob); CREATE INDEX "LocalMailsIndex3_contentIndex" ON "LocalMailsIndex3_content" ("c0id", "c1partName"); The database is created using SQLite 3.6.14.2, thread safe, on Windows with auto_vacuum=incremental. It is always opened as attached database with journal_mode=persist. Application crashes were most probably involved, but no operating system / power crashes as far as I know. One thread in the application is periodically running "pragma freelist_count" and "pragma incremental_vacuum(...)". Other threads are running combination of the following commands and no other: INSERT INTO mail_fti.LocalMailsIndex3("id", "partName", "content") VALUES (@id, @partName, @content) SELECT c2content AS content FROM mail_fti.LocalMailsIndex3_content WHERE c0...@id AND c1partna...@partname SELECT docid FROM mail_fti.LocalMailsIndex3_content WHERE c0id IN (...) DELETE FROM mail_fti.LocalMailsIndex3 WHERE doc...@docid SELECT ... WHERE "id" IN (SELECT "id" FROM mail_fti.LocalMailsIndex3 WHERE content MATCH "...") Anybody has seen something like this? Anybody willing to look at it? I can send the database privately. Best regards, Filip Navara Main freelist: Bad ptr map entry key=5143 expected=(2,0) got=(3,4467) Main freelist: freelist leaf count too big on page 5143 Main freelist: Bad ptr map entry key=5449 expected=(2,0) got=(4,5143) Main freelist: freelist leaf count too big on page 5449 Main freelist: 904 of 908 pages missing from overflow list starting at 5143 On tree page 3878 cell 26: invalid page number 5737 On tree page 3878 cell 26: Child page depth differs On tree page 3878 cell 27: Failed to read ptrmap key=5746 On tree page 3878 cell 27: invalid page number 5746 On tree page 3878 cell 28: Failed to read ptrmap key=5748 On tree page 3878 cell 28: invalid page number 5748 On tree page 3878 cell 29: Failed to read ptrmap key=5749 On tree page 3878 cell 29: invalid page number 5749 On tree page 3878 cell 30: Failed to read ptrmap key=5755 On tree page 3878 cell 30: invalid page number 5755 On tree page 3878 cell 31: Failed to read ptrmap key=5757 On tree page 3878 cell 31: invalid page number 5757 On tree page 3878 cell 32: Failed to read ptrmap key=5759 On tree page 3878 cell 32: invalid page number 5759 On tree page 3878 cell 33: Failed to read ptrmap key=5761 On tree page 3878 cell 33: invalid page number 5761 On tree page 3878 cell 34: Failed to read ptrmap key=5763 On tree page 3878 cell 34: invalid page number 5763 On tree page 3878 cell 35: Failed to read ptrmap key=5767 On tree page 3878 cell 35: invalid page number 5767 On tree page 3878 cell 36: Failed to read ptrmap key=5769 On tree page 3878 cell 36: invalid page number 5769 On tree page 3878 cell 37: Failed to read ptrmap key=5771 On tree page 3878 cell 37: invalid page number 5771 On tree page 3878 cell 38: Failed to read ptrmap key=5773 On tree page 3878 cell 38: invalid page number 5773 On tree page 3878 cell 39: Failed to read ptrmap key=5775 On tree page 3878 cell 39: invalid page number 5775 On tree page 3878 cell 40: Failed to read ptrmap key=5777 On tree page 3878 cell 40: invalid page number 5777 On tree page 3878 cell 41: Failed to read ptrmap key=5780 On tree page 3878 cell 41: invalid page number 5780 On tree page 3878 cell 42: Failed to read ptrmap key=5783 On tree page 3878 cell 42: invalid page number 5783 On tree page 3878 cell 43: Failed to read ptrmap key=5787 On tree page 3878 cell 43: invalid page number 5787 On tree page 3878 cell 44: Failed to read ptrmap key=5789 On tree page 3878 cell 44: invalid page number 5789 On tree page 3878 cell 45: Failed to read ptrmap key=5793 On tree page 3878 cell 45: invalid page number 5793 On tree page 3878 cell 46: Failed to read ptrmap key=5795 On tree page 3878 cell 46: invalid page number 5795 On tree page 3878 cell 47: Failed to read ptrmap key=5797 On tree page 3878 cell 47: invalid page number 5797 On tree page 3878 cell 48: Failed to read ptrmap key=5801 On tree page 3878 cell 48: invalid page number 5801 On tree page 3878 cell 49: Failed to read ptrmap key=5805 On tree page 3878 cell 49: invalid page number 5805 On tree page 3878 cell 50: Failed to read ptrmap key=5807 On tree page 3878 cell 50: invalid page number 5807 On tree page 3878 cell 51: Failed to read ptrmap key=5810 On tree page 3878 cell 51: invalid page number 5810 On tree page 3878 cell 52: Failed to read ptrmap key=5813 On tree page 3878 cell 52: invalid page number 5813 On tree page 3878 cell 53: Failed to read ptrmap key=5817 On tree page 3878 cell 53: invalid page number 5817 On tree page 3878 cell 54: Failed to read ptrmap key=5822 On tree page 3878 cell 54: invalid page number 5822 On tree page 3878 cell 55: Failed to read ptrmap key=5826 On tree page 3878 cell 55: invalid page number 5826 On tree page 3878 cell 56: Failed to read ptrmap key=5831 On tree page 3878 cell 56: invalid page number 5831 On tree page 3878 cell 57: Failed to read ptrmap key=5836 On tree page 3878 cell 57: invalid page number 5836 On tree page 3878 cell 58: Failed to read ptrmap key=5838 On tree page 3878 cell 58: invalid page number 5838 On tree page 3878 cell 59: Failed to read ptrmap key=5841 On tree page 3878 cell 59: invalid page number 5841 On tree page 3878 cell 60: Failed to read ptrmap key=5843 On tree page 3878 cell 60: invalid page number 5843 On tree page 3878 cell 61: Failed to read ptrmap key=5846 On tree page 3878 cell 61: invalid page number 5846 On tree page 3878 cell 62: Failed to read ptrmap key=5848 On tree page 3878 cell 62: invalid page number 5848 On tree page 3878 cell 63: Failed to read ptrmap key=5850 On tree page 3878 cell 63: invalid page number 5850 On tree page 3878 cell 64: Failed to read ptrmap key=5853 On tree page 3878 cell 64: invalid page number 5853 On tree page 3878 cell 65: Failed to read ptrmap key=5857 On tree page 3878 cell 65: invalid page number 5857 On tree page 3878 cell 66: Failed to read ptrmap key=5859 On tree page 3878 cell 66: invalid page number 5859 On tree page 3878 cell 67: Failed to read ptrmap key=5862 On tree page 3878 cell 67: invalid page number 5862 On tree page 3878 cell 68: Failed to read ptrmap key=5868 On tree page 3878 cell 68: invalid page number 5868 On tree page 3878 cell 69: Failed to read ptrmap key=5870 On tree page 3878 cell 69: invalid page number 5870 On tree page 3878 cell 70: Failed to read ptrmap key=5874 On tree page 3878 cell 70: invalid page number 5874 On tree page 3878 cell 71: Failed to read ptrmap key=5876 On tree page 3878 cell 71: invalid page number 5876 On tree page 3878 cell 72: Bad ptr map entry key=4495 expected=(5,3878) got=(2,0 ) On tree page 4495 cell 0: Bad ptr map entry key=4492 expected=(3,4495) got=(2,0) On tree page 3878 cell 72: Child page depth differs _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users