I run Plex on a MacMini with Big Sur
Version 1.21.1.3842
I recently successfully moved the metadata folder to an external HDD
I also regularly (even prior to that metadata folder move) get a message on my ipad/iphone that my database is corrupt, but I did not notice any issue running the server and watching content.
However, my Plex server seems lately to crash without announcing, I notice it only when I want to access a media and I see it is no longer running.
Then I restart it manually without any issue.
So I am trying to assert whether the database corruption is the source of that “silent” crash
I tried to apply the steps indicated in
Not sure if it was successful:
sondophan@Sons-Mac-mini-Crozet Databases % cd /Volumes/Music_Maxtor_USB_4TB/Plex\ Media\ Server/Plug-in\ Support/Databases
sondophan@Sons-Mac-mini-Crozet Databases % cp com.plexapp.plugins.library.db com.plexapp.plugins.library.db.original
sondophan@Sons-Mac-mini-Crozet Databases % sqlite3 com.plexapp.plugins.library.db “DROP index ‘index_title_sort_naturalsort’”
sondophan@Sons-Mac-mini-Crozet Databases % sqlite3 com.plexapp.plugins.library.db “DELETE from schema_migrations where version=‘20180501000000’”
sondophan@Sons-Mac-mini-Crozet Databases % sqlite3 com.plexapp.plugins.library.db “PRAGMA integrity_check”
wrong # of entries in index index_metadata_items_on_changed_at
wrong # of entries in index index_metadata_items_on_originally_available_at
sondophan@Sons-Mac-mini-Crozet Databases % cp com.plexapp.plugins.library.db com.plexapp.plugins.library.db.original
sondophan@Sons-Mac-mini-Crozet Databases % sqlite3 com.plexapp.plugins.library.db “DROP index ‘index_title_sort_naturalsort’”
Error: no such index: index_title_sort_naturalsort
sondophan@Sons-Mac-mini-Crozet Databases % sqlite3 com.plexapp.plugins.library.db “DROP index ‘index_title_sort_naturalsort’”
Error: no such index: index_title_sort_naturalsort
sondophan@Sons-Mac-mini-Crozet Databases % sqlite3 com.plexapp.plugins.library.db “DELETE from schema_migrations where version=‘20180501000000’”
sondophan@Sons-Mac-mini-Crozet Databases % sqlite3 com.plexapp.plugins.library.db .dump > dump.sql
sondophan@Sons-Mac-mini-Crozet Databases %
Can someone please tell me if the problem is fixed and what next steps to take to solve the silent crash/db corruption messages?
I downloaded the server log in case someone can detect the crash cause
(File removed)
Downloading the database yields a strange result (empty file), is it because the symlink?
If you tell me which folder to zip I can do it manually
(File removed)
Thank you
