Server Version#: 1.40.0.7996-4956e330f I am getting the error about the database and it has been 24 hours since 1.40.0.7996 was installed. How can I go about fixing the database? Feb 08, 2024 10:31:49.458 [139963157056312] INFO - [Req#265c2/Database optimization/com.plexapp.plugins.library.db] SQ…

It says Info, not Error. These messages are normal at the first start after a server version upgrade.

How long will I see the message for after the upgrade. It has been over 24 hours since the upgrade and I still can’t optimize the database.

These logs might also be relevant as well. Feb 08, 2024 15:38:40.132 [139861146823480] WARN - [Req#4a1] QueryParser: Invalid field ‘contentDirectoryID’ found, ignoring. Feb 08, 2024 15:38:40.140 [139861158001464] WARN - [Req#4a0] QueryParser: Invalid field ‘sectionID’ found, ignoring. Feb 08, 202…

What happens when you try to optimize the database?

According to the logs it doesn’t say it completed. I am experiencing log load times when I click on a library so I started looking into the logs and found these errors. Feb 08, 2024 16:19:52.505 [139861093010232] WARN - [Req#411b8] QueryParser: Invalid field ‘contentDirectoryID’ found, ignoring. F…

Any 3rd party tools accessing the database? There were a couple of threads a few weeks ago regarding Plex Meta Manager. It would sometimes cause slow query warnings when accessing the Plex database. Try the Plex DBRepair Utility: GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Me…

Thanks, I have tried that that utility but there was no change. I also used the official Plex guide to repair a corrupt database. Both of the result in the same. I do have a couple applications integrated into plex. I will disable them to see if it fixes the slowness.

I just updated PMS on my Synology NAS and then manually optimized the database. The database optimization completed. Feb 08, 2024 10:44:04.996 [140482405448504] DEBUG - [Req#a255/Database optimization/com.plexapp.plugins.library.db] Database optimization: complete. There were several INFO “statem…

If I may add ? One of the options available to you REPLACE. This is where you use one of the PMS-generated backups. (It is the same procedure as documented on the Plex support pages) Please read through the documentation provided for DBRepair and consider if you want to let it do the manual wor…

All the log extracts you pasted suggest you have disabled Debug Logging To investigate and see what is happening to the db optimization thread, debug logging is needed The warnings / errors you pasted are all normal - even the “Held transaction for too long” warning is normal when an optimize is i…

Optimize database not working after upgrade to 1.40.0.7996-4956e330f

Plex Media Server Plex Pass Betas

freakdude February 29, 2024, 4:22pm 14

Thanks everyone for the recommendations. Looks like my issue is related to the new version as pointed out here.

This can be closed.

Topic		Replies	Views
[Req#46c8/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x7f97147a18, 17, statement Plex Media Server server-synology , media-optimizer	5	79	October 11, 2023
Upgrade to 1.40.0.7998 causes error Plex Media Server server-windows	51	7147	July 14, 2024
Optimize error General Discussions	5	120	January 7, 2020
No database optimization because of changed schema Plex Media Server server-linux	9	211	October 2, 2024
Errors during Startup (still starts), then Optimize causes malformed disk image Plex Media Server server-linux	13	153	March 19, 2023

Optimize database not working after upgrade to 1.40.0.7996-4956e330f

Related topics