list_hosts.py -n (python3.11) generate high cpu spikes

[Giel538]

From version 26.1.1 without any warning the following script is causing cpu spikes of 25 or more.

usr/local/bin/python3 /usr/local/opnsense/scripts/interfaces/list_hosts.py -n (python3.11)

Normally opnsense is running around 4% cpu load without much spikes.


Here you can see the change in cpu usage
https://postimg.cc/9wMDcgC3


This is how it looks on a 1 hour time frame
https://postimg.cc/PLQJYnqk

What is this script doing and is this a fault in the update or is it something in my configuration?

https://postimg.cc/mPVKHdGS

[qballcow]

I had the same things, and tons and tons of I/O during it.
Turned out my hosts.db-wal was very large.
On every run it would read for 10s of seconds and re-create hosts.db-shm that each time grew to 100s of mbytes.

-rw-r--r--  1 hostd hostd  4.0M Mar  2 17:14 hosts.db
-rw-r--r--  1 hostd hostd  197M Mar  2 17:13 hosts.db-shm
-rw-r--r--  1 hostd hostd   99G Mar  2 17:14 hosts.db-wal

After executing a checkpoint with truncate and vacuuming it now runs pretty normal again, still keeping an eye on it.
(Not sure if that was a safe action to do, but current state was not sustainable).