Server Version#:1.40.2.8395
Player Version#:
After update media server, cannot start server.
The dmp log file is useless.
Make a tar.gz of the Logs directory and attach please.
attachment.
logs.zip (1.5 MB)
Thank you for the logs.
Bad news. The DB is corrupted.
Jun 04, 2024 17:57:28.836 [140170983435064] DEBUG - [JobRunner] Job running: /usr/lib/plexmediaserver/CrashUploader "--directory=/var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Crash Reports/1.40.2.8395-c67dce28e" --version=1.40.2.8395-c67dce28e --platform=Linux "--platformVersion=22.04.4 LTS (Jammy Jellyfish)" --serverUuid=8a372e71ec726a5deacbd3842337bded3a500dd6 --userId=hyosang82@naver.com --sentryUrl=https://o17675.ingest.sentry.io/api/1233455/ --sentryKey=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx --vendor=Ubuntu --model=x86_64 --device=PC
Jun 04, 2024 17:57:28.837 [140170983435064] DEBUG - [JobRunner] Jobs: Starting child process with pid 260845
Jun 04, 2024 17:57:28.848 [140170986068792] DEBUG - Jobs: '/usr/lib/plexmediaserver/CrashUploader' exit code for process 260845 is 0 (success)
Jun 04, 2024 17:57:29.921 [140170990832272] ERROR - SQLITE3:0x80000001, 11, database corruption at line 97023 of [a29f994989]
Jun 04, 2024 17:57:29.921 [140170990832272] ERROR - SQLITE3:0x80000001, 11, statement aborts at 8: [SELECT id, extra_data FROM media_parts WHERE extra_data IS NOT NULL] database disk image is malformed
Jun 04, 2024 17:57:29.921 [140170990832272] ERROR - Exception inside transaction (inside=1) (/home/runner/actions-runner/_work/plex-media-server/plex-media-server/Library/DatabaseMigrations.cpp:293): sqlite3_statement_backend::loadRS: database disk image is malformed
Jun 04, 2024 17:57:29.930 [140170990832272] ERROR - Exception thrown during migrations, aborting: sqlite3_statement_backend::loadRS: database disk image is malformed
Jun 04, 2024 17:57:29.974 [140170990832272] DEBUG - ChangestampAllocator: initialized to 1201210
Jun 04, 2024 17:57:29.982 [140170990832272] DEBUG - Opening 2 database sessions to library (com.plexapp.plugins.library.blobs), SQLite 3.39.4, threadsafe=1
Jun 04, 2024 17:57:29.982 [140170990832272] INFO - SQLITE3:0x80000001, 283, recovered 2 frames from WAL file /PLEX/plex-data/Plug-in Support/Databases/com.plexapp.plugins.library.blobs.db-wal
Jun 04, 2024 17:57:29.990 [140170990832272] INFO - Running migrations. (EPG 0)
Here you can see that PMS was somehow shutdown before fully closing the DB
Jun 04, 2024 17:57:29.982 [140170990832272] INFO - SQLITE3:0x80000001, 283, recovered 2 frames from WAL file /PLEX/plex-data/Plug-in Support/Databases/com.plexapp.plugins.library.blobs.db-wal
It’s trying to recover but can’t.
Jun 04, 2024 17:57:31.386 [140170990832272] DEBUG - [DatabaseFixups] Collections: Synced tags in section 4 in 0ms.
Jun 04, 2024 17:57:31.387 [140170990832272] ERROR - [DatabaseFixups] SQLITE3:0x80000001, 1, no such column: metadata_items.slug 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_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_a
Jun 04, 2024 17:57:31.387 [140170990832272] ERROR - [DatabaseFixups] Fixup 29DatabaseFixupsSyncCollections threw an exception: sqlite3_statement_backend::prepare: no such column: metadata_items.slug 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.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',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.slug as metadata_items_grandparents_slug, 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.guid as metadata_items_parents_guid, 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.library_section_id = 4 and metadata_items.metadata_type = 18 and metadata_items.extra_data like '%at^%3Asmart=1%' escape '^'
Jun 04, 2024 17:57:31.390 [140170990832272] DEBUG - [DatabaseFixups] Running database fix-ups completed in 0.0 seconds.
Was the server ever abruptly powered off ?
-OR-
As you upgraded into the 1.40.x series, did you abruptly kill PMS ?
The best I can suggest is to try and recover using backups.
If I may suggest?
- use my DB tool to automate the typing for you
- First attempt to repair the DB
- While staying in the tool (no need to exit as long as it sits quiet)
- Attempt to start PMS
- If it fails to start then the DB is corrupted at a deeper level and we need the backups.
- The Restore command will allow you to select one of your backups and use it .
- Again, stay in the tool as you try different backups until success.
If you get to the end of your backups without success, unfortunately you’ll have no choice but to reset the media, metadata, and databases directories (effective restart)
Thank you. Database recovered using PlexDBRepair auto process.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
