Looks like I have some type of db corruption…no idea why or how it happened to me.
Here are the logs from my synology:
^^Sorry this is an image…Synology apparently doesn’t let you copy log files for packages…^^
Any help gladly accepted. Really want to get this back up ASAP…
thanks!
Followed this guide: https://support.plex.tv/hc/en-us/articles/201100678-Repair-a-Corrupt-Database
Here are the steps I took:
root@Synology:/volume1/Plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases# which sqlite3
/bin/sqlite3
root@Synology:/volume1/Plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases# sqlite3 com.plexapp.plugins.library.db “PRAGMA integrity_check”
*** in database main ***
On tree page 229 cell 3: 2nd reference to page 69425
row 483 missing from index index_metadata_items_on_title
row 484 missing from index index_metadata_items_on_title
row 485 missing from index index_metadata_items_on_title
row 486 missing from index index_metadata_items_on_title
row 487 missing from index index_metadata_items_on_title
row 2289 missing from index index_metadata_items_on_title
row 2290 missing from index index_metadata_items_on_title
row 2291 missing from index index_metadata_items_on_title
row 2292 missing from index index_metadata_items_on_title
row 2293 missing from index index_metadata_items_on_title
row 2294 missing from index index_metadata_items_on_title
row 6219 missing from index index_metadata_items_on_title
row 6775 missing from index index_metadata_items_on_title
row 6901 missing from index index_metadata_items_on_title
row 7466 missing from index index_metadata_items_on_title
row 7723 missing from index index_metadata_items_on_title
row 7780 missing from index index_metadata_items_on_title
row 8097 missing from index index_metadata_items_on_title
row 8608 missing from index index_metadata_items_on_title
row 9401 missing from index index_metadata_items_on_title
row 9793 missing from index index_metadata_items_on_title
row 9827 missing from index index_metadata_items_on_title
row 11474 missing from index index_metadata_items_on_title
row 12306 missing from index index_metadata_items_on_title
row 12700 missing from index index_metadata_items_on_title
row 14988 missing from index index_metadata_items_on_originally_available_at
row 14988 missing from index index_metadata_items_on_hash
row 14988 missing from index index_metadata_items_on_guid
row 14988 missing from index index_metadata_items_on_title_sort
row 14988 missing from index index_metadata_items_on_title
Error: database disk image is malformed
root@Synology:/volume1/Plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases# sqlite3 com.plexapp.plugins.library.db .dump > dump.sql
root@Synology:/volume1/Plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases# mv com.plexapp.plugins.library.db com.plexapp.plugins.library.db.original
root@Synology:/volume1/Plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases# sqlite3 com.plexapp.plugins.library.db < dump.sql
then I moved
to a backup location. After that I rebooted and bam. Plex took a sec to set up but seems fine now.
