Video Libraries Unreachable

Plex Media Server NAS & Devices
1

Server Version#: 1.18.2.2058Plex Media Server Logs_2019-11-25_18-46-03.zip (1.8 MB)

Running a DS918 and any video library is offline from any player including the web interface. Rebooted multiple times but no luck. Verified permissions on both the Plex and media folders. My music library is working fine. Nothing has changed in the network config. Logs are attached, any help is appreciated. Thanks.

2

The database has become corrupted somehow.

  1. Stop Plex
  2. GIve your username access to the Plex share in Control Panel - Shared Folders - Plex share. You need R/W access
  3. Open File Station
  4. Drill into Plex / Library / Application Support / Plex Media Server / Plug-in Support / Databases
  5. Rename com.plexapp.plugins.library.db and add a -damaged to the end
  6. Using your most recent backup copy, Copy & Paste it to form a duplicate
  7. Now rename that file to be com.plexapp.plugins.library.db
  8. Right click it and verify it is owned by user plex
  9. Restart PMS
  10. Scan files to make sure it updates and resync’s with any changes you’ve made recently in the media
  11. Recheck preferences if you’ve made any recently.
Nov 25, 2019 18:38:54.868 [0x7f3541f76700] DEBUG - Starting plug-in /volume1/@appstore/Plex Media Server/Resources/Plug-ins-e67a4e892/Musicbrainz.bundle.
Nov 25, 2019 18:38:54.869 [0x7f3541f76700] DEBUG - Perfect cache hit, we don't need to start [org.musicbrainz.agents.music] yet.
Nov 25, 2019 18:38:54.902 [0x7f35416ac700] ERROR - SQLITE3:(nil), 11, database corruption at line 64817 of [bf8c1b2b7a]
Nov 25, 2019 18:38:54.902 [0x7f35416ac700] ERROR - SQLITE3:(nil), 11, statement aborts at 5: [select media_items.id from metadata_items join media_items on media_items.metadata_item_id=metadata_items.id where metadata_items.library_section_id=? and  metadata_items.id not in (sel
Nov 25, 2019 18:38:54.902 [0x7f35416ac700] ERROR - Exception inside transaction (inside=1) (../Library/DatabaseFixups.cpp:185): sqlite3_statement_backend::loadRS: database disk image is malformed
Nov 25, 2019 18:38:54.902 [0x7f35416ac700] ERROR - Fixup 42DatabaseFixupsGarbageCollectTransientItems threw an exception: sqlite3_statement_backend::loadRS: database disk image is malformed
Nov 25, 2019 18:38:54.903 [0x7f3542c5e700] DEBUG - Starting scheduled updates, every 3600 seconds
Nov 25, 2019 18:38:54.903 [0x7f3542c5e700] INFO - Refreshing paths watched by LibraryUpdateManager
Nov 25, 2019 18:38:54.904 [0x7f3542c5e700] DEBUG - LibraryUpdateManager will start watching /volume1/video/Movi

If the most recent does not correct the problem, repeat the sequence with the next most recent backup.

3

Looks like that did it. Don’t know how the db got corrupted but that fixed it. Thanks for the quick response!

4

Hi… I may have this same, frustrating problem. I do not understand what backup is referenced here. A clarification would be apppreciated.

5

Whit,

If you’re also using a Synology, Follow along with the above procedure.
If you’re using something else, Lookup where your Plex databases are below then use the same technique:
https://support.plex.tv/articles/202915258-where-is-the-plex-media-server-data-directory-located/

However, before taking such action, it is strongly advised to confirm there is database corruption indicated in the log files.

6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.