Strange errors in log - Redux - library.db

Plex Media Server
1

Server Version#: 1.28.1.6041

I’m seeing some errors in Plex Media Server.log regarding com.plexapp.plugins.library.db

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 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!

2

Nothing to solve, looks completely normal.

3

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?

4

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.

5

Many thanks!

Feel better now :slightly_smiling_face:

6

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