I'm pretty sure I have things configured correctly for DNS on my local machine, though, because when I configured OpenWRT to announce the RPI IP (and I'm using Unbound on that same RPI, btw), I read the way to do that is to configure (Linux) clients like that, with 127.0.0.53. It's been set up that way for a few years now, and has been working fine. All the clients on the network use the Unbound server, per my previous tests - and DNS is working.
All clients have been using the "announced" RPI IP via OpenWRT (the Unbound server on the RPi) when they connect to the network. And it definitely was working. But now when I go to the v6 of Pi-hole's admin Query Log page, I just noticed that I'm not seeing my DNS requests showing up at all... I was on seeing them fine on Pi-hole v5. I do see a few (too few) of Unbound's requests, however, but that's it. Very strange...
Here's the data (and that's all - there should be about 3-4 other clients showing up on here). This is after I rebooted the RPi and I guess Unbound queried an NTP server. But there's nothing else in the Query table on that page, when there definitely should be (this is data I cut and pasted from the Pihole web GUI, sorry for the formatting):
2025-02-25 22:57:59
PTR
e.3.4.c.2.2.1.b.a.2.3.2.f.5.0.3.0.0.0.0.0.0.0.0.0.0.0.0.0.8.e.f.ip6.arpa 192.168.1.223 22.2 µs
2025-02-25 22:57:59
PTR
223.1.168.192.in-addr.arpa 192.168.1.223 29.6 µs
2025-02-25 22:57:59
PTR
e.3.4.c.2.2.1.b.a.2.3.2.f.5.0.3.0.0.0.0.0.0.0.0.0.0.0.0.0.8.e.f.ip6.arpa 192.168.1.223 26.9 µs
2025-02-25 22:57:59
AAAA pool.ntp.org 192.168.1.223
2025-02-25 22:57:59
A pool.ntp.org 192.168.1.223
I also just tested going to a domain that I know is blocked by Pi-hole, and it appears to have blocked it, but it didn't show up on the Query Logs page... UPDATE 1: However, I just checked the logs via the Pihole web GUI and it is showing that it is blocking the things I expect to be blocked and it is showing my machine's IP as being observed.
UPDATE 2: Also, out of curiosity I went to the FTL log and it shows this:
2025-02-25 23:28:48.891 INFO Local URI: "/admin/img/favicons/favicon-16x16.png"
2025-02-25 23:29:00.072 ERROR SQLite3: statement aborts at 1: [BEGIN TRANSACTION IMMEDIATE] cannot start a transaction within a transaction (1)
2025-02-25 23:29:00.072 ERROR ERROR: SQL query "BEGIN TRANSACTION IMMEDIATE" failed: SQL logic error (SQLITE_ERROR)
2025-02-25 23:29:00.072 ERROR Storing devices in network table ("BEGIN TRANSACTION IMMEDIATE") failed
2025-02-25 23:30:00.071 ERROR SQLite3: statement aborts at 52: [DELETE FROM query_storage WHERE id IN (SELECT id FROM query_storage WHERE timestamp <= 1732663800 LIMIT (SELECT COUNT(*)/100 FROM query_storage));] database disk image is malformed (11)
2025-02-25 23:30:00.071 ERROR ERROR: SQL query "DELETE FROM query_storage WHERE id IN (SELECT id FROM query_storage WHERE timestamp <= 1732663800 LIMIT (SELECT COUNT(*)/100 FROM query_storage));" failed: database disk image is malformed (SQLITE_CORRUPT)
2025-02-25 23:30:00.071 WARNING Database /etc/pihole/pihole-FTL.db is damaged and cannot be used.
2025-02-25 23:30:00.071 ERROR delete_old_queries_in_DB() failed!
2025-02-25 23:30:00.071 ERROR SQLite3: statement aborts at 1: [BEGIN TRANSACTION IMMEDIATE] cannot start a transaction within a transaction (1)
2025-02-25 23:30:00.071 ERROR ERROR: SQL query "BEGIN TRANSACTION IMMEDIATE" failed: SQL logic error (SQLITE_ERROR)
2025-02-25 23:30:00.071 ERROR Storing devices in network table ("BEGIN TRANSACTION IMMEDIATE") failed
2025-02-25 23:31:00.069 ERROR SQLite3: statement aborts at 1: [BEGIN TRANSACTION IMMEDIATE] cannot start a transaction within a transaction (1)
2025-02-25 23:31:00.069 ERROR ERROR: SQL query "BEGIN TRANSACTION IMMEDIATE" failed: SQL logic error (SQLITE_ERROR)
2025-02-25 23:31:00.069 ERROR Storing devices in network table ("BEGIN TRANSACTION IMMEDIATE") failed
2025-02-25 23:31:28.020 INFO Local URI: "/admin/taillog"
2025-02-25 23:31:28.111 INFO Local URI: "/admin/scripts/js/taillog.js"
2025-02-25 23:31:53.556 INFO Local URI: "/admin/taillog"
2025-02-25 23:32:00.073 ERROR SQLite3: statement aborts at 1: [BEGIN TRANSACTION IMMEDIATE] cannot start a transaction within a transaction (1)
2025-02-25 23:32:00.074 ERROR ERROR: SQL query "BEGIN TRANSACTION IMMEDIATE" failed: SQL logic error (SQLITE_ERROR)
2025-02-25 23:32:00.074 ERROR Storing devices in network table ("BEGIN TRANSACTION IMMEDIATE") failed
2025-02-25 23:32:49.695 INFO Local URI: "/admin/taillog"
2025-02-25 23:33:00.074 ERROR SQLite3: statement aborts at 1: [BEGIN TRANSACTION IMMEDIATE] cannot start a transaction within a transaction (1)
2025-02-25 23:33:00.074 ERROR ERROR: SQL query "BEGIN TRANSACTION IMMEDIATE" failed: SQL logic error (SQLITE_ERROR)
2025-02-25 23:33:00.074 ERROR Storing devices in network table ("BEGIN TRANSACTION IMMEDIATE") failed
2025-02-25 23:33:23.913 INFO Local URI: "/admin/taillog"
This sounds like a problem:
2025-02-25 23:30:00.071 WARNING Database /etc/pihole/pihole-FTL.db is damaged and cannot be used.

Any way to fix this?