Client List doesn't load

Help
1

Expected Behaviour:

I used to see all clients on this list

Actual Behaviour:

I previously had a full list of configured clients populated by /etc/hosts, but now nothing loads

Debug Token:

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

2

Your database /etc/pihole/pihole-ftl.db is locked

Database not available, please ensure the database is unlocked when starting pihole-FTL !

No idea why. Easy try could be to just reboot the system and see if the issue reoccurrs.

3

In addition to the locked database status, your debug log shows numerous failures accessing various database tables (messages, network, network_addresses being among the most frequent).

I've also stumbled over the following line:

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

-rw-r--r-- 1 pihole pihole 11608 Sep  4 20:34 /var/log/pihole-FTL.log
   -----tail of pihole-FTL.log------
   [2020-09-04 20:34:00.403 22375/T22380] getDatabaseHostname("192.168.69.53") - SQL error prepare: SQL logic error

Your Pi-hole is configured for a different IP on a different subnet altogether:

*** [ DIAGNOSING ]: Setup variables
    IPV4_ADDRESS=192.168.66.30/24

If you did recently rearrange your network and relocated your Pi-hole to a new IP, running pihole -r with Reconfigure would make your Pi-hole installation aware of that change.

4

i've rebooted a few times and still nothing

5

that's a new device added to my network. i don't think i added it to my /etc/pihole/custom.list or /etc/hosts as I recently added it

6

Have a look in /var/log/pihole-FTL.log for errors after reboot.

7

i did have a recent issue where my logs kept trying to query 192.168.66.0 and it was flooding my db, so i did clear the db to reclaim space.

what permissions should the db have? i can chmod it

8

rebooting now after doing the reconfigure, i'll check it out to see what comes up

9 
162M -rw-rw-r-- 1 pihole pihole 162M Sep  5 14:16 /etc/pihole/gravity.db
2,4M -rw-r--r-- 1 pihole pihole 2,4M Aug 30 21:46 /etc/pihole/macvendor.db
 98M -rw-r--r-- 1 pihole pihole  98M Sep  5 22:17 /etc/pihole/pihole-FTL.db
10 
[2020-09-05 15:15:01.782 1056M] Using log file /var/log/pihole-FTL.log
[2020-09-05 15:15:01.797 1056M] ########## FTL started! ##########
[2020-09-05 15:15:01.974 1056M] SQLite3 message: no such table: ftl in "SELECT VALUE FROM ftl WHERE id = 0;" (1)
[2020-09-05 15:15:01.975 1056M] Encountered prepare error in db_query_int("SELECT VALUE FROM ftl WHERE id = 0;"): SQL logic error
[2020-09-05 15:15:01.975 1056M] Database not available, please ensure the database is unlocked when starting pihole-FTL !

[2020-09-05 15:15:02.063 1067M] SQLite3 message: no such table: message in "DELETE FROM message;" (1)
[2020-09-05 15:15:02.063 1067M] ERROR: SQL query "DELETE FROM message;" failed: SQL logic error
[2020-09-05 15:15:02.064 1067M] ERROR: flush_message_table() failed!
11

-rw-rw-r-- 1 pihole pihole 11722752 Sep 5 15:13 gravity.db
-rw-r--r-- 1 pihole pihole 2514944 Sep 3 23:31 macvendor.db
-rw-r--r-- 1 pihole pihole 0 Aug 27 01:49 pihole-FTL.db

12

Still the same error.

Try

sudo service pihole-FTL stop

mv /etc/pihole/pihole-FTL.db /etc/pihole/pihole-FTL-old.db

sudo service pihole-FTL start
13

Size is 0.

14

just did this and now it's showing a size

-rw-r--r-- 1 pihole pihole 44K Sep 5 15:23 pihole-FTL.db

1 Like
15

aaand the clients list is back! thank you @yubiuser

1 Like
16

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