Pi-hole stops resolving - database locked

Help Community Help
1

Tagging Community Help because I'm running on AlmaLinux 9.2. Thank you for your attention!

Expected Behaviour:

Pi-hole should be answering DNS queries from the local network.

Actual Behaviour:

Pi-hole stops responding to DNS queries. Pi-hole is running behind pfSense. When the problem occurs, other clients can ping and dig well-known DNS servers (1.1.1.1 and 9.9.9.9) and the Pi-hole server can ping but not dig the same servers. The Pi-hole was not resolving for a period of 4 hours. There are no errors on the switch at this time. After 4 hours, FTL restarted on its own.

OS: AlmaLinux 9.2 (Turquoise Kodkod) x86_64
Host: X9DRH-7TF/7F/iTF/iF 1234567890
Kernel: 5.14.0-284.25.1.el9_2.x86_64
Uptime: 1 day, 1 hour, 20 mins
Packages: 1944 (rpm)
Shell: bash 5.1.8
CPU: Dual Intel Xeon E5-2667 v2 (32) @ 4.000GHz
Memory: 4646MiB / 63853MiB
Network: Intel X520-DA2 @ 10Gbps

I have one very chatty client - my wife's work laptop. There is line after line of warnings that the client is trying using its own domain (wife's work), recurring around every 8 seconds. I see the following in the logs:

[2023-09-11 03:16:45.374 2001M] WARNING in dnsmasq core: Ignoring domain [REDACTED].org for DHCP host name [REDACTED]
[2023-09-11 03:16:52.687 2001M] WARNING in dnsmasq core: Ignoring domain [REDACTED].org for DHCP host name [REDACTED]
[2023-09-11 03:17:00.097 2001M] WARNING in dnsmasq core: Ignoring domain [REDACTED].org for DHCP host name [REDACTED]
[2023-09-11 03:17:00.097 2001/T3546] Encountered error while trying to store client in long-term database
[2023-09-11 03:17:00.097 2001/T3546] Statement finalization failed when trying to store queries to long-term database
[2023-09-11 03:17:00.097 2001/T3546] Error while trying to close database: database is locked
[2023-09-11 03:17:00.100 2001/T3546] SQLite3 message: database is locked in "DELETE FROM network_addresses WHERE lastSeen < 1662887820;" (5)
[2023-09-11 03:17:00.100 2001/T3546] ERROR: SQL query "DELETE FROM network_addresses WHERE lastSeen < 1662887820;" failed: database is locked (SQLITE_BUSY)
[2023-09-11 03:17:01.098 2001M] add_message(type=5, message=Ignoring domain [REDACTED].org for DHCP host name [REDACTED]) - SQL error step DELETE: database is locked
[2023-09-11 03:17:01.098 2001M] Error while trying to close database: database is locked
[2023-09-11 03:17:03.522 2001M] WARNING in dnsmasq core: Ignoring domain [REDACTED].org for DHCP host name [REDACTED]
[2023-09-11 03:17:04.522 2001M] add_message(type=5, message=Ignoring domain [REDACTED].org for DHCP host name [REDACTED]) - SQL error step DELETE: database is locked
[2023-09-11 03:17:04.522 2001M] Error while trying to close database: database is locked
[2023-09-11 03:17:07.050 2001M] WARNING in dnsmasq core: Ignoring domain [REDACTED].org for DHCP host name [REDACTED]
[2023-09-11 03:17:08.050 2001M] add_message(type=5, message=Ignoring domain [REDACTED].org for DHCP host name [REDACTED]) - SQL error step DELETE: database is locked
[2023-09-11 03:17:08.050 2001M] Error while trying to close database: database is locked

[…] Sequence continues until

[2023-09-11 03:18:01.009 2001/T3546] ERROR: SQL query "END TRANSACTION" failed: database is locked (SQLITE_BUSY)
[2023-09-11 03:18:01.009 2001/T3546] END TRANSACTION failed when trying to store queries to long-term database
[2023-09-11 03:18:01.009 2001/T3546] Keeping queries in memory for later new attempt
[2023-09-11 03:18:02.024 2001/T3546] ERROR: SQL query "END TRANSACTION" failed: database is locked (SQLITE_BUSY)
[2023-09-11 03:18:02.024 2001/T3546] WARNING: Storing devices in network table failed: database is locked

[…]

[2023-09-11 04:57:05.104 2001M] WARNING in dnsmasq core: Ignoring domain [REDACTED].org for DHCP host name [REDACTED]
[2023-09-11 04:57:06.105 2001M] add_message(type=5, message=Ignoring domain [REDACTED].org for DHCP host name [REDACTED]) - SQL error step DELETE: database is locked
[2023-09-11 04:57:06.105 2001M] Error while trying to close database: database is locked
[2023-09-11 04:57:08.582 2001M] WARNING in dnsmasq core: Ignoring domain [REDACTED].org for DHCP host name [REDACTED]
[2023-09-11 06:41:56.529 13233M] Using log file /var/log/pihole/FTL.log
[2023-09-11 06:41:56.529 13233M] ########## FTL started on super-1u! ##########
[2023-09-11 06:41:56.529 13233M] FTL branch: master
[2023-09-11 06:41:56.529 13233M] FTL version: v5.23
[2023-09-11 06:41:56.529 13233M] FTL commit: d201776e
[2023-09-11 06:41:56.529 13233M] FTL date: 2023-05-28 11:55:26 +0100
[2023-09-11 06:41:56.529 13233M] FTL user: pihole
[2023-09-11 06:41:56.529 13233M] Compiled for x86_64 (compiled on CI) using gcc (Debian 8.3.0-6) 8.3.0
[2023-09-11 06:41:56.529 13233M] Starting config file parsing (/etc/pihole/pihole-FTL.conf)

Debug Token:

(https://tricorder.pi-hole.net/Al28PwY6/)

2

Are those the DNS servers that Pi-hole uses as upstreams?

Could you check Pi-hole's long term Query Log for that timeframe, specifically for the upstream answers?

3

Hello, I'm back from a trip. Thanks for taking a look.

Yes, these are my upstream DNS servers. I have checked both IP4 columns for Quad9 and Cloudflare. I also have conditional forwarding for 10.0.0.0/22 on domain home.arpa to 10.0.0.1.

726×682 47 KB

There are no queries logged during the error period until FTL restarted.
1023×861 111 KB

4

Adding what I see in /var/log/messages from the time period when FTL stopped responding until it restarted.

Nothing is unusual around 3:15am. This is a normal message for the raid controller starting a concurrent patrol read and consistency check. Both completed without errors.

Sep 11 03:00:00 localhost MR_MONITOR[2694]: <MRMON039> Controller ID:  0   Patrol Read started
Sep 11 03:00:00 localhost MR_MONITOR[2694]: <MRMON066> Controller ID:  0   Consistency Check started on VD:   0
Sep 11 03:41:05 localhost MR_MONITOR[2694]: <MRMON058> Controller ID:  0   Consistency Check done on VD:   0
Sep 11 03:48:56 localhost cupsd[1340]: REQUEST localhost - - "POST / HTTP/1.1" 200 182 Renew-Subscription successful-ok

Here is the restart of FTL.

Sep 11 06:20:02 localhost PackageKit[3748]: uid 0 obtained auth for org.freedesktop.packagekit.system-sources-refresh
Sep 11 06:41:51 localhost systemd[1]: pihole-FTL.service: Main process exited, code=exited, status=1/FAILURE
Sep 11 06:41:51 localhost systemd[1]: pihole-FTL.service: Failed with result 'exit-code'.
Sep 11 06:41:51 localhost systemd[1]: pihole-FTL.service: Consumed 1min 30.610s CPU time.
Sep 11 06:41:56 localhost systemd[1]: pihole-FTL.service: Scheduled restart job, restart counter is at 1.
Sep 11 06:41:56 localhost systemd[1]: Stopped Pi-hole FTL.
Sep 11 06:41:56 localhost systemd[1]: pihole-FTL.service: Consumed 1min 30.610s CPU time.
Sep 11 06:41:56 localhost systemd[1]: Starting Pi-hole FTL...
Sep 11 06:41:56 localhost systemd[1]: Started Pi-hole FTL.
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M] Using log file /var/log/pihole/FTL.log
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M] ########## FTL started on super-1u! ##########
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M] FTL branch: master
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M] FTL version: v5.23
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M] FTL commit: d201776e
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M] FTL date: 2023-05-28 11:55:26 +0100
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M] FTL user: pihole
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M] Compiled for x86_64 (compiled on CI) using gcc (Debian 8.3.0-6) 8.3.0
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M] Starting config file parsing (/etc/pihole/pihole-FTL.conf)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M]    SOCKET_LISTENING: only local
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M]    AAAA_QUERY_ANALYSIS: Show AAAA queries
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M]    MAXDBDAYS: max age for stored queries is 365 days
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M]    RESOLVE_IPV6: Resolve IPv6 addresses
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M]    RESOLVE_IPV4: Resolve IPv4 addresses
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M]    DBINTERVAL: saving to DB file every minute
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M]    DBFILE: Using /etc/pihole/pihole-FTL.db
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M]    MAXLOGAGE: Importing up to 24.0 hours of log data
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M]    PRIVACYLEVEL: Set to 0
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M]    IGNORE_LOCALHOST: Show queries from localhost
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M]    BLOCKINGMODE: Null IPs for blocked domains
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.529 13233M]    ANALYZE_ONLY_A_AND_AAAA: Disabled. Analyzing all queries
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    DBIMPORT: Importing history from database
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    PIDFILE: Using /run/pihole-FTL.pid
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    SOCKETFILE: Using /run/pihole/FTL.sock
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    SETUPVARSFILE: Using /etc/pihole/setupVars.conf
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    MACVENDORDB: Using /etc/pihole/macvendor.db
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    GRAVITYDB: Using /etc/pihole/gravity.db
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    PARSE_ARP_CACHE: Active
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    CNAME_DEEP_INSPECT: Active
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    DELAY_STARTUP: No delay requested.
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    BLOCK_ESNI: Enabled, blocking _esni.{blocked domain}
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    NICE: Set process niceness to -10 (default)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    MAXNETAGE: Removing IP addresses and host names from network table after 365 days
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    NAMES_FROM_NETDB: Enabled, trying to get names from network database
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    EDNS0_ECS: Overwrite client from ECS information
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    REFRESH_HOSTNAMES: Periodically refreshing IPv4 names
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    RATE_LIMIT: Rate-limiting client making more than 10000 queries in 60 seconds
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    LOCAL_IPV4: Automatic interface-dependent detection of address
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    LOCAL_IPV6: Automatic interface-dependent detection of address
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    BLOCK_IPV4: Automatic interface-dependent detection of address
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    BLOCK_IPV6: Automatic interface-dependent detection of address
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    SHOW_DNSSEC: Enabled, showing automatically generated DNSSEC queries
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    MOZILLA_CANARY: Enabled
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    PIHOLE_PTR: internal PTR generation enabled (pi.hole)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    ADDR2LINE: Enabled
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    REPLY_WHEN_BUSY: Drop queries when the database is busy
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    BLOCK_TTL: 2 seconds
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    BLOCK_ICLOUD_PR: Enabled
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    CHECK_LOAD: Enabled
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    CHECK_SHMEM: Warning if shared-memory usage exceeds 90%
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M]    CHECK_DISK: Warning if certain disk usage exceeds 90%
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M] Finished config file parsing
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M] Creating mutex
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M] Creating mutex
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.530 13233M] PID of FTL process: 13233
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.531 13233M] Database version is 12
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.531 13233M] Resizing "FTL-strings" from 40960 to (81920 * 1) == 81920 (/dev/shm: 712.7KB used, 33.5GB total, FTL uses 700.8KB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.531 13233M] Imported 0 alias-clients
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.531 13233M] Database successfully initialized
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.532 13233M] New upstream server: 1.1.1.1:53 (0/512)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.534 13233M] New upstream server: 149.112.112.112:53 (1/512)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.537 13233M] New upstream server: 1.0.0.1:53 (2/512)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.541 13233M] New upstream server: 9.9.9.9:53 (3/512)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.543 13233M] New upstream server: 10.0.0.1:53 (4/512)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.545 13233M] Resizing "FTL-queries" from 229376 to (8192 * 56) == 458752 (/dev/shm: 753.7KB used, 33.5GB total, FTL uses 741.7KB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.550 13233M] Resizing "FTL-domains" from 12288 to (1024 * 24) == 24576 (/dev/shm: 983.0KB u
sed, 33.5GB total, FTL uses 971.1KB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.555 13233M] Resizing "FTL-queries" from 458752 to (12288 * 56) == 688128 (/dev/shm: 995.3K
B used, 33.5GB total, FTL uses 983.4KB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.564 13233M] Resizing "FTL-queries" from 688128 to (16384 * 56) == 917504 (/dev/shm: 1.2MB 
used, 33.5GB total, FTL uses 1.2MB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.573 13233M] Resizing "FTL-queries" from 917504 to (20480 * 56) == 1146880 (/dev/shm: 1.5MB
 used, 33.5GB total, FTL uses 1.4MB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.582 13233M] Resizing "FTL-queries" from 1146880 to (24576 * 56) == 1376256 (/dev/shm: 1.7M
B used, 33.5GB total, FTL uses 1.7MB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.592 13233M] Resizing "FTL-domains" from 24576 to (1536 * 24) == 36864 (/dev/shm: 1.9MB use
d, 33.5GB total, FTL uses 1.9MB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.593 13233M] Resizing "FTL-queries" from 1376256 to (28672 * 56) == 1605632 (/dev/shm: 1.9M
B used, 33.5GB total, FTL uses 1.9MB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.611 13233M] Resizing "FTL-queries" from 1605632 to (32768 * 56) == 1835008 (/dev/shm: 2.2M
B used, 33.5GB total, FTL uses 2.1MB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.631 13233M] Resizing "FTL-queries" from 1835008 to (36864 * 56) == 2064384 (/dev/shm: 2.4M
B used, 33.5GB total, FTL uses 2.4MB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.651 13233M] Resizing "FTL-queries" from 2064384 to (40960 * 56) == 2293760 (/dev/shm: 2.6M
B used, 33.5GB total, FTL uses 2.6MB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.670 13233M] Resizing "FTL-queries" from 2293760 to (45056 * 56) == 2523136 (/dev/shm: 2.8M
B used, 33.5GB total, FTL uses 2.8MB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.689 13233M] Resizing "FTL-queries" from 2523136 to (49152 * 56) == 2752512 (/dev/shm: 3.1M
B used, 33.5GB total, FTL uses 3.1MB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.709 13233M] Resizing "FTL-queries" from 2752512 to (53248 * 56) == 2981888 (/dev/shm: 3.3M
B used, 33.5GB total, FTL uses 3.3MB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.729 13233M] Resizing "FTL-queries" from 2981888 to (57344 * 56) == 3211264 (/dev/shm: 3.5M
B used, 33.5GB total, FTL uses 3.5MB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.748 13233M] Resizing "FTL-queries" from 3211264 to (61440 * 56) == 3440640 (/dev/shm: 3.8M
B used, 33.5GB total, FTL uses 3.7MB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.767 13233M] Resizing "FTL-queries" from 3440640 to (65536 * 56) == 3670016 (/dev/shm: 4.0M
B used, 33.5GB total, FTL uses 4.0MB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.786 13233M] Resizing "FTL-queries" from 3670016 to (69632 * 56) == 3899392 (/dev/shm: 4.2M
B used, 33.5GB total, FTL uses 4.2MB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.805 13233M] Resizing "FTL-queries" from 3899392 to (73728 * 56) == 4128768 (/dev/shm: 4.4M
B used, 33.5GB total, FTL uses 4.4MB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.824 13233M] Resizing "FTL-queries" from 4128768 to (77824 * 56) == 4358144 (/dev/shm: 4.7M
B used, 33.5GB total, FTL uses 4.7MB)
Sep 11 06:41:56 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.844 13233M] Resizing "FTL-queries" from 4358144 to (81920 * 56) == 4587520 (/dev/shm: 4.9M
B used, 33.5GB total, FTL uses 4.9MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.863 13233M] Resizing "FTL-queries" from 4587520 to (86016 * 56) == 4816896 (/dev/shm: 5.1M
B used, 33.5GB total, FTL uses 5.1MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.883 13233M] Resizing "FTL-queries" from 4816896 to (90112 * 56) == 5046272 (/dev/shm: 5.4M
B used, 33.5GB total, FTL uses 5.4MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.903 13233M] Resizing "FTL-queries" from 5046272 to (94208 * 56) == 5275648 (/dev/shm: 5.6M
B used, 33.5GB total, FTL uses 5.6MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.926 13233M] Resizing "FTL-queries" from 5275648 to (98304 * 56) == 5505024 (/dev/shm: 5.8M
B used, 33.5GB total, FTL uses 5.8MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.936 13233M] Resizing "FTL-queries" from 5505024 to (102400 * 56) == 5734400 (/dev/shm: 6.1
MB used, 33.5GB total, FTL uses 6.0MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.937 13233M] Resizing "FTL-domains" from 36864 to (2048 * 24) == 49152 (/dev/shm: 6.3MB use
d, 33.5GB total, FTL uses 6.3MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.945 13233M] Resizing "FTL-strings" from 81920 to (122880 * 1) == 122880 (/dev/shm: 6.3MB u
sed, 33.5GB total, FTL uses 6.3MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.947 13233M] Resizing "FTL-queries" from 5734400 to (106496 * 56) == 5963776 (/dev/shm: 6.3
MB used, 33.5GB total, FTL uses 6.3MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.971 13233M] Resizing "FTL-queries" from 5963776 to (110592 * 56) == 6193152 (/dev/shm: 6.6
MB used, 33.5GB total, FTL uses 6.6MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.983 13233M] Resizing "FTL-queries" from 6193152 to (114688 * 56) == 6422528 (/dev/shm: 6.8
MB used, 33.5GB total, FTL uses 6.8MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:56.995 13233M] Resizing "FTL-queries" from 6422528 to (118784 * 56) == 6651904 (/dev/shm: 7.0
MB used, 33.5GB total, FTL uses 7.0MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:57.005 13233M] Resizing "FTL-domains" from 49152 to (2560 * 24) == 61440 (/dev/shm: 7.3MB use
d, 33.5GB total, FTL uses 7.2MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:57.009 13233M] Resizing "FTL-queries" from 6651904 to (122880 * 56) == 6881280 (/dev/shm: 7.3
MB used, 33.5GB total, FTL uses 7.3MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:57.027 13233M] Resizing "FTL-queries" from 6881280 to (126976 * 56) == 7110656 (/dev/shm: 7.5
MB used, 33.5GB total, FTL uses 7.5MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:57.043 13233M] Resizing "FTL-queries" from 7110656 to (131072 * 56) == 7340032 (/dev/shm: 7.7
MB used, 33.5GB total, FTL uses 7.7MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:57.056 13233M] Resizing "FTL-queries" from 7340032 to (135168 * 56) == 7569408 (/dev/shm: 8.0
MB used, 33.5GB total, FTL uses 7.9MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:57.081 13233M] Resizing "FTL-queries" from 7569408 to (139264 * 56) == 7798784 (/dev/shm: 8.2
MB used, 33.5GB total, FTL uses 8.2MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:57.119 13233M] Resizing "FTL-queries" from 7798784 to (143360 * 56) == 8028160 (/dev/shm: 8.4
MB used, 33.5GB total, FTL uses 8.4MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:57.149 13233M] Resizing "FTL-queries" from 8028160 to (147456 * 56) == 8257536 (/dev/shm: 8.6
MB used, 33.5GB total, FTL uses 8.6MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:57.159 13233M] Resizing "FTL-queries" from 8257536 to (151552 * 56) == 8486912 (/dev/shm: 8.9
MB used, 33.5GB total, FTL uses 8.9MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:57.169 13233M] Resizing "FTL-queries" from 8486912 to (155648 * 56) == 8716288 (/dev/shm: 9.1
MB used, 33.5GB total, FTL uses 9.1MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:57.198 13233M] Resizing "FTL-queries" from 8716288 to (159744 * 56) == 8945664 (/dev/shm: 9.3
MB used, 33.5GB total, FTL uses 9.3MB)
ep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:57.209 13233M] Resizing "FTL-queries" from 8945664 to (163840 * 56) == 9175040 (/dev/shm: 9.6
MB used, 33.5GB total, FTL uses 9.5MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:57.220 13233M] Resizing "FTL-queries" from 9175040 to (167936 * 56) == 9404416 (/dev/shm: 9.8
MB used, 33.5GB total, FTL uses 9.8MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:57.222 13233M] Resizing "FTL-domains" from 61440 to (3072 * 24) == 73728 (/dev/shm: 10.0MB us
ed, 33.5GB total, FTL uses 10.0MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:57.236 13233M] Resizing "FTL-queries" from 9404416 to (172032 * 56) == 9633792 (/dev/shm: 10.
0MB used, 33.5GB total, FTL uses 10.0MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:57.254 13233M] Resizing "FTL-queries" from 9633792 to (176128 * 56) == 9863168 (/dev/shm: 10.
3MB used, 33.5GB total, FTL uses 10.2MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:57.272 13233M] Resizing "FTL-queries" from 9863168 to (180224 * 56) == 10092544 (/dev/shm: 10
.5MB used, 33.5GB total, FTL uses 10.5MB)
Sep 11 06:41:57 localhost pihole-FTL[13233]: [2023-09-11 06:41:5
Sep 11 06:43:56 localhost cupsd[1340]: REQUEST localhost - - "POST / HTTP/1.1" 200 182 Renew-Subscription successful-ok

After this point, the log entries appear to return to a normal pace. Note, the second to last line here appears truncated. That is the way it appears in the logfile.