Block list disappeared

Block list disappeared after updating. Did the gravity rebuild but didn't work:

$ pihole -g -r
[i] Restoring from migration backup...cp: cannot stat 'migration_backup/*': No such file or directory
[✓] Restoring from migration backup
[i] Creating new gravity database
/opt/pihole/gravity.sh: line 82: 3124 Illegal instruction sqlite3 "${1}" < "${gravityDBschema}"
Error: no such table: info
[i] Migrating content of /etc/pihole/adlists.list into new database

[✗] Unable to fill table adlist in database /etc/pihole/gravity.db
CREATE TABLE adlist(...) failed: duplicate column name: 1
[✓] Cleaning up stray matter
[✓] DNS service is running
[✓] Pi-hole blocking is Enabled

Debug Token:

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

Are they really gone or do they just not appear in the web interface. We've seen some reports of the latter.

Please check by

 sqlite3 /etc/pihole/gravity.db "Select * from adlist;"

They are really gone. There is no gravity database:

*** [ DIAGNOSING ]: Gravity List and Database
-rw-r--r-- 1 root root 0 Aug 16 14:45 /etc/pihole/gravity.db

*** [ DIAGNOSING ]: Info table
   Last gravity run finished at: 

   ----- First 10 Gravity Domains -----


*** [ DIAGNOSING ]: Groups

*** [ DIAGNOSING ]: Domainlist (0/1 = exact white-/blacklist, 2/3 = regex white-/blacklist)

*** [ DIAGNOSING ]: Clients

*** [ DIAGNOSING ]: Adlists
 -----tail of pihole-FTL.log------
   [2020-08-16 14:43:25.441 492M] get_client_groupids(): Gravity database not available
   [2020-08-16 14:43:25.443 492M] SQLite3 message: no such table: domain_audit in "SELECT EXISTS(SELECT domain, CASE WHEN substr(domain, 1, 1) = '*' THEN '*' || substr(:input, - length(domain) + 1) ELSE :input END matcher FROM domain_audit WHERE matcher = doma (1)
   [2020-08-16 14:43:25.444 492M] gravityDB_open("SELECT EXISTS(... domain_audit ...)") - SQL error prepare: SQL logic error
   [2020-08-16 14:43:25.444 492M] get_client_groupids(): Gravity database not available
.....

sqlite3 /etc/pihole/gravity.db "Select * from adlist;"

Error: no such table: adlist

It looks like it's gone. What will be the next step? Reinstall pi-hole?

Try

pihole -r choose repair.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.