Pihole -g updates retrieves some list but not all

#How i got here. dns resolution was not working, dns servers offline.
updated it & rebooted.
ran the GUI gravity update and ran into some unsuccessful retrievals while others passed,. eg rawgithub passed on some while others were not retrievable using either whats cached or not available
#TL;DR ------------- able to fetch and parse sources from github, but other github repos unable and firebog.net & tried removing some lists.

#everything at the OS system level is fine, pihole, unbound, tailscale, pingable
#following from Adlist connections refused, no cached list downloaded - #3 by dgani

rpi5-1@raspberrypi:~ $ pihole -g -f

[✗] DNS resolution is currently unavailable
[✗] DNS resolution is not available```

```rpi5-1@raspberrypi:~ $ curl -Li https://raw.githubusercontent.com/StevenBlack/hosts/master/hosts | head -n 20
% Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                               Dload  Upload   Total   Spent    Left  Speed
0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0HTTP/2 200 
cache-control: max-age=300
content-security-policy: default-src 'none'; style-src 'unsafe-inline'; sandbox
content-type: text/plain; charset=utf-8
etag: "8b409c420e9d07788cf9deb0243585e667f5cd0cf24333f1db77b06314906ded"
strict-transport-security: max-age=31536000
x-content-type-options: nosniff
x-frame-options: deny
x-xss-protection: 1; mode=block
x-github-request-id: 19DF:15CE15:57ABD3:6CB79F:671F8070
accept-ranges: bytes
date: Mon, 28 Oct 2024 23:08:05 GMT
via: 1.1 varnish
x-served-by: cache-adl2040024-ADL
x-cache: HIT
x-cache-hits: 0
x-timer: S1730156885.088885,VS0,VE1
vary: Authorization,Accept-Encoding,Origin
access-control-allow-origin: *
cross-origin-resource-policy: cross-origin
0 3453k    0 31856    0     0  48193      0  0:01:13 --:--:--  0:01:13 48193
curl: (23) Failure writing output to destination```

`curl -L https://raw.githubusercontent.com/StevenBlack/hosts/master/hosts
echo $?`
[Untitled.txt|attachment](upload://1zZ9s20oqV6y5sVauUQQ9P8w8BQ.txt) (3.4 MB)
#list is quite large, 10.4M

`sudo bash -x /opt/pihole/gravity.sh`
dns resolution failed
```rpi5-1@raspberrypi:~ $ curl --connect-timeout 10 -s -L --compressed -w '%{http_code}\n' https://raw.githubusercontent.com/StevenBlack/hosts/master/hosts -o /tmp/tmp.DZE2Jn7Rrg ; echo "Exited with $?"
200
Exited with 0```
#following from thread https://discourse.pi-hole.net/t/adlist-connections-refused-no-cached-list-downloaded/66525/24




## Debug Token:
https://tricorder.pi-hole.net/A8V268Dv/

Untitled.txt (3.4 MB)

10.4M list

i additional findings,
pihole -g works via ssh but returns as suggested in the help.
pihole -g on the host returns dns resolution is current unavailable

pihole -g works via host, miraculously but no cached list available

pihole -r returns that my dns resolution is currently unavailable and is not available.
i just changed it as mention above, and i doubled checked that my servers are up. im using servers via opennic

update
removing unretrievable list and adding them back into gravity worked for 85% of the list that were getting connected refused

Maybe some lists are offline.

Are you able to access the "failing" lists on the browser (in a different machine)?

yes i am. i just flushed my dns thinking maybe it was using old caches. my majority of my list is connection refused, i'm trying on my second pihole server, ubuntu.

i forgot to mention that the issue with my current server is on bookworm.
ubuntu seems to be working perfectly fine with the same lists but not as much as bookworm, i think it might have to do with the a new bookworm update i did on it ?

bookworm version 12. pihole v5.18.3

Your debug log shows several problems:

*** [ DIAGNOSING ]: Operating system
[i] Distro: Debian
[i] Version: 12
[✗] dig return code: 10
[✗] dig response: dig: couldn't get address for 'ns1.pi-hole.net': failure
[✗] Error: dig command failed - Unable to check OS
*** [ DIAGNOSING ]: Networking
[✗] No IPv4 address(es) found on the eth0 interface.

[✗] No IPv6 address(es) found on the eth0 interface.

You have a WLAN0 IP (wlan0 (192.168.0.250)), but your Pi-hole is configured to use eth0 interface, which has no active IP.

*** [ DIAGNOSING ]: Setup variables
    PIHOLE_INTERFACE=eth0

I suspect these connectivity problems are leading to the inability to download adlists.

yesterday i ssh via android and got it to work by editing
etc/resolv.conf and input nameserver 127.0.0.1 to
but it didn't allow to fully populate because i tried pihole -g and still unable.
i edited /etc/pihole/pihole-FTL.conf
placed INTERFACE=wlan0 and now im getting pihole-FTL.service is not running with a exit code error 2

i some how had major typos in the etc/resolv.conf
back to where i was..stay tuned

i edited /etc/pihole/setupVars.conf and changed eth0 to wlan0 i'm still getting the same results, some are retrieving and majority are not

i need assistance, its now saying dns is not running after running pihole -g
and tailscale connection is unable to connect to any servers. for troubleshoot i have now turned off tailscale.
i ran pihole -r
output
[✗] Downloading and Installing FTL Error: URL https://github.com/pi-hole/ftl/releases/latest/download/pihole-FTL-aarch64-linux-gnu not found [✗] FTL Engine not installed
i'm in the process of backing it up and reinstalling pihole and i'm getting the same error above

This kind of intermittent issues could indicate a connectivity issue on the router, or wifi connection is failing, or bad cables, etc.

hmmm, i also edited /etc/resolv/conf and added nameserver 127.0.0.1 to nameservers 0000000
i tried to run pihole -r buts its unable to complete the update.
no devices connected to tailscale are able to reach the internet but are able to ping servers

Download Mbps

93.43

Upload Mbps

18.50

it can't be my internet because my ubuntu server is fine

rpi5-1@raspberrypi:~ $ sudo systemctl enable dnsmasq && sudo systemctl start dnsmasq
output:
Synchronizing state of dnsmasq.service with SysV service script with /lib/systemd/systemd-sysv-install. Executing: /lib/systemd/systemd-sysv-install enable dnsmasq Job for dnsmasq.service failed because the control process exited with error code. See "systemctl status dnsmasq.service" and "journalctl -xeu dnsmasq.service" for details.

input
rpi5-1@raspberrypi:~ $ unbound -d

output
[1730237533] unbound[14040:0] error: can't bind socket: Address already in use for 127.0.0.1 port 5335 [1730237533] unbound[14040:0] fatal error: could not open ports

inputs
rpi5-1@raspberrypi:~ $ sudo systemctl stop dnsmasq sudo systemctl disable dnsmasq sudo systemctl restart pihole-FTL

output
Synchronizing state of dnsmasq.service with SysV service script with /lib/systemd/systemd-sysv-install. Executing: /lib/systemd/systemd-sysv-install disable dnsmasq Removed "/etc/systemd/system/multi-user.target.wants/dnsmasq.service".

input
rpi5-1@raspberrypi:~ $ sudo systemctl enable pihole-FTL rpi5-1@raspberrypi:~ $ sudo systemctl start pihole-FTL rpi5-1@raspberrypi:~ $ sudo systemctl start pihole-FTL.service

so i got dns resolution, resoluting(is that a word lol) but i'm back to where i am. where some servers are connecting and others are getting instant refused.
in my previous comments i ran a speed.test.io but what i notice is that on a brave browser opening large raw github files it fails upon first instance and i would have to hit refresh for it to load, but when i try this on safari it reaches automatically with no issues on first instance.

un related to the matter but i just want to reinforce the idea that it can't be my internet. i got my tailscale exit node working again by just going through the install process again without reinstall, and exit nodes have even further latency. im able to reach servers and browse but im still getting connection refusals on pihole -g