I recently noticed when trying to remove the old Plex Arcade Games Library I am no longer able to access the manage library settings on the Plex Server. I have done a repair install and uninstall/reinstall same issue. I don’t normally go into this setting so I am not sure when this actually started. This is what I get when I try to access that option on the server.
Server Version#: 1.28.2.6151
Player Version#:N/A
I performed those actions and reclaimed the server. Same issue is present when trying to access the manage library settings.
Restart/reboot the server and let it sit a few minutes.
After reclaiming the server, I recommend you to force-reload the web app.
Signing out of the web app and back in can’t hurt either. (use the Sign Out link under user avatar in the upper-right corner)
Same results after following those directions… Let it sit for about 45mins.
Which browser are you using?
Any browser add-ons installed?
Are internet filters active, like pi-hole or similar?
Any VPN software? (Or remnants thereof)
I am using chrome but receive the same results with edge. No add-ons. No filters or vpn. I tested with a clean install of plex server and the option works so I assume it is a broken setting/file somewhere?
How did you test this? On a different computer or different Windows user account?
Yes this was on another machine. I could completely remove all plex data on the server as I have a copy of the plex server data folder but i feel that would result in the same thing as I saw on the other machine with a clean install.
So it is definitely the data base file “com.plexapp.plugins.library.db”. If I delete that the library option in settings shows up. Obviously with nothing in it though. Is there a way to find out what in there maybe an issue. I have run the plex recommended options to check for corruption with nothing coming back as an issue.
I have tried the .dump and the .recover both to no avail. I did get a “no such collation sequence icu_root” error at one point but was able to run this command to remove it " `sqlite3 com.plexapp.plugins.library.db “DROP index ‘index_title_sort_icu’”
I also opened the database and tried to find any lines that might say “corruption error” but also did not come back with anything.
I am at a loss at what else it could be causing it. The integrity check comes back ok though.
Are you using the plex sqllite or some other sqllite program?
I used both plex and sqlite3 to perform the various functions. Testing if either made one difference or another.
If you mixed the two editors you may have caused more damage. Plex uses a custom version of sqllite. Do you have a copy of the database prior to edit attempts? Another question is, do you need the database or is starting over OK?
I have copies yes. I restored back to the original after each attempt.
Would I like to keep the database of course if possible but if there is truly no way to recover it then that maybe my only option.
can you post your server logs? Might be able to give some more insight into what needs fixed
Of course.
Not sure which database you where trying to fix, but it looks like the error is in com.plexapp.plugins.library.db-wal Might want to close plex, and just delete that file, along with clearing everything in the /logs directory and seeing if the issue persists. If so, can I get a clean set of logs after recreating the error you screenshot?
So that file is created when plex is started and deleted once I close out of plex. I cleared the logs and went back to the manage libraries tab where the error is and these are the logs.
Im coming up with nothing, perhaps one of the Ninja’s will see something I missed.
