Error after updating

Plex Media Server
1

Hello. After updating from version 1.27.2.5929 to version 1.28.2.6151, I get an empty library with an error:

6BcFcb
6BcFcb879×569 77.1 KB

There is also an error in the logs:

Sep 03, 2022 09:36:26.283 [0x8099b9a00] Error — [Req#b46] Unknown metadata type: folder
Sep 03, 2022 09:36:26.299 [0x8099b9a00] Error — [Req#b46] SQLITE3:0x10, 1, no such column: metadata_items.edition_title in "select distinct media_items.id as 'media_items_id', media_items.library_section_id as 'media_items_library_section_id', media_items.section_location_id as 'medi
Sep 03, 2022 09:36:26.300 [0x8099b9a00] Error — Got exception from request handler: sqlite3_statement_backend::prepare: no such column: metadata_items.edition_title for SQL: select distinct 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' 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= 1 where metadata_items.id in (997027,996955,996951,996950,996880,708793,534397,163741,163584,163583,113675,113442,113326,113310,113260,47073,38196,37726,37718,37717,37714,36583,36470,36447,36408) order by  metadata_items.title_sort collate icu_root asc, metadata_items.originally_available_at asc, metadata_items.id asc, media_items.width desc, metadata_items.originally_available_at asc, media_parts.id asc

What could be the problem, how to solve it?

Server Version#: 1.28.2.6151
Player Version#: 4.87.2

2

Can you post your full server logs?

3

Plex Media Server Logs_2022-09-07_17-20-14.zip (4.7 MB)
Here is the log.

4

Im seeing:
Sep 07, 2022 17:18:11.152 [0x808550f00] ERROR - 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' ,media_item_settings.id as 'media_item_settings_id', media_item_settings.account_id as 'media_item_settings_account_id', media_item_settings.media_item_id as 'media_item_settings_media_item_id', media_item_settings.settings as 'media_item_settings_settings', media_item_settings.created_at as 'media_item_settings_created_at', media_item_settings.updated_at as 'media_item_settings_updated_at',media_part_settings.id as 'media_part_settings_id', media_part_settings.account_id as 'media_part_settings_account_id', media_part_settings.media_part_id as 'media_part_settings_media_part_id', media_part_settings.selected_audio_stream_id as 'media_part_settings_selected_audio_stream_id', media_part_settings.selected_subtitle_stream_id as 'media_part_settings_selected_subtitle_stream_id', media_part_settings.settings as 'media_part_settings_settings', media_part_settings.created_at as 'media_part_settings_created_at', media_part_settings.updated_at as 'media_part_settings_updated_at', media_part_settings.changed_at as 'media_part_settings_changed_at',media_streams.id as 'media_streams_id', media_streams.stream_type_id as 'media_streams_stream_type_id', media_streams.media_item_id as 'media_streams_media_item_id', media_streams.media_part_id as 'media_streams_media_part_id', media_streams.url as 'media_streams_url', media_streams.'index' as 'media_streams_index', media_streams.codec as 'media_streams_codec', media_streams.language as 'media_streams_language', media_streams.created_at as 'media_streams_created_at', media_streams.updated_at as 'media_streams_updated_at', media_streams.channels as 'media_streams_channels', media_streams.bitrate as 'media_streams_bitrate', media_streams.url_index as 'media_streams_url_index', media_streams.'default' as 'media_streams_default', media_streams.forced as 'media_streams_forced', media_streams.extra_data as 'media_streams_extra_data',media_stream_settings.id as 'media_stream_settings_id', media_stream_settings.account_id as 'media_stream_settings_account_id', media_stream_settings.media_stream_id as 'media_stream_settings_media_stream_id', media_stream_settings.extra_data as 'media_stream_settings_extra_data', media_stream_settings.created_at as 'media_stream_settings_created_at', media_stream_settings.updated_at as 'media_stream_settings_updated_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.user_thumb_url as metadata_items_parents_user_thumb_url,parents.user_art_url as metadata_items_parents_user_art_url,parents.user_music_url as metadata_items_parents_user_music_url,parents.added_at as metadata_items_parents_added_at,parents.updated_at as metadata_items_parents_updated_at,parents.indexas metadata_items_parents_index, parents.guid as metadata_items_parents_guid, parents.title as metadata_items_parents_title, parents.studio as metadata_items_parents_studio, parents.title_sort as metadata_items_parents_title_sort, parents.year as metadata_items_parents_year 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 left join media_item_settings on media_item_settings.media_item_id=media_items.id and media_item_settings.account_id=? left join media_part_settings on media_part_settings.media_part_id=media_parts.id and media_part_settings.account_id=? left join media_streams on media_streams.media_part_id=media_parts.id left join media_stream_settings on media_stream_settings.media_stream_id=media_streams.id and media_stream_settings.account_id=? where metadata_items.id in (996892,996855,773644,442391,13867,113446,113629,113612,113551,113505,38449,38399,38354,38349,35307,29925,26557,26553,25944,25942,25893,25828,25257,25113,25111,25096,24706,24662,24567,23270,23225,22796,22361,21579,20224,18738,18734,18729,18727,18332,18329,18327,18319,13866,18272,17834,17493,17491,16714,16199) and (media_streams.extra_data is null or media_streams.extra_data not like '%userID%' or media_streams.extra_data like '%userID=1%') order by metadata_items.id,media_items.width desc,metadata_items.originally_available_at

See https://support.plex.tv/articles/repair-a-corrupted-database/ and the Rebuilding indexes section

5

Unfortunately, this doesn’t help. I did everything according to this article. Rebuilt indexes, restored the database. I also restored the database from a backup. No effect!

6

Perhaps before version 1.28 there were some changes in the structure of the database?

The same problem occurred when trying to update Plex to version 1.28.0.5999.

7

@vik021 Are you still seeing that error above after rebuilding the indexes?

@anon18523487 any chance you can lend a hand repairing their database?

8

After rebuilding indexes the same error.

9

Perhaps it somehow affects that Plex is installed on XigmaNAS (FreeBSD)?

10

This is not an issue of corruption. PMS needs to run a migration on the database to get it tp to the current schema but it’s not able to. Looks like your disk is full so PMS has no room to write the new database.

Free up some space, restart PMS and let it sit for about 5 minutes to allow all the database updates to occur, then check it with web to see if your libraries show up.

11

There is currently 634GB free on the disk.
Perhaps a problem with the rights to the database files?

Should the process of updating the database be visible in the logs? Maybe just wait a little longer?

12

Hmm. Maybe it’s your OS’s temp location. I’m not familiar with FreeBSD but PMS was complaining about no space.

Should the process of updating the database be visible in the logs?

Yes, it happens when PMS starts, but it can get delayed to later if your PMS is busy.

13

VACUUM also reported a lack of free space!
Is it possible to specify a separate TMP for SQLite and Plex?

14

Thank you! The problem really was the lack of free space in the TMP. How did I not guess? )))

15

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