DNS issue has not been resolved, still cannot connect

[BigWheel]

@RSWilliams62

I am using OpenDNS also for years with Plex and it worked until 2 days ago

Nothing changed on our end two days ago. what there was a couple days ago was a global outage of DNS services throughout the planet effecting multiple companies. I also use OpenDNS as do others without issue. Like mentioned above I would try what this user did.

I cannot access my server with a browser but i can with the Plex app

My setup is also using Pi-Hole. I went into Settings - DNS and switch my ipv4 settings from OpenDNS to Quad9 (filtered, DNSSEC). After i made the change on Pi-Hole, i close my browser and reopen app.plex.tv with the new dns settings in pi-hole. I had to do that for each PC in my house using the link before switching back to OpenDNS.

[L3gion]

@BigWheel, did you have chance to look at the logs I sent you?

I tried all suggested fixes, still have no access, dns flush, restarted everything, changed pi-hole settings, switched to cloudflare, google, quad9, disabled pi-hole and connect to google DNS directly, nothing worked.

PMS Version 1.23.5.4862 (repository:plexinc/pms-docker)

[BigWheel]

@L3gion Apologies. i did, was just very hectic the last few days and forgot to get back to you. I don’t see anything wrong with your server network-wise but you do seem to have database corruption causing things not to load.

Jul 22, 2021 23:05:18.699 [0x1544792f9b38] ERROR - SQLITE3:0x80000001, 11, database corruption at line 81887 of [1b256d97b5]
Jul 22, 2021 23:05:18.699 [0x1544792f9b38] ERROR - SQLITE3:0x80000001, 11, statement aborts at 16: [select metadata_items.id from metadata_item_settings join metadata_items on metadata_items.guid=metadata_item_settings.guid and metadata_item_settings.account_id=? where  view_offset>0
Jul 22, 2021 23:05:18.699 [0x1544792f9b38] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed

You can either restore a back up or try to repair it .

[RSWilliams62]

Yep did a DNS flip from OpenDNS to another, then changed it back. seems to work for now.

[L3gion]

Hey, back with good news @BigWheel.

Followed your recommendation of rolling back the database (app restore from a week ago via unraid) and that finally fixed my issues.

Would be great if we got some type to warning in Plex about this type database corruption.
Something like: database was unable to load “database disk image is malformed”
This would help a lot and save users and devs some time going over logs.

Thanks for the help.

[BigWheel]

@L3gion

Would be great if we got some type to warning in Plex about this type database corruption.
Something like: database was unable to load “database disk image is malformed”

it is a mobile app notification option. https://support.plex.tv/articles/push-notifications/ But I will ask about it being added to web browser app