Domains on ad lists is showing as negative 2

[tihhetave]

The domains on ad lists is showing as negative 2 on the admin page. I've tried to uninstall and reinstall pihole many times, but that's not fixing the issue.

When I run pihole -g I get the following right at the end which I think looks a bit suspicious. I'm also getting an sql error somewhere, but I can't seem to reproduce that at the moment.

200)
  [✗] List download failed: using previously cached list
  [i] Analyzed 110298 domains

  [✓] Creating new gravity databases
  [✓] Storing downloaded domains in new gravity database
  [✓] Building tree
  [✓] Swapping databases
  [✓] The old database remains available.
  [i] Number of gravity domains: COUNT(*)
--------
110298   (COUNT(DISTINCT domain)
----------------------
110298                 unique domains)
  [i] Number of exact blacklisted domains: COUNT(*)
--------
0       
  [i] Number of regex blacklist filters: COUNT(*)
--------
0       
  [i] Number of exact whitelisted domains: COUNT(*)
--------
0       
  [i] Number of regex whitelist filters: COUNT(*)
--------
0       
  [✓] Cleaning up stray matter

  [✓] FTL is listening on port 53
     [✓] UDP (IPv4)
     [✓] TCP (IPv4)
     [✓] UDP (IPv6)
     [✓] TCP (IPv6)

  [✓] Pi-hole blocking is enabled

Debug Token:

https://tricorder.pi-hole.net/pNKV98P5/

[Bucking_Horn]

You have problems with illegal domains in one of your donwloaded blocklists:

*** [ DIAGNOSING ]: contents of /var/log

-rw-r--r-- 1 pihole pihole 9.7K Apr 10 17:45 /var/log/pihole-FTL.log
   -----tail of pihole-FTL.log------
   [2022-04-10 17:45:02.184 2261M] INFO: FTL escaped 15 characters in "domain~~~~~~~~~~~~~~~
   ---------------------
   countappchkpoin.rf.gd"

Since you are only using the default blocklist (and that's known to work with Pi-hole), that may indicate issues while downloading that blocklist, or potentially also file system corruption.

Run from your RPi hosting Pi-hole, what's the output of

grep -nm 2 countappchkpoin /etc/pihole/list*

[tihhetave]

Thanks for getting back to me. I get the following when running that command:

/etc/pihole/list.1 .raw.githubusercontent.com.domains:49240:countappchkpoin.rf.gd
/etc/pihole/list.1 .raw.githubusercontent.com.domains:67256:www.countappchkpoin.rf.gd

I've also just done a cat /var/log/pihole-FTL.log and I get the following:

[2022-04-11 12:49:37.600 2261M] Reloading DNS cache
[2022-04-11 12:49:37.005 2261/T2265] SQLite3 message: file renamed while open: /etc/pihole/gravity.db (28)
[2022-04-11 12:49:37.008 2261/T2265] gravityDB_count(SELECT value FROM info WHERE property = 'gravity_count';) - SQL error step no more rows available
[2022-04-11 12:49:37.008 2261/T2265] Count of gravity domains not available. Please run pihole -g
[2022-04-11 12:49:37.010 2261/T2265] Compiled 0 whitelist and 0 blacklist regex filters for 6 clients in 2.2 msec

Is there something wrong with the SQLite3 database? There seems to be an SQL error.