Server Version#: Upgrading from 1.32.8.7639 to any 1.40 versions
Player Version#: using web
<If providing server logs please do NOT turn on verbose logging, only debug logging should be enabled>
I originally posted in this thread earlier this year and transparently, none of the solutions posted worked for me.
When I followed ChuckPA’s instructions this is what happened:
I then re-tried upgrading to a 1.4x version (in this case 1.41.0.8992). This gives me the following error where media server tries to upgrade, gets about 40% through, and then errors.
I then tried using ChuckPA’s DB repair tool and it wiped out my database entirely. My DB file was ~350MB and Blobs was ~640MB. After running ChuckPA’s DB repair tool, my DB file went to 0KB and my Blobs file went to 650 MB. This is what the DB repair tool says:
But given my DB file has been wiped clean through this process, Media Server doesn’t even try to build a database, it just goes straight to error with no progress bar:
For now, I am back down to the old 1.32 version but this is not sustainable. Is there anything I can do to upgrade? Thank you!
Update - I tried following the Plex Support instructions to completely rebuild since I guess the corruption was fairly extreme: Repair a Corrupted Database | Plex Support
Microsoft Windows [Version 10.0.19045.4894]
(c) Microsoft Corporation. All rights reserved.
C:\WINDOWS\system32>“C:\Program Files\Plex\Plex Media Server\Plex SQLite.exe” “%LOCALAPPDATA%\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db”
SQLite version 3.39.4 2022-09-29 15:55:41
Enter “.help” for usage hints.
sqlite> DELETE from external_metadata_items;
sqlite> .quit
C:\WINDOWS\system32>“C:\Program Files\Plex\Plex Media Server\Plex SQLite.exe” “%LOCALAPPDATA%\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db”
SQLite version 3.39.4 2022-09-29 15:55:41
Enter “.help” for usage hints.
sqlite> PRAGMA integrity_check;
row 33039 missing from index index_metadata_items_on_guid
database disk image is malformed
sqlite> vacuum;
sqlite> reindex;
Runtime error: database disk image is malformed (11)
sqlite> .output db-recover.sqlite
sqlite> .recover
sqlite> .quit
C:\WINDOWS\system32>“C:\Program Files\Plex\Plex Media Server\Plex SQLite.exe” “%LOCALAPPDATA%\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db”
SQLite version 3.39.4 2022-09-29 15:55:41
Enter “.help” for usage hints.
sqlite> .read db-recover.sqlite
sqlite>
sqlite>
And that has now worked with an upgrade to 1.41.0.8992. We can close this thread now - sorry for opening! But may be useful for someone else facing the same issues as me.
