# Strange errors in log - Redux - library.db **URL:** \ **Category:** Plex Media Server\ **Tags:** server-windows\ **Created:** [August 9, 2022, 9:37am UTC](https://forums.plex.tv/t/strange-errors-in-log-redux-library-db/803801 "2022-08-09T09:37:52Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Yaracuy](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/yaracuy/32/313162_2.png) [@Yaracuy](https://forums.plex.tv/u/Yaracuy)\ **Post date:** [August 9, 2022, 9:37am UTC](https://forums.plex.tv/t/strange-errors-in-log-redux-library-db/803801/1 "2022-08-09T09:37:52Z")
Server Version#: 1.28.1.6041 I’m seeing some errors in `Plex Media Server.log` regarding `com.plexapp.plugins.library.db` ```auto Aug 09, 2022 09:36:20.262 [9852] WARN - [Req#b2/Database optimization/com.plexapp.plugins.library.db/DatabaseFixups] Held transaction for too long (E:\jenkins\server\3580694791\Library\DatabaseFixups.cpp:217): 0.171875 seconds Aug 09, 2022 09:36:22.379 [9852] WARN - [Req#b2/Database optimization/com.plexapp.plugins.library.db] Held transaction for too long (E:\jenkins\server\3580694791\Library\FullTextSearch.cpp:58): 2.015625 seconds Aug 09, 2022 09:36:23.205 [9852] WARN - [Req#b2/Database optimization/com.plexapp.plugins.library.db] Held transaction for too long (E:\jenkins\server\3580694791\Library\FullTextSearch.cpp:71): 0.703125 seconds Aug 09, 2022 09:36:26.542 [9852] WARN - [Req#b2/Database optimization/com.plexapp.plugins.library.db] Held transaction for too long (E:\jenkins\server\3580694791\Library\FullTextSearch.cpp:81): 3.250000 seconds Aug 09, 2022 09:36:29.962 [9852] WARN - [Req#b2/Database optimization/com.plexapp.plugins.library.db] Held transaction for too long (E:\jenkins\server\3580694791\Library\FullTextSearch.cpp:94): 3.312500 seconds Aug 09, 2022 09:36:33.931 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.932 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.934 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.935 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.937 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.938 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.940 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.941 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.942 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.944 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.945 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.946 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.948 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.949 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.950 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.951 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.953 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.954 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed Aug 09, 2022 09:36:33.955 [9852] INFO - [Req#b2/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x940122cf, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed ``` I’ve done all the steps outlined here: [Repair a Corrupted Database | Plex Support](https://support.plex.tv/articles/repair-a-corrupted-database/) but the errors keep coming back. They happen when I try to optimize the database from Plex Web UI. I am afraid the process bails out before the database is optimized. PMS is otherwise working fine. Any clue how can I solve this? Many thanks! ---
**Author:** ![drzoidberg33](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/drzoidberg33/32/4184_2.png) [@drzoidberg33](https://forums.plex.tv/u/drzoidberg33)\ **Post date:** [August 9, 2022, 9:51am UTC](https://forums.plex.tv/t/strange-errors-in-log-redux-library-db/803801/2 "2022-08-09T09:51:15Z")
Nothing to solve, looks completely normal. ---
**Author:** ![Yaracuy](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/yaracuy/32/313162_2.png) [@Yaracuy](https://forums.plex.tv/u/Yaracuy)\ **Post date:** [August 9, 2022, 9:54am UTC](https://forums.plex.tv/t/strange-errors-in-log-redux-library-db/803801/3 "2022-08-09T09:54:46Z")
Thanks. The lines `Held transaction for too long` and `statement aborts at 58: [select * from metadata_items limit 1] database schema has changed` sounded a bit ominous to me. So the database optimization process runs as it should? ---
**Author:** ![dbirch](https://avatars.discourse-cdn.com/v4/letter/d/f19dbf/32.png) [@dbirch](https://forums.plex.tv/u/dbirch)\ **Post date:** [August 9, 2022, 12:35pm UTC](https://forums.plex.tv/t/strange-errors-in-log-redux-library-db/803801/4 "2022-08-09T12:35:02Z")
Those are fairly routine messages. Any time a query takes longer than expected (some low value in milliseconds) plex starts complaining about held transactions. The schema changes are normal during database upgrades and sometimes optimizations. ---
**Author:** ![Yaracuy](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/yaracuy/32/313162_2.png) [@Yaracuy](https://forums.plex.tv/u/Yaracuy)\ **Post date:** [August 9, 2022, 1:12pm UTC](https://forums.plex.tv/t/strange-errors-in-log-redux-library-db/803801/5 "2022-08-09T13:12:37Z")
Many thanks! Feel better now 🙂 ---
**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\ **Post date:** [November 7, 2022, 1:12pm UTC](https://forums.plex.tv/t/strange-errors-in-log-redux-library-db/803801/6 "2022-11-07T13:12:44Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.