Server Version#:1.42.10060-700010060
Player Version#:1.110.0.351-4e48eb83
Actions:
Deselected opportunistic Locking in Synology File settings
Selected “Database Optimisation” in Plex.
Immediatedly my Server was unreachable, and after restarting PLex, I have no way of monitoring the Optimization process (or see if anything is ■■■■■■ up !)
How long is this going to take ? I thought it could run in the background, but it seems like doomsday have arrived, and I have absolutely no clue what to do now ?
Media libraries is around 21 TB in total. Databases looks like 440 MB
That optimization shouldnt take that long, an hour or two at most for a database your size. does http://[Local Plex Media Server IP Address]:32400/web show anything? If its been at least an hour I would post a copy of your server logs. Rebooting Plex in the middle of a database process, may have caused issues.
I was not rebooting the PMS. I was only restarting the Plex app.
The Plex Media Server is still running.
I cannot access the server via Plex App, so it is not possible to access any server logs either.
This is the issue, that the database optimization process blocks any access to the Plex Media Server, and leave no options for monitoring the process or access data logs etc.
I think Plex locks the database while optimization is running so the DB doesn’t get corrupted if a user tries to write on it. AFAIR the very first run could take much longer (after the 2nd time it is usually much faster).
thanks. Its is still running , I guess, and I have not done anything to stop it. I am just really confused why there are absolutely no warning, or ways to monitor the process while it is running. A simple status bar would be sufficient, as to show all is well, and how much is left.
Allright, Ill let it run overnight , and post any news here…
I hope the developers see this… This is crazy scary ■■■■ !
PMS doesn’t know the status of the process. External program “Plex SQLite” (sqlite3 with additions) does the work. sqlite3 does not provide feedback)
Given what I see in the screenshot above,
The database size is within reason.
PMS optimizing is a “Vacuum” operation which just removes the empty space without any actual optimization (repack it)
The optimization I perform is a full “export and rebuild”.
I export the tables (in order) and then import into a new DB in that perfect table-sorted and packed order.
PMS’ optimize will still contain fragmentation (like a HDD).
My optimize puts the tables (“files”) in contiguous order.
Before giving a suggested action plan,
How versed are you at the SSH command line (Linux shell) ?
Thankyou very much for your feedback and explanations.
I am not at all versed in any programming and command lines. I dont know what SSH Linux shell is…
It is now next morning, and the process has been running 14 Hours at this point. Still no access to my PMS.
And to be honest, I find this situation unreasonable. There should be at least a hefty warning prompt when clicking “optimize database”
It doesnt make sense that a single click in Plex plunges one into days of unknown terror. Who , what and when would it be known if something went wrong, or if the process is running at all ??? There are no way to monitor this , not from Plex (since I cannot access my server via Plex) and neither from Synology DSM.
In my humble opinion, it would be brilliant , if there at least was a status bar somewhere in Synology DSM (Package center, etc)
But all this agony aside, what do you suggest , regarding Plex SQLite and SSH command lines ?
My HDDs are fine and well, and I never had any trouble with my databases before.
Reason for fiddling with optimization, was some issues with slow UI in Plex, and bad transcoding. I was trying to find the correct settings, to play directly from my NAS (via ethernet) - so perhaps once I get my server back, you can help me with these settings ?
