Server Version#: 1.41.8.9834
Player Version#: N/A
These errors present in the log when I attempt a database optimisation
21 instances of:
[Req#1444a6/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x14b633b08, 17, statement aborts at 60: [select * from metadata_items limit 1] database schema has changed.
1 instance of
SQLITE3:0x14b633b08, 17, statement aborts at 21: [UPDATE activities SET finished_at=:U1 WHERE id=:C1] database schema has changed
This appears to be the angry query, as pulled from the verbose log:
May 29, 2025 21:08:28.542 [0x16c72b000] INFO - [Req#13fa3d] SQLITE3:0x14b633b08, 17, statement aborts at 59: [SELECT mt.id,mt.library_section_id,mt.parent_id,mt.metadata_type,mt.guid,mt.edition_title,mt.slug,mt.hash,mt.media_item_count,mt.title,mt.title_sort,mt.original_title,mt.studio,mt.rating,mt.audience_rating,mt.rating_count,mt.tagline,mt.summary,mt.content_rating,mt.content_rating_age,mt.index,mt.absolute_index,mt.duration,mt.user_thumb_url,mt.user_art_url,mt.user_banner_url,mt.user_clear_logo_url,mt.user_music_url,mt.user_fields,mt.originally_available_at,mt.available_at,mt.expires_at,mt.refreshed_at,mt.year,mt.added_at,mt.created_at,mt.updated_at,mt.changed_at,mt.resources_changed_at,mt.tags_genre,mt.tags_collection,mt.tags_director,mt.tags_writer,
Is this anything I should worry about? Should I rollback to the old database backup? Unfortunately it predates this PMS version - but it’s only the version prior so I presume PMS will pick it up and attempt a schema upgrade if necessary?
