Error opening Dashboard

server-mac

#1

I can not open the dashboard. I get this message: There was an unexpected error loading the dashboard
It also says to contact the forum so here we go. I updated to the latest version and now can not load the dashboard. I checked cpu usage and the iMac is fine with that. rebooted and stopped/restarted the PMS several times but can't seem to get it to work. Anyone with suggestions?


#2

Just downloaded the latest software: Version 1.13.2.5154. Still no Dashboard can anyone from Plex help me with this?


#3

Yup. I am having the same problem as of 2 days ago. Am on Version 1.13.3.5223. Did not do anything to my system or files at all. Just logged on 2 days ago and got the same error message as you “There was an unexpected error loading the dashboard. Please visit our forums if you continue to experience problems”.
Not a very technical person. Reading thru the forums not helping at all.

Anyone out there with a fix for this?


#4

There is an issue with you database. There is an article on how to rebuild the database but I restored a backup copy I had before the issue occurred and that fixed it.


#5

TDD,
Thanks for the invitation but two things:

  1. Log files (manually created ZIP of the Logs directory will work in a pinch
  2. I don’t know Macs. If it’s macOS unique, I’m useless. Fair enough?

#6

HI ChuckPA - yes I’m on macOS. Is there anyone in PLEX who knows macOS that can help? I’ve downloaded the logs for your perusal. Plex Media Server Logs_2018-07-10_13-53-21.zip (2.7 MB)


#7

This one doesn’t take a Mac team member. :frowning:

Your database was corrupted somehow (abrupt power off?)

Jul 10, 2018 10:03:34.534 [0x700008949000] DEBUG - Request: [127.0.0.1:59250 (Loopback)] GET /library/metadata/6300/tree (12 live) GZIP Signed-in Token (TDD)
Jul 10, 2018 10:03:34.536 [0x700008949000] ERROR - SQLITE3:0x70000819b590, 11, database corruption at line 59437 of [fc49f556e4]
Jul 10, 2018 10:03:34.536 [0x700008949000] ERROR - SQLITE3:0x70000819b590, 11, database corruption at line 59479 of [fc49f556e4]
Jul 10, 2018 10:03:34.536 [0x700008949000] ERROR - SQLITE3:0x70000819b590, 11, statement aborts at 204: [select metadata_items.id as 'metadata_items_id', metadata_items.metadata_type as 'metadata_items_metadata_type', metadata_items.title as 'metadata_items_title', metadata_items.parent_
Jul 10, 2018 10:03:34.536 [0x700008949000] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed

If you have your database backups enabled in Schedule Tasks, you can use a prior backup copy (scan files after copying in the backup).

Here’s the procedure.

https://support.plex.tv/articles/202485658-restore-a-database-backed-up-via-scheduled-tasks/


#8

hello i seem to be having the same issue, as i cannot find any of the plex files in the application support folder, i am also unable to delete the library files.

I m attaching my logs and database files if anyone can help

Plex Media Server Databases_2018-07-11_15-15-16.zip (22 Bytes)
Plex Media Server Logs_2018-07-11_15-15-24.zip (1.4 MB)


#9

There is no content to your logs. I believe you replied before upload completed.

If you see the same errors in your logs as shown above, follow the same link and perform the same procedure


#10

Plex Media Server Databases_2018-07-11_15-15-16.zip (22 Bytes)
Plex Media Server Logs_2018-07-11_15-15-24.zip (1.4 MB)


#11

@w4hala

Your database is indeed corrupt. Abrupt power off/power failure?

Jul 11, 2018 15:15:11.790 [0x700001782000] DEBUG - Request: [127.0.0.1:49801 (Loopback)] GET /diagnostics/databases (5 live) GZIP Signed-in Token (w4hala)
Jul 11, 2018 15:15:11.791 [0x700001782000] DEBUG - Diagnostics: Building database zip
Jul 11, 2018 15:15:11.812 [0x700001782000] DEBUG - Activity: registered new activity 8833fa39-426c-408e-8d60-5e481624f7d4 - Database
Jul 11, 2018 15:15:15.278 [0x700001782000] ERROR - SQLITE3:0x7000010da590, 11, database corruption at line 59437 of [fc49f556e4]
Jul 11, 2018 15:15:15.278 [0x700001782000] ERROR - SQLITE3:0x7000010da590, 11, database corruption at line 59479 of [fc49f556e4]
Jul 11, 2018 15:15:15.279 [0x700001782000] ERROR - SQLITE3:0x7000010da590, 11, database corruption at line 59437 of [fc49f556e4]
Jul 11, 2018 15:15:15.279 [0x700001782000] ERROR - SQLITE3:0x7000010da590, 11, database corruption at line 59479 of [fc49f556e4]
Jul 11, 2018 15:15:15.279 [0x700001782000] ERROR - SQLITE3:0x7000010da590, 11, database corruption at line 59437 of [fc49f556e4]
Jul 11, 2018 15:15:15.279 [0x700001782000] ERROR - SQLITE3:0x7000010da590, 11, database corruption at line 59479 of [fc49f556e4]
Jul 11, 2018 15:15:15.279 [0x700001782000] ERROR - SQLITE3:0x7000010da590, 11, database corruption at line 59437 of [fc49f556e4]
Jul 11, 2018 15:15:15.279 [0x700001782000] ERROR - SQLITE3:0x7000010da590, 11, database corruption at line 59479 of [fc49f556e4]
Jul 11, 2018 15:15:16.493 [0x700001782000] ERROR - The database failed its integrity check, not backing up.
Jul 11, 2018 15:15:16.494 [0x700001782000] DEBUG - Activity: Ended activity 8833fa39-426c-408e-8d60-5e481624f7d4.

If you have the database backups under Plex Media Server/Plug-in Support/Databases, you can restore to one of those using this procedure. https://support.plex.tv/articles/202485658-restore-a-database-backed-up-via-scheduled-tasks/?_ga=2.207377110.47310637.1529628278-1771450803.1526193491

If you do not have any, you must unfortunately delete it all and begin again.
After your next installation, I advise you to make certain you enable database backups at a time when your PMS will be known to be running/not sleeping.


#12

I have tried deleting but it keeps the corrupted server active


#13

Make sure the server is not running by quitting it from the Menu item in top menu bar.

44%20PM


#14

HI CheckPA - so I did not get to your reply until today but for whatever reason, my dashboard is back up. I did not do anything. Weird huh? Thanks for your prompt attention to this issue however. Cheers.