Constantly getting "an unexpected error occured" after upgrading server

Plex Media Server NAS & Devices
1

Server Version#: 1.28.0.5999
Player Version#: 4.76.1

I’ve been unable to run plex since the 1.26 update. I manually update Plex in my WD Mycloud, I can pull up the dashboard, I see my server but every time I go to the dashboard to see any of my content, I get “something went wrong. an unexpected error occurred”

I can see the mediaserver, and it shows as connected, but can’t see any of my content.

Things I’ve tried so far, all of which have been unsuccessful:
Reinstallation
Reversion back to previous Plex version (all I have to go back to is 1.26)
Check logs–no errors that I can see
SSH into mycloud and checking the SQLite database (the integrity checks were successful)

at this point I’m at my wit’s end, I’ve had this particular device working for 2 years without any issues, I’ve upgraded it plenty of times before without issue, but something has gone wrong and I can’t figure it out.

Is there someplace else I should look, or something else I can try to do? I guess the next step is to blow away the entire installation and start from scratch? I was hoping there might be something else I can try before that though. If anyone has any ideas, I’d be very appreciative. I’ll be glad to post whatever logs might help.

2

I just happened to see this right before I read your post. The “deadlocking” servers part of that description sounds similar enough to your issue that you might want to take a look at it.

Normally my first guess with your problem would be a corrupt database but you said you checked that

3

I also experienced this same issue recently. I upgraded my Synology OS, then received this error for a few weeks. I moved recently, so I didn’t pay much attention to it. Then yesterday, I checked and Plex was working again. So what do I do? I upgraded to the latest Plex. :man_facepalming: Now I’m getting this error again.

Something went wrong

An unexpected error occurred.

Server: 1.28.2.6103
Synology 1019+ running DSM 7.1 update 4

I tried to optimize the database. That completed. I downloaded the database, and it was an empty ZIP. The db, db-wal, and db-shm files are where I’d expect to find them, and they’re significant in size (not 0k).

When I hit Retry after the error, I see the following lines in the console:

[Req#35f] 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

Got exception from request handler: 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 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.id in (122005,77600,11051,24319,4759,4018,4046,14329,10902,14685)order by metadata_item_settings.updated_at desc,metadata_items.index,metadata_items.id,media_items.width desc

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.