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 (https://postimg.cc/9wMDcgC3)
This is how it looks on a 1 hour time frame
https://postimg.cc/PLQJYnqk (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 (https://postimg.cc/mPVKHdGS)
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).