Upgrade to 1.40.0.7998 causes error

Plex Media Server
1

Server Version#: Upgrade to 1.40.0.7998

Player Version#: Multiple versions - tried to access on iPhone, web, and through both the app.plex.tv portal and the ip address on the host device itself.

When I log on after the upgrade, I see this error message:

image
image865Ɨ578 11 KB

When I downgraded to PlexMediaServer-1.32.8.7639-fb6452ebf-x86_64, the server started working again and I could access my Library fine - see the messages here:
Plex Media Server.1.log (739.2 KB)

I then tried re-upgrading to PlexMediaServer-1.40.0.7998-c29d4c0c8-x86_64 . The server broke again (same error message) and I saw a lot of database error messages that didnā€™t exist for v1.32:
Plex Media Server.log (1.3 MB)

I then tried to fix my database following this guide: Repair a Corrupted Database | Plex Support

And the command PRAGMA integrity check showed no errors (it returned message ā€œokā€). I ran all the commands and nothing was wrong, so I am unsure why my database is causing errors upon upgrade, and only upon upgrade. And why does it then work on v1.32?

Could someone please point me in the right direction? For now I have downgraded to v1.32 but this is obviously not sustainable long-term.

Thank you!

2 Likes
2

Iā€™m having the same issue.

Here is my log
Plex Media Server Logs_2024-02-18_03-46-43.zip (2.2 MB)

Screenshot 2024-02-18 at 3.49.41 AM
Screenshot 2024-02-18 at 3.49.41 AM872Ɨ574 4.36 KB

3

Is this the first 1.40.x.xxxx version youā€™re upgrading to and how long are you waiting after upgrading to the new server version? If you have substantial .db files it can take quite a while for the first db conversion during which time youā€™ll see an error message.

4

Hello! It is the first 1.40 update for me, but it is not my first update where there has been a database conversion - Iā€™ve been running Plex Pass for over 4 years now and there have been multiple database changes in that period.

The new update was running for over 72 hours before I found the spare time to actually try and fix why my Plex server was not working - I find it unlikely that a database conversion would take 72 hours.

Thanks for your response!

5

Per your logs, a migration seems to have failed midway:

Feb 17, 2024 10:04:05.888 [10736] INFO - Running forward migration 202309200919.
Feb 17, 2024 10:04:05.949 [10736] ERROR - SQLITE3:0x7ff781175760, 11, database corruption at line 91363 of [a29f994989]
Feb 17, 2024 10:04:05.949 [10736] ERROR - SQLITE3:0x7ff781175760, 11, statement aborts at 3: [SELECT id, extra_data FROM tags WHERE extra_data IS NOT NULL] database disk image is malformed
Feb 17, 2024 10:04:05.949 [10736] ERROR - Exception inside transaction (inside=1) (D:\gha\plex-media-server\plex-media-server\Library\DatabaseMigrations.cpp:292): sqlite3_statement_backend::loadRS: database disk image is malformed
Feb 17, 2024 10:04:05.950 [10736] ERROR - Exception thrown during migrations, aborting: sqlite3_statement_backend::loadRS: database disk image is malformed
Feb 17, 2024 10:04:06.049 [10736] DEBUG - ChangestampAllocator: initialized to 4798094
Feb 17, 2024 10:04:06.050 [10736] DEBUG - Opening 2 database sessions to library (com.plexapp.plugins.library.blobs), SQLite 3.39.4, threadsafe=1

You should restore a pre-1.40 DB backup and try the upgrade again.

6

Are my logs saying the same thing? Which log do I check for the error? Iā€™ve been letting the server sit for nearly 24 hours now.

Plex Media Server Logs_2024-02-18_03-46-43.zip (2.2 MB)

7

Yours seems to be a different error:

From the Plex Media Server.4.log file:

Feb 17, 2024 18:30:32.965 [9508] INFO - Running forward migration 202309200901.
... Unrelated lines ...
Feb 17, 2024 18:30:34.340 [9292] DEBUG - Opening 1 database sessions to library (), SQLite 3.39.4, threadsafe=1
Feb 17, 2024 18:30:34.341 [9292] DEBUG - Completed: [10.27.27.25:64977] 503 GET /media/providers (3 live) #3 TLS GZIP 11ms 559 bytes (pipelined: 1)
Feb 17, 2024 18:30:34.646 [9360] WARN - Crash: Crash reporting disabled
Feb 17, 2024 18:30:35.764 [9508] ERROR - Exception inside transaction (inside=1) (D:\gha\plex-media-server\plex-media-server\Library\DatabaseMigrations.cpp:292): Null value not allowed for this type
Feb 17, 2024 18:30:35.766 [9508] ERROR - Exception thrown during migrations, aborting: Null value not allowed for this type
Feb 17, 2024 18:30:37.472 [9508] DEBUG - ChangestampAllocator: initialized to 83852736

Ping @ChuckPa

8

Additional DB Error details.

Plex Media Server.1.log

Feb 17, 2024 20:41:47.842 [9692] DEBUG - [DatabaseFixups] Running fix-ups.
Feb 17, 2024 20:41:47.870 [9692] DEBUG - [DatabaseFixups] Deleting media item 963256.
Feb 17, 2024 20:41:47.871 [9692] DEBUG - [DatabaseFixups] Was connected to metadata item 679793, count is now 0.
Feb 17, 2024 20:41:47.871 [9692] ERROR - [DatabaseFixups] SQLITE3:0x6ae34276, 1, no such column: metadata_items.slug in "select metadata_items.id as 'metadata_items_id', metadata_items.library_section_id as 'metadata_items_library_section_id', metadata_items.parent_id as 'metadata_items_parent_id', metadata_items.metadata_type as 'metadata_items_metadata_type', metadata_items.guid as 'metadata_items_guid', metadata_items.slug as 'metadata_items_slug', metadata_items.hash as 'metadata_items_hash', metadata_items.media_item_count as 'metadata_items_media_item_count', metadata_items.title as 'metadata_items_title', metadata_items.title_sort as 'metadata_items_title_sort', metadata_items.original_title as 'metadata_items_original_title', metadata_items.studio as 'metadata_items_studio', metadata_items.rating as 'metadata_items_rating', meta
Feb 17, 2024 20:41:47.871 [9692] ERROR - [DatabaseFixups] Exception inside transaction (inside=1) (D:\gha\plex-media-server\plex-media-server\Library\MediaItem.cpp:907): sqlite3_statement_backend::prepare: no such column: metadata_items.slug for SQL: select metadata_items.id as 'metadata_items_id', metadata_items.library_section_id as 'metadata_items_library_section_id', metadata_items.parent_id as 'metadata_items_parent_id', metadata_items.metadata_type as 'metadata_items_metadata_type', metadata_items.guid as 'metadata_items_guid', metadata_items.slug as 'metadata_items_slug', metadata_items.hash as 'metadata_items_hash', metadata_items.media_item_count as 'metadata_items_media_item_count', metadata_items.title as 'metadata_items_title', metadata_items.title_sort as 'metadata_items_title_sort', metadata_items.original_title as 'metadata_items_original_title', metadata_items.studio as 'metadata_items_studio', metadata_items.rating as 'metadata_items_rating', metadata_items.audience_rating as 'metadata_items_audience_rating', metadata_items.rating_count as 'metadata_items_rating_count', metadata_items.tagline as 'metadata_items_tagline', metadata_items.edition_title as 'metadata_items_edition_title', metadata_items.summary as 'metadata_items_summary', metadata_items.content_rating as 'metadata_items_content_rating', metadata_items.content_rating_age as 'metadata_items_content_rating_age', metadata_items.'index' as 'metadata_items_index', metadata_items.absolute_index as 'metadata_items_absolute_index', metadata_items.duration as 'metadata_items_duration', metadata_items.user_thumb_url as 'metadata_items_user_thumb_url', metadata_items.user_art_url as 'metadata_items_user_art_url', metadata_items.user_banner_url as 'metadata_items_user_banner_url', metadata_items.user_music_url as 'metadata_items_user_music_url', metadata_items.user_fields as 'metadata_items_user_fields', metadata_items.originally_available_at as 'metadata_items_originally_available_at', metadata_items.available_at as 'metadata_items_available_at', metadata_items.expires_at as 'metadata_items_expires_at', metadata_items.refreshed_at as 'metadata_items_refreshed_at', metadata_items.year as 'metadata_items_year', metadata_items.added_at as 'metadata_items_added_at', metadata_items.created_at as 'metadata_items_created_at', metadata_items.updated_at as 'metadata_items_updated_at', metadata_items.changed_at as 'metadata_items_changed_at', metadata_items.resources_changed_at as 'metadata_items_resources_changed_at', metadata_items.tags_genre as 'metadata_items_tags_genre', metadata_items.tags_collection as 'metadata_items_tags_collection', metadata_items.tags_director as 'metadata_items_tags_director', metadata_items.tags_writer as 'metadata_items_tags_writer', metadata_items.tags_star as 'metadata_items_tags_star', metadata_items.deleted_at as 'metadata_items_deleted_at', metadata_items.tags_country as 'metadata_items_tags_country', metadata_items.extra_data as 'metadata_items_extra_data' from metadata_items where id=:id
Feb 17, 2024 20:41:47.871 [9692] ERROR - [DatabaseFixups] Exception inside transaction (inside=1) (D:\gha\plex-media-server\plex-media-server\Library\DatabaseFixups.cpp:200): sqlite3_statement_backend::prepare: no such column: metadata_items.slug for SQL: select metadata_items.id as 'metadata_items_id', metadata_items.library_section_id as 'metadata_items_library_section_id', metadata_items.parent_id as 'metadata_items_parent_id', metadata_items.metadata_type as 'metadata_items_metadata_type', metadata_items.guid as 'metadata_items_guid', metadata_items.slug as 'metadata_items_slug', metadata_items.hash as 'metadata_items_hash', metadata_items.media_item_count as 'metadata_items_media_item_count', metadata_items.title as 'metadata_items_title', metadata_items.title_sort as 'metadata_items_title_sort', metadata_items.original_title as 'metadata_items_original_title', metadata_items.studio as 'metadata_items_studio', metadata_items.rating as 'metadata_items_rating', metadata_items.audience_rating as 'metadata_items_audience_rating', metadata_items.rating_count as 'metadata_items_rating_count', metadata_items.tagline as 'metadata_items_tagline', metadata_items.edition_title as 'metadata_items_edition_title', metadata_items.summary as 'metadata_items_summary', metadata_items.content_rating as 'metadata_items_content_rating', metadata_items.content_rating_age as 'metadata_items_content_rating_age', metadata_items.'index' as 'metadata_items_index', metadata_items.absolute_index as 'metadata_items_absolute_index', metadata_items.duration as 'metadata_items_duration', metadata_items.user_thumb_url as 'metadata_items_user_thumb_url', metadata_items.user_art_url as 'metadata_items_user_art_url', metadata_items.user_banner_url as 'metadata_items_user_banner_url', metadata_items.user_music_url as 'metadata_items_user_music_url', metadata_items.user_fields as 'metadata_items_user_fields', metadata_items.originally_available_at as 'metadata_items_originally_available_at', metadata_items.available_at as 'metadata_items_available_at', metadata_items.expires_at as 'metadata_items_expires_at', metadata_items.refreshed_at as 'metadata_items_refreshed_at', metadata_items.year as 'metadata_items_year', metadata_items.added_at as 'metadata_items_added_at', metadata_items.created_at as 'metadata_items_created_at', metadata_items.updated_at as 'metadata_items_updated_at', metadata_items.changed_at as 'metadata_items_changed_at', metadata_items.resources_changed_at as 'metadata_items_resources_changed_at', metadata_items.tags_genre as 'metadata_items_tags_genre', metadata_items.tags_collection as 'metadata_items_tags_collection', metadata_items.tags_director as 'metadata_items_tags_director', metadata_items.tags_writer as 'metadata_items_tags_writer', metadata_items.tags_star as 'metadata_items_tags_star', metadata_items.deleted_at as 'metadata_items_deleted_at', metadata_items.tags_country as 'metadata_items_tags_country', metadata_items.extra_data as 'metadata_items_extra_data' from metadata_items where id=:id
Feb 17, 2024 20:41:47.871 [9692] ERROR - [DatabaseFixups] Fixup class DatabaseFixupsGarbageCollectTransientItems threw an exception: sqlite3_statement_backend::prepare: no such column: metadata_items.slug for SQL: select metadata_items.id as 'metadata_items_id', metadata_items.library_section_id as 'metadata_items_library_section_id', metadata_items.parent_id as 'metadata_items_parent_id', metadata_items.metadata_type as 'metadata_items_metadata_type', metadata_items.guid as 'metadata_items_guid', metadata_items.slug as 'metadata_items_slug', metadata_items.hash as 'metadata_items_hash', metadata_items.media_item_count as 'metadata_items_media_item_count', metadata_items.title as 'metadata_items_title', metadata_items.title_sort as 'metadata_items_title_sort', metadata_items.original_title as 'metadata_items_original_title', metadata_items.studio as 'metadata_items_studio', metadata_items.rating as 'metadata_items_rating', metadata_items.audience_rating as 'metadata_items_audience_rating', metadata_items.rating_count as 'metadata_items_rating_count', metadata_items.tagline as 'metadata_items_tagline', metadata_items.edition_title as 'metadata_items_edition_title', metadata_items.summary as 'metadata_items_summary', metadata_items.content_rating as 'metadata_items_content_rating', metadata_items.content_rating_age as 'metadata_items_content_rating_age', metadata_items.'index' as 'metadata_items_index', metadata_items.absolute_index as 'metadata_items_absolute_index', metadata_items.duration as 'metadata_items_duration', metadata_items.user_thumb_url as 'metadata_items_user_thumb_url', metadata_items.user_art_url as 'metadata_items_user_art_url', metadata_items.user_banner_url as 'metadata_items_user_banner_url', metadata_items.user_music_url as 'metadata_items_user_music_url', metadata_items.user_fields as 'metadata_items_user_fields', metadata_items.originally_available_at as 'metadata_items_originally_available_at', metadata_items.available_at as 'metadata_items_available_at', metadata_items.expires_at as 'metadata_items_expires_at', metadata_items.refreshed_at as 'metadata_items_refreshed_at', metadata_items.year as 'metadata_items_year', metadata_items.added_at as 'metadata_items_added_at', metadata_items.created_at as 'metadata_items_created_at', metadata_items.updated_at as 'metadata_items_updated_at', metadata_items.changed_at as 'metadata_items_changed_at', metadata_items.resources_changed_at as 'metadata_items_resources_changed_at', metadata_items.tags_genre as 'metadata_items_tags_genre', metadata_items.tags_collection as 'metadata_items_tags_collection', metadata_items.tags_director as 'metadata_items_tags_director', metadata_items.tags_writer as 'metadata_items_tags_writer', metadata_items.tags_star as 'metadata_items_tags_star', metadata_items.deleted_at as 'metadata_items_deleted_at', metadata_items.tags_country as 'metadata_items_tags_country', metadata_items.extra_data as 'metadata_items_extra_data' from metadata_items where id=:id

Plex Media Server.log

Feb 18, 2024 02:32:34.560 [13212] DEBUG - Native Scanner: Executed Local Metadata stage in 0.00 sec.
Feb 18, 2024 02:32:34.561 [20308] DEBUG - Skipping hash check, no size match for 8794618283 bytes.
Feb 18, 2024 02:32:34.561 [20308] DEBUG - No match for hash.
Feb 18, 2024 02:32:34.561 [20064] DEBUG - Scanner [Plex Movie]: found existing media id 933300
Feb 18, 2024 02:32:34.561 [20064] DEBUG - Native Scanner: Executed Cloud Match stage in 0.00 sec.
Feb 18, 2024 02:32:34.562 [20308] ERROR - SQLITE3:0x6ae34276, 1, table metadata_items has no column named slug in "insert into metadata_items (library_section_id,parent_id,metadata_type,guid,slug,hash,media_item_count,title,title_sort,original_title,studio,rating,audience_rating,rating_count,tagline,edition_title,summary,content_rating,content_rating_age,'index',absolute_index,duration,user_thumb_url,user_art_url,user_banner_url,user_music_url,user_fields,tags_genre,tags_collection,tags_director,tags_writer,tags_star,originally_available_at,available_at,expires_at,refreshed_at,year,added_at,created_at,updated_at,deleted_at,changed_at,resources_changed_at,tags_country,extra_data) values (:metadata_items_library_section_id,:metadata_items_parent_id,:metadata_items_metadata_type,:metadata_items_guid,:metadata_items_slug,:me
Feb 18, 2024 02:32:34.562 [20308] ERROR - Exception inside transaction (inside=1) (D:\gha\plex-media-server\plex-media-server\Library\MetadataItem.cpp:1133): sqlite3_statement_backend::prepare: table metadata_items has no column named slug for SQL: insert into metadata_items (library_section_id,parent_id,metadata_type,guid,slug,hash,media_item_count,title,title_sort,original_title,studio,rating,audience_rating,rating_count,tagline,edition_title,summary,content_rating,content_rating_age,'index',absolute_index,duration,user_thumb_url,user_art_url,user_banner_url,user_music_url,user_fields,tags_genre,tags_collection,tags_director,tags_writer,tags_star,originally_available_at,available_at,expires_at,refreshed_at,year,added_at,created_at,updated_at,deleted_at,changed_at,resources_changed_at,tags_country,extra_data) values (:metadata_items_library_section_id,:metadata_items_parent_id,:metadata_items_metadata_type,:metadata_items_guid,:metadata_items_slug,:metadata_items_hash,:metadata_items_media_item_count,:metadata_items_title,:metadata_items_title_sort,:metadata_items_original_title,:metadata_items_studio,:metadata_items_rating,:metadata_items_audience_rating,:metadata_items_rating_count,:metadata_items_tagline,:metadata_items_edition_title,:metadata_items_summary,:metadata_items_content_rating,:metadata_items_content_rating_age,:metadata_items_index,:metadata_items_absolute_index,:metadata_items_duration,:metadata_items_user_thumb_url,:metadata_items_user_art_url,:metadata_items_user_banner_url,:metadata_items_user_music_url,:metadata_items_user_fields,:metadata_items_tags_genre,:metadata_items_tags_collection,:metadata_items_tags_director,:metadata_items_tags_writer,:metadata_items_tags_star,:metadata_items_originally_available_at,:metadata_items_available_at,:metadata_items_expires_at,:metadata_items_refreshed_at,:metadata_items_year,:metadata_items_added_at,:metadata_items_created_at,:metadata_items_updated_at,:metadata_items_deleted_at,:metadata_items_changed_at,:metadata_items_resources_changed_at,:metadata_items_tags_country,:metadata_items_extra_data)
Feb 18, 2024 02:32:34.562 [20308] ERROR - Exception inside transaction (inside=1) (D:\gha\plex-media-server\plex-media-server\Library\MetadataItem.cpp:3923): sqlite3_statement_backend::prepare: table metadata_items has no column named slug for SQL: insert into metadata_items (library_section_id,parent_id,metadata_type,guid,slug,hash,media_item_count,title,title_sort,original_title,studio,rating,audience_rating,rating_count,tagline,edition_title,summary,content_rating,content_rating_age,'index',absolute_index,duration,user_thumb_url,user_art_url,user_banner_url,user_music_url,user_fields,tags_genre,tags_collection,tags_director,tags_writer,tags_star,originally_available_at,available_at,expires_at,refreshed_at,year,added_at,created_at,updated_at,deleted_at,changed_at,resources_changed_at,tags_country,extra_data) values (:metadata_items_library_section_id,:metadata_items_parent_id,:metadata_items_metadata_type,:metadata_items_guid,:metadata_items_slug,:metadata_items_hash,:metadata_items_media_item_count,:metadata_items_title,:metadata_items_title_sort,:metadata_items_original_title,:metadata_items_studio,:metadata_items_rating,:metadata_items_audience_rating,:metadata_items_rating_count,:metadata_items_tagline,:metadata_items_edition_title,:metadata_items_summary,:metadata_items_content_rating,:metadata_items_content_rating_age,:metadata_items_index,:metadata_items_absolute_index,:metadata_items_duration,:metadata_items_user_thumb_url,:metadata_items_user_art_url,:metadata_items_user_banner_url,:metadata_items_user_music_url,:metadata_items_user_fields,:metadata_items_tags_genre,:metadata_items_tags_collection,:metadata_items_tags_director,:metadata_items_tags_writer,:metadata_items_tags_star,:metadata_items_originally_available_at,:metadata_items_available_at,:metadata_items_expires_at,:metadata_items_refreshed_at,:metadata_items_year,:metadata_items_added_at,:metadata_items_created_at,:metadata_items_updated_at,:metadata_items_deleted_at,:metadata_items_changed_at,:metadata_items_resources_changed_at,:metadata_items_tags_country,:metadata_items_extra_data)
Feb 18, 2024 02:32:34.562 [20308] ERROR - Exception assimilating media item in : sqlite3_statement_backend::prepare: table metadata_items has no column named slug for SQL: insert into metadata_items (library_section_id,parent_id,metadata_type,guid,slug,hash,media_item_count,title,title_sort,original_title,studio,rating,audience_rating,rating_count,tagline,edition_title,summary,content_rating,content_rating_age,'index',absolute_index,duration,user_thumb_url,user_art_url,user_banner_url,user_music_url,user_fields,tags_genre,tags_collection,tags_director,tags_writer,tags_star,originally_available_at,available_at,expires_at,refreshed_at,year,added_at,created_at,updated_at,deleted_at,changed_at,resources_changed_at,tags_country,extra_data) values (:metadata_items_library_section_id,:metadata_items_parent_id,:metadata_items_metadata_type,:metadata_items_guid,:metadata_items_slug,:metadata_items_hash,:metadata_items_media_item_count,:metadata_items_title,:metadata_items_title_sort,:metadata_items_original_title,:metadata_items_studio,:metadata_items_rating,:metadata_items_audience_rating,:metadata_items_rating_count,:metadata_items_tagline,:metadata_items_edition_title,:metadata_items_summary,:metadata_items_content_rating,:metadata_items_content_rating_age,:metadata_items_index,:metadata_items_absolute_index,:metadata_items_duration,:metadata_items_user_thumb_url,:metadata_items_user_art_url,:metadata_items_user_banner_url,:metadata_items_user_music_url,:metadata_items_user_fields,:metadata_items_tags_genre,:metadata_items_tags_collection,:metadata_items_tags_director,:metadata_items_tags_writer,:metadata_items_tags_star,:metadata_items_originally_available_at,:metadata_items_available_at,:metadata_items_expires_at,:metadata_items_refreshed_at,:metadata_items_year,:metadata_items_added_at,:metadata_items_created_at,:metadata_items_updated_at,:metadata_items_deleted_at,:metadata_items_changed_at,:metadata_items_resources_changed_at,:metadata_items_tags_country,:metadata_items_extra_data)
Feb 18, 2024 02:32:34.562 [20308] DEBUG - Native Scanner: Executed Add to Database stage in 0.00 sec.
Feb 18, 2024 02:32:34.562 [14944] DEBUG - Native Scanner: Executed Media Analysis stage in 0.00 sec.
9

Pong! :rofl:

Regarding these new errors showing up with the DBā€¦

  1. There are a LOT of broken databases out there which nobody knows about

  2. PMS 1.40.x, with its new DB structure is exposing those errors

  3. Some of the errors are insignificant while others arenā€™t.
    ā€“ ā€œNo such columnā€ comes from another error having prevented updating the DB correctly in the past so now there are two errors in one.

  4. Given any errors represent data missing. we need to figure out how to get over the error and (re)create whatā€™s missing.

If we can figure out a process, weā€™ll hopefully be able to save folks from doing a full-rebuild of the DB

12

Thank you for the explanation! What should I do in the interim? My server is down. Iā€™ve spent 5 years carefully curating all metadata with lots of custom information and really donā€™t want to lose any of that information. Could you please let me know which steps I should take next? Should I try to repair database, downgrade server versions for awhile, try to reload a DB backup?

13

Can I assume if I run a few tasks on the DB repair tool before I upgrade can I ensure there isnā€™t an issue that is going to bite me in the ass when I do upgrade?

14

My first steps here would be:

  1. Stop Plex
  2. Make a ā€˜tar.gzā€™ of the Databases directory so nothing is lost (including backups)
    ā€“ DO NOT LOSE it

What Iā€™m thinking of doing is identifying the missing columns and

@nx6

NO, you cannot assume.

My tool only works with the physical structure of the SQL ā€œ.dbā€ file.
The problems being seen relate to the tables / records in those tables.
Only PMS can validate that data

15

Side question: ChuckPa, does your tool work with the new DB structure?

16

@Kilgry

My tool continues to work with the new DB for the following reasons:

  1. My tool works at the SQL level, not the schema level.
  2. I only have one function (watch history import) which touches ā€œPlexā€ tables in the DB.
1 Like
17

Okay, so is there anything those of us still on 1.32.8.7639 can do to check/fix a database before we upgrade? This is starting to sound like ā€œyou wont find out until itā€™s too lateā€.

1 Like
18

Unfortunately ā€” No.

Short of examining / checking every single record in your database, thereā€™s no way of knowing what might be cobbled up.

The one thing I can tell you which will keep you safe:

  1. Stop Plex
  2. Make that full tar.gz/ZIP / Backup of the ā€œDatabasesā€ directory ā€“ including all the PMS-generated backup DBs
  3. Keep that tar.gz/ZIP file safe

ā€“ NOW ā€“

  1. When you upgrade.
  2. Pay VERY VERY CLOSE attention to PMS CPU utilization. WAIT for it to return to normal

ā€“ANDā€“

  1. Open Plex using Plex/web browser the first time. Wait for the ā€˜503ā€™ maintenance return to go away

ā€“IFā€“

  1. If itā€™s still there after some 30 minutes,
    ā€“ And you have a big CPU (not a little NAS / ARM / whatever thing)
    ā€“ And the CPU is idle

  2. Manually grab the logs ZIP (or tar.gz) so we can see whatā€™s happening in there
    BEFORE killing it.

When shutting PMS down this way, If we must, Let it shutdown itself.
(Linux gets a sudo pkill -15 'Plex Media Server') This is the normal, polite 'Terminate" message

2 Likes
19

Thank you. I made backups. Iā€™m sorry I have a few additional questions.

You say youā€™re identifying the missing columns. Do I need to provide you with anything additional? Are you going to let me know when the column is identified and what the fix is (are you directly helping me or do I wait for a server update)? Is there anything I can do to get my server up in the meantime? I want to be proactive in trying to fix this and Iā€™m very unsure of what I should be doing next to get my server running again?

20

Identifying missing columns ā€”

When we look in the PMS logs, weā€™ll see where the DB transactions fail (for whatever reason).

This is how weā€™ll know what each individualā€™s DB needs .
Everyone is going to be different.

21

Is this a reply to my post above? If so can you please answer these questions too?

Do I need to provide you with anything additional? Are you going to let me know when the column is identified and what the fix is (are you directly helping me or do I wait for a server update)? Is there anything I can do to get my server up in the meantime? I want to be proactive in trying to fix this and Iā€™m very unsure of what I should be doing next to get my server running again?

22

@L_D

Can you please show me the directory listing for your ā€œDatabasesā€ directory ?

Iā€™m looking at this:

Feb 17, 2024 20:37:54.399 [22460] DEBUG - Completed: [[2600:1700:85d0:f31f:99be:d329:6180:a030]:57023] 503 GET /media/providers (6 live) #a TLS GZIP 0ms 559 bytes (pipelined: 1)
Feb 17, 2024 20:37:54.939 [15856] WARN - Crash: Crash reporting disabled
Feb 17, 2024 20:37:56.308 [24436] ERROR - Exception inside transaction (inside=1) (D:\gha\plex-media-server\plex-media-server\Library\DatabaseMigrations.cpp:292): Null value not allowed for this type
Feb 17, 2024 20:37:56.310 [24436] ERROR - Exception thrown during migrations, aborting: Null value not allowed for this type
Feb 17, 2024 20:37:57.104 [24436] DEBUG - ChangestampAllocator: initialized to 83852764
Feb 17, 2024 20:37:57.228 [24436] DEBUG - Opening 2 database sessions to library (com.plexapp.plugins.library.blobs), SQLite 3.39.4, threadsafe=1
Feb 17, 2024 20:37:57.235 [24436] INFO - Running migrations. (EPG 0)
Feb 17, 2024 20:37:57.235 [24436] DEBUG - Captured session 0.

This tells me thereā€™s bad junk in the DB so itā€™s time to figure out a new path.

That path might be to pull your watch history and rebuild.