# Percentage Blocked blinking 'Undefined%'
**URL:** https://discourse.pi-hole.net/t/percentage-blocked-blinking-undefined/46792
**Category:** Community Help
**Created:** [May 4, 2021, 5:24pm UTC](https://discourse.pi-hole.net/t/percentage-blocked-blinking-undefined/46792 "2021-05-04T17:24:51Z")
**Posts on this page:** 15
**Page:** 1
### Author:  [@Donavyn\_de\_Raine\_Don](https://discourse.pi-hole.net/u/Donavyn_de_Raine_Don)
#### Post date: [May 4, 2021, 5:24pm UTC](https://discourse.pi-hole.net/t/percentage-blocked-blinking-undefined/46792/1 "2021-05-04T17:24:51Z")
**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 version of PiHole on a Raspberry Pi Desktop environment. Debian kernel with Jessie (?) desktop environment.
**What I have changed since installing Pi-hole:**
Quite literally nothing except system updates and upgrades.
---
### Author:  [@jfb](https://discourse.pi-hole.net/u/jfb)
#### Post date: [May 4, 2021, 5:36pm UTC](https://discourse.pi-hole.net/t/percentage-blocked-blinking-undefined/46792/2 "2021-05-04T17:36:48Z")
> [@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 log is uploaded by running the following command from the Pi-hole host terminal:
```auto
pihole -d
```
or do it through the Web interface:
_ **Tools \> Generate Debug Log** _
---
### Author:  [@Donavyn\_de\_Raine\_Don](https://discourse.pi-hole.net/u/Donavyn_de_Raine_Don)
#### Post date: [May 4, 2021, 6:20pm UTC](https://discourse.pi-hole.net/t/percentage-blocked-blinking-undefined/46792/3 "2021-05-04T18:20:34Z")
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.
---
### Author:  [@Donavyn\_de\_Raine\_Don](https://discourse.pi-hole.net/u/Donavyn_de_Raine_Don)
#### Post date: [May 4, 2021, 7:05pm UTC](https://discourse.pi-hole.net/t/percentage-blocked-blinking-undefined/46792/4 "2021-05-04T19:05:29Z")
[https://tricorder.pi-hole.net/61zh2r2a9e](https://tricorder.pi-hole.net/61zh2r2a9e)
---
### Author:  [@jfb](https://discourse.pi-hole.net/u/jfb)
#### Post date: [May 4, 2021, 7:14pm UTC](https://discourse.pi-hole.net/t/percentage-blocked-blinking-undefined/46792/5 "2021-05-04T19:14:25Z")
You are running Buster, not Jessie. Buster is supported.
```auto
*** [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:
```auto
-rw-r--r-- 1 pihole pihole 3022789 May 4 13:04 /var/log/pihole-FTL.log
-----head of pihole-FTL.log------
[2021-05-04 00:00:05.242 8625/T8626] Client denied (at max capacity of 255): 321
[2021-05-04 00:00:05.242 8625/T8626] IPv4 telnet error: Success (0)
-----tail of pihole-FTL.log------
[2021-05-04 13:03:42.812 22096M] SQLite3 message: no such table: network in "SELECT hwaddr FROM network WHERE id = (SELECT network_id FROM network_addresses WHERE ip = ? GROUP BY ip HAVING max(lastSeen));" (1)
[2021-05-04 13:03:42.812 22096M] getMACfromIP("192.168.7.102") - SQL error prepare: SQL logic error
[2021-05-04 13:03:42.812 22096M] SQLite3 message: no such table: network_addresses in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
[2021-05-04 13:03:42.812 22096M] getNameFromIP("192.168.7.102") - SQL error prepare: SQL logic error
[2021-05-04 13:03:42.813 22096M] SQLite3 message: no such table: network in "SELECT interface FROM network JOIN network_addresses ON network_addresses.network_id = network.id WHERE network_addresses.ip = ? AND interface != 'N/A' AND interface IS NOT NULL;" (1)
[2021-05-04 13:03:42.813 22096M] getIfaceFromIP("192.168.7.102") - SQL error prepare: SQL logic error
[2021-05-04 13:03:42.814 22096M] SQLite3 message: no such table: network in "SELECT hwaddr FROM network WHERE id = (SELECT network_id FROM network_addresses WHERE ip = ? GROUP BY ip HAVING max(lastSeen));" (1)
[2021-05-04 13:03:42.814 22096M] getMACfromIP("192.168.7.102") - SQL error prepare: SQL logic error
[2021-05-04 13:03:42.815 22096M] SQLite3 message: no such table: network_addresses in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
...
[2021-05-04 13:03:59.802 22096M] SQLite3 message: no such table: network in "SELECT interface FROM network JOIN network_addresses ON network_addresses.network_id = network.id WHERE network_addresses.ip = ? AND interface != 'N/A' AND interface IS NOT NULL;" (1)
[2021-05-04 13:03:59.802 22096M] getIfaceFromIP("192.168.7.15") - SQL error prepare: SQL logic error
[2021-05-04 13:04:00.140 22096/T22100] SQLite3 message: no such table: network_addresses in "DELETE FROM network_addresses WHERE lastSeen < 1588619040;" (1)
[2021-05-04 13:04:00.140 22096/T22100] ERROR: SQL query "DELETE FROM network_addresses WHERE lastSeen < 1588619040;" failed: SQL logic error
[2021-05-04 13:04:00.140 22096/T22100] SQLite3 message: API call with invalid database connection pointer (21)
[2021-05-04 13:04:00.140 22096/T22100] SQLite3 message: misuse at line 165242 of [5d4c65779d] (21)
[2021-05-04 13:04:00.140 22096/T22100] Error while trying to close database: bad parameter or other API misuse
```
How much traffic is your Pi-hole seeing on a daily basis? Please post the output of the following run from the Pi terminal:
`ls -lha /etc/pihole/pihole-FTL.db`
`sqlite3 /etc/pihole/pihole-FTL.db "SELECT value FROM counters WHERE id = 0"`
`echo ">stats >quit" | nc localhost 4711`
`echo ">top-clients withzero (25) >quit" | nc localhost 4711`
---
### Author:  [@Donavyn\_de\_Raine\_Don](https://discourse.pi-hole.net/u/Donavyn_de_Raine_Don)
#### Post date: [May 4, 2021, 8:25pm UTC](https://discourse.pi-hole.net/t/percentage-blocked-blinking-undefined/46792/6 "2021-05-04T20:25:37Z")
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.
---
### Author:  [@Donavyn\_de\_Raine\_Don](https://discourse.pi-hole.net/u/Donavyn_de_Raine_Don)
#### Post date: [May 4, 2021, 8:30pm UTC](https://discourse.pi-hole.net/t/percentage-blocked-blinking-undefined/46792/7 "2021-05-04T20:30:00Z")
-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
---
### Author:  [@Donavyn\_de\_Raine\_Don](https://discourse.pi-hole.net/u/Donavyn_de_Raine_Don)
#### Post date: [May 4, 2021, 8:40pm UTC](https://discourse.pi-hole.net/t/percentage-blocked-blinking-undefined/46792/8 "2021-05-04T20:40:57Z")
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
reply\_IP 3609
privacy\_level 0
status enabled
Nothing displayed for the line:
`echo ">top-clients withzero (25) >quit" | nc localhost 4711`
---
### Author:  [@jfb](https://discourse.pi-hole.net/u/jfb)
#### Post date: [May 5, 2021, 12:30am UTC](https://discourse.pi-hole.net/t/percentage-blocked-blinking-undefined/46792/9 "2021-05-05T00:30:12Z")
> [@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 problem persists.
`sudo service pihole-FTL stop`
`sudo mv /etc/pihole/pihole-FTL.db /etc/pihole/pihole-FTL-old.db`
`sudo service pihole-FTL start`
---
### Author:  [@Donavyn\_de\_Raine\_Don](https://discourse.pi-hole.net/u/Donavyn_de_Raine_Don)
#### Post date: [May 5, 2021, 12:57am UTC](https://discourse.pi-hole.net/t/percentage-blocked-blinking-undefined/46792/10 "2021-05-05T00:57:05Z")
> [@jfb](#):
>
> sudo service pihole-FTL start
OK, did that. Now waiting to see if the % Blocked starts blinking again. Fingers crossed.
---
### Author:  [@Donavyn\_de\_Raine\_Don](https://discourse.pi-hole.net/u/Donavyn_de_Raine_Don)
#### Post date: [May 5, 2021, 1:36pm UTC](https://discourse.pi-hole.net/t/percentage-blocked-blinking-undefined/46792/11 "2021-05-05T13:36:38Z")
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? Anything like that?
---
### Author:  [@jfb](https://discourse.pi-hole.net/u/jfb)
#### Post date: [May 5, 2021, 3:38pm UTC](https://discourse.pi-hole.net/t/percentage-blocked-blinking-undefined/46792/12 "2021-05-05T15:38:52Z")
> [@Donavyn\_de\_Raine\_Don](#):
>
> what do you think caused the issue so that I can be proactive on it?
It's hard to say. A sudden power loss can corrupt files, as one possibility.
---
### Author:  [@Donavyn\_de\_Raine\_Don](https://discourse.pi-hole.net/u/Donavyn_de_Raine_Don)
#### Post date: [May 5, 2021, 4:46pm UTC](https://discourse.pi-hole.net/t/percentage-blocked-blinking-undefined/46792/13 "2021-05-05T16:46:52Z")
That's what I was thinking, too. Time to invest in a UPS then.
Again thank you very much for your help, I appreciate you!
---
### Author:  [@jfb](https://discourse.pi-hole.net/u/jfb)
#### Post date: [May 19, 2021, 7:05pm UTC](https://discourse.pi-hole.net/t/percentage-blocked-blinking-undefined/46792/14 "2021-05-19T19:05:33Z")
A post was split to a new topic: [Free space on SD card?](https://discourse.pi-hole.net/t/free-space-on-sd-card/47156)
---
### Author:  [@system](https://discourse.pi-hole.net/u/system)
#### Post date: [June 9, 2021, 7:06pm UTC](https://discourse.pi-hole.net/t/percentage-blocked-blinking-undefined/46792/15 "2021-06-09T19:06:28Z")
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.