Have I broken my database?

Check your log files for SQLITE3 error messages. You need debug level logs. Verbose logs contain too much information and can cause the files to wrap, missing important info. See Reporting issues with Plex Media Server.

See this thread. It is for Plex on Synology, but the error messages will be the same.