Query Log is empty after v6.0 upgrade

cups.growths.9s · February 22, 2025, 1:46am

My setup:

Standard Pihole with Unbound as recursive DNS.
RPi 4B - 8GB (latest Raspbian on bare metal) - nothing else running on it apart from Pihole and Tailscale
Issue started after upgrade to v6.0
I tried to remove the pihole-FTL.db to see if it was the issue after attempting to move over my old db replying on this article here.

`pihole -v`:

Core version is v6.0.1 (Latest: v6.0.1)
Web version is v6.0 (Latest: v6.0)
FTL version is v6.0 (Latest: v6.0)

pihole status:
[✓] FTL is listening on port 53
[✓] UDP (IPv4)
[✓] TCP (IPv4)
[✓] UDP (IPv6)
[✓] TCP (IPv6)
[✓] Pi-hole blocking is enabled

Expected Behaviour:

Query Log should display a list of DNS queries. It is not reacting to any advanced filtering either.

Actual Behaviour:

Allow/Block domain list did not survive the upgrade (I had to restore them from a Teleporter backup)
All other features are working fine
pihole.log shows all DNS queries
Query Log is empty:

Debug Token:

Debug with database check: https://tricorder.pi-hole.net/C6Nn9lLj/
I tried pihole -r to repair and reconfigure (both)

Output from tail -F /var/log/pihole/FTL.log has some SQLite3 errors from 18 hours ago:

2025-02-20 17:27:48.865 INFO PID of FTL process: 10588
2025-02-20 17:27:48.866 INFO listening on 0.0.0.0 port 53
2025-02-20 17:27:48.866 INFO listening on :: port 53
2025-02-20 17:27:48.868 INFO PID of FTL process: 10588
2025-02-20 17:27:48.870 INFO Database version is 21
2025-02-20 17:27:48.871 INFO Database successfully initialized
2025-02-20 17:27:49.073 INFO FTL is running as user pihole (UID 999)
2025-02-20 17:27:49.074 INFO Reading certificate from /etc/pihole/tls.pem ...
2025-02-20 17:27:49.074 INFO Using SSL/TLS certificate file /etc/pihole/tls.pem
2025-02-20 17:27:49.075 INFO Web server ports:
2025-02-20 17:27:49.075 INFO   - 80 (HTTP, IPv4, optional)
2025-02-20 17:27:49.075 INFO   - 443 (HTTPS, IPv4, optional)
2025-02-20 17:27:49.075 INFO   - 80 (HTTP, IPv6, optional)
2025-02-20 17:27:49.075 INFO   - 443 (HTTPS, IPv6, optional)
2025-02-20 17:27:49.075 INFO Restored 2 API sessions from the database
2025-02-20 17:27:49.085 INFO Blocking status is enabled
2025-02-20 17:27:49.181 INFO Compiled 0 allow and 6 deny regex for 1 client in 5.1 msec
2025-02-20 17:27:50.675 ERROR SQLite3: no such table: main.antigravity in "SELECT adlist_id from vw_antigravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:27:50.676 ERROR domain_in_list("api.github.com", 0x7fa3cf3558, antigravity): Failed to perform step: SQL logic error
2025-02-20 17:27:50.676 ERROR SQLite3: no such table: main.gravity in "SELECT adlist_id from vw_gravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:27:50.676 ERROR domain_in_list("api.github.com", 0x7fa3cf3418, gravity): Failed to perform step: SQL logic error
2025-02-20 17:27:50.702 ERROR SQLite3: no such table: main.antigravity in "SELECT adlist_id from vw_antigravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:27:50.702 ERROR domain_in_list("api.github.com", 0x7fa3cf3558, antigravity): Failed to perform step: SQL logic error
2025-02-20 17:27:50.702 ERROR SQLite3: no such table: main.gravity in "SELECT adlist_id from vw_gravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:27:50.702 ERROR domain_in_list("api.github.com", 0x7fa3cf3418, gravity): Failed to perform step: SQL logic error
2025-02-20 17:27:50.908 ERROR SQLite3: no such table: main.antigravity in "SELECT adlist_id from vw_antigravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:27:50.908 ERROR domain_in_list("github.com", 0x7fa3cf3558, antigravity): Failed to perform step: SQL logic error
2025-02-20 17:27:50.908 ERROR SQLite3: no such table: main.gravity in "SELECT adlist_id from vw_gravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:27:50.908 ERROR domain_in_list("github.com", 0x7fa3cf3418, gravity): Failed to perform step: SQL logic error
2025-02-20 17:27:50.909 ERROR SQLite3: no such table: main.antigravity in "SELECT adlist_id from vw_antigravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:27:50.910 ERROR domain_in_list("github.com", 0x7fa3cf3558, antigravity): Failed to perform step: SQL logic error
2025-02-20 17:27:50.910 ERROR SQLite3: no such table: main.gravity in "SELECT adlist_id from vw_gravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:27:50.910 ERROR domain_in_list("github.com", 0x7fa3cf3418, gravity): Failed to perform step: SQL logic error
2025-02-20 17:27:51.080 ERROR SQLite3: no such table: main.gravity in "SELECT adlist_id from vw_gravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:27:51.080 ERROR gravityDB_open("SELECT(... vw_gravity ...)") - SQL error prepare: SQL logic error
2025-02-20 17:27:51.080 ERROR Gravity database not available (allowlist)
2025-02-20 17:27:51.087 INFO Gravity database has been updated, reloading now
2025-02-20 17:27:51.098 INFO Compiled 0 allow and 6 deny regex for 3 clients in 9.1 msec
2025-02-20 17:27:53.667 INFO Received 8/8 valid NTP replies from pool.ntp.org
2025-02-20 17:27:53.668 INFO Time offset: -6.971210e+00 ms (excluded 0 outliers)
2025-02-20 17:27:53.668 INFO Round-trip delay: 3.058964e+01 ms (excluded 0 outliers)
2025-02-20 17:27:53.668 INFO NTP server listening on 0.0.0.0:123 (IPv4)
2025-02-20 17:27:53.668 INFO NTP server listening on :::123 (IPv6)
2025-02-20 17:41:20.614 ERROR SQLite3: no such table: main.antigravity in "SELECT adlist_id from vw_antigravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.614 ERROR domain_in_list("nipponsei.minglong.org", 0x7fa3cf2158, antigravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.614 ERROR SQLite3: no such table: main.gravity in "SELECT adlist_id from vw_gravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.614 ERROR domain_in_list("nipponsei.minglong.org", 0x7fa3c41668, gravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.615 ERROR SQLite3: no such table: main.antigravity in "SELECT adlist_id from vw_antigravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.615 ERROR domain_in_list("nipponsei.minglong.org", 0x7fa3cf2158, antigravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.615 ERROR SQLite3: no such table: main.gravity in "SELECT adlist_id from vw_gravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.615 ERROR domain_in_list("nipponsei.minglong.org", 0x7fa3c41668, gravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.675 ERROR SQLite3: no such table: main.antigravity in "SELECT adlist_id from vw_antigravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.675 ERROR domain_in_list("www.epublibre.org", 0x7fa3cf2158, antigravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.675 ERROR SQLite3: no such table: main.gravity in "SELECT adlist_id from vw_gravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.675 ERROR domain_in_list("www.epublibre.org", 0x7fa3c41668, gravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.676 ERROR SQLite3: no such table: main.antigravity in "SELECT adlist_id from vw_antigravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.676 ERROR domain_in_list("www.epublibre.org", 0x7fa3cf2158, antigravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.676 ERROR SQLite3: no such table: main.gravity in "SELECT adlist_id from vw_gravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.676 ERROR domain_in_list("www.epublibre.org", 0x7fa3c41668, gravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.678 ERROR SQLite3: no such table: main.antigravity in "SELECT adlist_id from vw_antigravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.678 ERROR domain_in_list("audiobookbay.lu", 0x7fa3cf2158, antigravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.678 ERROR SQLite3: no such table: main.gravity in "SELECT adlist_id from vw_gravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.678 ERROR domain_in_list("audiobookbay.lu", 0x7fa3c41668, gravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.679 ERROR SQLite3: no such table: main.antigravity in "SELECT adlist_id from vw_antigravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.679 ERROR domain_in_list("audiobookbay.lu", 0x7fa3cf2158, antigravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.679 ERROR SQLite3: no such table: main.gravity in "SELECT adlist_id from vw_gravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.679 ERROR domain_in_list("audiobookbay.lu", 0x7fa3c41668, gravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.705 ERROR SQLite3: no such table: main.antigravity in "SELECT adlist_id from vw_antigravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.705 ERROR domain_in_list("epublibre.org", 0x7fa3cf2158, antigravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.705 ERROR SQLite3: no such table: main.gravity in "SELECT adlist_id from vw_gravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.705 ERROR domain_in_list("epublibre.org", 0x7fa3c41668, gravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.709 ERROR SQLite3: no such table: main.antigravity in "SELECT adlist_id from vw_antigravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.709 ERROR domain_in_list("epublibre.org", 0x7fa3cf2158, antigravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.709 ERROR SQLite3: no such table: main.gravity in "SELECT adlist_id from vw_gravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.709 ERROR domain_in_list("epublibre.org", 0x7fa3c41668, gravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.789 ERROR SQLite3: no such table: main.antigravity in "SELECT adlist_id from vw_antigravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.789 ERROR domain_in_list("apibay.org", 0x7fa3cf2158, antigravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.789 ERROR SQLite3: no such table: main.gravity in "SELECT adlist_id from vw_gravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.790 ERROR domain_in_list("apibay.org", 0x7fa3c41668, gravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.790 ERROR SQLite3: no such table: main.antigravity in "SELECT adlist_id from vw_antigravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.790 ERROR domain_in_list("apibay.org", 0x7fa3cf2158, antigravity): Failed to perform step: SQL logic error
2025-02-20 17:41:20.790 ERROR SQLite3: no such table: main.gravity in "SELECT adlist_id from vw_gravity WHERE domain = ? AND group_id IN (0);" (1)
2025-02-20 17:41:20.790 ERROR domain_in_list("apibay.org", 0x7fa3c41668, gravity): Failed to perform step: SQL logic error
2025-02-20 17:41:21.099 INFO Gravity database has been updated, reloading now
2025-02-20 17:41:21.132 INFO Compiled 0 allow and 6 deny regex for 12 clients in 30.1 msec
2025-02-20 18:27:54.040 INFO Received 8/8 valid NTP replies from pool.ntp.org
2025-02-20 18:27:54.040 INFO Time offset: -5.448001e+00 ms (excluded 1 outliers)
2025-02-20 18:27:54.040 INFO Round-trip delay: 3.363092e+01 ms (excluded 1 outliers)
2025-02-20 19:27:54.334 INFO Received 8/8 valid NTP replies from pool.ntp.org
2025-02-20 19:27:54.334 INFO Time offset: -4.589260e-01 ms (excluded 0 outliers)
2025-02-20 19:27:54.334 INFO Round-trip delay: 2.909642e+01 ms (excluded 0 outliers)
2025-02-20 20:27:54.521 INFO Received 8/8 valid NTP replies from pool.ntp.org
2025-02-20 20:27:54.522 INFO Time offset: -2.107688e+00 ms (excluded 1 outliers)
2025-02-20 20:27:54.522 INFO Round-trip delay: 1.331070e+01 ms (excluded 1 outliers)
2025-02-20 21:27:54.753 INFO Received 8/8 valid NTP replies from pool.ntp.org
2025-02-20 21:27:54.753 INFO Time offset: 1.335651e+00 ms (excluded 0 outliers)
2025-02-20 21:27:54.753 INFO Round-trip delay: 2.736610e+01 ms (excluded 0 outliers)
2025-02-20 22:27:55.101 INFO Received 8/8 valid NTP replies from pool.ntp.org
2025-02-20 22:27:55.101 INFO Time offset: -9.841238e-01 ms (excluded 1 outliers)
2025-02-20 22:27:55.101 INFO Round-trip delay: 3.461661e+01 ms (excluded 1 outliers)
2025-02-20 23:27:55.383 INFO Received 8/8 valid NTP replies from pool.ntp.org
2025-02-20 23:27:55.383 INFO Time offset: -5.796977e+00 ms (excluded 1 outliers)
2025-02-20 23:27:55.383 INFO Round-trip delay: 2.386747e+01 ms (excluded 1 outliers)
2025-02-21 00:27:55.729 INFO Received 8/8 valid NTP replies from pool.ntp.org
2025-02-21 00:27:55.729 INFO Time offset: -1.036078e+00 ms (excluded 0 outliers)
2025-02-21 00:27:55.729 INFO Round-trip delay: 2.951556e+01 ms (excluded 0 outliers)
2025-02-21 01:27:56.034 INFO Received 8/8 valid NTP replies from pool.ntp.org
2025-02-21 01:27:56.034 INFO Time offset: -9.353161e-01 ms (excluded 0 outliers)
2025-02-21 01:27:56.035 INFO Round-trip delay: 2.757740e+01 ms (excluded 0 outliers)
2025-02-21 02:27:56.378 INFO Received 8/8 valid NTP replies from pool.ntp.org
2025-02-21 02:27:56.379 INFO Time offset: 3.127456e-01 ms (excluded 0 outliers)
2025-02-21 02:27:56.379 INFO Round-trip delay: 3.251648e+01 ms (excluded 0 outliers)
2025-02-21 03:27:56.699 INFO Received 8/8 valid NTP replies from pool.ntp.org
2025-02-21 03:27:56.699 INFO Time offset: 2.037627e+00 ms (excluded 1 outliers)
2025-02-21 03:27:56.699 INFO Round-trip delay: 2.910158e+01 ms (excluded 1 outliers)
2025-02-21 04:27:57.004 INFO Received 8/8 valid NTP replies from pool.ntp.org
2025-02-21 04:27:57.004 INFO Time offset: -1.945700e+00 ms (excluded 1 outliers)
2025-02-21 04:27:57.004 INFO Round-trip delay: 3.050300e+01 ms (excluded 1 outliers)
2025-02-21 05:27:57.335 INFO Received 8/8 valid NTP replies from pool.ntp.org
2025-02-21 05:27:57.335 INFO Time offset: -1.985490e+00 ms (excluded 0 outliers)
2025-02-21 05:27:57.335 INFO Round-trip delay: 3.214800e+01 ms (excluded 0 outliers)
2025-02-21 06:27:57.643 INFO Received 8/8 valid NTP replies from pool.ntp.org
2025-02-21 06:27:57.643 INFO Time offset: 6.411473e-01 ms (excluded 2 outliers)
2025-02-21 06:27:57.643 INFO Round-trip delay: 3.048666e+01 ms (excluded 2 outliers)
2025-02-21 07:27:58.020 INFO Received 8/8 valid NTP replies from pool.ntp.org
2025-02-21 07:27:58.020 INFO Time offset: -1.417535e+00 ms (excluded 1 outliers)
2025-02-21 07:27:58.021 INFO Round-trip delay: 3.293358e+01 ms (excluded 1 outliers)
2025-02-21 08:27:58.253 INFO Received 8/8 valid NTP replies from pool.ntp.org
2025-02-21 08:27:58.253 INFO Time offset: 3.934205e-01 ms (excluded 0 outliers)
2025-02-21 08:27:58.253 INFO Round-trip delay: 1.529032e+01 ms (excluded 0 outliers)
2025-02-21 09:27:58.537 INFO Received 8/8 valid NTP replies from pool.ntp.org
2025-02-21 09:27:58.537 INFO Time offset: -1.174348e+00 ms (excluded 1 outliers)
2025-02-21 09:27:58.537 INFO Round-trip delay: 3.047882e+01 ms (excluded 1 outliers)

jfb · February 22, 2025, 2:30am

Try this. Nothing to lose since your query database is empty anyway:

Run these commands to move the existing database to a new file name and create a fresh database.

sudo service pihole-FTL stop

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

sudo service pihole-FTL start

rdwebdesign · February 22, 2025, 4:14am

Try to run pihole -g to fix gravity database.

cups.growths.9s · February 22, 2025, 7:47am

Thanks, I tried both, with no luck.

I have also updated to most recent versions:

Core version is v6.0.3 (Latest: v6.0.3)
Web version is v6.0.1 (Latest: v6.0.1)
FTL version is v6.0.2 (Latest: v6.0.2)

Bucking_Horn · February 22, 2025, 11:10am

Your debug log shows you've disabled importing queries from the long-term database, which may contribute to your observation:

   [database]
     DBimport = false ### CHANGED, default = true

You may re-enable that via Settings | Privacy by ticking Should FTL load queries from the database on (re)start?

Of course, this would only make a difference when there is data in pihole-FTL.db, and upon restarting Pi-hole.

cups.growths.9s · February 22, 2025, 1:26pm

Thank you! This helped.

The new UI confused me with the Basic | Expert toggle and in the pihole -r I did indicate to record everything.

Many thanks.

system · March 15, 2025, 1:26pm

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