The issue I am facing: After a reboot or restart (pihole restartdns) everything works normally as expected, however after a period of time when I pull up the admin interface the section that shows the percentage Blocked blinks with 'Undefined% Details about my system: I am running the latest vers…

[image] Donavyn_de_Raine_Don: I am running the latest version of PiHole on a Raspberry Pi Desktop environment. Debian kernel with Jessie (?) desktop environment. Jessie has been unsupported for several years now. Please upload a debug log and post just the token that is generated after the …

Yeah I didn't think Jessie sounded right either, but it's the latest version of Pi. I'll get that information and post it.

https://tricorder.pi-hole.net/61zh2r2a9e

You are running Buster, not Jessie. Buster is supported. *** [ DIAGNOSING ]: Operating system [i] dig return code: 0 [i] dig response: "Raspbian=9,10 Ubuntu=16,18,20 Debian=9,10 Fedora=32,33 CentOS=7,8" [✓] Distro: Debian [✓] Version: 10 You have some errors/abnormal entries in your logs: -rw…

We have about 30+ devices in our home network, traffic will vary depending on the user and what they're doing. I'll run those commands and post them.

-rw-r--r-- 1 pihole pihole 0 Dec 20 11:50 /etc/pihole/pihole-FTL.db Is that script supposed to run on one line? I've tried to copy and paste the SQL line item and it provides me with Error: no such table: counters

domains_being_blocked 115711 dns_queries_today 8742 ads_blocked_today 865 ads_percentage_today 9.894761 unique_domains 1612 queries_forwarded 4674 queries_cached 2933 clients_ever_seen 21 unique_clients 21 dns_queries_all_types 8742 reply_NODATA 254 reply_NXDOMAIN 1529 reply_CNAME 1126 …

[image] jfb: sqlite3 /etc/pihole/pihole-FTL.db "SELECT value FROM counters WHERE id = 0" It appears your long term database is corrupted. The filesize is zero, and the database doesn't have information that would be expected. Let's move the existing file and start a new one and see if the p…

[image] jfb: sudo service pihole-FTL start OK, did that. Now waiting to see if the % Blocked starts blinking again. Fingers crossed.

That looks like it fixed the issue, I let it do its thing during the night and checked this morning, information has populated and its no longer blinking. Thank you very much! If we can indulge just a bit further, what do you think caused the issue so that I can be proactive on it? Power loss? An…

Pi-hole Userspace

Percentage Blocked blinking 'Undefined%'

Help Community Help

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled