Server Version 1.11.1.4753 on Windows 10 64Bit
My Plex dashboard is empty on all clients.
I have tried rebuilding a 3 day old backup database with sqlite3 - and then i get the dashboard back. Until i optimize the database. Then the dashboard is empty again. Rebuilding the current database solves nothing.
Once the current database is optimized, whatever corruption is in it, seems to be there to stay. Optomimizing seems to introduce the corruption. At least, tthe best i can sort out - that’s what it’s doing. I have not tried to re-install everything from scratch. My libraries are very extensive and i have about a dozen users. It’s too much to loose. I have not tried going to an older version of plex - i don’t know how.
My rebuild procedure is as follows:
A. sqlite3 com.plexapp.plugins.library.db .dump > dump.sql
B. rename com.plexapp.plugins.library.db com.plexapp.plugins.library.db.original
C. sqlite3 com.plexapp.plugins.library.db < dump.sql
Any help would be appreciated. I’m at my wits end sort this out.
Oh, i forgot to mention my layout. Plex server is running on an SSD - local drive c. Plex databases are on a different ssd - local drive d. My library is on 3 local hard disks. The server is a 6 Core FX6300 with 16gB ram. This entire issue started more or less after Jan 28, 2018.
I have the same problem since the latest update.
The Dashboard is empty for all users except the main Plex Admin user on all tested applications (Plex web via browser, Windows App and LG TV App.).
Having looked further down the forum page I see that a member of the Plex team has said this is a known issue and they are looking to fix it as soon as possible.
The thread link is below.
I do see one difference between what i read (for what you just posted) and what i have. In my case, even the Plex admin user has this blank dashboard issue. I do however have things in common with what was described as the problem: a number of my users do indeed have library restrictions. But in my case, even the ones that have no restrictions (including the admin) have a blank dashboard.
… also, that being said, i do not get an error message stating “there was an unexpected eror loading the dashboard”. I get no error message. I just have a blank dashboard. I did check into the settings regarding at each library you can include or not this libray form the dashboard. They are all checked ot be included.
I’m just hoping the issues the other are having is the same issue i am having and there is a fix on the way.
@Burninator_237 said:
I do see one difference between what i read (for what you just posted) and what i have. In my case, even the Plex admin user has this blank dashboard issue. I do however have things in common with what was described as the problem: a number of my users do indeed have library restrictions. But in my case, even the ones that have no restrictions (including the admin) have a blank dashboard.
if the admin account is getting this then it could be database corruption
Please get logs from the server after the problem arises and indicate time of the issue
See https://support.plex.tv/articles/201643703-reporting-issues-with-plex-media-server/
https://support.plex.tv/articles/200250417-plex-media-server-log-files/
@sa2000 said:
@Burninator_237 said:
I do see one difference between what i read (for what you just posted) and what i have. In my case, even the Plex admin user has this blank dashboard issue. I do however have things in common with what was described as the problem: a number of my users do indeed have library restrictions. But in my case, even the ones that have no restrictions (including the admin) have a blank dashboard.if the admin account is getting this then it could be database corruption
Please get logs from the server after the problem arises and indicate time of the issue
See https://support.plex.tv/articles/201643703-reporting-issues-with-plex-media-server/
https://support.plex.tv/articles/200250417-plex-media-server-log-files/
I will collect the logs and send them through. To recreate the corruption, i use sqlite3 to rebuild a previous backed up database, then install the database and start Plex. At this point it is still showing the dashboard. Then I run the database optimization, and then open a client and the dashboard is empty. There is no “error” popping up on the screen. It just says “your dashboard is empty” in the middle of the dashboard screen. Does any of this create any issues for you with regards to the creation of the logs?
@Burninator_237 said:
@sa2000 said:
@Burninator_237 said:
I do see one difference between what i read (for what you just posted) and what i have. In my case, even the Plex admin user has this blank dashboard issue. I do however have things in common with what was described as the problem: a number of my users do indeed have library restrictions. But in my case, even the ones that have no restrictions (including the admin) have a blank dashboard.if the admin account is getting this then it could be database corruption
Please get logs from the server after the problem arises and indicate time of the issue
See https://support.plex.tv/articles/201643703-reporting-issues-with-plex-media-server/
https://support.plex.tv/articles/200250417-plex-media-server-log-files/I will collect the logs and send them through. To recreate the corruption, i use sqlite3 to rebuild a previous backed up database, then install the database and start Plex. At this point it is still showing the dashboard. Then I run the database optimization, and then open a client and the dashboard is empty. There is no “error” popping up on the screen. It just says “your dashboard is empty” in the middle of the dashboard screen. Does any of this create any issues for you with regards to the creation of the logs?
would this be whilst the optimization is in progress or after it completes ?
Anyway- logs hopefully would show the problem
@sa2000 said:
@Burninator_237 said:
@sa2000 said:
@Burninator_237 said:
I do see one difference between what i read (for what you just posted) and what i have. In my case, even the Plex admin user has this blank dashboard issue. I do however have things in common with what was described as the problem: a number of my users do indeed have library restrictions. But in my case, even the ones that have no restrictions (including the admin) have a blank dashboard.if the admin account is getting this then it could be database corruption
Please get logs from the server after the problem arises and indicate time of the issue
See https://support.plex.tv/articles/201643703-reporting-issues-with-plex-media-server/
https://support.plex.tv/articles/200250417-plex-media-server-log-files/I will collect the logs and send them through. To recreate the corruption, i use sqlite3 to rebuild a previous backed up database, then install the database and start Plex. At this point it is still showing the dashboard. Then I run the database optimization, and then open a client and the dashboard is empty. There is no “error” popping up on the screen. It just says “your dashboard is empty” in the middle of the dashboard screen. Does any of this create any issues for you with regards to the creation of the logs?
would this be whilst the optimization is in progress or after it completes ?
Anyway- logs hopefully would show the problem
Part of the problem is it does not give me any kind of error in the interface when i open the dashboard. it’s just empty, and it ssays it’s empty.
I wait until after the optimization is complete for the emply dashbvoard to occur. So it’s as though the optimization process is doing the corrupting. The order i gave you is exactly my procedure. When the optimization is complete, if i re-open the dashboard, the dashboard is empty. I’m just not clear on whether i have to log in and out or not for the dashboard to be empty. But i can supply that information.
I will send that information through tonight.
Let me know if any of this is unclear.
And let me know the next step when you have looked through the logs.
This is a big library.
Here we go… it appears the no dashboard appears after a full libray scan. I supply the details and log files here.
I did the entire process twice, the difference between the 2 is the order in which i did optimize database and scan library files.
The empty dashboard issue always appears after the scan library files is completed.
it shows up as empty in the first trial procedure in line index 5.36
In the 2nd test it shows up at time index 5.52
Please note, my time indexes are not from the database itself, but from the windows 10 desktop clock.
Previous to this, from time 5.28 to time 5.37, i also did a rebuild
5.28 Reastart server after rebuild - log in - dashboard exists - log out
5.29 Optimize database
5.30 log out - log in - dashboard exist
5.31 Clean bundles - log out - log in - dashboard exists
5.32 Scan library files
5.36 Log out - log in - dashboard empty
5.37 - optimize libraries again - log out - log in - no dashboard
Rebuild Jan 28 2018 database with sqlite3
5.46 Restart plex with rebuilt database - log in - dashbaord exists - log out
5.47 Log in - dashboard exists
5.47 start scan library files
5.52 scan complete - dashboard exists - log out - log in - dashboard empty
5.53 optimize database - log out - log in - no dashboard
5.55 clean bundles - log out - log in - no dashboard
5.56 download logs
@Burninator_237 said:
Here we go… it appears the no dashboard appears after a full libray scan. I supply the details and log files here.
I did the entire process twice, the difference between the 2 is the order in which i did optimize database and scan library files.
The empty dashboard issue always appears after the scan library files is completed.it shows up as empty in the first trial procedure in line index 5.36
In the 2nd test it shows up at time index 5.52Please note, my time indexes are not from the database itself, but from the windows 10 desktop clock.
Previous to this, from time 5.28 to time 5.37, i also did a rebuild
5.28 Reastart server after rebuild - log in - dashboard exists - log out
5.29 Optimize database
5.30 log out - log in - dashboard exist
5.31 Clean bundles - log out - log in - dashboard exists
5.32 Scan library files
5.36 Log out - log in - dashboard empty
5.37 - optimize libraries again - log out - log in - no dashboardRebuild Jan 28 2018 database with sqlite3
5.46 Restart plex with rebuilt database - log in - dashbaord exists - log out
5.47 Log in - dashboard exists
5.47 start scan library files
5.52 scan complete - dashboard exists - log out - log in - dashboard empty
5.53 optimize database - log out - log in - no dashboard
5.55 clean bundles - log out - log in - no dashboard5.56 download logs
Thanks for all the logs and detail.
I have not been able to find any errors in the requests for the dashboard - so i need to get into more detail and actually look at xml returned for the dashboard related requests and also get screenshots noting the exact time and what url is showing on the dashboard screen
The individual requests you can enter in a browser on the server and then copy the displayed xml for each into a separate text file - clearly marking it so we match xml to actual requests
The requests you enter will need to have the server security token so please find that out and note it down to include in rach request. Do not post here any text that has the token string. It should not be in the xml - it would only be in what you type in as the url for each request
To find the server security token (known as X-Plex-Token) see https://support.plex.tv/articles/204059436-finding-an-authentication-token-x-plex-token/
These are the dashboard related requests that were being made at the time
http://localhost:32400/hubs/home/continueWatching?X-Plex-Token=xxxxxxxxxxxxxxxxxxxxxxxx
http://localhost:32400/hubs/home/onDeck?X-Plex-Token=xxxxxxxxxxxxxxxxxxxxxxxx
http://localhost:32400/hubs/home/recentlyAdded?type=1&X-Plex-Token=xxxxxxxxxxxxxxxxxxxxxxxx
http://localhost:32400/hubs/home/recentlyAdded?type=1&personal=1&X-Plex-Token=xxxxxxxxxxxxxxxxxxxxxxxx
http://localhost:32400/hubs/home/recentlyAdded?type=2&X-Plex-Token=xxxxxxxxxxxxxxxxxxxxxxxx
http://localhost:32400/hubs/home/recentlyAdded?type=8&X-Plex-Token=xxxxxxxxxxxxxxxxxxxxxxxx
http://localhost:32400/hubs/home/recentlyAdded?type=13&X-Plex-Token=xxxxxxxxxxxxxxxxxxxxxxxx
http://localhost:32400/hubs?excludeFields=summary&count=12&includeEmpty=1&includeFeaturedTags=1&excludePlaylists=1&X-Plex-Token=xxxxxxxxxxxxxxxxxxxxxxxx
http://localhost:32400/hubs?excludeFields=summary&count=12&includeEmpty=1&includeFeaturedTags=1&excludePlaylists=1&onlyTransient=1&X-Plex-Token=xxxxxxxxxxxxxxxxxxxxxxxx
I am sorry it will be a bit tedious - 9 requests to be made when dashboard is there and again 9 requests when dashboard is not there. The xxxxxxxxxxxxxxxxxxxxxx is to be replaced on each with your server security token
When dashboard disappears I would need a screenshot showing the url and the time when the empty dashboard pops up
If you like you can name the filenames 1 to 9 in same order as above
By the way if you a lot of tests the logs may not go back to the beginning of the tests. For example in your previous tests the logs only went back to 05:34
So suggest capturing the logs when the dashboard is there and getting the 9 requests
and please take a screenshot of the dashboard being visible as well
and then capture the logs again when the dashboard disappears and the screenshot and time and url and the 9 requests
This is going to take me a bit of time.
And the information is going to get confusing fast
To be clear on my normal procedure to show the event, i rebuild a database from Jan 28 and get it running in Plex - the dashboard will be showing. The first time it scans the library files - the dashboard will disappear. I need some time to get the information you want and i dont know if i can temporarily disable automatic rescanning of the files. it will want to rescan as there is new media available since Jan 28. If i rebuild the current database instead, it’s no good to use as i cannot get the dashboard to show up at all using the current database.
But i need clarification on a couple of things.
Can you clarifiy this next item for me -
----So suggest capturing the logs when the dashboard is there and getting the 9 requests
and please take a screenshot of the dashboard being visible as well----
You want to “download the logs” for every event - or are you just looking for one partiuclar log file or what? When exactly do you want me to get logs and how? Running “Download logs” - for every event - and then attaching them for you - is going to be one huge pile of logs.
Y0u also want informaiton at the time the dashboard disappears. it will disppear when i run a library re-scan, and then try rto go to the home dashboard. There is no error message or anything. The dashbaord justs says “your dashboard is empty”. So i’ll run a rescan and then you want what exactly to try to get the information?
And, in the end, you want me to create text files for the xml, screen captures at certtain times and log files, and then .zip it all up and attach it here?
I also want to quick note again to eliminate this as an issue that my database is on the same pc as plex, but it is on a different ssd and path than plex is.
You want to “download the logs” for every event - or are you just looking for one partiuclar log file or what? When exactly do you want me to get logs and how? Running “Download logs” - for every event - and then attaching them for you - is going to be one huge pile of logs
I want 2 zip files - one captured when the dashboard is there and one captured when the dashboard is not there. Not huge pile - just 2 files from you (2 zip files) - too many files in the zip is my problem and I can cope with that
The screenshots give me the url at the top of the browser and the time as well as indicator whether empty dashboard or not
I do not want xml screen captures
But scraping the screen contents as text into notepad / text editor for each. Select all on screen, copy and paste text into file and save each file as req-1a req-2a etc and then req-1b req2-b etc and zip before attaching
so we have for the 2
dashboard present
1 zip of logs
1 screenshot showing url and time
1 zip fo reqs 9 xml text files
dashboard absent
1 zip of logs
1 screenshot showing url and time
1 zip of reqs 9 xml text files
You can PM me the 6 files if you prefer
@Burninator_237 said:
I also want to quick note again to eliminate this as an issue that my database is on the same pc as plex, but it is on a different ssd and path than plex is.
The database is here D:\Users\Admin\Appdata\Local\Plex Media Server\Plug-in Support\Databases\
and as long as it is an internal drive and always available - that is ok
Can i temporarily disable the library scanners to give me time to work?
@Burninator_237 said:
Can i temporarily disable the library scanners to give me time to work?
See settings / server / library / show advanced
There are two settings - one for periodic scans and one for automatic updates
Ok, i have the data. I laid it out a little bit different. I hope this isnt an issue. if it is i can re-lay it out for you and send it again.
There are 2 zipped folders. 1 called “dashboard exists” and 1 called “dashboard gone”
I will PM you the 2 zipped folders right after i complete this note.
Each folder contains:
2 sets of log files - 1 before i started and 1 after i completed.
2 jpeg images - 1 dashboard when i started, 1 dashboard when i finished.
1 set of (9) text files with xml data.
1 text file called notes.txt which has some details of what happened as i followed through the procedures to create the 9 files.
1 text file is empty in the “dashboard exists” folder as Chrome could not generate the data. I discovered when i did the same for the same test in “dashbaord gone”, that chrome also couldn’t produce it, but Microsft edge could. It acts like it’s an issue of sheer amounts of data - chrome tries to buffer it all before displaying - and it can’t - and Edge streams it to the screen as the data is being produced. I did not start all over just so i could recreate the 1 file in the dashboard exists section.
“Dashboard gone” test result text files have some in which Chrome produced an error and no data - the error is shown in the file. If i tried to use Edge to create the same file, Edge just produced nothing but a blank screen - nothing at all on the html page.
Thank you - I will look at it all later this evening
Thanks for your help
