Plex not importing new media

Plex Media Server NAS & Devices
1

Server Version#: Version 1.21.3.4046
Player Version#: Many

For the last several days PMS has ignored new additions to my source directories.

Looking in the Plex Media Scanner logs, I find an instance of this SQLITE error on every new file:

Apr 02, 2021 21:15:09.182 [0x7f51dc996bc0] ERROR - SQLITE3:(nil), 257, no such collation sequence: icu_root in "insert into metadata_items (library_section_id,parent_id,metadata_type,guid,hash,media_item_count,title,title_sort,original_title,studio,rating,audience_rating,rating_c
Apr 02, 2021 21:15:09.182 [0x7f51dc996bc0] ERROR - Exception inside transaction (inside=1) (../Library/MetadataItem.cpp:1142): sqlite3_statement_backend::prepare: no such collation sequence: icu_root for SQL: insert into metadata_items (library_section_id,parent_id,metadata_type,guid,hash,media_item_count,title,title_sort,original_title,studio,rating,audience_rating,rating_count,tagline,summary,content_rating,content_rating_age,'index',absolute_index,duration,user_thumb_url,user_art_url,user_banner_url,user_music_url,user_fields,tags_genre,tags_collection,tags_director,tags_writer,tags_star,originally_available_at,available_at,expires_at,refreshed_at,year,added_at,created_at,updated_at,deleted_at,changed_at,resources_changed_at,tags_country,extra_data) values (:metadata_items_library_section_id,:metadata_items_parent_id,:metadata_items_metadata_type,:metadata_items_guid,:metadata_items_hash,:metadata_items_media_item_count,:metadata_items_title,:metadata_items_title_sort,:metadata_items_original_title,:metadata_items_studio,:metadata_items_rating,:metadata_items_audience_rating,:metadata_items_rating_count,:metadata_items_tagline,:metadata_items_summary,:metadata_items_content_rating,:metadata_items_content_rating_age,:metadata_items_index,:metadata_items_absolute_index,:metadata_items_duration,:metadata_items_user_thumb_url,:metadata_items_user_art_url,:metadata_items_user_banner_url,:metadata_items_user_music_url,:metadata_items_user_fields,:metadata_items_tags_genre,:metadata_items_tags_collection,:metadata_items_tags_director,:metadata_items_tags_writer,:metadata_items_tags_star,:metadata_items_originally_available_at,:metadata_items_available_at,:metadata_items_expires_at,:metadata_items_refreshed_at,:metadata_items_year,:metadata_items_added_at,:metadata_items_created_at,:metadata_items_updated_at,:metadata_items_deleted_at,:metadata_items_changed_at,:metadata_items_resources_changed_at,:metadata_items_tags_country,:metadata_items_extra_data)
Apr 02, 2021 21:15:09.182 [0x7f51dc996bc0] ERROR - Exception inside transaction (inside=1) (../Library/Episode.cpp:280): sqlite3_statement_backend::prepare: no such collation sequence: icu_root for SQL: insert into metadata_items (library_section_id,parent_id,metadata_type,guid,hash,media_item_count,title,title_sort,original_title,studio,rating,audience_rating,rating_count,tagline,summary,content_rating,content_rating_age,'index',absolute_index,duration,user_thumb_url,user_art_url,user_banner_url,user_music_url,user_fields,tags_genre,tags_collection,tags_director,tags_writer,tags_star,originally_available_at,available_at,expires_at,refreshed_at,year,added_at,created_at,updated_at,deleted_at,changed_at,resources_changed_at,tags_country,extra_data) values (:metadata_items_library_section_id,:metadata_items_parent_id,:metadata_items_metadata_type,:metadata_items_guid,:metadata_items_hash,:metadata_items_media_item_count,:metadata_items_title,:metadata_items_title_sort,:metadata_items_original_title,:metadata_items_studio,:metadata_items_rating,:metadata_items_audience_rating,:metadata_items_rating_count,:metadata_items_tagline,:metadata_items_summary,:metadata_items_content_rating,:metadata_items_content_rating_age,:metadata_items_index,:metadata_items_absolute_index,:metadata_items_duration,:metadata_items_user_thumb_url,:metadata_items_user_art_url,:metadata_items_user_banner_url,:metadata_items_user_music_url,:metadata_items_user_fields,:metadata_items_tags_genre,:metadata_items_tags_collection,:metadata_items_tags_director,:metadata_items_tags_writer,:metadata_items_tags_star,:metadata_items_originally_available_at,:metadata_items_available_at,:metadata_items_expires_at,:metadata_items_refreshed_at,:metadata_items_year,:metadata_items_added_at,:metadata_items_created_at,:metadata_items_updated_at,:metadata_items_deleted_at,:metadata_items_changed_at,:metadata_items_resources_changed_at,:metadata_items_tags_country,:metadata_items_extra_data)
Apr 02, 2021 21:15:09.182 [0x7f51dc996bc0] ERROR - Exception inside transaction (inside=1) (../Library/MetadataItem.cpp:3739): sqlite3_statement_backend::prepare: no such collation sequence: icu_root for SQL: insert into metadata_items (library_section_id,parent_id,metadata_type,guid,hash,media_item_count,title,title_sort,original_title,studio,rating,audience_rating,rating_count,tagline,summary,content_rating,content_rating_age,'index',absolute_index,duration,user_thumb_url,user_art_url,user_banner_url,user_music_url,user_fields,tags_genre,tags_collection,tags_director,tags_writer,tags_star,originally_available_at,available_at,expires_at,refreshed_at,year,added_at,created_at,updated_at,deleted_at,changed_at,resources_changed_at,tags_country,extra_data) values (:metadata_items_library_section_id,:metadata_items_parent_id,:metadata_items_metadata_type,:metadata_items_guid,:metadata_items_hash,:metadata_items_media_item_count,:metadata_items_title,:metadata_items_title_sort,:metadata_items_original_title,:metadata_items_studio,:metadata_items_rating,:metadata_items_audience_rating,:metadata_items_rating_count,:metadata_items_tagline,:metadata_items_summary,:metadata_items_content_rating,:metadata_items_content_rating_age,:metadata_items_index,:metadata_items_absolute_index,:metadata_items_duration,:metadata_items_user_thumb_url,:metadata_items_user_art_url,:metadata_items_user_banner_url,:metadata_items_user_music_url,:metadata_items_user_fields,:metadata_items_tags_genre,:metadata_items_tags_collection,:metadata_items_tags_director,:metadata_items_tags_writer,:metadata_items_tags_star,:metadata_items_originally_available_at,:metadata_items_available_at,:metadata_items_expires_at,:metadata_items_refreshed_at,:metadata_items_year,:metadata_items_added_at,:metadata_items_created_at,:metadata_items_updated_at,:metadata_items_deleted_at,:metadata_items_changed_at,:metadata_items_resources_changed_at,:metadata_items_tags_country,:metadata_items_extra_data)
Apr 02, 2021 21:15:09.182 [0x7f51dc996bc0] ERROR - Exception assimilating media item in Servant/Season 1: sqlite3_statement_backend::prepare: no such collation sequence: icu_root for SQL: insert into metadata_items (library_section_id,parent_id,metadata_type,guid,hash,media_item_count,title,title_sort,original_title,studio,rating,audience_rating,rating_count,tagline,summary,content_rating,content_rating_age,'index',absolute_index,duration,user_thumb_url,user_art_url,user_banner_url,user_music_url,user_fields,tags_genre,tags_collection,tags_director,tags_writer,tags_star,originally_available_at,available_at,expires_at,refreshed_at,year,added_at,created_at,updated_at,deleted_at,changed_at,resources_changed_at,tags_country,extra_data) values (:metadata_items_library_section_id,:metadata_items_parent_id,:metadata_items_metadata_type,:metadata_items_guid,:metadata_items_hash,:metadata_items_media_item_count,:metadata_items_title,:metadata_items_title_sort,:metadata_items_original_title,:metadata_items_studio,:metadata_items_rating,:metadata_items_audience_rating,:metadata_items_rating_count,:metadata_items_tagline,:metadata_items_summary,:metadata_items_content_rating,:metadata_items_content_rating_age,:metadata_items_index,:metadata_items_absolute_index,:metadata_items_duration,:metadata_items_user_thumb_url,:metadata_items_user_art_url,:metadata_items_user_banner_url,:metadata_items_user_music_url,:metadata_items_user_fields,:metadata_items_tags_genre,:metadata_items_tags_collection,:metadata_items_tags_director,:metadata_items_tags_writer,:metadata_items_tags_star,:metadata_items_originally_available_at,:metadata_items_available_at,:metadata_items_expires_at,:metadata_items_refreshed_at,:metadata_items_year,:metadata_items_added_at,:metadata_items_created_at,:metadata_items_updated_at,:metadata_items_deleted_at,:metadata_items_changed_at,:metadata_items_resources_changed_at,:metadata_items_tags_country,:metadata_items_extra_data)

“No such collation sequence: icu_root” appears to be the basic complaint out of SQLITE. Database corruption?

What to do?

2

You might try Repair a Corrupt Database | Plex Support
It worked for me with a similar problem and log

3

Did you try a newer version of Plex Media Server, and then revert back to a previous version? It appears that way, from those error messages. The newest versions of PMS include some database changes.

If so, the easiest solution is to re-install the newest version of Plex Media Server.

An alternative would be to revert to a previous database backup.

A final alternative would be to manually delete the new tables and triggers from the database. I can try to help with that if re-upgrading PMS or using a backup isn’t possible.

I don’t think that the Repair a Corrupt Database procedure will help fix this issue.

4

I’m using the linuxserver.io docker package. I’m not really a docker whiz, but I don’t think I did anything to revert to earlier versions.

Perhaps relatedly, though, I am on the most recent image they’ve released, but PMS still thinks it needs an upgrade. Maybe linuxserver is lagging the PMS releases, but it’s been quite a few days like this which is unusual.

I’ll take a whack at grhiner’s Repair link, but in the meantime if you could work up the final alternative instructions, that’d be great.

EDIT: Yeah, that repair page didn’t help–at the step of rebuilding the db from the sql file I get my old friend “Error: near line 295940: no such collation sequence: icu_root”. So you’re right, @Volts , it seems structural somehow.

5

SOLVED!

Your hint about stepping back a version made me curious. I’ve also had a tautulli container I couldn’t start because its port was in use–and Tautulli was reachable in the browser despite ‘docker ps’ showing it not running. Curious.

Turns out I have Docker installed via the Snap store, and also running inside systemctrl as a stand-alone service. I must have installed it twice at some point, and after a reboot a couple days ago, both were running at once, with different images and therefore different versions–though configured to use the same directories for their library!

I did:

sudo snap disable docker
sudo service docker stop
sudo snap enable docker

And now I see all the containers I expect, including Plex, which just imported my missing files just great.

6

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