First time running this updated script and it found bad fts indexes in my db …
2026-01-28 22.52.04 - Auto - FTS Check: fts4_metadata_titles - FAIL (Error: stepping, database disk image is malformed (11))
2026-01-28 22.52.05 - Auto - FTS Check: fts4_metadata_titles_icu - FAIL (Error: stepping, database disk image is malformed (11))
2026-01-28 22.52.05 - Auto - FTS Check: fts4_tag_titles - FAIL (Error: stepping, database disk image is malformed (11))
2026-01-28 22.52.07 - Auto - FTS Check: fts4_tag_titles_icu - FAIL (Error: stepping, database disk image is malformed (11))
2026-01-28 22.52.07 - Auto - FTS Check (blobs): fts4_metadata_titles - PASS
2026-01-28 22.52.07 - Auto - FTS Check (blobs): fts4_metadata_titles_icu - PASS
2026-01-28 22.52.07 - Auto - FTS Check (blobs): fts4_tag_titles - PASS
2026-01-28 22.52.07 - Auto - FTS Check (blobs): fts4_tag_titles_icu - PASS
2026-01-28 22.52.07 - Auto - FTS Check - FAIL
2026-01-28 22.52.07 - Auto - FTS damaged, attempting rebuild
2026-01-28 22.52.07 - FTSRbld - MakeBackup com.plexapp.plugins.library.db - PASS
2026-01-28 22.52.07 - FTSRbld - MakeBackup com.plexapp.plugins.library.blobs.db - PASS
2026-01-28 22.52.07 - FTSRbld - MakeBackup - PASS
2026-01-28 22.52.07 - FTSRbld - Rebuild: fts4_metadata_titles - PASS
2026-01-28 22.52.09 - FTSRbld - Rebuild: fts4_metadata_titles_icu - PASS
2026-01-28 22.52.13 - FTSRbld - Rebuild: fts4_tag_titles - PASS
2026-01-28 22.52.19 - FTSRbld - Rebuild: fts4_tag_titles_icu - PASS
2026-01-28 22.52.19 - FTSRbld - Rebuild (blobs): fts4_metadata_titles - PASS
2026-01-28 22.52.19 - FTSRbld - Rebuild (blobs): fts4_metadata_titles_icu - PASS
2026-01-28 22.52.19 - FTSRbld - Rebuild (blobs): fts4_tag_titles - PASS
2026-01-28 22.52.19 - FTSRbld - Rebuild (blobs): fts4_tag_titles_icu - PASS
2026-01-28 22.52.19 - FTSRbld - PASS
2026-01-28 22.52.19 - Auto - FTS Rebuild - PASS
… never noticed any search problem really, outside of it being a little slow. I wonder if it might be worth putting this index rebuild/repair in some future pms build so everyone’s indexes can be checked.
