Upgrade to 1.40.0.7998 causes error

Plex Media Server
28

@L_D

I have answers from Engineering about your database problem.

  1. The problem can originate if any of the shared servers (another server with this server)

  2. At some point, the “other” server is nuked and a fresh DB is created without first removing it. (now there is an orphaned entry in the DB).

  3. After the other server is rebuilt, it is also added to the DB. Now there’s duplication.

  4. PMS 1.40 attempts to upgrade – BOOM.

Engineering will address this but has given instructions for now.

  1. Stop PMS
  2. Using SQLITE3 for com.plexapp.plugins.library.db (`Plex SQLite)
  3. DELETE from external_metadata_items;
  4. Exit SQLITE3
  5. Start PMS

The table will repopulate itself through normal refresh/operation.
They will be tweaking the DB to ensure the database doesn’t have a duplicate again.

3 Likes