Plex upgrade failed and will not start, help me recover
Posted: 15 Apr 2023, 18:30
The recent PlexMediaServer-1.32.0.6918-6f393eda1-x86_64.tpk update file was applied as always, but since then attempting to start Plex results in it immediately reverting to a Stopped state. I have uninstalled and reinstalled Plex with no joy.
Please advise.
In the logs:
Apr 15, 2023 11:16:27.300 [0x7f3ff7aff1c0] DEBUG - Captured session 19.
Apr 15, 2023 11:16:27.300 [0x7f3ff7aff1c0] ERROR - SQLITE3:0x80000001, 1, table sqlite_master may not be modified in "UPDATE sqlite_schema SET sql = replace(sql, 'dt_integer(8)', 'datetime') WHERE name = 'media_provider_resources' AND type = 'table'"
Apr 15, 2023 11:16:27.300 [0x7f3ff7aff1c0] ERROR - Exception inside transaction (inside=1) (/data/jenkins/server/3534295259/Library/DatabaseMigrations.cpp:295): sqlite3_statement_backend::prepare: table sqlite_master may not be modified for SQL: UPDATE sqlite_schema SET sql = replace(sql, 'dt_integer(8)', 'datetime') WHERE name = 'media_provider_resources' AND type = 'table'
Apr 15, 2023 11:16:27.304 [0x7f3ff7aff1c0] ERROR - Exception thrown during migrations, aborting: sqlite3_statement_backend::prepare: table sqlite_master may not be modified for SQL: UPDATE sqlite_schema SET sql = replace(sql, 'dt_integer(8)', 'datetime') WHERE name = 'media_provider_resources' AND type = 'table'
Apr 15, 2023 11:16:27.304 [0x7f3ff7aff1c0] ERROR - SQLITE3:0x80000001, 1, no such table: synced_metadata_items in "select max(max(synced_metadata_items.changed_at),max(synced_metadata_items.first_packaged_at)) from synced_metadata_items"
Apr 15, 2023 11:16:27.305 [0x7f3ff7aff1c0] ERROR - Database corruption: sqlite3_statement_backend::prepare: no such table: synced_metadata_items for SQL: select max(max(synced_metadata_items.changed_at),max(synced_metadata_items.first_packaged_at)) from synced_metadata_items
Apr 15, 2023 11:16:27.305 [0x7f3ff7aff1c0] ERROR - Error: Unable to set up server: sqlite3_statement_backend::prepare: no such table: synced_metadata_items for SQL: select max(max(synced_metadata_items.changed_at),max(synced_metadata_items.first_packaged_at)) from synced_metadata_items (N4soci10soci_errorE)
Please advise.
In the logs:
Apr 15, 2023 11:16:27.300 [0x7f3ff7aff1c0] DEBUG - Captured session 19.
Apr 15, 2023 11:16:27.300 [0x7f3ff7aff1c0] ERROR - SQLITE3:0x80000001, 1, table sqlite_master may not be modified in "UPDATE sqlite_schema SET sql = replace(sql, 'dt_integer(8)', 'datetime') WHERE name = 'media_provider_resources' AND type = 'table'"
Apr 15, 2023 11:16:27.300 [0x7f3ff7aff1c0] ERROR - Exception inside transaction (inside=1) (/data/jenkins/server/3534295259/Library/DatabaseMigrations.cpp:295): sqlite3_statement_backend::prepare: table sqlite_master may not be modified for SQL: UPDATE sqlite_schema SET sql = replace(sql, 'dt_integer(8)', 'datetime') WHERE name = 'media_provider_resources' AND type = 'table'
Apr 15, 2023 11:16:27.304 [0x7f3ff7aff1c0] ERROR - Exception thrown during migrations, aborting: sqlite3_statement_backend::prepare: table sqlite_master may not be modified for SQL: UPDATE sqlite_schema SET sql = replace(sql, 'dt_integer(8)', 'datetime') WHERE name = 'media_provider_resources' AND type = 'table'
Apr 15, 2023 11:16:27.304 [0x7f3ff7aff1c0] ERROR - SQLITE3:0x80000001, 1, no such table: synced_metadata_items in "select max(max(synced_metadata_items.changed_at),max(synced_metadata_items.first_packaged_at)) from synced_metadata_items"
Apr 15, 2023 11:16:27.305 [0x7f3ff7aff1c0] ERROR - Database corruption: sqlite3_statement_backend::prepare: no such table: synced_metadata_items for SQL: select max(max(synced_metadata_items.changed_at),max(synced_metadata_items.first_packaged_at)) from synced_metadata_items
Apr 15, 2023 11:16:27.305 [0x7f3ff7aff1c0] ERROR - Error: Unable to set up server: sqlite3_statement_backend::prepare: no such table: synced_metadata_items for SQL: select max(max(synced_metadata_items.changed_at),max(synced_metadata_items.first_packaged_at)) from synced_metadata_items (N4soci10soci_errorE)