thanks.
I found it, unfortunately.
Sep 08, 2023 09:17:56.518 [23183531424568] DEBUG - Looking for path match for [/data/media/tv/America's Got Talent (2006) [imdb-tt0759364]/Season 18/America's Got Talent (2006) - S18E16 - Qualifiers 3 [WEBDL-1080p][AAC 2.0][x264]-EDITH.mkv]
Sep 08, 2023 09:17:56.518 [23183562681144] DEBUG - [LibraryTimeline] Scanner activity on section 2: 292 added, 3 deleted
Sep 08, 2023 09:17:56.518 [23183531424568] DEBUG - Skipping hash check, no size match for 2138683320 bytes.
Sep 08, 2023 09:17:56.518 [23183531424568] DEBUG - No match for hash.
Sep 08, 2023 09:17:56.519 [23183531424568] DEBUG - Found existing show 348169
Sep 08, 2023 09:17:56.520 [23183531424568] DEBUG - Added new metadata item (Qualifiers 3) with ID 435357
Sep 08, 2023 09:17:56.520 [23183531424568] ERROR - SQLITE3:0x80000001, 11, database corruption at line 72267 of [a29f994989]
Sep 08, 2023 09:17:56.520 [23183531424568] ERROR - SQLITE3:0x80000001, 11, statement aborts at 10: [SELECT (SELECT max(idx) FROM 'main'.'fts4_metadata_titles_icu_segdir' WHERE level = ?) + 1] database disk image is malformed
Sep 08, 2023 09:17:56.520 [23183531424568] ERROR - SQLITE3:0x80000001, 11, statement aborts at 178: [update metadata_items set updated_at=null,guid=?,hash=? where id=?] database disk image is malformed
Sep 08, 2023 09:17:56.520 [23183531424568] ERROR - Exception inside transaction (inside=1) (/data/jenkins/server/3532787937/Library/MetadataItem.cpp:4012): sqlite3_statement_backend::loadOne: database disk image is malformed
Sep 08, 2023 09:17:56.520 [23183531424568] ERROR - Exception assimilating media item in America's Got Talent (2006) [imdb-tt0759364]/Season 18: sqlite3_statement_backend::loadOne: database disk image is malformed
Sep 08, 2023 09:17:56.520 [23183562681144] DEBUG - [LibraryTimeline] Scanner activity on section 2: 293 added, 3 deleted
Sep 08, 2023 09:17:56.770 [23183531424568] DEBUG - Native Scanner: Executed Add to Database stage in 0.28 sec.
Sep 08, 2023 09:17:56.770 [23183531424568] DEBUG - Native Scanner: Executed Media Analysis stage in 0.00 sec.
Sep 08, 2023 09:17:56.770 [23183550409528] DEBUG - Scanner [Plex TV Series]: Idle and left with 9069 media items.
Sep 08, 2023 09:17:56.771 [23183550409528] DEBUG - Removing 152 media items that were left.
Sep 08, 2023 09:17:56.771 [23183550409528] DEBUG - Deleting media item 314618.
You can use my tool to help restore a recent backup to use as current.
It checks each of your available backups then presents you with the option of to use them for the restore.
The first you say “Yes” to is what it will use.
When restored, you can then scan files, refresh metadata and get the DB caught back up
If all the backups are damaged, you can try to repair but there are no guarantees.