Plex Server Mac Failing after update 1.27.2.5929

Plex Media Server
1

Server Version#: 1.27.2.5929
Player Version#: 4.76.1 (Plex web build in - but also fails on Apple TV)
I upgraded about a week ago and the server just would not work anymore. I am just getting “Something went wrong. An unexpected error occurred” See Screenshot.

Screenshot 2022-07-06 at 12.35.42
Screenshot 2022-07-06 at 12.35.421377×692 24.9 KB

I tried all the usual, uninstall, manual reinstall etc to no avail.
I then turned on debug logging, re-created the problem again and downloaded the logs.
After that I grep’ed through them (darn there are many logs!!!) for anything containing WARNING, ERROR or CRITICAL. What I found where these lines:

com.plexapp.system.log:2022-07-06 11:51:14,348 (11691fdc0) : DEBUG (core:450) - Starting localization component.
com.plexapp.system.log:2022-07-06 11:51:14,349 (11691fdc0) : INFO (localization:409) - Setting the default locale to en-us
com.plexapp.system.log:2022-07-06 11:51:14,349 (11691fdc0) : WARNING (data:179) - Error decoding with simplejson, using demjson instead (this will cause a performance hit) - Expecting property name enclosed in double quotes: line 26 column 1 (char 1078)
com.plexapp.system.log:2022-07-06 11:51:14,352 (11691fdc0) : DEBUG (localization:427) - Loaded en strings

Which is only a WARNING.
Later on this:

com.plexapp.system.log:2022-07-06 11:51:18,298 (70000f8ae000) : ERROR (networking:196) - Error opening URL ‘http://resources-cdn.plexapp.com/hashes.json’
com.plexapp.system.log:2022-07-06 11:51:18,300 (70000f8ae000) : CRITICAL (runtime:1299) - Exception getting hosted resource hashes (most recent call last):

Then later this repeats for each agent but using a local url:
com.plexapp.agents.plexthememusic.log:2022-07-06 11:51:31,274 (112424dc0) : ERROR (networking:196) - Error opening URL ‘http://127.0.0.1:32400/:/plugins/com.plexapp.system/resourceHashes’
com.plexapp.agents.plexthememusic.log:2022-07-06 11:51:31,275 (112424dc0) : CRITICAL (runtime:1299) - Exception getting hosted resource hashes (most recent call last):

OK, if anyone can shed light on this? If you need full logs they are attached here
Plex Media Server Logs_2022-07-06_12-19-19.zip (1.0 MB)

Thank you!

2

sqlite3_statement_backend::loadOne: database disk image is malformed see Repair a Corrupted Database | Plex Support

3

Thanks for your input. It worked!
This is what I did exactly:

% cd ~/Library/Application Support/Plex Media Server/Plug-in Support/Databases
% cp com.plexapp.plugins.library.db com.plexapp.plugins.library.db.original
% "/Applications/Plex Media Server.app/Contents/MacOS/Plex SQLite"  \
com.plexapp.plugins.library.db

Got the sqlite prompt:

SQLite version 3.35.5 2021-04-19 18:32:05
Enter ".help" for usage hints.
sqlite> PRAGMA integrity_check;
row 90 missing from index index_metadata_item_settings_on_guid
row 698 missing from index index_metadata_item_settings_on_last_viewed_at
row 699 missing from index index_metadata_item_settings_on_last_viewed_at
row 700 missing from index index_metadata_item_settings_on_last_viewed_at
row 701 missing from index index_metadata_item_settings_on_last_viewed_at
wrong # of entries in index index_metadata_item_settings_on_last_viewed_at
wrong # of entries in index index_metadata_item_settings_on_guid
sqlite> REINDEX;
sqlite> PRAGMA integrity_check;
ok
sqlite> VACUUM;
sqlite> .quit

Restarted the Plex Server.
All back as it should be!
Thank you!