Local dns entries taking significantly more time to get loaded rendering dns resolving unpossible

So after trying to add a local dns entry, i found out my dns was out. Trying to reproduce the issue, I found out that adding a local dns entreis made the pihole-ftl sky rocket in cpu usage for about a minute. It also made pihole unable to resolve dns queries.
Rebooting pihole, I alse saw that when booting, the ftl had about the same issue maxing out cpu usage for a little while.
I am running pihole on a vm with only 1 cpu core but never had the issue before.

edit: it actually maxes cpu for about 5 minutes before comming back down to normal.

Is this via the web interface?

yes it is.
and local queries take much more time than before but I think this has already been pointed out.

I did notice mine felt a little slow when adding a local domain via the web interface yesterday, but didn't think much of it. I'll have a proper play tomorrow some time.

It may all be related to the other issues around cache response times/types. There is already a patch that should fix that in dnsmasq, we just need to bring it into FTL and find out... (Tomorrow, at the very earliest)

ok great to here that thank you very much. I'll keep you updated if I get anything new.

@DL6ER did we change something in FTL startup order that might have affected this? Not dug too deeply but here are some logs after adding a local DNS entry via the web interface

My main Pihole running `:beta-v5.9`
[2021-07-06 07:51:50.626 584M] ########## FTL started on pihole-docker! ##########
[2021-07-06 07:51:50.626 584M] FTL branch: release/v5.9
[2021-07-06 07:51:50.626 584M] FTL version: vDev-8980cc8
[2021-07-06 07:51:50.627 584M] FTL commit: 8980cc8a
[2021-07-06 07:51:50.627 584M] FTL date: 2021-07-06 07:40:50 +0200
[2021-07-06 07:51:50.627 584M] FTL user: root
[2021-07-06 07:51:50.627 584M] Compiled for x86_64 (compiled on CI) using gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516
[2021-07-06 07:51:50.627 584M] Creating mutex
[2021-07-06 07:51:50.627 584M] Creating mutex
[2021-07-06 07:51:50.627 584M] Starting config file parsing (/etc/pihole/pihole-FTL.conf)
[2021-07-06 07:51:50.627 584M]    SOCKET_LISTENING: only local
[2021-07-06 07:51:50.628 584M]    AAAA_QUERY_ANALYSIS: Show AAAA queries
[2021-07-06 07:51:50.628 584M]    MAXDBDAYS: max age for stored queries is 365 days
[2021-07-06 07:51:50.628 584M]    RESOLVE_IPV6: Resolve IPv6 addresses
[2021-07-06 07:51:50.628 584M]    RESOLVE_IPV4: Resolve IPv4 addresses
[2021-07-06 07:51:50.628 584M]    DBINTERVAL: saving to DB file every minute
[2021-07-06 07:51:50.628 584M]    DBFILE: Using /etc/pihole/pihole-FTL.db
[2021-07-06 07:51:50.628 584M]    MAXLOGAGE: Importing up to 24.0 hours of log data
[2021-07-06 07:51:50.628 584M]    PRIVACYLEVEL: Set to 0
[2021-07-06 07:51:50.628 584M]    IGNORE_LOCALHOST: Show queries from localhost
[2021-07-06 07:51:50.628 584M]    BLOCKINGMODE: Null IPs for blocked domains
[2021-07-06 07:51:50.628 584M]    ANALYZE_ONLY_A_AND_AAAA: Disabled. Analyzing all queries
[2021-07-06 07:51:50.628 584M]    DBIMPORT: Importing history from database
[2021-07-06 07:51:50.628 584M]    PIDFILE: Using /run/pihole-FTL.pid
[2021-07-06 07:51:50.629 584M]    PORTFILE: Using /run/pihole-FTL.port
[2021-07-06 07:51:50.629 584M]    SOCKETFILE: Using /run/pihole/FTL.sock
[2021-07-06 07:51:50.629 584M]    SETUPVARSFILE: Using /etc/pihole/setupVars.conf
[2021-07-06 07:51:50.629 584M]    MACVENDORDB: Using /etc/pihole/macvendor.db
[2021-07-06 07:51:50.629 584M]    GRAVITYDB: Using /etc/pihole/gravity.db
[2021-07-06 07:51:50.629 584M]    PARSE_ARP_CACHE: Active
[2021-07-06 07:51:50.629 584M]    CNAME_DEEP_INSPECT: Active
[2021-07-06 07:51:50.629 584M]    DELAY_STARTUP: No delay requested.
[2021-07-06 07:51:50.629 584M]    BLOCK_ESNI: Enabled, blocking _esni.{blocked domain}
[2021-07-06 07:51:50.629 584M]    NICE: Cannot change niceness to -10 (permission denied)
[2021-07-06 07:51:50.630 584M]    MAXNETAGE: Removing IP addresses and host names from network table after 365 days
[2021-07-06 07:51:50.630 584M]    NAMES_FROM_NETDB: Enabled, trying to get names from network database
[2021-07-06 07:51:50.630 584M]    EDNS0_ECS: Overwrite client from ECS information
[2021-07-06 07:51:50.630 584M]    REFRESH_HOSTNAMES: Periodically refreshing IPv4 names
[2021-07-06 07:51:50.630 584M]    RATE_LIMIT: Rate-limiting client making more than 1000 queries in 60 seconds
[2021-07-06 07:51:50.630 584M]    REPLY_ADDR4: Automatic interface-dependent detection of address
[2021-07-06 07:51:50.630 584M]    REPLY_ADDR6: Automatic interface-dependent detection of address
[2021-07-06 07:51:50.630 584M]    SHOW_DNSSEC: Enabled, showing automatically generated DNSSEC queries
[2021-07-06 07:51:50.630 584M]    MOZILLA_CANARY: Enabled
[2021-07-06 07:51:50.630 584M] Finished config file parsing
[2021-07-06 07:51:50.630 584M] WARNING: Starting pihole-FTL as user root is not recommended
[2021-07-06 07:51:50.631 584M] Database version is 9
[2021-07-06 07:51:50.631 584M] Resizing "FTL-strings" from 40960 to (81920 * 1) == 81920 (/dev/shm: 688.1KB used, 67.1MB total, FTL uses 676.2KB)
[2021-07-06 07:51:50.631 584M] Imported 0 alias-clients
[2021-07-06 07:51:50.632 584M] Database successfully initialized
[2021-07-06 07:51:50.632 584M] New upstream server: 8.8.4.4:53 (0/32)
[2021-07-06 07:51:50.637 584M] New upstream server: 192.168.0.1:53 (1/32)
[2021-07-06 07:51:50.683 584M] New upstream server: 8.8.8.8:53 (2/32)
[2021-07-06 07:51:50.721 584M] Resizing "FTL-domains" from 12288 to (1024 * 24) == 24576 (/dev/shm: 729.1KB used, 67.1MB total, FTL uses 717.1KB)
[2021-07-06 07:51:50.850 584M] Resizing "FTL-queries" from 229376 to (8192 * 56) == 458752 (/dev/shm: 741.4KB used, 67.1MB total, FTL uses 729.4KB)
[2021-07-06 07:51:51.053 584M] Resizing "FTL-queries" from 458752 to (12288 * 56) == 688128 (/dev/shm: 970.8KB used, 67.1MB total, FTL uses 958.8KB)
[2021-07-06 07:51:51.319 584M] Resizing "FTL-queries" from 688128 to (16384 * 56) == 917504 (/dev/shm: 1.2MB used, 67.1MB total, FTL uses 1.2MB)
[2021-07-06 07:51:51.416 584M] Resizing "FTL-domains" from 24576 to (1536 * 24) == 36864 (/dev/shm: 1.4MB used, 67.1MB total, FTL uses 1.4MB)
[2021-07-06 07:51:51.531 584M] Resizing "FTL-queries" from 917504 to (20480 * 56) == 1146880 (/dev/shm: 1.4MB used, 67.1MB total, FTL uses 1.4MB)
[2021-07-06 07:51:51.824 584M] Resizing "FTL-queries" from 1146880 to (24576 * 56) == 1376256 (/dev/shm: 1.7MB used, 67.1MB total, FTL uses 1.7MB)
[2021-07-06 07:51:52.112 584M] Resizing "FTL-queries" from 1376256 to (28672 * 56) == 1605632 (/dev/shm: 1.9MB used, 67.1MB total, FTL uses 1.9MB)
[2021-07-06 07:51:52.513 584M] Resizing "FTL-queries" from 1605632 to (32768 * 56) == 1835008 (/dev/shm: 2.1MB used, 67.1MB total, FTL uses 2.1MB)
[2021-07-06 07:51:52.591 584M] Resizing "FTL-domains" from 36864 to (2048 * 24) == 49152 (/dev/shm: 2.4MB used, 67.1MB total, FTL uses 2.3MB)
[2021-07-06 07:51:52.817 584M] Resizing "FTL-queries" from 1835008 to (36864 * 56) == 2064384 (/dev/shm: 2.4MB used, 67.1MB total, FTL uses 2.4MB)
[2021-07-06 07:51:52.920 584M] Resizing "FTL-strings" from 81920 to (122880 * 1) == 122880 (/dev/shm: 2.6MB used, 67.1MB total, FTL uses 2.6MB)
[2021-07-06 07:51:53.149 584M] Resizing "FTL-queries" from 2064384 to (40960 * 56) == 2293760 (/dev/shm: 2.6MB used, 67.1MB total, FTL uses 2.6MB)
[2021-07-06 07:51:53.349 584M] Resizing "FTL-queries" from 2293760 to (45056 * 56) == 2523136 (/dev/shm: 2.9MB used, 67.1MB total, FTL uses 2.9MB)
[2021-07-06 07:51:53.508 584M] Resizing "FTL-queries" from 2523136 to (49152 * 56) == 2752512 (/dev/shm: 3.1MB used, 67.1MB total, FTL uses 3.1MB)
[2021-07-06 07:51:53.715 584M] Imported 46763 queries from the long-term database
[2021-07-06 07:51:53.716 584M]  -> Total DNS queries: 46763
[2021-07-06 07:51:53.716 584M]  -> Cached DNS queries: 10039
[2021-07-06 07:51:53.716 584M]  -> Forwarded DNS queries: 28265
[2021-07-06 07:51:53.716 584M]  -> Blocked DNS queries: 7943
[2021-07-06 07:51:53.716 584M]  -> Unknown DNS queries: 0
[2021-07-06 07:51:53.716 584M]  -> Unique domains: 2010
[2021-07-06 07:51:53.716 584M]  -> Unique clients: 23
[2021-07-06 07:51:53.716 584M]  -> Known forward destinations: 3
[2021-07-06 07:51:53.716 584M] Successfully accessed setupVars.conf
[2021-07-06 07:51:53.716 584M] *************************************************************************
[2021-07-06 07:51:53.716 584M] * WARNING: Required Linux capability CAP_NET_ADMIN not available        *
[2021-07-06 07:51:53.716 584M] *************************************************************************
[2021-07-06 07:51:53.717 584M] *************************************************************************
[2021-07-06 07:51:53.717 584M] * WARNING: Required Linux capability CAP_SYS_NICE not available         *
[2021-07-06 07:51:53.717 584M] *************************************************************************
[2021-07-06 07:51:53.719 584M] listening on 0.0.0.0 port 53
[2021-07-06 07:51:53.719 584M] listening on :: port 53
[2021-07-06 07:51:53.721 584M] PID of FTL process: 584
[2021-07-06 07:51:53.723 584M] INFO: FTL is running as root
[2021-07-06 07:51:53.722 584/T585] Listening on port 4711 for incoming IPv4 telnet connections
[2021-07-06 07:51:53.723 584/T587] Listening on Unix socket
[2021-07-06 07:51:53.725 584M] Reloading DNS cache
[2021-07-06 07:51:53.725 584M] Blocking status is enabled
[2021-07-06 07:51:54.865 584/T588] Compiled 0 whitelist and 0 blacklist regex filters for 23 clients in 0.3 msec

And then switching back to `:v5.8.1`
[2021-07-06 07:55:21.209 544M] ########## FTL started! ##########
[2021-07-06 07:55:21.209 544M] FTL branch: master
[2021-07-06 07:55:21.210 544M] FTL version: v5.8.1
[2021-07-06 07:55:21.210 544M] FTL commit: b90ab8b1
[2021-07-06 07:55:21.210 544M] FTL date: 2021-04-21 20:03:47 +0100
[2021-07-06 07:55:21.210 544M] FTL user: root
[2021-07-06 07:55:21.210 544M] Compiled for x86_64 (compiled on CI) using gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516
[2021-07-06 07:55:21.210 544M] Creating mutex
[2021-07-06 07:55:21.211 544M] Starting config file parsing (/etc/pihole/pihole-FTL.conf)
[2021-07-06 07:55:21.211 544M]    SOCKET_LISTENING: only local
[2021-07-06 07:55:21.211 544M]    AAAA_QUERY_ANALYSIS: Show AAAA queries
[2021-07-06 07:55:21.211 544M]    MAXDBDAYS: max age for stored queries is 365 days
[2021-07-06 07:55:21.211 544M]    RESOLVE_IPV6: Resolve IPv6 addresses
[2021-07-06 07:55:21.211 544M]    RESOLVE_IPV4: Resolve IPv4 addresses
[2021-07-06 07:55:21.211 544M]    DBINTERVAL: saving to DB file every minute
[2021-07-06 07:55:21.211 544M]    DBFILE: Using /etc/pihole/pihole-FTL.db
[2021-07-06 07:55:21.211 544M]    MAXLOGAGE: Importing up to 24.0 hours of log data
[2021-07-06 07:55:21.211 544M]    PRIVACYLEVEL: Set to 0
[2021-07-06 07:55:21.212 544M]    IGNORE_LOCALHOST: Show queries from localhost
[2021-07-06 07:55:21.212 544M]    BLOCKINGMODE: Null IPs for blocked domains
[2021-07-06 07:55:21.212 544M]    ANALYZE_ONLY_A_AND_AAAA: Disabled. Analyzing all queries
[2021-07-06 07:55:21.212 544M]    DBIMPORT: Importing history from database
[2021-07-06 07:55:21.212 544M]    PIDFILE: Using /run/pihole-FTL.pid
[2021-07-06 07:55:21.212 544M]    PORTFILE: Using /run/pihole-FTL.port
[2021-07-06 07:55:21.212 544M]    SOCKETFILE: Using /run/pihole/FTL.sock
[2021-07-06 07:55:21.212 544M]    SETUPVARSFILE: Using /etc/pihole/setupVars.conf
[2021-07-06 07:55:21.212 544M]    MACVENDORDB: Using /etc/pihole/macvendor.db
[2021-07-06 07:55:21.212 544M]    GRAVITYDB: Using /etc/pihole/gravity.db
[2021-07-06 07:55:21.212 544M]    PARSE_ARP_CACHE: Active
[2021-07-06 07:55:21.213 544M]    CNAME_DEEP_INSPECT: Active
[2021-07-06 07:55:21.213 544M]    DELAY_STARTUP: No delay requested.
[2021-07-06 07:55:21.213 544M]    BLOCK_ESNI: Enabled, blocking _esni.{blocked domain}
[2021-07-06 07:55:21.213 544M]    NICE: Cannot change niceness to -10 (permission denied)
[2021-07-06 07:55:21.213 544M]    MAXNETAGE: Removing IP addresses and host names from network table after 365 days
[2021-07-06 07:55:21.213 544M]    NAMES_FROM_NETDB: Enabled, trying to get names from network database
[2021-07-06 07:55:21.213 544M]    EDNS0_ECS: Overwrite client from ECS information
[2021-07-06 07:55:21.213 544M]    REFRESH_HOSTNAMES: Periodically refreshing IPv4 names
[2021-07-06 07:55:21.213 544M]    RATE_LIMIT: Rate-limiting client making more than 1000 queries in 60 seconds
[2021-07-06 07:55:21.213 544M]    REPLY_ADDR4: Automatic interface-dependent detection of address
[2021-07-06 07:55:21.213 544M]    REPLY_ADDR6: Automatic interface-dependent detection of address
[2021-07-06 07:55:21.213 544M] Finished config file parsing
[2021-07-06 07:55:21.213 544M] WARNING: Starting pihole-FTL as user root is not recommended
[2021-07-06 07:55:21.214 544M] Database version is 9
[2021-07-06 07:55:21.214 544M] Imported 0 alias-clients
[2021-07-06 07:55:21.215 544M] Database successfully initialized
[2021-07-06 07:55:21.215 544M] Resizing "FTL-strings" from 40960 to (81920 * 1) == 81920 (/dev/shm: 720.9KB used, 67.1MB total, FTL uses 708.9KB)
[2021-07-06 07:55:21.215 544M] New upstream server: 8.8.4.4:53 (0/512)
[2021-07-06 07:55:21.218 544M] New upstream server: 192.168.0.1:53 (1/512)
[2021-07-06 07:55:21.225 544M] New upstream server: 8.8.8.8:53 (2/512)
[2021-07-06 07:55:21.229 544M] Resizing "FTL-domains" from 12288 to (1024 * 24) == 24576 (/dev/shm: 761.9KB used, 67.1MB total, FTL uses 749.9KB)
[2021-07-06 07:55:21.241 544M] Resizing "FTL-queries" from 262144 to (8192 * 64) == 524288 (/dev/shm: 774.1KB used, 67.1MB total, FTL uses 762.1KB)
[2021-07-06 07:55:21.260 544M] Resizing "FTL-queries" from 524288 to (12288 * 64) == 786432 (/dev/shm: 1.0MB used, 67.1MB total, FTL uses 1.0MB)
[2021-07-06 07:55:21.283 544M] Resizing "FTL-queries" from 786432 to (16384 * 64) == 1048576 (/dev/shm: 1.3MB used, 67.1MB total, FTL uses 1.3MB)
[2021-07-06 07:55:21.292 544M] Resizing "FTL-domains" from 24576 to (1536 * 24) == 36864 (/dev/shm: 1.6MB used, 67.1MB total, FTL uses 1.5MB)
[2021-07-06 07:55:21.303 544M] Resizing "FTL-queries" from 1048576 to (20480 * 64) == 1310720 (/dev/shm: 1.6MB used, 67.1MB total, FTL uses 1.6MB)
[2021-07-06 07:55:21.327 544M] Resizing "FTL-queries" from 1310720 to (24576 * 64) == 1572864 (/dev/shm: 1.8MB used, 67.1MB total, FTL uses 1.8MB)
[2021-07-06 07:55:21.351 544M] Resizing "FTL-queries" from 1572864 to (28672 * 64) == 1835008 (/dev/shm: 2.1MB used, 67.1MB total, FTL uses 2.1MB)
[2021-07-06 07:55:21.381 544M] Resizing "FTL-queries" from 1835008 to (32768 * 64) == 2097152 (/dev/shm: 2.4MB used, 67.1MB total, FTL uses 2.3MB)
[2021-07-06 07:55:21.388 544M] Resizing "FTL-domains" from 36864 to (2048 * 24) == 49152 (/dev/shm: 2.6MB used, 67.1MB total, FTL uses 2.6MB)
[2021-07-06 07:55:21.406 544M] Resizing "FTL-queries" from 2097152 to (36864 * 64) == 2359296 (/dev/shm: 2.6MB used, 67.1MB total, FTL uses 2.6MB)
[2021-07-06 07:55:21.414 544M] Resizing "FTL-strings" from 81920 to (122880 * 1) == 122880 (/dev/shm: 2.9MB used, 67.1MB total, FTL uses 2.9MB)
[2021-07-06 07:55:21.432 544M] Resizing "FTL-queries" from 2359296 to (40960 * 64) == 2621440 (/dev/shm: 2.9MB used, 67.1MB total, FTL uses 2.9MB)
[2021-07-06 07:55:21.450 544M] Resizing "FTL-queries" from 2621440 to (45056 * 64) == 2883584 (/dev/shm: 3.2MB used, 67.1MB total, FTL uses 3.2MB)
[2021-07-06 07:55:21.467 544M] Resizing "FTL-queries" from 2883584 to (49152 * 64) == 3145728 (/dev/shm: 3.5MB used, 67.1MB total, FTL uses 3.4MB)
[2021-07-06 07:55:21.482 544M] Imported 46807 queries from the long-term database
[2021-07-06 07:55:21.483 544M]  -> Total DNS queries: 46807
[2021-07-06 07:55:21.483 544M]  -> Cached DNS queries: 10040
[2021-07-06 07:55:21.483 544M]  -> Forwarded DNS queries: 28316
[2021-07-06 07:55:21.483 544M]  -> Blocked DNS queries: 7935
[2021-07-06 07:55:21.484 544M]  -> Unknown DNS queries: 0
[2021-07-06 07:55:21.484 544M]  -> Unique domains: 2010
[2021-07-06 07:55:21.484 544M]  -> Unique clients: 23
[2021-07-06 07:55:21.484 544M]  -> Known forward destinations: 3
[2021-07-06 07:55:21.484 544M] Successfully accessed setupVars.conf
[2021-07-06 07:55:21.484 544M] *************************************************************************
[2021-07-06 07:55:21.484 544M] * WARNING: Required Linux capability CAP_NET_ADMIN not available        *
[2021-07-06 07:55:21.484 544M] *************************************************************************
[2021-07-06 07:55:21.485 544M] *************************************************************************
[2021-07-06 07:55:21.485 544M] * WARNING: Required Linux capability CAP_SYS_NICE not available         *
[2021-07-06 07:55:21.485 544M] *************************************************************************
[2021-07-06 07:55:21.487 544M] PID of FTL process: 544
[2021-07-06 07:55:21.487 544/T545] Listening on port 4711 for incoming IPv4 telnet connections
[2021-07-06 07:55:21.487 544M] INFO: FTL is running as root
[2021-07-06 07:55:21.488 544/T547] Listening on Unix socket
[2021-07-06 07:55:21.488 544M] Reloading DNS cache
[2021-07-06 07:55:21.489 544M] Blocking status is enabled
[2021-07-06 07:55:22.636 544/T548] Compiled 0 whitelist and 0 blacklist regex filters for 23 clients in 0.2 msec

I do note a fairly significant time difference in the Resizing... parts (same db). Any thoughts?

(edit: Note to add I will add those capabilities, but don't think they're the cause as the difference is quite clear between the two)

Double Edit:
I think on beta it is 10x slower? 3 whole seconds vs ~300 milliseconds on 5.8.1

Bit of an update, trying to update some of the logging policies i found out that it reproduced the issue. So I think the issue, on my side at least, is that whenever an update is made to the pihole-FTL, it has to be reloaded (correct me if I am wrong) which seams to be normal but the time the FTL takes to load seams to be the issue here.
When I boot pihole up, it does the same thing, boots as it would before but then for about 5 minutes the FTL loads or something making it take much more time than before.

The delay issues should be resolved now, please update and test again if the delay is still an issue for you.

Confirmed - it's super zoomy now. Thanks!

[2021-07-06 13:56:19.709 563M] ########## FTL started on pihole-docker! ##########
[2021-07-06 13:56:19.709 563M] FTL branch: release/v5.9
[2021-07-06 13:56:19.709 563M] FTL version: vDev-f31ff95
[2021-07-06 13:56:19.709 563M] FTL commit: f31ff954
[2021-07-06 13:56:19.710 563M] FTL date: 2021-07-06 14:18:12 +0200
[2021-07-06 13:56:19.710 563M] FTL user: root
[2021-07-06 13:56:19.710 563M] Compiled for x86_64 (compiled on CI) using gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516
[2021-07-06 13:56:19.714 563M] Creating mutex
[2021-07-06 13:56:19.714 563M] Creating mutex
[2021-07-06 13:56:19.716 563M] Starting config file parsing (/etc/pihole/pihole-FTL.conf)
[2021-07-06 13:56:19.716 563M]    SOCKET_LISTENING: only local
[2021-07-06 13:56:19.719 563M]    AAAA_QUERY_ANALYSIS: Show AAAA queries
[2021-07-06 13:56:19.719 563M]    MAXDBDAYS: max age for stored queries is 365 days
[2021-07-06 13:56:19.720 563M]    RESOLVE_IPV6: Resolve IPv6 addresses
[2021-07-06 13:56:19.722 563M]    RESOLVE_IPV4: Resolve IPv4 addresses
[2021-07-06 13:56:19.723 563M]    DBINTERVAL: saving to DB file every minute
[2021-07-06 13:56:19.724 563M]    DBFILE: Using /etc/pihole/pihole-FTL.db
[2021-07-06 13:56:19.726 563M]    MAXLOGAGE: Importing up to 24.0 hours of log data
[2021-07-06 13:56:19.728 563M]    PRIVACYLEVEL: Set to 0
[2021-07-06 13:56:19.729 563M]    IGNORE_LOCALHOST: Show queries from localhost
[2021-07-06 13:56:19.730 563M]    BLOCKINGMODE: Null IPs for blocked domains
[2021-07-06 13:56:19.731 563M]    ANALYZE_ONLY_A_AND_AAAA: Disabled. Analyzing all queries
[2021-07-06 13:56:19.733 563M]    DBIMPORT: Importing history from database
[2021-07-06 13:56:19.734 563M]    PIDFILE: Using /run/pihole-FTL.pid
[2021-07-06 13:56:19.736 563M]    PORTFILE: Using /run/pihole-FTL.port
[2021-07-06 13:56:19.738 563M]    SOCKETFILE: Using /run/pihole/FTL.sock
[2021-07-06 13:56:19.739 563M]    SETUPVARSFILE: Using /etc/pihole/setupVars.conf
[2021-07-06 13:56:19.740 563M]    MACVENDORDB: Using /etc/pihole/macvendor.db
[2021-07-06 13:56:19.740 563M]    GRAVITYDB: Using /etc/pihole/gravity.db
[2021-07-06 13:56:19.742 563M]    PARSE_ARP_CACHE: Active
[2021-07-06 13:56:19.742 563M]    CNAME_DEEP_INSPECT: Active
[2021-07-06 13:56:19.742 563M]    DELAY_STARTUP: No delay requested.
[2021-07-06 13:56:19.744 563M]    BLOCK_ESNI: Enabled, blocking _esni.{blocked domain}
[2021-07-06 13:56:19.745 563M]    NICE: Set process niceness to -10 (default)
[2021-07-06 13:56:19.745 563M]    MAXNETAGE: Removing IP addresses and host names from network table after 365 days
[2021-07-06 13:56:19.746 563M]    NAMES_FROM_NETDB: Enabled, trying to get names from network database
[2021-07-06 13:56:19.747 563M]    EDNS0_ECS: Overwrite client from ECS information
[2021-07-06 13:56:19.748 563M]    REFRESH_HOSTNAMES: Periodically refreshing IPv4 names
[2021-07-06 13:56:19.750 563M]    RATE_LIMIT: Rate-limiting client making more than 1000 queries in 60 seconds
[2021-07-06 13:56:19.750 563M]    REPLY_ADDR4: Automatic interface-dependent detection of address
[2021-07-06 13:56:19.750 563M]    REPLY_ADDR6: Automatic interface-dependent detection of address
[2021-07-06 13:56:19.751 563M]    SHOW_DNSSEC: Enabled, showing automatically generated DNSSEC queries
[2021-07-06 13:56:19.751 563M]    MOZILLA_CANARY: Enabled
[2021-07-06 13:56:19.753 563M] Finished config file parsing
[2021-07-06 13:56:19.753 563M] WARNING: Starting pihole-FTL as user root is not recommended
[2021-07-06 13:56:19.755 563M] Database version is 9
[2021-07-06 13:56:19.757 563M] Resizing "FTL-strings" from 40960 to (81920 * 1) == 81920 (/dev/shm: 688.1KB used, 67.1MB total, FTL uses 676.2KB)
[2021-07-06 13:56:19.757 563M] Imported 0 alias-clients
[2021-07-06 13:56:19.757 563M] Database successfully initialized
[2021-07-06 13:56:19.758 563M] New upstream server: 8.8.4.4:53 (0/32)
[2021-07-06 13:56:19.760 563M] New upstream server: 192.168.0.1:53 (1/32)
[2021-07-06 13:56:19.762 563M] New upstream server: 8.8.8.8:53 (2/32)
[2021-07-06 13:56:19.781 563M] Resizing "FTL-queries" from 229376 to (8192 * 56) == 458752 (/dev/shm: 729.1KB used, 67.1MB total, FTL uses 717.1KB)
[2021-07-06 13:56:19.785 563M] Resizing "FTL-domains" from 12288 to (1024 * 24) == 24576 (/dev/shm: 958.5KB used, 67.1MB total, FTL uses 946.5KB)
[2021-07-06 13:56:19.805 563M] Resizing "FTL-queries" from 458752 to (12288 * 56) == 688128 (/dev/shm: 970.8KB used, 67.1MB total, FTL uses 958.8KB)
[2021-07-06 13:56:19.829 563M] Resizing "FTL-queries" from 688128 to (16384 * 56) == 917504 (/dev/shm: 1.2MB used, 67.1MB total, FTL uses 1.2MB)
[2021-07-06 13:56:19.839 563M] Resizing "FTL-domains" from 24576 to (1536 * 24) == 36864 (/dev/shm: 1.4MB used, 67.1MB total, FTL uses 1.4MB)
[2021-07-06 13:56:19.860 563M] Resizing "FTL-queries" from 917504 to (20480 * 56) == 1146880 (/dev/shm: 1.4MB used, 67.1MB total, FTL uses 1.4MB)
[2021-07-06 13:56:19.887 563M] Resizing "FTL-queries" from 1146880 to (24576 * 56) == 1376256 (/dev/shm: 1.7MB used, 67.1MB total, FTL uses 1.7MB)
[2021-07-06 13:56:19.919 563M] Resizing "FTL-queries" from 1376256 to (28672 * 56) == 1605632 (/dev/shm: 1.9MB used, 67.1MB total, FTL uses 1.9MB)
[2021-07-06 13:56:19.938 563M] Resizing "FTL-queries" from 1605632 to (32768 * 56) == 1835008 (/dev/shm: 2.1MB used, 67.1MB total, FTL uses 2.1MB)
[2021-07-06 13:56:19.946 563M] Resizing "FTL-domains" from 36864 to (2048 * 24) == 49152 (/dev/shm: 2.4MB used, 67.1MB total, FTL uses 2.3MB)
[2021-07-06 13:56:19.956 563M] Resizing "FTL-queries" from 1835008 to (36864 * 56) == 2064384 (/dev/shm: 2.4MB used, 67.1MB total, FTL uses 2.4MB)
[2021-07-06 13:56:19.968 563M] Resizing "FTL-strings" from 81920 to (122880 * 1) == 122880 (/dev/shm: 2.6MB used, 67.1MB total, FTL uses 2.6MB)
[2021-07-06 13:56:19.992 563M] Resizing "FTL-queries" from 2064384 to (40960 * 56) == 2293760 (/dev/shm: 2.6MB used, 67.1MB total, FTL uses 2.6MB)
[2021-07-06 13:56:20.014 563M] Imported 40094 queries from the long-term database
[2021-07-06 13:56:20.015 563M]  -> Total DNS queries: 40094
[2021-07-06 13:56:20.015 563M]  -> Cached DNS queries: 8783
[2021-07-06 13:56:20.015 563M]  -> Forwarded DNS queries: 24337
[2021-07-06 13:56:20.015 563M]  -> Blocked DNS queries: 6451
[2021-07-06 13:56:20.015 563M]  -> Unknown DNS queries: 0
[2021-07-06 13:56:20.015 563M]  -> Unique domains: 1810
[2021-07-06 13:56:20.015 563M]  -> Unique clients: 23
[2021-07-06 13:56:20.016 563M]  -> Known forward destinations: 3
[2021-07-06 13:56:20.016 563M] Successfully accessed setupVars.conf
[2021-07-06 13:56:20.017 563M] listening on 0.0.0.0 port 53
[2021-07-06 13:56:20.017 563M] listening on :: port 53
[2021-07-06 13:56:20.019 563M] PID of FTL process: 563
[2021-07-06 13:56:20.019 563M] INFO: FTL is running as root
[2021-07-06 13:56:20.020 563/T564] Listening on port 4711 for incoming IPv4 telnet connections
[2021-07-06 13:56:20.020 563/T566] Listening on Unix socket
[2021-07-06 13:56:20.021 563M] Reloading DNS cache
[2021-07-06 13:56:20.021 563M] Blocking status is enabled
[2021-07-06 13:56:21.217 563/T567] Compiled 0 whitelist and 0 blacklist regex filters for 23 clients in 0.3 msec
1 Like

Yup everything seems to be back to normal, inserting local dns is quick and resolving is to, thanks.