No database optimization because of changed schema

Plex Media Server Desktops & Laptops
1

Server Version#: 1.40.3.8555
Player Version#: 4.129.1
Good morning,
Since multiple months I can’t do database optimization because schema seems to be changed. I don’t know when but operation abort each time.
I’ve tried to recreate plex database but no change nor errors. Tried this one too GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Media Server databases and nothing again.
My logs are :

Jun 24, 2024 22:09:20.788 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Activity: updated activity 92bbf7be-be5e-485c-9a95-34e9fdf8502e - completed 0.0% - Optimizing database
Jun 24, 2024 22:09:20.788 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Activity: updated activity 92bbf7be-be5e-485c-9a95-34e9fdf8502e - completed 10.0% - Optimizing database
Jun 24, 2024 22:09:20.788 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db/DatabaseFixups] Running fix-ups.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db/DatabaseFixups] Running database fix-ups completed in 0.1 seconds.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 0.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 1.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 2.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 3.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 4.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 5.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 6.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 7.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 8.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 9.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 10.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 11.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 12.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 13.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 14.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 15.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 16.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 17.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 18.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Captured session 19.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Rebuilding full text search tables.
Jun 24, 2024 22:09:20.896 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Activity: updated activity 92bbf7be-be5e-485c-9a95-34e9fdf8502e - completed 40.0% - Optimizing database
Jun 24, 2024 22:09:22.033 [140330839219000] WARN - [Req#563/Database optimization/com.plexapp.plugins.library.db] Held transaction for too long (/home/runner/actions-runner/_work/plex-media-server/plex-media-server/Library/FullTextSearch.cpp:58): 1.130000 seconds
Jun 24, 2024 22:09:22.631 [140330839219000] WARN - [Req#563/Database optimization/com.plexapp.plugins.library.db] Held transaction for too long (/home/runner/actions-runner/_work/plex-media-server/plex-media-server/Library/FullTextSearch.cpp:71): 0.530000 seconds
Jun 24, 2024 22:09:23.813 [140330839219000] WARN - [Req#563/Database optimization/com.plexapp.plugins.library.db] Held transaction for too long (/home/runner/actions-runner/_work/plex-media-server/plex-media-server/Library/FullTextSearch.cpp:81): 1.160000 seconds
Jun 24, 2024 22:09:25.313 [140330839219000] WARN - [Req#563/Database optimization/com.plexapp.plugins.library.db] Held transaction for too long (/home/runner/actions-runner/_work/plex-media-server/plex-media-server/Library/FullTextSearch.cpp:94): 1.460000 seconds
Jun 24, 2024 22:09:25.333 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Database optimization: starting.
Jun 24, 2024 22:09:25.333 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Activity: updated activity 92bbf7be-be5e-485c-9a95-34e9fdf8502e - completed 60.0% - Optimizing database
Jun 24, 2024 22:09:27.302 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Database optimization: complete.
Jun 24, 2024 22:09:27.314 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.316 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.319 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.320 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.321 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.322 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.323 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.323 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.324 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.325 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.326 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.327 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.328 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.329 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.329 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.330 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.331 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.332 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.333 [140330839219000] INFO - [Req#563/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x80000001, 17, statement aborts at 59: [select * from metadata_items limit 1] database schema has changed
Jun 24, 2024 22:09:27.336 [140330839219000] DEBUG - [Req#563/Database optimization/com.plexapp.plugins.library.db] Activity: Ended activity 92bbf7be-be5e-485c-9a95-34e9fdf8502e.

With SQLite Viewer I don’t really see anything.
My plex database exists since 3-5 years at least.

Can someone have a tips to do ?

Best regards

2

Can you tell me which steps you’ve taken with DBRepair?
(Showing me the DBRepair log file helps too)

3

DBRepair.log (3,0 Ko)
Here log file
I’ve tried multiple options, auto was the last one.
BDD was backed up, so I can revert if necessary

4

That shows the SQLite file is Ok but we don’t know if the Plex DB Schema is scrambled.

Is is possible to get the entire server logs (debug) zip file?

5

Hello,
Sure, how do you wish the logs files ? I’m not confident posting in public post with all private data.

6

This specific query, select * from metadata_items limit 1 is executed to make the SQLite library notice the schema has changed and it must be executed for each connection. After it succeeds (or fails), subsequent queries will execute as they should. This is not causing a problem and the logs indicate the optimization is complete.

7

This is not causing a problem but do my database corrupted ?
I wish to correct it before stacking errors and one day it will be not revertible.
Is there a way to correct only what is damaged ? Drop table for exemple ?

8

As I stated:

Do you have any indication of any issue other than this single query which I told you is not indicative of a problem?

9

As far as I know, there is no visible trouble at the moment.

10

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