PMS crashes whenever a user tries to view a list of content

[mikl0]

Ever since upgrading to version 1.13, PMS on my 2017 iMac (with macOS 10.13.6) has been unusable.

The server runs fine in the background (for days on end with no problem, scanning for new media and that kind of thing), and if I go directly to the preferences URLs, I can also see those pages. But as soon as I try to open “On Deck” or a library the server immediately crashes, no matter which client I’m connecting with (tried browser, PMP, Plex iPad).

The logs carry no record of the crash, even with verbose logging enabled. I’ve attached an example (without verbose, as instructed) here: Plex Media Server.log (76.5 KB)

Is there anything at all to get my PMS back in a workable state without having to blow away my existing database?

[OttoKerner]

The log file only covers 40 seconds. There is not much to see in there.
But before you blow away your database, I’d say it can’t hurt to try and repair it.

this procedure here
https://support.plex.tv/articles/201100678-repair-a-corrupt-database/

needs to be ‘augmented’ by 2 additional commands which need to be performed right at the beginning, as explained here:

"There was an unexpected error loading this library" when accessing all movies- server bug?

@maccrory said: Well - so much for restoring an older db version. So it appears that the corruption was already present in the backup as well. OR maybe: how much space is left on drive C:? If it runs out of free space, the DB can get damaged really quick. Instruct your anti-virus to leave the plex data folder alone. If you have enough space free on C, we may need to perform the proper repair procedure after all. There are 2 lines more now, compared with the instructions in the help artic…

[mikl0]

It’s the entirety of the log file. I started the server, and then tried to load “On Deck” in Plex Media Player, leading to the server crashing as usual.

I can get you a longer logfile if you wish.

[mikl0]

Ah, the database integrity check found a whole bunch of errors. Doing the dump and restore procedure have restored the server to working order.

In case its of any use, here are the errors:

[~/Library/Application Support/Plex Media Server/Plug-in Support/Databases] % sqlite3 com.plexapp.plugins.library.db "PRAGMA integrity_check"

row 976 missing from index index_statistics_media_on_timespan
row 976 missing from index index_statistics_media_on_device_id
row 976 missing from index index_statistics_media_on_account_id
wrong # of entries in index index_statistics_media_on_timespan
wrong # of entries in index index_statistics_media_on_device_id
wrong # of entries in index index_statistics_media_on_account_id
row 1483 missing from index index_statistics_bandwidth_on_timespan
row 1483 missing from index index_statistics_bandwidth_on_device_id
row 1483 missing from index index_statistics_bandwidth_on_account_id
row 1484 missing from index index_statistics_bandwidth_on_timespan
row 1484 missing from index index_statistics_bandwidth_on_device_id
row 1484 missing from index index_statistics_bandwidth_on_account_id
row 1485 missing from index index_statistics_bandwidth_on_timespan
row 1485 missing from index index_statistics_bandwidth_on_device_id
row 1485 missing from index index_statistics_bandwidth_on_account_id
row 1486 missing from index index_statistics_bandwidth_on_timespan
row 1486 missing from index index_statistics_bandwidth_on_device_id
row 1486 missing from index index_statistics_bandwidth_on_account_id
row 1487 missing from index index_statistics_bandwidth_on_timespan
row 1487 missing from index index_statistics_bandwidth_on_device_id
row 1487 missing from index index_statistics_bandwidth_on_account_id
row 1488 missing from index index_statistics_bandwidth_on_timespan
row 1488 missing from index index_statistics_bandwidth_on_device_id
row 1488 missing from index index_statistics_bandwidth_on_account_id
row 1489 missing from index index_statistics_bandwidth_on_timespan
row 1489 missing from index index_statistics_bandwidth_on_device_id
row 1489 missing from index index_statistics_bandwidth_on_account_id
row 1490 missing from index index_statistics_bandwidth_on_timespan
row 1490 missing from index index_statistics_bandwidth_on_device_id
row 1490 missing from index index_statistics_bandwidth_on_account_id
row 1491 missing from index index_statistics_bandwidth_on_timespan
row 1491 missing from index index_statistics_bandwidth_on_device_id
row 1491 missing from index index_statistics_bandwidth_on_account_id
row 1492 missing from index index_statistics_bandwidth_on_timespan
row 1492 missing from index index_statistics_bandwidth_on_device_id
row 1492 missing from index index_statistics_bandwidth_on_account_id
row 1493 missing from index index_statistics_bandwidth_on_timespan
row 1493 missing from index index_statistics_bandwidth_on_device_id
row 1493 missing from index index_statistics_bandwidth_on_account_id
row 1494 missing from index index_statistics_bandwidth_on_timespan
row 1494 missing from index index_statistics_bandwidth_on_device_id
row 1494 missing from index index_statistics_bandwidth_on_account_id
row 1495 missing from index index_statistics_bandwidth_on_timespan
row 1495 missing from index index_statistics_bandwidth_on_device_id
row 1495 missing from index index_statistics_bandwidth_on_account_id
row 1496 missing from index index_statistics_bandwidth_on_timespan
row 1496 missing from index index_statistics_bandwidth_on_device_id
row 1496 missing from index index_statistics_bandwidth_on_account_id
wrong # of entries in index index_statistics_bandwidth_on_timespan
wrong # of entries in index index_statistics_bandwidth_on_device_id
wrong # of entries in index index_statistics_bandwidth_on_account_id
row 182 missing from index index_metadata_item_settings_on_guid
row 183 missing from index index_metadata_item_settings_on_guid
row 184 missing from index index_metadata_item_settings_on_guid
row 185 missing from index index_metadata_item_settings_on_guid
row 186 missing from index index_metadata_item_settings_on_guid
row 187 missing from index index_metadata_item_settings_on_guid
row 188 missing from index index_metadata_item_settings_on_guid
row 189 missing from index index_metadata_item_settings_on_guid
row 191 missing from index index_metadata_item_settings_on_guid
row 889 missing from index index_metadata_item_settings_on_guid
row 941 missing from index index_metadata_item_settings_on_guid
row 1233 missing from index index_metadata_item_settings_on_guid
row 1234 missing from index index_metadata_item_settings_on_guid
row 1235 missing from index index_metadata_item_settings_on_guid
row 1278 missing from index index_metadata_item_settings_on_guid
row 1279 missing from index index_metadata_item_settings_on_guid
row 1280 missing from index index_metadata_item_settings_on_guid
row 1344 missing from index index_metadata_item_settings_on_guid
row 1345 missing from index index_metadata_item_settings_on_guid
row 1346 missing from index index_metadata_item_settings_on_guid
row 1356 missing from index index_metadata_item_settings_on_guid
row 1531 missing from index index_metadata_item_settings_on_guid
wrong # of entries in index index_metadata_item_settings_on_guid

[OttoKerner]

Glad the repair worked!
Happy plexing!