I could reproduce the issue.
Pi-hole version is development v5.0-118-ge76f011 (Latest: v5.0)
AdminLTE version is v5.0 (Latest: v5.0)
FTL version is new/tre-regex vDev-bc7d84e (Latest: v5.0)
I only use one the default group. Switching it off in group management and then on again stops DNS resolution. Pihole hangs at Querying count of distinct domains in gravity database table vw_gravity. Manually restating by pihole restartdns works without issues.
[2020-07-08 15:26:48.270 10745] gravityDB_open(): Trying to open /etc/pihole/gravity.db in read-only mode
[2020-07-08 15:26:48.271 10745] gravityDB_open(): Setting location for temporary object to MEMORY
[2020-07-08 15:26:48.271 10745] gravityDB_open(): Preparing audit query
[2020-07-08 15:26:48.274 10745] gravityDB_open(): Setting busy timeout to 1000
[2020-07-08 15:26:48.274 10745] gravityDB_open(): Setting busy timeout to zero
[2020-07-08 15:26:48.274 10745] gravityDB_open(): Successfully opened gravity.db
[2020-07-08 15:26:48.274 10745] Querying count of distinct domains in gravity database table vw_gravity
[2020-07-08 15:29:55.711 11047] Using log file /var/log/pihole-FTL.log
[2020-07-08 15:29:55.712 11047] ########## FTL started! ##########
Switching to tweak/gravity_counting_logging and dis/enable default group didn't stop DNS resolution.
However I noticed that the count for regex black/whitelist is wrong....
Maybe vw_gravity was a red hering and it's more the counting of the regex entries.....?
What happens first: counting or logging?
Full log
2020-07-08 15:37:27.701 11740M] ########## FTL started! ##########
[2020-07-08 15:37:27.701 11740M] FTL branch: tweak/gravity_counting_logging
[2020-07-08 15:37:27.701 11740M] FTL version: vDev-5f9a590
[2020-07-08 15:37:27.701 11740M] FTL commit: 5f9a590
[2020-07-08 15:37:27.701 11740M] FTL date: 2020-07-06 16:36:26 +0200
[2020-07-08 15:37:27.701 11740M] FTL user: pihole
[2020-07-08 15:37:27.701 11740M] Compiled for aarch64 (compiled on CI) using aarch64-linux-gnu-gcc (Debian 6.3.0-18) 6.3.0 20170516
[2020-07-08 15:37:27.701 11740M] Starting config file parsing (/etc/pihole/pihole-FTL.conf)
[2020-07-08 15:37:27.701 11740M] SOCKET_LISTENING: only local
[2020-07-08 15:37:27.701 11740M] AAAA_QUERY_ANALYSIS: Show AAAA queries
[2020-07-08 15:37:27.702 11740M] MAXDBDAYS: max age for stored queries is 90 days
[2020-07-08 15:37:27.702 11740M] RESOLVE_IPV6: Resolve IPv6 addresses
[2020-07-08 15:37:27.702 11740M] RESOLVE_IPV4: Resolve IPv4 addresses
[2020-07-08 15:37:27.702 11740M] DBINTERVAL: saving to DB file every minute
[2020-07-08 15:37:27.702 11740M] DBFILE: Using /etc/pihole/pihole-FTL.db
[2020-07-08 15:37:27.702 11740M] MAXLOGAGE: Importing up to 24.0 hours of log data
[2020-07-08 15:37:27.702 11740M] PRIVACYLEVEL: Set to 0
[2020-07-08 15:37:27.702 11740M] IGNORE_LOCALHOST: Show queries from localhost
[2020-07-08 15:37:27.702 11740M] BLOCKINGMODE: Null IPs for blocked domains
[2020-07-08 15:37:27.702 11740M] ANALYZE_ONLY_A_AND_AAAA: Disabled. Analyzing all queries
[2020-07-08 15:37:27.702 11740M] DBIMPORT: Importing history from database
[2020-07-08 15:37:27.702 11740M] PIDFILE: Using /run/pihole-FTL.pid
[2020-07-08 15:37:27.702 11740M] SOCKETFILE: Using /run/pihole/FTL.sock
[2020-07-08 15:37:27.702 11740M] SETUPVARSFILE: Using /etc/pihole/setupVars.conf
[2020-07-08 15:37:27.703 11740M] MACVENDORDB: Using /etc/pihole/macvendor.db
[2020-07-08 15:37:27.703 11740M] GRAVITYDB: Using /etc/pihole/gravity.db
[2020-07-08 15:37:27.703 11740M] PARSE_ARP_CACHE: Active
[2020-07-08 15:37:27.703 11740M] CNAME_DEEP_INSPECT: Active
[2020-07-08 15:37:27.703 11740M] DELAY_STARTUP: No delay requested.
[2020-07-08 15:37:27.703 11740M] NICE: Set process niceness to -10 (default)
[2020-07-08 15:37:27.703 11740M] BLOCK_ESNI: Enabled, blocking _esni.{blocked domain}
[2020-07-08 15:37:27.703 11740M] NAMES_FROM_NETDB: Enabled, trying to get names from network database
[2020-07-08 15:37:27.703 11740M] *****************************
[2020-07-08 15:37:27.703 11740M] * Debugging enabled *
[2020-07-08 15:37:27.703 11740M] * DEBUG_DATABASE YES *
[2020-07-08 15:37:27.703 11740M] * DEBUG_NETWORKING NO *
[2020-07-08 15:37:27.704 11740M] * DEBUG_LOCKS NO *
[2020-07-08 15:37:27.704 11740M] * DEBUG_QUERIES NO *
[2020-07-08 15:37:27.704 11740M] * DEBUG_FLAGS NO *
[2020-07-08 15:37:27.704 11740M] * DEBUG_SHMEM NO *
[2020-07-08 15:37:27.704 11740M] * DEBUG_GC NO *
[2020-07-08 15:37:27.704 11740M] * DEBUG_ARP NO *
[2020-07-08 15:37:27.704 11740M] * DEBUG_REGEX NO *
[2020-07-08 15:37:27.704 11740M] * DEBUG_API NO *
[2020-07-08 15:37:27.704 11740M] * DEBUG_OVERTIME NO *
[2020-07-08 15:37:27.704 11740M] * DEBUG_EXTBLOCKED NO *
[2020-07-08 15:37:27.704 11740M] * DEBUG_CAPS NO *
[2020-07-08 15:37:27.704 11740M] * DEBUG_DNSMASQ_LINES NO *
[2020-07-08 15:37:27.704 11740M] * DEBUG_VECTORS NO *
[2020-07-08 15:37:27.704 11740M] * DEBUG_RESOLVER NO *
[2020-07-08 15:37:27.704 11740M] *****************************
[2020-07-08 15:37:27.704 11740M] Finished config file parsing
[2020-07-08 15:37:27.706 11740M] dbquery: "SELECT VALUE FROM ftl WHERE id = 0;"
[2020-07-08 15:37:27.707 11740M] ---> Result 6 (int)
[2020-07-08 15:37:27.707 11740M] Database version is 6
[2020-07-08 15:37:27.707 11740M] Database successfully initialized
[2020-07-08 15:37:27.708 11740M] DB_read_queries(): "SELECT * FROM queries WHERE timestamp >= 1594129047"
[2020-07-08 15:37:27.709 11740M] New upstream server: 127.0.0.1 (0/128)
[2020-07-08 15:37:27.715 11740M] Resizing "/FTL-strings" from 4096 to 8192
[2020-07-08 15:37:27.733 11740M] Resizing "/FTL-strings" from 8192 to 12288
[2020-07-08 15:37:27.757 11740M] Resizing "/FTL-queries" from 262144 to 524288
[2020-07-08 15:37:27.759 11740M] Resizing "/FTL-strings" from 12288 to 16384
[2020-07-08 15:37:27.760 11740M] New upstream server: 10.0.1.1 (1/128)
[2020-07-08 15:37:27.918 11740M] Resizing "/FTL-queries" from 524288 to 786432
[2020-07-08 15:37:28.085 11740M] Resizing "/FTL-queries" from 786432 to 1048576
[2020-07-08 15:37:28.253 11740M] Resizing "/FTL-queries" from 1048576 to 1310720
[2020-07-08 15:37:28.421 11740M] Resizing "/FTL-queries" from 1310720 to 1572864
[2020-07-08 15:37:28.567 11740M] Resizing "/FTL-queries" from 1572864 to 1835008
[2020-07-08 15:37:28.596 11740M] Resizing "/FTL-strings" from 16384 to 20480
[2020-07-08 15:37:28.630 11740M] Resizing "/FTL-queries" from 1835008 to 2097152
[2020-07-08 15:37:28.670 11740M] Resizing "/FTL-queries" from 2097152 to 2359296
[2020-07-08 15:37:28.673 11740M] Resizing "/FTL-strings" from 20480 to 24576
[2020-07-08 15:37:28.747 11740M] Resizing "/FTL-queries" from 2359296 to 2621440
[2020-07-08 15:37:28.749 11740M] Resizing "/FTL-strings" from 24576 to 28672
[2020-07-08 15:37:28.805 11740M] Imported 40411 queries from the long-term database
[2020-07-08 15:37:28.807 11740M] -> Total DNS queries: 40411
[2020-07-08 15:37:28.807 11740M] -> Cached DNS queries: 4290
[2020-07-08 15:37:28.807 11740M] -> Forwarded DNS queries: 28785
[2020-07-08 15:37:28.808 11740M] -> Blocked DNS queries: 7336
[2020-07-08 15:37:28.808 11740M] -> Unknown DNS queries: 0
[2020-07-08 15:37:28.808 11740M] -> Unique domains: 1275
[2020-07-08 15:37:28.808 11740M] -> Unique clients: 13
[2020-07-08 15:37:28.808 11740M] -> Known forward destinations: 2
[2020-07-08 15:37:28.808 11740M] Successfully accessed setupVars.conf
[2020-07-08 15:37:28.808 11740M] DEBUG: argv[0] = ""
[2020-07-08 15:37:28.808 11740M] DEBUG: argv[1] = "-k"
[2020-07-08 15:37:28.817 11742M] PID of FTL process: 11742
[2020-07-08 15:37:28.818 11742/T11743] Listening on port 4711 for incoming IPv4 telnet connections
[2020-07-08 15:37:28.819 11742/T11744] Listening on port 4711 for incoming IPv6 telnet connections
[2020-07-08 15:37:28.819 11742M] Reloading DNS cache
[2020-07-08 15:37:28.819 11742M] Blocking status is enabled
[2020-07-08 15:37:28.820 11742M] *****************************
[2020-07-08 15:37:28.820 11742M] * Debugging enabled *
[2020-07-08 15:37:28.820 11742M] * DEBUG_DATABASE YES *
[2020-07-08 15:37:28.820 11742M] * DEBUG_NETWORKING NO *
[2020-07-08 15:37:28.820 11742M] * DEBUG_LOCKS NO *
[2020-07-08 15:37:28.820 11742M] * DEBUG_QUERIES NO *
[2020-07-08 15:37:28.820 11742M] * DEBUG_FLAGS NO *
[2020-07-08 15:37:28.820 11742M] * DEBUG_SHMEM NO *
[2020-07-08 15:37:28.824 11742M] * DEBUG_GC NO *
[2020-07-08 15:37:28.825 11742M] * DEBUG_ARP NO *
[2020-07-08 15:37:28.825 11742M] * DEBUG_REGEX NO *
[2020-07-08 15:37:28.825 11742M] * DEBUG_API NO *
[2020-07-08 15:37:28.826 11742M] * DEBUG_OVERTIME NO *
[2020-07-08 15:37:28.826 11742M] * DEBUG_EXTBLOCKED NO *
[2020-07-08 15:37:28.826 11742M] * DEBUG_CAPS NO *
[2020-07-08 15:37:28.826 11742M] * DEBUG_DNSMASQ_LINES NO *
[2020-07-08 15:37:28.826 11742M] * DEBUG_VECTORS NO *
[2020-07-08 15:37:28.826 11742M] * DEBUG_RESOLVER NO *
[2020-07-08 15:37:28.826 11742M] *****************************
[2020-07-08 15:37:28.826 11742/T11745] Listening on Unix socket
[2020-07-08 15:37:28.827 11742M] dbquery: "DELETE FROM message;"
[2020-07-08 15:37:28.837 11742M] ---> OK
[2020-07-08 15:37:28.838 11742M] gravityDB_open(): Trying to open /etc/pihole/gravity.db in read-only mode
[2020-07-08 15:37:28.838 11742M] gravityDB_open(): Setting location for temporary object to MEMORY
[2020-07-08 15:37:28.840 11742M] gravityDB_open(): Preparing audit query
[2020-07-08 15:37:28.843 11742M] gravityDB_open(): Setting busy timeout to 1000
[2020-07-08 15:37:28.843 11742M] gravityDB_open(): Setting busy timeout to zero
[2020-07-08 15:37:28.843 11742M] gravityDB_open(): Successfully opened gravity.db
[2020-07-08 15:37:28.843 11742M] Querying count of distinct domains in gravity database table vw_gravity: SELECT value FROM info WHERE property = 'gravity_count';
[2020-07-08 15:37:28.844 11742M] Querying count of distinct domains in gravity database table vw_regex_blacklist: SELECT COUNT(DISTINCT domain) FROM vw_regex_blacklist
[2020-07-08 15:37:28.851 11742M] Querying count of distinct domains in gravity database table vw_regex_whitelist: SELECT COUNT(DISTINCT domain) FROM vw_regex_whitelist
[2020-07-08 15:37:28.854 11742M] Querying gravity database for client 10.0.1.1 (getting best match)
[2020-07-08 15:37:28.855 11742M] SQL: Comparing 10.0.1.1 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.855 11742M] SQL: Comparing 10.0.1.1 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.855 11742M] SQL: Comparing 10.0.1.1 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-07-08 15:37:28.855 11742M] SQL: Comparing 10.0.1.1 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.856 11742M] Querying gravity database for client 10.0.1.1 (getting groups)
[2020-07-08 15:37:28.857 11742M] Querying gravity database for client 10.0.99.192 (getting best match)
[2020-07-08 15:37:28.858 11742M] SQL: Comparing 10.0.99.192 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.858 11742M] SQL: Comparing 10.0.99.192 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.859 11742M] SQL: Comparing 10.0.99.192 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-07-08 15:37:28.859 11742M] SQL: Comparing 10.0.99.192 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.859 11742M] Querying gravity database for client 10.0.99.192 (getting groups)
[2020-07-08 15:37:28.861 11742M] Querying gravity database for client 10.0.40.3 (getting best match)
[2020-07-08 15:37:28.861 11742M] SQL: Comparing 10.0.40.3 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.862 11742M] SQL: Comparing 10.0.40.3 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.862 11742M] SQL: Comparing 10.0.40.3 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-07-08 15:37:28.862 11742M] SQL: Comparing 10.0.40.3 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.862 11742M] Querying gravity database for client 10.0.40.3 (getting groups)
[2020-07-08 15:37:28.864 11742M] Querying gravity database for client 10.0.10.64 (getting best match)
[2020-07-08 15:37:28.865 11742M] SQL: Comparing 10.0.10.64 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.865 11742M] SQL: Comparing 10.0.10.64 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.865 11742M] SQL: Comparing 10.0.10.64 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:28.865 11742M] SQL: Comparing 10.0.10.64 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:28.865 11742M] SQL: Comparing 10.0.10.64 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:28.865 11742M] Querying gravity database for client 10.0.10.64 (getting groups)
[2020-07-08 15:37:28.867 11742M] Querying gravity database for client 10.0.10.136 (getting best match)
[2020-07-08 15:37:28.867 11742M] SQL: Comparing 10.0.10.136 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.868 11742M] SQL: Comparing 10.0.10.136 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.868 11742M] SQL: Comparing 10.0.10.136 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:28.868 11742M] SQL: Comparing 10.0.10.136 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:28.868 11742M] SQL: Comparing 10.0.10.136 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:28.868 11742M] Querying gravity database for client 10.0.10.136 (getting groups)
[2020-07-08 15:37:28.869 11742M] Querying gravity database for client 10.0.99.33 (getting best match)
[2020-07-08 15:37:28.870 11742M] SQL: Comparing 10.0.99.33 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.870 11742M] SQL: Comparing 10.0.99.33 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.870 11742M] SQL: Comparing 10.0.99.33 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-07-08 15:37:28.870 11742M] SQL: Comparing 10.0.99.33 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.870 11742M] Querying gravity database for client 10.0.99.33 (getting groups)
[2020-07-08 15:37:28.871 11742M] Querying gravity database for client 10.0.10.84 (getting best match)
[2020-07-08 15:37:28.872 11742M] SQL: Comparing 10.0.10.84 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.872 11742M] SQL: Comparing 10.0.10.84 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.872 11742M] SQL: Comparing 10.0.10.84 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:28.872 11742M] SQL: Comparing 10.0.10.84 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:28.872 11742M] SQL: Comparing 10.0.10.84 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:28.872 11742M] Querying gravity database for client 10.0.10.84 (getting groups)
[2020-07-08 15:37:28.873 11742M] Querying gravity database for client 10.0.10.190 (getting best match)
[2020-07-08 15:37:28.874 11742M] SQL: Comparing 10.0.10.190 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.874 11742M] SQL: Comparing 10.0.10.190 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.874 11742M] SQL: Comparing 10.0.10.190 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:28.874 11742M] SQL: Comparing 10.0.10.190 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:28.874 11742M] SQL: Comparing 10.0.10.190 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:28.874 11742M] Querying gravity database for client 10.0.10.190 (getting groups)
[2020-07-08 15:37:28.875 11742M] Querying gravity database for client 127.0.0.1 (getting best match)
[2020-07-08 15:37:28.875 11742M] SQL: Comparing 127.0.0.1 vs. 10.0.1.0/16 (subnet 255.255.0.0) - NO MATCH
[2020-07-08 15:37:28.875 11742M] SQL: Comparing 127.0.0.1 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-07-08 15:37:28.876 11742M] Querying gravity database for client 10.0.1.2 (getting best match)
[2020-07-08 15:37:28.877 11742M] SQL: Comparing 10.0.1.2 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.877 11742M] SQL: Comparing 10.0.1.2 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.877 11742M] SQL: Comparing 10.0.1.2 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-07-08 15:37:28.877 11742M] SQL: Comparing 10.0.1.2 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.877 11742M] Querying gravity database for client 10.0.1.2 (getting groups)
[2020-07-08 15:37:28.878 11742M] Querying gravity database for client 10.0.1.4 (getting best match)
[2020-07-08 15:37:28.879 11742M] SQL: Comparing 10.0.1.4 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.879 11742M] SQL: Comparing 10.0.1.4 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.879 11742M] SQL: Comparing 10.0.1.4 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-07-08 15:37:28.879 11742M] SQL: Comparing 10.0.1.4 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.879 11742M] Querying gravity database for client 10.0.1.4 (getting groups)
[2020-07-08 15:37:28.880 11742M] Querying gravity database for client 10.0.1.3 (getting best match)
[2020-07-08 15:37:28.880 11742M] SQL: Comparing 10.0.1.3 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.881 11742M] SQL: Comparing 10.0.1.3 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.881 11742M] SQL: Comparing 10.0.1.3 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-07-08 15:37:28.881 11742M] SQL: Comparing 10.0.1.3 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.881 11742M] Querying gravity database for client 10.0.1.3 (getting groups)
[2020-07-08 15:37:28.882 11742M] Querying gravity database for client 10.0.10.6 (getting best match)
[2020-07-08 15:37:28.882 11742M] SQL: Comparing 10.0.10.6 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.882 11742M] SQL: Comparing 10.0.10.6 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:28.882 11742M] SQL: Comparing 10.0.10.6 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:28.882 11742M] SQL: Comparing 10.0.10.6 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:28.882 11742M] SQL: Comparing 10.0.10.6 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:28.883 11742M] Querying gravity database for client 10.0.10.6 (getting groups)
[2020-07-08 15:37:28.883 11742M] Compiled 1 whitelist and 25 blacklist regex filters for 13 clients in 39.4 msec
[2020-07-08 15:37:37.418 11761/F11742] TCP worker forked
[2020-07-08 15:37:37.418 11761/F11742] gravityDB_open(): Trying to open /etc/pihole/gravity.db in read-only mode
[2020-07-08 15:37:37.419 11761/F11742] gravityDB_open(): Setting location for temporary object to MEMORY
[2020-07-08 15:37:37.419 11761/F11742] gravityDB_open(): Preparing audit query
[2020-07-08 15:37:37.423 11761/F11742] gravityDB_open(): Setting busy timeout to 1000
[2020-07-08 15:37:37.423 11761/F11742] gravityDB_open(): Setting busy timeout to zero
[2020-07-08 15:37:37.423 11761/F11742] gravityDB_open(): Successfully opened gravity.db
[2020-07-08 15:37:37.423 11761/F11742] TCP worker terminating (client disconnected)
[2020-07-08 15:37:47.900 11742M] Initializing gravity statements for 10.0.10.136
[2020-07-08 15:37:47.901 11742M] Querying gravity database for client 10.0.10.136 (getting best match)
[2020-07-08 15:37:47.902 11742M] SQL: Comparing 10.0.10.136 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:47.902 11742M] SQL: Comparing 10.0.10.136 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:47.902 11742M] SQL: Comparing 10.0.10.136 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:47.902 11742M] SQL: Comparing 10.0.10.136 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:47.902 11742M] SQL: Comparing 10.0.10.136 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:47.903 11742M] Querying gravity database for client 10.0.10.136 (getting groups)
[2020-07-08 15:37:47.903 11742M] gravityDB_open(): Preparing vw_whitelist statement for client 10.0.10.136
[2020-07-08 15:37:47.903 11742M] get_client_querystr: SELECT EXISTS(SELECT domain from vw_whitelist WHERE domain = ? AND group_id IN (0));
[2020-07-08 15:37:47.904 11742M] gravityDB_open(): Preparing vw_gravity statement for client 10.0.10.136
[2020-07-08 15:37:47.904 11742M] get_client_querystr: SELECT EXISTS(SELECT domain from vw_gravity WHERE domain = ? AND group_id IN (0));
[2020-07-08 15:37:47.905 11742M] gravityDB_open(): Preparing vw_blacklist statement for client 10.0.10.136
[2020-07-08 15:37:47.905 11742M] get_client_querystr: SELECT EXISTS(SELECT domain from vw_blacklist WHERE domain = ? AND group_id IN (0));
[2020-07-08 15:37:47.906 11742M] domain_in_list("discovery-v6.syncthing.net", 0xaaaaef9b53e8, whitelist): 0
[2020-07-08 15:37:47.907 11742M] domain_in_list("discovery-v6.syncthing.net", 0xaaaaef9b3c78, blacklist): 0
[2020-07-08 15:37:47.907 11742M] domain_in_list("discovery-v6.syncthing.net", 0xaaaaef9b37c8, gravity): 0
[2020-07-08 15:37:51.295 11742M] Received: Real-time signal 0 (34 -> 0)
[2020-07-08 15:37:51.296 11742M] dbquery: "DELETE FROM message;"
[2020-07-08 15:37:51.306 11742M] ---> OK
[2020-07-08 15:37:51.307 11742M] gravityDB_open(): Trying to open /etc/pihole/gravity.db in read-only mode
[2020-07-08 15:37:51.307 11742M] gravityDB_open(): Setting location for temporary object to MEMORY
[2020-07-08 15:37:51.307 11742M] gravityDB_open(): Preparing audit query
[2020-07-08 15:37:51.310 11742M] gravityDB_open(): Setting busy timeout to 1000
[2020-07-08 15:37:51.310 11742M] gravityDB_open(): Setting busy timeout to zero
[2020-07-08 15:37:51.311 11742M] gravityDB_open(): Successfully opened gravity.db
[2020-07-08 15:37:51.311 11742M] Querying count of distinct domains in gravity database table vw_gravity: SELECT value FROM info WHERE property = 'gravity_count';
[2020-07-08 15:37:51.312 11742M] Querying count of distinct domains in gravity database table vw_regex_blacklist: SELECT COUNT(DISTINCT domain) FROM vw_regex_blacklist
[2020-07-08 15:37:51.314 11742M] INFO: No regex blacklist entries found
[2020-07-08 15:37:51.314 11742M] Querying count of distinct domains in gravity database table vw_regex_whitelist: SELECT COUNT(DISTINCT domain) FROM vw_regex_whitelist
[2020-07-08 15:37:51.314 11742M] INFO: No regex whitelist entries found
[2020-07-08 15:37:51.315 11742M] Querying gravity database for client 10.0.1.1 (getting best match)
[2020-07-08 15:37:51.315 11742M] SQL: Comparing 10.0.1.1 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.315 11742M] SQL: Comparing 10.0.1.1 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.315 11742M] SQL: Comparing 10.0.1.1 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-07-08 15:37:51.315 11742M] SQL: Comparing 10.0.1.1 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.316 11742M] Querying gravity database for client 10.0.1.1 (getting groups)
[2020-07-08 15:37:51.317 11742M] Querying gravity database for client 10.0.99.192 (getting best match)
[2020-07-08 15:37:51.317 11742M] SQL: Comparing 10.0.99.192 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.317 11742M] SQL: Comparing 10.0.99.192 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.317 11742M] SQL: Comparing 10.0.99.192 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-07-08 15:37:51.318 11742M] SQL: Comparing 10.0.99.192 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.318 11742M] Querying gravity database for client 10.0.99.192 (getting groups)
[2020-07-08 15:37:51.319 11742M] Querying gravity database for client 10.0.40.3 (getting best match)
[2020-07-08 15:37:51.319 11742M] SQL: Comparing 10.0.40.3 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.319 11742M] SQL: Comparing 10.0.40.3 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.319 11742M] SQL: Comparing 10.0.40.3 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-07-08 15:37:51.319 11742M] SQL: Comparing 10.0.40.3 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.320 11742M] Querying gravity database for client 10.0.40.3 (getting groups)
[2020-07-08 15:37:51.321 11742M] Querying gravity database for client 10.0.10.64 (getting best match)
[2020-07-08 15:37:51.321 11742M] SQL: Comparing 10.0.10.64 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.321 11742M] SQL: Comparing 10.0.10.64 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.321 11742M] SQL: Comparing 10.0.10.64 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:51.322 11742M] SQL: Comparing 10.0.10.64 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:51.322 11742M] SQL: Comparing 10.0.10.64 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:51.322 11742M] Querying gravity database for client 10.0.10.64 (getting groups)
[2020-07-08 15:37:51.323 11742M] Querying gravity database for client 10.0.10.136 (getting best match)
[2020-07-08 15:37:51.330 11742M] SQL: Comparing 10.0.10.136 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.331 11742M] SQL: Comparing 10.0.10.136 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.331 11742M] SQL: Comparing 10.0.10.136 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:51.331 11742M] SQL: Comparing 10.0.10.136 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:51.331 11742M] SQL: Comparing 10.0.10.136 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:51.331 11742M] Querying gravity database for client 10.0.10.136 (getting groups)
[2020-07-08 15:37:51.332 11742M] Querying gravity database for client 10.0.99.33 (getting best match)
[2020-07-08 15:37:51.332 11742M] SQL: Comparing 10.0.99.33 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.333 11742M] SQL: Comparing 10.0.99.33 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.333 11742M] SQL: Comparing 10.0.99.33 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-07-08 15:37:51.333 11742M] SQL: Comparing 10.0.99.33 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.333 11742M] Querying gravity database for client 10.0.99.33 (getting groups)
[2020-07-08 15:37:51.334 11742M] Querying gravity database for client 10.0.10.84 (getting best match)
[2020-07-08 15:37:51.334 11742M] SQL: Comparing 10.0.10.84 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.334 11742M] SQL: Comparing 10.0.10.84 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.334 11742M] SQL: Comparing 10.0.10.84 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:51.335 11742M] SQL: Comparing 10.0.10.84 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:51.335 11742M] SQL: Comparing 10.0.10.84 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:51.335 11742M] Querying gravity database for client 10.0.10.84 (getting groups)
[2020-07-08 15:37:51.336 11742M] Querying gravity database for client 10.0.10.190 (getting best match)
[2020-07-08 15:37:51.336 11742M] SQL: Comparing 10.0.10.190 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.336 11742M] SQL: Comparing 10.0.10.190 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.336 11742M] SQL: Comparing 10.0.10.190 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:51.336 11742M] SQL: Comparing 10.0.10.190 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:51.337 11742M] SQL: Comparing 10.0.10.190 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:51.337 11742M] Querying gravity database for client 10.0.10.190 (getting groups)
[2020-07-08 15:37:51.338 11742M] Querying gravity database for client 127.0.0.1 (getting best match)
[2020-07-08 15:37:51.338 11742M] SQL: Comparing 127.0.0.1 vs. 10.0.1.0/16 (subnet 255.255.0.0) - NO MATCH
[2020-07-08 15:37:51.338 11742M] SQL: Comparing 127.0.0.1 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-07-08 15:37:51.339 11742M] Querying gravity database for client 10.0.1.2 (getting best match)
[2020-07-08 15:37:51.339 11742M] SQL: Comparing 10.0.1.2 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.339 11742M] SQL: Comparing 10.0.1.2 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.339 11742M] SQL: Comparing 10.0.1.2 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-07-08 15:37:51.340 11742M] SQL: Comparing 10.0.1.2 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.340 11742M] Querying gravity database for client 10.0.1.2 (getting groups)
[2020-07-08 15:37:51.341 11742M] Querying gravity database for client 10.0.1.4 (getting best match)
[2020-07-08 15:37:51.341 11742M] SQL: Comparing 10.0.1.4 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.341 11742M] SQL: Comparing 10.0.1.4 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.341 11742M] SQL: Comparing 10.0.1.4 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-07-08 15:37:51.341 11742M] SQL: Comparing 10.0.1.4 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.342 11742M] Querying gravity database for client 10.0.1.4 (getting groups)
[2020-07-08 15:37:51.343 11742M] Querying gravity database for client 10.0.1.3 (getting best match)
[2020-07-08 15:37:51.343 11742M] SQL: Comparing 10.0.1.3 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.343 11742M] SQL: Comparing 10.0.1.3 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.343 11742M] SQL: Comparing 10.0.1.3 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-07-08 15:37:51.343 11742M] SQL: Comparing 10.0.1.3 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.343 11742M] Querying gravity database for client 10.0.1.3 (getting groups)
[2020-07-08 15:37:51.344 11742M] Querying gravity database for client 10.0.10.6 (getting best match)
[2020-07-08 15:37:51.345 11742M] SQL: Comparing 10.0.10.6 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.345 11742M] SQL: Comparing 10.0.10.6 vs. 10.0.1.0/16 (subnet 255.255.0.0) - !! MATCH !!
[2020-07-08 15:37:51.345 11742M] SQL: Comparing 10.0.10.6 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:51.345 11742M] SQL: Comparing 10.0.10.6 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:51.345 11742M] SQL: Comparing 10.0.10.6 vs. 10.0.10.1/24 (subnet 255.255.255.0) - !! MATCH !!
[2020-07-08 15:37:51.345 11742M] Querying gravity database for client 10.0.10.6 (getting groups)
[2020-07-08 15:37:51.346 11742M] Compiled 0 whitelist and 0 blacklist regex filters for 13 clients in 33.9 msec