# No database optimization because of changed schema **URL:** \ **Category:** Plex Media Server\ **Tags:** server-linux\ **Created:** [June 24, 2024, 8:20pm UTC](https://forums.plex.tv/t/no-database-optimization-because-of-changed-schema/880897 "2024-06-24T20:20:12Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![zicdeha](https://avatars.discourse-cdn.com/v4/letter/z/e79b87/32.png) [@zicdeha](https://forums.plex.tv/u/zicdeha)\ **Post date:** [June 24, 2024, 8:20pm UTC](https://forums.plex.tv/t/no-database-optimization-because-of-changed-schema/880897/1 "2024-06-24T20:20:12Z")
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 [https://github.com/ChuckPa/PlexDBRepair](https://github.com/ChuckPa/PlexDBRepair) and nothing again. My logs are : ```auto 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 ---
**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\ **Post date:** [June 24, 2024, 9:10pm UTC](https://forums.plex.tv/t/no-database-optimization-because-of-changed-schema/880897/2 "2024-06-24T21:10:06Z")
Can you tell me which steps you’ve taken with DBRepair? (Showing me the DBRepair log file helps too) ---
**Author:** ![zicdeha](https://avatars.discourse-cdn.com/v4/letter/z/e79b87/32.png) [@zicdeha](https://forums.plex.tv/u/zicdeha)\ **Post date:** [June 24, 2024, 9:50pm UTC](https://forums.plex.tv/t/no-database-optimization-because-of-changed-schema/880897/3 "2024-06-24T21:50:07Z")
[DBRepair.log](https://forums.plex.tv/uploads/short-url/oQ7x6AM6KAWXAEyfkZRMSqPFzSE.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 ---
**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\ **Post date:** [June 24, 2024, 10:26pm UTC](https://forums.plex.tv/t/no-database-optimization-because-of-changed-schema/880897/4 "2024-06-24T22:26:44Z")
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](https://support.plex.tv/articles/200250417-plex-media-server-log-files/) (debug) zip file? ---
**Author:** ![zicdeha](https://avatars.discourse-cdn.com/v4/letter/z/e79b87/32.png) [@zicdeha](https://forums.plex.tv/u/zicdeha)\ **Post date:** [June 25, 2024, 3:17pm UTC](https://forums.plex.tv/t/no-database-optimization-because-of-changed-schema/880897/5 "2024-06-25T15:17:39Z")
Hello, Sure, how do you wish the logs files ? I’m not confident posting in public post with all private data. ---
**Author:** ![gbooker02](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/gbooker02/32/9726_2.png) [@gbooker02](https://forums.plex.tv/u/gbooker02)\ **Post date:** [June 26, 2024, 8:31pm UTC](https://forums.plex.tv/t/no-database-optimization-because-of-changed-schema/880897/6 "2024-06-26T20:31:11Z")
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. ---
**Author:** ![zicdeha](https://avatars.discourse-cdn.com/v4/letter/z/e79b87/32.png) [@zicdeha](https://forums.plex.tv/u/zicdeha)\ **Post date:** [June 27, 2024, 1:50pm UTC](https://forums.plex.tv/t/no-database-optimization-because-of-changed-schema/880897/7 "2024-06-27T13:50:56Z")
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 ? ---
**Author:** ![gbooker02](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/gbooker02/32/9726_2.png) [@gbooker02](https://forums.plex.tv/u/gbooker02)\ **Post date:** [July 2, 2024, 3:19pm UTC](https://forums.plex.tv/t/no-database-optimization-because-of-changed-schema/880897/8 "2024-07-02T15:19:29Z")
As I stated: > [@gbooker02](#): > > the logs indicate the optimization is complete. Do you have any indication of any issue other than this single query which I told you is not indicative of a problem? ---
**Author:** ![zicdeha](https://avatars.discourse-cdn.com/v4/letter/z/e79b87/32.png) [@zicdeha](https://forums.plex.tv/u/zicdeha)\ **Post date:** [July 4, 2024, 4:44pm UTC](https://forums.plex.tv/t/no-database-optimization-because-of-changed-schema/880897/9 "2024-07-04T16:44:23Z")
As far as I know, there is no visible trouble at the moment. ---
**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\ **Post date:** [October 2, 2024, 4:44pm UTC](https://forums.plex.tv/t/no-database-optimization-because-of-changed-schema/880897/10 "2024-10-02T16:44:58Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.