There was an unexpected error loading the dashboard

General Discussions
1

For weeks I have been getting the same error message when I try to load my dashboard “There was an unexpected error loading the dashboard”. I see the same issue being reported by many people in your discussion forums but no clear instructions (for a lay-person) on how to fix it. I was about to sign up for a Plex-pass, but this latest issue and the absence of any support on how to fix it has made me reconsider.

I have enabled debugging as suggested and attached my server logs. I am running version 1.12.1.4885 (which I just updated).

Can someone please give me clear concise instructions on how to fix a problem which as far as I can tell, multiple people are having?

2

Having the same problem. I just installed Plex, and was able to use it once before this error cropped up. Log attached. Running version 1.12.1.4885. Mac OS 10.12.6.

3

@“audiofan@comcast.net” said:
Having the same problem. I just installed Plex, and was able to use it once before this error cropped up. Log attached. Running version 1.12.1.4885. Mac OS 10.12.6.

From looking at your log, you need to repair your DB.

https://support.plex.tv/articles/201100678-repair-a-corrupt-database/

Line 3976: Mar 31, 2018 16:40:43.102 [0x70000ee4c000] ERROR - SQLITE3:0x70000e0fd590, 11, database corruption at line 72951 of [fc49f556e4]

4

@elit3ge said:

@“audiofan@comcast.net” said:
Having the same problem. I just installed Plex, and was able to use it once before this error cropped up. Log attached. Running version 1.12.1.4885. Mac OS 10.12.6.

From looking at your log, you need to repair your DB.

https://support.plex.tv/articles/201100678-repair-a-corrupt-database/

Line 3976: Mar 31, 2018 16:40:43.102 [0x70000ee4c000] ERROR - SQLITE3:0x70000e0fd590, 11, database corruption at line 72951 of [fc49f556e4]

I tried that already, didn’t work. So then I wiped everything out and started from scratch. Same problem.

5

And how can i check it on a NAS of Synology? The problem what i have is almost the same, i can optimize the database, that’s what helping sometimes. But for the rest i see that the system is switch off in the services of the NAS.

6

@AlexanderRink said:
And how can i check it on a NAS of Synology? The problem what i have is almost the same, i can optimize the database, that’s what helping sometimes. But for the rest i see that the system is switch off in the services of the NAS.

Stop Plex in software, browse the plex database with your computer, copy and paste to your desktop and then complete the task. Copy and paste the file back (make sure you make a copy of the original file just in case) and start the application again.

7

Update. As I wrote above, I wiped everything out and restarted, but had the same problem. So I wiped everything out again and restarted, but this time I added libraries one at a time. First, I added a Movies library, with about 2,500 movies. Waited a couple of days to make sure that all was working as it ought to. Then added a TV Shows library, with about 3,000 episodes. Again, waited a few days, everything working fine. Then added a Music library, with about 30,000 songs. Crash.

8

Could be timing out on requests that are now taking a long time -
We have seen this recently with large number of weeks set for on deck

Are you able to get logs of the dashboard loading now (after a database optimize ) and also to try again without the music and after adding the music - downloading logs for each test

Please ensure debug logging is enabled on the server

9

@“audiofan@comcast.net” said:
Update. As I wrote above, I wiped everything out and restarted, but had the same problem. So I wiped everything out again and restarted, but this time I added libraries one at a time. First, I added a Movies library, with about 2,500 movies. Waited a couple of days to make sure that all was working as it ought to. Then added a TV Shows library, with about 3,000 episodes. Again, waited a few days, everything working fine. Then added a Music library, with about 30,000 songs. Crash.

As follow up to my earlier reply

The original error to load the dashboard was clearly a database corruption as you found out - which led to response code 500 returned to the plex web app

Mar 31, 2018 16:38:55.246 [0x70000edc9000] DEBUG - Request: [127.0.0.1:50698 (Loopback)] GET /hubs?excludeFields=summary&count=12&includeEmpty=1&includeFeaturedTags=1&excludePlaylists=1 (9 live) GZIP Signed-in Token (audiofan@comcast.net)
Mar 31, 2018 16:38:55.403 [0x70000edc9000] ERROR - SQLITE3:0x70000e0fd590, 11, database corruption at line 72951 of [fc49f556e4]
Mar 31, 2018 16:38:55.404 [0x70000dff8000] DEBUG - Completed: [127.0.0.1:50698] 500 GET /hubs?excludeFields=summary&count=12&includeEmpty=1&includeFeaturedTags=1&excludePlaylists=1 (9 live) GZIP 158ms 405 bytes (pipelined: 5)

Mar 31, 2018 16:40:42.915 [0x70000ee4c000] DEBUG - Request: [127.0.0.1:52212 (Loopback)] GET /hubs?excludeFields=summary&count=12&includeEmpty=1&includeFeaturedTags=1&excludePlaylists=1 (8 live) GZIP Signed-in Token (audiofan@comcast.net)
Mar 31, 2018 16:40:43.102 [0x70000ee4c000] ERROR - SQLITE3:0x70000e0fd590, 11, database corruption at line 72951 of [fc49f556e4]
Mar 31, 2018 16:40:43.107 [0x70000dff8000] DEBUG - Completed: [127.0.0.1:52212] 500 GET /hubs?excludeFields=summary&count=12&includeEmpty=1&includeFeaturedTags=1&excludePlaylists=1 (8 live) GZIP 192ms 405 bytes (pipelined: 1)

As you are getting the dashboard error again, i would like to see if the database became corrupt again - or if we have a different issue - the one i mentioned with timeouts

10

@sa2000 said:

@“audiofan@comcast.net” said:
Update. As I wrote above, I wiped everything out and restarted, but had the same problem. So I wiped everything out again and restarted, but this time I added libraries one at a time. First, I added a Movies library, with about 2,500 movies. Waited a couple of days to make sure that all was working as it ought to. Then added a TV Shows library, with about 3,000 episodes. Again, waited a few days, everything working fine. Then added a Music library, with about 30,000 songs. Crash.

As follow up to my earlier reply

The original error to load the dashboard was clearly a database corruption as you found out - which led to response code 500 returned to the plex web app

Mar 31, 2018 16:38:55.246 [0x70000edc9000] DEBUG - Request: [127.0.0.1:50698 (Loopback)] GET /hubs?excludeFields=summary&count=12&includeEmpty=1&includeFeaturedTags=1&excludePlaylists=1 (9 live) GZIP Signed-in Token (audiofan@comcast.net)
Mar 31, 2018 16:38:55.403 [0x70000edc9000] ERROR - SQLITE3:0x70000e0fd590, 11, database corruption at line 72951 of [fc49f556e4]
Mar 31, 2018 16:38:55.404 [0x70000dff8000] DEBUG - Completed: [127.0.0.1:50698] 500 GET /hubs?excludeFields=summary&count=12&includeEmpty=1&includeFeaturedTags=1&excludePlaylists=1 (9 live) GZIP 158ms 405 bytes (pipelined: 5)

Mar 31, 2018 16:40:42.915 [0x70000ee4c000] DEBUG - Request: [127.0.0.1:52212 (Loopback)] GET /hubs?excludeFields=summary&count=12&includeEmpty=1&includeFeaturedTags=1&excludePlaylists=1 (8 live) GZIP Signed-in Token (audiofan@comcast.net)
Mar 31, 2018 16:40:43.102 [0x70000ee4c000] ERROR - SQLITE3:0x70000e0fd590, 11, database corruption at line 72951 of [fc49f556e4]
Mar 31, 2018 16:40:43.107 [0x70000dff8000] DEBUG - Completed: [127.0.0.1:52212] 500 GET /hubs?excludeFields=summary&count=12&includeEmpty=1&includeFeaturedTags=1&excludePlaylists=1 (8 live) GZIP 192ms 405 bytes (pipelined: 1)

As you are getting the dashboard error again, i would like to see if the database became corrupt again - or if we have a different issue - the one i mentioned with timeouts

OK, so I again wiped everything out, started anew. This time, the only thing that I did was to import iTunes playlists. It worked after a fashion for a while - it would actually load the playlists and play files, but only a fraction of the playlists loaded. Now, it has stopped working again. Attached is the log file.

11

@“audiofan@comcast.net” said:

@sa2000 said:

@“audiofan@comcast.net” said:
Update. As I wrote above, I wiped everything out and restarted, but had the same problem. So I wiped everything out again and restarted, but this time I added libraries one at a time. First, I added a Movies library, with about 2,500 movies. Waited a couple of days to make sure that all was working as it ought to. Then added a TV Shows library, with about 3,000 episodes. Again, waited a few days, everything working fine. Then added a Music library, with about 30,000 songs. Crash.

As follow up to my earlier reply

The original error to load the dashboard was clearly a database corruption as you found out - which led to response code 500 returned to the plex web app

Mar 31, 2018 16:38:55.246 [0x70000edc9000] DEBUG - Request: [127.0.0.1:50698 (Loopback)] GET /hubs?excludeFields=summary&count=12&includeEmpty=1&includeFeaturedTags=1&excludePlaylists=1 (9 live) GZIP Signed-in Token (audiofan@comcast.net)
Mar 31, 2018 16:38:55.403 [0x70000edc9000] ERROR - SQLITE3:0x70000e0fd590, 11, database corruption at line 72951 of [fc49f556e4]
Mar 31, 2018 16:38:55.404 [0x70000dff8000] DEBUG - Completed: [127.0.0.1:50698] 500 GET /hubs?excludeFields=summary&count=12&includeEmpty=1&includeFeaturedTags=1&excludePlaylists=1 (9 live) GZIP 158ms 405 bytes (pipelined: 5)

Mar 31, 2018 16:40:42.915 [0x70000ee4c000] DEBUG - Request: [127.0.0.1:52212 (Loopback)] GET /hubs?excludeFields=summary&count=12&includeEmpty=1&includeFeaturedTags=1&excludePlaylists=1 (8 live) GZIP Signed-in Token (audiofan@comcast.net)
Mar 31, 2018 16:40:43.102 [0x70000ee4c000] ERROR - SQLITE3:0x70000e0fd590, 11, database corruption at line 72951 of [fc49f556e4]
Mar 31, 2018 16:40:43.107 [0x70000dff8000] DEBUG - Completed: [127.0.0.1:52212] 500 GET /hubs?excludeFields=summary&count=12&includeEmpty=1&includeFeaturedTags=1&excludePlaylists=1 (8 live) GZIP 192ms 405 bytes (pipelined: 1)

As you are getting the dashboard error again, i would like to see if the database became corrupt again - or if we have a different issue - the one i mentioned with timeouts

OK, so I again wiped everything out, started anew. This time, the only thing that I did was to import iTunes playlists. It worked after a fashion for a while - it would actually load the playlists and play files, but only a fraction of the playlists loaded. Now, it has stopped working again. Attached is the log file.

There was some severe overload on the server creating thumbnails for loads of items
The iTunes import completed at 13:09:12

Apr 14, 2018 13:09:12.916 [0x700007e2a000] DEBUG - iTunes: There are 56154 audio tracks and 5308 video tracks.

But the server got overloaded when attempting to create thumbnails for the playlists when you accessed the web app at 16:48

During this period where the server was severely overloaded requests were taking too long

Apr 14, 2018 17:04:15.015 [0x700007a95000] DEBUG - Completed: [127.0.0.1:53313] 200 GET /hubs/home/recentlyAdded?type=8 (311 live) GZIP Page 12-38 921852ms 2442 bytes (pipelined: 4)

Could you tell me how many items in each playlist

You can get me lists of your playlists using the following requests in a browser (other than safari as that does not display xml)

The last dashboard request took 35 seconds to complete

Apr 14, 2018 17:46:53.945 [0x700008d84000] DEBUG - Request: [127.0.0.1:57063 (Loopback)] GET /hubs/home/recentlyAdded?type=8 (53 live) Page 0-38 GZIP Signed-in Token (greguva)
Apr 14, 2018 17:47:29.295 [0x700007b9b000] DEBUG - Completed: [127.0.0.1:57063] 200 GET /hubs/home/recentlyAdded?type=8 (5 live) GZIP Page 0-38 35360ms 3220 bytes (pipelined: 2)

Lets first optimize the database - see Library Actions Optimize Database on this article
https://support.plex.tv/articles/200392106-library-actions/

See if that makes a difference. It may take a while to complete the optimize and during that period the database would be locked out

After that get me information on the playlists
First you need to find out the server security token string as it would needed for the requests I am going you to do
To find your token - see https://support.plex.tv/articles/204059436-finding-an-authentication-token-x-plex-token/

Note that down and replace the xxxxxxxxxxx with it in the request below

On the server in a browser other than safari
http://127.0.0.1:32400/playlists/all?X-Plex-Token=xxxxxxxxxxxxxxxxx
Copy the results displayed into a text file and save as text file

If you continue to get issues, get new logs please

12

I have been having the same issue. I found that using a different browser solves this problem I switch from google to Microsoft edge. Edge works fine.

13

@“levpettett123@gmail.com” said:
I have been having the same issue. I found that using a different browser solves this problem I switch from google to Microsoft edge. Edge works fine.

That is interesting. Almost all cases of getting this error have been due to the time taken to get a response from the server.

14

yes when i open it. I have been having the same issue. I found that using a different browser solves this problem but i am unble to solve the problem. Quickpay

Geeta

15

I had the exact same problem and I tried all the things which people have been suggesting, database optimization etc.
However the real resolution (for me at least) is to just use a different web browser.
Fiirefox = not working
Edge = works fine

Hope this helps someone.

16

I know this is old, but this was absolutely the issue for me, and I didn’t see this suggested anywhere else yet. Thanks!

17

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.