Server Version#: DSM 6.2.4-25556 update 6
Player Version#: 1.29.2.6334-6000
None of my libraries show: Movies, music, pictures. All have the same error - “Something’s wrong. An unexpected error occurred”
What log should I upload?
When it doesn’t respond to you… like it is now.
-
Control-F5 once – to see if it will respond (sometimes a Syno can get too busy)
-
If that doesn’t work.
-
Stop PMS in Package Center
-
FileStation
-
Navigate: Plex / Library / Application Support / Plex Media Server
-
Right-Click
Logs→Compress to Logs.zip -
When that finishes, download it to your computer
-
Upload the ZIP here.
Here are the logs. Thanks
Logs.zip (2.3 MB)
Thanks for that.
Info I get isn’t the most detailed ( You turned off DEBUG logging )
- Fix this typo AFTER PMS is working again (got a leading space on the netmask)
Oct 31, 2022 09:23:11.078 [0x7f663cdbbb38] ERROR - Error parsing allowedNetworks ' 255.255.255.0': Invalid argument
- The bigger problem – Corrupt database
Oct 31, 2022 09:23:08.114 [0x7f6640bd00d0] INFO - Running forward migration 202203040100.
Oct 31, 2022 09:23:08.515 [0x7f6640bd00d0] ERROR - SQLITE3:0x80000001, 779, index corruption at line 91877 of [1b256d97b5]
Oct 31, 2022 09:23:08.515 [0x7f6640bd00d0] ERROR - SQLITE3:0x80000001, 779, statement aborts at 247: [update metadata_items set originally_available_at = iif(typeof(originally_available_at) in ('integer', 'real'), originally_available_at, strftime('%s', originally_available_at)), avai
Oct 31, 2022 09:23:08.516 [0x7f6640bd00d0] ERROR - Exception inside transaction (inside=1) (/data/jenkins/server/3537506525/Library/DatabaseMigrations.cpp:289): sqlite3_statement_backend::loadOne: database disk image is malformed
Oct 31, 2022 09:23:08.528 [0x7f6640bd00d0] ERROR - Exception thrown during migrations, aborting: sqlite3_statement_backend::loadOne: database disk image is malformed
Oct 31, 2022 09:23:08.880 [0x7f6640bd00d0] INFO - Running migrations. (EPG 0)
Oct 31, 2022 09:23:09.541 [0x7f6639e98b38] WARN - Couldn't determine bundle identifier for plug-in at: "/volume1/Plex/Library/Application Support/Plex Media Server/Plug-ins/Hulu.bundle"
Oct 31, 2022 09:23:09.849 [0x7f663a4b1b38] WARN - Crash: Crash reporting disabled
Sorry, I went in and turned on debugging. I also removed the space before 255
Here are the updated logs
Logs.zip (2.1 MB)
How do you fix a corrupt database?
That looks better but the database is still damaged.
Oct 31, 2022 10:25:24.693 [0x7f3cffda2b38] DEBUG - [HCl#12] HTTP requesting GET https://plex.tv/api/v2/geoip
Oct 31, 2022 10:25:24.700 [0x7f3d077b60d0] DEBUG - [DatabaseFixups] Collection: Refreshed visibility in section 1 in 7ms.
Oct 31, 2022 10:25:24.728 [0x7f3d077b60d0] 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
Oct 31, 2022 10:25:24.728 [0x7f3d077b60d0] ERROR - [DatabaseFixups] Exception inside transaction (inside=1) (/data/jenkins/server/3537506525/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 '^'
We need to repair it or replace it using one of the backup databses.
If you look in `Plex / Library / Application Support / Plex Media Server / Plug-in Support / Databases
Make certain there are backups (they have dates in the file name)
I have a utility which helps with all the typing - if you’re comfortable enough with basic command line typing.
Here’s the link to it. Please let me know if you’d be comfortable running this from the command-line menu .
You have a bit of a problem there.
Notice you have recent backups for “blobs” but haven’t had a backup of your main database for 7 years now meaning there’s been damage in there all this time which only now caught up
To run the utility.
- Put it in the Plex share
- Stop Plex
- SSH into the Syno
sudo bash
cd /volume*/Plex
chmod +x DBRepair.sh
./DBRepair.sh
It will now give you the menu (it will confirm it’s identified the Synology host and knows where everything is)
Given you have no backups, we need to jump in deep.
-
Repair option
– Give it time to export both databases (blobs and main)
– It willl re-import them (part of the rebuild)
– It will then verify both databases are intact -
When successfully completed, REINDEX (Option 3)
You won’t need to Check the databases after this (it does itself at every step) but you can if you wish.
When you exit, it will prompt you to keep or delete the intermediate copies it made.
The choice is yours
I do need a bit of a user manual for this to describe how best to use in the different situations.
How do I download DBRepair.sh, or do I just copy it into a text file and change the extension?
My apologies.
Use this link. Now you have a tar or zip
- Download whichever is your preference
- upload to the Syno
- Extract the tar or zip (
tar xforunzip)
no worries… just found it and am at the menu now…
Cool.
REPAIR (you have no backups)
Let it do its thing.
REINDEX
then
CHECK
That should do it
No… Option 4 - Repair.
We must repair first
doh, would help if i actually followed your directions 
repairing now
You got excited 
Yes.
- Reindex
- Exit
- Start PMS
- Give it extra time to catch up with the database migrations which PMS itself must complete.
- When CPU is again idle, Open PMS in the web browser
You might have media missing . This is expected due to the damaged records.
Scan files on all library sections to ensure all media has again been found.
Looking good!
Thank you so much!
I’m working on the Readme… it will be a lot of writing
Glad you’re working again.
