I have no further ideas, except to:
- perform the database repair procedure https://support.plex.tv/articles/201100678-repair-a-corrupt-database/
- reset all agent preferences “the thorough way” [HowTo] Reset metadata agent preferences to defaults and whack caches