I have a lot of TV-Series on my local Plex server and made the mistake of selecting them all and specifying “Optimize” for them all (even though they’d already been optimized). Now I have over 2000 queued conversions. I can select them one at a time and delete them, but that will take a very long time.
Is there any other way to clear the queued Optimize Conversions?
I realized that the list is going to be stored somewhere in the sqLite database.
The help page at where is the plex media database located let me find the database location, and then I could extract the DDLs for the tables and search around. While it wasn’t initially obvious, it turns out that the table “play_queue_items” contains the queued optimize conversions.
Removing the items from that table worked, but soon after restarting the plex server those entries appear in the queue again; so, I must be missing some other location where this data is stored.
I had one entry in the “play_queue_generators” table which was dated today, so I stopped the plex server, deleted that entry and cleared the “play_queue_items” again. That seems to have done the trick.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
