On 4/6/62 12:11, bhandari_nikhil wrote:
Thanks Dan. I had checked the database integrity using the following command:
sqlite3 myfile.db "PRAGMA integrity_check;"
Try "INSERT INTO ft(ft) VALUES('integrity-check')", where "ft" is the
name of the fts5 table.
And it had reported ok. I will see if I can share the database file here.
Can you let me know how to check the db file (in case I am not able to share
the db file here) ? And how the fts5 can get corrupted ?
The easiest explanation is that the fts5 tables were modified directly,
bypassing fts5. Or there could be a bug in fts5 - a bug that may or may not
still be present; there have been fixes since 3.14. A memory related bug in the
application could also cause this.
To run the rebuild command, the ft refers to the db name ?
The fts5 table name.
Dan.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
