Thank you for providing the logs with your first post.
Installing the update exposed database corruption.
PMS will run for a long time with a damaged database.
However, it won’t be able to make backups nor will it be able to be upgraded (schema migration with the new update)
If, using FileStation, you look in Plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases,
and you can see backups of both a .... library.db and a ..... library.blobs.db with the same date, we can use those to restore with.
Would you please look and let me know?
DB corruption here:
Aug 15, 2022 11:28:45.411 [0x7f5e971f7b00] DEBUG - [DatabaseFixups] Collection: Refreshed visibility in section 2 in 9ms.
Aug 15, 2022 11:28:45.412 [0x7f5e971f7b00] ERROR - [DatabaseFixups] SQLITE3:0x80000001, 1, no such column: metadata_items.edition_title in "select media_items.id as 'media_items_id', media_items.library_section_id as 'media_items_library_section_id', media_items.section_location_id as 'media_items_s
Aug 15, 2022 11:28:45.412 [0x7f5e971f7b00] ERROR - [DatabaseFixups] Exception inside transaction (inside=1) (/data/jenkins/server/3534098653/Library/MetadataCollection.cpp:481): sqlite3_statement_backend::prepare: no such column: metadata_items.edition_title for SQL: select media_items.id as 'media_items_id', media_items.library_section_id as 'media_items_library_section_id', media_items.section_location_id as 'media_items_section_location_id', media_items.metadata_item_id as 'media_items_metadata_item_id', media_items.type_id as 'media_items_type_id', media_items.width as 'media_items_width', media_items.height as 'media_items_height', media_items.size as 'media_items_size', media_items.duration as 'media_items_duration', media_items.bitrate as 'media_items_bitrate', media_items.container as 'media_items_container', media_items.video_codec as 'media_items_video_codec', media_items.audio_codec as 'media_items_audio_codec', media_items.display_aspect_ratio as 'media_items_display_aspect_ratio', media_items.frames_per_second as 'media_items_frames_per_second', media_items.audio_channels as 'media_items_audio_channels', media_items.interlaced as 'media_items_interlaced', media_items.source as 'media_items_source', media_items.hints as 'media_items_hints', media_items.display_offset as 'media_items_display_offset', media_items.settings as 'media_items_settings', media_items.created_at as 'media_items_created_at', media_items.updated_at as 'media_items_updated_at', media_items.optimized_for_streaming as 'media_items_optimized_for_streaming', media_items.deleted_at as 'media_items_deleted_at', media_items.media_analysis_version as 'media_items_media_analysis_version', media_items.sample_aspect_ratio as 'media_items_sample_aspect_ratio', media_items.proxy_type as 'media_items_proxy_type', media_items.extra_data as 'media_items_extra_data', media_items.channel_id as 'media_items_channel_id', media_items.begins_at as 'media_items_begins_at', media_items.ends_at as 'media_items_ends_at', media_items.color_trc as 'media_items_color_trc',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.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',media_parts.id as 'media_parts_id', media_parts.media_item_id as 'media_parts_media_item_id', media_parts.directory_id as 'media_parts_directory_id', media_parts.hash as 'media_parts_hash', media_parts.open_subtitle_hash as 'media_parts_open_subtitle_hash', media_parts.file as 'media_parts_file', media_parts.'index' as 'media_parts_index', media_parts.size as 'media_parts_size', media_parts.duration as 'media_parts_duration', media_parts.created_at as 'media_parts_created_at', media_parts.updated_at as 'media_parts_updated_at', media_parts.deleted_at as 'media_parts_deleted_at', media_parts.extra_data as 'media_parts_extra_data',metadata_item_settings.id as 'metadata_item_settings_id', metadata_item_settings.account_id as 'metadata_item_settings_account_id', metadata_item_settings.guid as 'metadata_item_settings_guid', metadata_item_settings.rating as 'metadata_item_settings_rating', metadata_item_settings.view_offset as 'metadata_item_settings_view_offset', metadata_item_settings.view_count as 'metadata_item_settings_view_count', metadata_item_settings.last_viewed_at as 'metadata_item_settings_last_viewed_at', metadata_item_settings.created_at as 'metadata_item_settings_created_at', metadata_item_settings.updated_at as 'metadata_item_settings_updated_at', metadata_item_settings.skip_count as 'metadata_item_settings_skip_count', metadata_item_settings.last_skipped_at as 'metadata_item_settings_last_skipped_at', metadata_item_settings.last_rated_at as 'metadata_item_settings_last_rated_at', metadata_item_settings.extra_data as 'metadata_item_settings_extra_data', metadata_item_settings.changed_at as 'metadata_item_settings_changed_at' ,grandparents.id as metadata_items_grandparents_id, grandparents.title as metadata_items_grandparents_title, grandparents.user_thumb_url as metadata_items_grandparents_user_thumb_url, grandparents.user_art_url as metadata_items_grandparents_user_art_url, grandparents.user_music_url as metadata_items_grandparents_user_music_url, grandparents.content_rating as metadata_items_grandparents_content_rating,grandparents.updated_at as metadata_items_grandparents_updated_at, grandparents.guid as metadata_items_grandparents_guid, grandparents.extra_data as metadata_items_grandparents_extra_data, grandparents.title_sort as metadata_items_grandparents_title_sort, parents.`index` as metadata_items_parents_index, parents.title as metadata_items_parents_title, parents.updated_at as metadata_items_parents_updated_at,parents.user_thumb_url as metadata_items_parents_user_thumb_url from metadata_items left join media_items on media_items.metadata_item_id=metadata_items.id left join media_parts on media_parts.media_item_id=media_items.id left join metadata_item_settings on metadata_item_settings.guid=metadata_items.guid and metadata_item_settings.account_id=? left join metadata_items as parents on parents.id=metadata_items.parent_id left join metadata_items as grandparents on grandparents.id=parents.parent_id where metadata_items.metadata_type=18 and metadata_items.extra_data like '%at^%3Asmart=1%' escape '^'
Aug 15, 2022 11:28:45.412 [0x7f5e971f7b00] ERROR - [DatabaseFixups] Fixup 29DatabaseFixupsSyncCollections threw an exception: sqlite3_statement_backend::prepare: no such column: metadata_items.edition_title for SQL: select media_items.id as 'media_items_id', media_items.library_section_id as 'media_items_library_section_id', media_items.section_location_id as 'media_items_section_location_id', media_items.metadata_item_id as 'media_items_metadata_item_id', media_items.type_id as 'media_items_type_id', media_items.width as 'media_items_width', media_items.height as 'media_items_height', media_items.size as 'media_items_size', media_items.duration as 'media_items_duration', media_items.bitrate as 'media_items_bitrate', media_items.container as 'media_items_container', media_items.video_codec as 'media_items_video_codec', media_items.audio_codec as 'media_items_audio_codec', media_items.display_aspect_ratio as 'media_items_display_aspect_ratio', media_items.frames_per_second as 'media_items_frames_per_second', media_items.audio_channels as 'media_items_audio_channels', media_items.interlaced as 'media_items_interlaced', media_items.source as 'media_items_source', media_items.hints as 'media_items_hints', media_items.display_offset as 'media_items_display_offset', media_items.settings as 'media_items_settings', media_items.created_at as 'media_items_created_at', media_items.updated_at as 'media_items_updated_at', media_items.optimized_for_streaming as 'media_items_optimized_for_streaming', media_items.deleted_at as 'media_items_deleted_at', media_items.media_analysis_version as 'media_items_media_analysis_version', media_items.sample_aspect_ratio as 'media_items_sample_aspect_ratio', media_items.proxy_type as 'media_items_proxy_type', media_items.extra_data as 'media_items_extra_data', media_items.channel_id as 'media_items_channel_id', media_items.begins_at as 'media_items_begins_at', media_items.ends_at as 'media_items_ends_at', media_items.color_trc as 'media_items_color_trc',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.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',media_parts.id as 'media_parts_id', media_parts.media_item_id as 'media_parts_media_item_id', media_parts.directory_id as 'media_parts_directory_id', media_parts.hash as 'media_parts_hash', media_parts.open_subtitle_hash as 'media_parts_open_subtitle_hash', media_parts.file as 'media_parts_file', media_parts.'index' as 'media_parts_index', media_parts.size as 'media_parts_size', media_parts.duration as 'media_parts_duration', media_parts.created_at as 'media_parts_created_at', media_parts.updated_at as 'media_parts_updated_at', media_parts.deleted_at as 'media_parts_deleted_at', media_parts.extra_data as 'media_parts_extra_data',metadata_item_settings.id as 'metadata_item_settings_id', metadata_item_settings.account_id as 'metadata_item_settings_account_id', metadata_item_settings.guid as 'metadata_item_settings_guid', metadata_item_settings.rating as 'metadata_item_settings_rating', metadata_item_settings.view_offset as 'metadata_item_settings_view_offset', metadata_item_settings.view_count as 'metadata_item_settings_view_count', metadata_item_settings.last_viewed_at as 'metadata_item_settings_last_viewed_at', metadata_item_settings.created_at as 'metadata_item_settings_created_at', metadata_item_settings.updated_at as 'metadata_item_settings_updated_at', metadata_item_settings.skip_count as 'metadata_item_settings_skip_count', metadata_item_settings.last_skipped_at as 'metadata_item_settings_last_skipped_at', metadata_item_settings.last_rated_at as 'metadata_item_settings_last_rated_at', metadata_item_settings.extra_data as 'metadata_item_settings_extra_data', metadata_item_settings.changed_at as 'metadata_item_settings_changed_at' ,grandparents.id as metadata_items_grandparents_id, grandparents.title as metadata_items_grandparents_title, grandparents.user_thumb_url as metadata_items_grandparents_user_thumb_url, grandparents.user_art_url as metadata_items_grandparents_user_art_url, grandparents.user_music_url as metadata_items_grandparents_user_music_url, grandparents.content_rating as metadata_items_grandparents_content_rating,grandparents.updated_at as metadata_items_grandparents_updated_at, grandparents.guid as metadata_items_grandparents_guid, grandparents.extra_data as metadata_items_grandparents_extra_data, grandparents.title_sort as metadata_items_grandparents_title_sort, parents.`index` as metadata_items_parents_index, parents.title as metadata_items_parents_title, parents.updated_at as metadata_items_parents_updated_at,parents.user_thumb_url as metadata_items_parents_user_thumb_url from metadata_items left join media_items on media_items.metadata_item_id=metadata_items.id left join media_parts on media_parts.media_item_id=media_items.id left join metadata_item_settings on metadata_item_settings.guid=metadata_items.guid and metadata_item_settings.account_id=? left join metadata_items as parents on parents.id=metadata_items.parent_id left join metadata_items as grandparents on grandparents.id=parents.parent_id where metadata_items.metadata_type=18 and metadata_items.extra_data like '%at^%3Asmart=1%' escape '^'
Aug 15, 2022 11:28:45.536 [0x7f5e971f7b00] DEBUG - [DatabaseFixups] Running database fix-ups completed in 0.1 seconds.
Aug 15, 2022 11:28:45.536 [0x7f5e971f7b00] DEBUG - [HCl#13] HTTP requesting GET https://plex.tv/api/v2/features?X-Plex-Token=xxxxxxxxxxxxxxxxxxxx
