I deleted everything last night, way too many problems. I then created new libraries:
I was hoping I could finally relax and watch something good but obviously not, there was an unexpected error… Expected or not, what difference does it make? I am SO tired with Plex, it is SO unreliable. That’s why I pay a subscription to Netflix and thanks to them, I will relax and watch something good.
It could either be a Corrupt database or may be needs to be optimized if a lot of media getting added
Try to optimize first
See https://support.plex.tv/articles/200392106-library-actions/
If problem persists get server logs
See
https://support.plex.tv/articles/201643703-reporting-issues-with-plex-media-server/
https://support.plex.tv/articles/200250417-plex-media-server-log-files/
There are multiple errors. Optimizing the libraries didn’t change anything. I’m deleting the libraries again and restart fresh like I did last night. I’ve never had any problem installing libraries before… It seems like I got errors after installing the plugins. Hopefully it’ll work this time…
Here are the logs. errors in the database, IOError: [Errno 2], File “/Applications/Plex Media Server.app/Contents/Resources/Plugin215c28d86/Framework.bundle/Contents/Resources/Versions/2/Python/Framework/api/parsekit.py”, line 22, in check_size
if len(data) > max_size:
TypeError: object of type ‘NoneType’ has no len()
@chop-shop said:
There are multiple errors. Optimizing the libraries didn’t change anything. I’m deleting the libraries again and restart fresh like I did last night. I’ve never had any problem installing libraries before… It seems like I got errors after installing the plugins. Hopefully it’ll work this time…Here are the logs. errors in the database, IOError: [Errno 2], File “/Applications/Plex Media Server.app/Contents/Resources/Plugin215c28d86/Framework.bundle/Contents/Resources/Versions/2/Python/Framework/api/parsekit.py”, line 22, in check_size
if len(data) > max_size:
TypeError: object of type ‘NoneType’ has no len()
it is a database corruption issue
Apr 22, 2018 01:13:55.085 [0x70000cf07000] DEBUG - Request: [127.0.0.1:60136 (Loopback)] GET /hubs?excludeFields=summary&count=12&includeEmpty=1&includeFeaturedTags=1&excludePlaylists=1 (11 live) GZIP Signed-in Token (chop-shop)
Apr 22, 2018 01:13:55.085 [0x70000cf07000] DEBUG - HubCache: Adding '1/home.continue/hubs/12/en' to the cache (1/home.continue/hubs/12/en).
Apr 22, 2018 01:13:55.085 [0x70000cf07000] DEBUG - HubCache: Adding '1/home.ondeck/hubs/12/en' to the cache (1/home.ondeck/hubs/12/en).
Apr 22, 2018 01:13:55.093 [0x70000cf07000] ERROR - SQLITE3:0x70000c341590, 11, database corruption at line 72951 of [fc49f556e4]
Apr 22, 2018 01:13:55.093 [0x70000cf07000] ERROR - SQLITE3:0x70000c341590, 11, statement aborts at 14: [select grandparents.id from metadata_items INDEXED BY index_metadata_items_on_library_section_id_and_metadata_type_and_added_at join metadata_items as parents on metadata_items.parent_
Apr 22, 2018 01:13:55.094 [0x70000cf07000] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed
Apr 22, 2018 01:13:55.094 [0x70000c654000] DEBUG - Completed: [127.0.0.1:60136] 500 GET /hubs?excludeFields=summary&count=12&includeEmpty=1&includeFeaturedTags=1&excludePlaylists=1 (11 live) GZIP 9ms 405 bytes (pipelined: 11)
Please see these support articles
https://support.plex.tv/articles/201100678-repair-a-corrupt-database/
https://support.plex.tv/articles/202485658-restore-a-database-backed-up-via-scheduled-tasks/
Thank you, I guess there is a network corruption too now because suddenly, Plex on the AppleTV, on the Roku or on the TV itself can’t find the server that is on the same ethernet or Wi-Fi network (I’ve tried both) also Plex refuses to match the new movies I recently added. Having to sign in every single time I open that more and more problematic app bothers me enough but today it decided I had to create a new password. Will it ever stop bothering me and just work as it used to or is it gonna be more headache that pleasure? I am asking because after using Plex every day for the past 5 or 6 years, I’m seriously considering getting rid ot it…
it is getting better and better : http://127.0.0.1:32400/web/index.html get me to:
This site can’t be reached
127.0.0.1 refused to connect.
Try:
Checking the connection
Checking the proxy and the firewall
ERR_CONNECTION_REFUSED
and of course: Plex Cloud no longer scans new files automatically. Please select Scan Library Files after uploading new media to a Plex Cloud library to see it.
ENOUGH IS ENOUGH, BYE BYE PLEX, BYE BYE HEADACHES…
@chop-shop said:
and of course: Plex Cloud no longer scans new files automatically. Please select Scan Library Files after uploading new media to a Plex Cloud library to see it.ENOUGH IS ENOUGH, BYE BYE PLEX, BYE BYE HEADACHES…
Suey, really it works well if your set it up correct. Get your Chop shop in order have a Paracetamol or 5
@chop-shop said:
it is getting better and better : http://127.0.0.1:32400/web/index.html get me to:This site can’t be reached
127.0.0.1 refused to connect.
Try:
Checking the connection
Checking the proxy and the firewall
ERR_CONNECTION_REFUSED
I am sorry to hear that you have other issues - we can resolve such problems from log files. It could be for example that you have multiple plex accounts and the server is signed in to a different acccount and you did not realize that
If the server is signed in to plex.tv then all accrss - even through 127.0.0.1 must authenticate
@SE56 said:
@chop-shop said:
and of course: Plex Cloud no longer scans new files automatically. Please select Scan Library Files after uploading new media to a Plex Cloud library to see it.ENOUGH IS ENOUGH, BYE BYE PLEX, BYE BYE HEADACHES…
Suey, really it works well if your set it up correct. Get your Chop shop in order have a Paracetamol or 5
Thank you so much for your help, next time I need proper set up, I won’t forget to ask the one and only real pro here
@sa2000 said:
@chop-shop said:
it is getting better and better : http://127.0.0.1:32400/web/index.html get me to:This site can’t be reached
127.0.0.1 refused to connect.
Try:
Checking the connection
Checking the proxy and the firewall
ERR_CONNECTION_REFUSEDI am sorry to hear that you have other issues - we can resolve such problems from log files. It could be for example that you have multiple plex accounts and the server is signed in to a different acccount and you did not realize that
If the server is signed in to plex.tv then all accrss - even through 127.0.0.1 must authenticate
Yeah well, I thought so too… Anyway, now, http://127.0.0.1:32400/web/index.html# gets me to the server on the Mac Pro but not one single device (AppleTV, Roku, iThis, iThat or Stupid TV (Smart seems a bit overrated to me)) on the network detects the server…? It says: “Direct connection unavailable (chop-shop)” and it keeps trying to no avail…
I don’t understand what is going on, it was all working fine until God knows what happened and why?
You’ll find the logs attached to this message.
One more thing, before this happened, I had to get rid of my Plex music library because Plex would only scan the music library, not the movies or the tv shows even after adding movies and asking it to scan Movies A-L for instance, it would scan it for like 2 seconds, not changing a thing and immediately go back to scanning the music library… I have a huge music library that I don’t listen to so much anymore because I have both Apple Music and Spotify that allows me to listen to anything from any device so I don’t miss it but so you know…
Thanks for your help, I appreciate 
@chop-shop said:
@sa2000 said:
@chop-shop said:
it is getting better and better : http://127.0.0.1:32400/web/index.html get me to:This site can’t be reached
127.0.0.1 refused to connect.
Try:
Checking the connection
Checking the proxy and the firewall
ERR_CONNECTION_REFUSEDI am sorry to hear that you have other issues - we can resolve such problems from log files. It could be for example that you have multiple plex accounts and the server is signed in to a different acccount and you did not realize that
If the server is signed in to plex.tv then all accrss - even through 127.0.0.1 must authenticate
Yeah well, I thought so too… Anyway, now, http://127.0.0.1:32400/web/index.html# gets me to the server on the Mac Pro but not one single device (AppleTV, Roku, iThis, iThat or Stupid TV (Smart seems a bit overrated to me)) on the network detects the server…? It says: “Direct connection unavailable (chop-shop)” and it keeps trying to no avail…
I don’t understand what is going on, it was all working fine until God knows what happened and why?
You’ll find the logs attached to this message.
One more thing, before this happened, I had to get rid of my Plex music library because Plex would only scan the music library, not the movies or the tv shows even after adding movies and asking it to scan Movies A-L for instance, it would scan it for like 2 seconds, not changing a thing and immediately go back to scanning the music library… I have a huge music library that I don’t listen to so much anymore because I have both Apple Music and Spotify that allows me to listen to anything from any device so I don’t miss it but so you know…
Thanks for your help, I appreciate
Thanks for the logs
Can’t see any requests from within the local network to the server. It could be DNS Rebinding Protection blocking local access and because server is not available for remote access, there is no alternative secure connection route to the server.
To establish if there is DNS Rebinding protection on the local network, try this in a terminal session on the Mac Pro
nslookup 192-168-1-100.20cc502aaa1745689fac5741b969c713.plex.direct
nslookup 192-168-1-101.20cc502aaa1745689fac5741b969c713.plex.direct
These should translate to 192.168.1.100 and 192.168.1.101 respectively
If they give an error, try with Google DNS
nslookup 192-168-1-100.20cc502aaa1745689fac5741b969c713.plex.direct 8.8.8.8
nslookup 192-168-1-101.20cc502aaa1745689fac5741b969c713.plex.direct 8.8.8.8
The logs show that may be you are going through a vpn and have a double NAT
Extracts from the log (I have masked parts of your WAN IP addresses)
May 31, 2018 13:00:24.717 [0x700000631000] DEBUG - PublicAddressManager: Got public IP from http://plex.tv: 14.207.xxx.xxx
May 31, 2018 13:00:27.728 [0x700000631000] DEBUG - NAT: UPnP, public address is 183.89.xxx.xxx
May 31, 2018 13:00:27.728 [0x700000631000] DEBUG - PublicAddressManager: got WAN IP 183.89.xxx.xxx from router
May 31, 2018 13:00:27.728 [0x700000631000] WARN - PublicAddressManager: WAN IP on router does not match public IP from plex.tv
May 31, 2018 13:00:30.112 [0x700000acc000] ERROR - MyPlex: mapping failed due to potential double NAT configuration
This would impact availability of remote access route to the server and if there is DNS Rebinding Protection blocking local IP access plex.direct urls, remote access route would avoid the issue. Some plex apps do have means of getting round that, though.
You could try signing the roku out and in within the app settings and if problem persists get log from the roku as well server log to see why it is not getting through
See https://support.plex.tv/articles/201377603-roku-logs/
There is a general support article about apps not finding the server
https://support.plex.tv/articles/204604227-why-can-t-the-plex-app-find-or-connect-to-my-plex-media-server/
The terminal session for the DNS translated to 192.168 1 100 & 192.168.1.101 right away and I do not use a VPN or 2 routers so I don’t see how I’d get double Mapping and even if I did. I would not be available remotely but I would on the local network. It is now getting crazier by the minute… my iPhone suddenly sees the server again and is able to play anything, not the TV though or the AppleTV or the Roku…?
Also the WAN IP on the router does not match the public IP from Plex TV because the routing is modified by the service provider. It’s always been like that and it always worked until 4 days ago… Anyway, thanks for your help…
It is working!!!
Just by adding the localhost address and the subnet mask in the Network tab under LAN Networks and BINGO: 127.0.0.1/255.255.255.0
The server’s still not available remotely though but at least I can now watch a f…g movie and relax…
I had the exact same problem… the real resolution (for me at least) is to just use a different web browser.
