I really try to do my own troubleshooting before dipping into the forum. I’ve had lots of issues over the years, but this is the first I’ve not been able to figure out. I actually didn’t notice it right away, because it developed as slow reactions on AppleTV - but no error messages.
If anyone comes across this issue… I tried a million different things to try to fix, including a manual database rebuild. Eventually I gave up and ended up starting a whole new library directory, then using some sql to move watched statuses and intro markers.
I followed this guide for watch statuses:
and used this tool for intro markers:
The server now runs SMOOTH as SILK. Faster than ever. Sorry I don’t have an easy fix for you - but I could have saved a lot of time troubleshooting by just blowing it up and starting fresh.