24.7.2 became unusable, hogging all CPU for python3.11 process

[milgner]

After upgrading this morning to the latest version, the system became completely unusable. After some investigation, I found that there was a very noticeable Python 3.11 process related to Netflow which was hogging most of the CPU.

Some browsing on the forums yielded some results that suggested this had already been an issue on older versions.
So, I tried the following things (in order):

- In "Reporting: Settings", used "Reset DNS data"
- same page, used "Reset Netflow Data"
- afterwards, disabled "Enables local gathering of statistics"
- in "Reporting: NetFlow", disabled "capture local"

That final change seems to have helped: now the system is responsive again.

Just posting it here in case anyone else is affected.

[milgner]

Just installed todays update and for some reason it took several minutes after the reboot for the system to become usable again. I couldn't identify any noticeable process hogging the CPU in `top` except `update_tables.py` causing CPU spikes every now and then. Previous mentions on the forum exist... https://forum.opnsense.org/index.php?topic=18215.0

I wonder whether this might be caused by DNS caches having been cleared and needing to be filled again? Although that wouldn't explain why the OPNsense dashboard is slow to load, too.