That’s bad and explains the slowness.
Executing a SQL query against a file that size will take time and cause the timeouts (locked database).
There is already a fix being circulated (in test) to remedy the problem.
I would like you to do the following:
- make certain
sqlite3is installed on the linux host. - stop plex
- On the Linux host side of the container
cd '/path/to/container/Library/Application Support/Plex Media Server/Plug-in Support/Databases'
echo 'select count(metadata_item_id),metadata_item_id from metadata_relations group by metadata_item_id order by count(metadata_item_id) desc limit 20' | sqlite3 com.plexapp.plug-ins.library.db
This will take a moment to run.
It will generate a report.
The report (query results) will be of the form ‘Count | Media_Item_Id’
If you have any media item IDs where the count > 50-60 (50-60 extras) then you are experiencing the known database problem.
A corrected version of Plex exists for the native host app but I don’t know if a docker container version exists. it’s not likely to exist.
We can fake out a native installation to use your existing docker container if you wish.
Please let me know your query results and how you wish to proceed
