On 10 Jul 2018, at 21:17, Dan Kennedy wrote:
>>
>
> Try running the FTS5 integrity-check command with the 3.24.0 command line to
> ensure it really is corrupt:
>
> https://www.sqlite.org/fts5.html#the_integrity_check_command
>
> The index can be rebuilt using the rebuild command:
>
> https://www.sqlite.org/fts5.html#the_rebuild_command
>
> 3.13.0 was about 2 years ago. There have been a couple of fixes for fts5
> corruption bugs since then. This one, for example:
>
> https://www.sqlite.org/src/info/9a2de4f05fabf7e7
>
> So you may have hit a known issue. Hard to say.
>
> Dan.
>
Thanks Dan.
Reading the webpage it says it doesn't work for contentless FTS5 but ran the
commands anyway
sqlite> INSERT INTO [i_epg]([i_epg]) VALUES('integrity-check');
Error: database disk image is malformed
sqlite> INSERT INTO [i_epg]([i_epg]) VALUES('rebuild');
sqlite> INSERT INTO [i_epg]([i_epg]) VALUES('integrity-check');
sqlite>
Running previous commands also seem to show its been fixed
sqlite> SELECT * FROM [i_epg] WHERE [i_epg] MATCH '{ mangled_title } : big +
ban';
sqlite> SELECT * FROM [i_epg] WHERE [i_epg] MATCH '{ mangled_title } : big +
ban*';
<deleted lots of output>
sqlite> SELECT [mangled_title] FROM [i_epg] WHERE [i_epg] MATCH '{
mangled_title } : black + adder';
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
sqlite>
Thanks again Dan.
Regards
Nick
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
