OPNsense
  • Home
  • Help
  • Search
  • Login
  • Register

  • OPNsense Forum »
  • Archive »
  • 22.1 Legacy Series »
  • 22.1.8 sqlite3 eat cpu 99%
« previous next »
  • Print
Pages: [1]

Author Topic: 22.1.8 sqlite3 eat cpu 99%  (Read 466 times)

Archanfel80

  • Jr. Member
  • **
  • Posts: 54
  • Karma: 6
    • View Profile
22.1.8 sqlite3 eat cpu 99%
« on: May 25, 2022, 02:35:42 pm »
In the latest update (22.1.8) the sqlite3 is also updated to the 3.38.2.
This eats one cpu fully.
Logged

mimugmail

  • Hero Member
  • *****
  • Posts: 6286
  • Karma: 432
    • View Profile
Re: 22.1.8 sqlite3 eat cpu 99%
« Reply #1 on: May 25, 2022, 03:01:53 pm »
Maybe you run Netflow/Insight and the database needs to be repaired cause of the reboot?
Logged
Twitter: mimu_muc
WWW: www.routerperformance.net
Support plans: https://www.max-it.de/en/it-services/opnsense/
Commercial Plugins (German): https://opnsense.max-it.de/

Archanfel80

  • Jr. Member
  • **
  • Posts: 54
  • Karma: 6
    • View Profile
Re: 22.1.8 sqlite3 eat cpu 99%
« Reply #2 on: May 30, 2022, 01:15:33 pm »
Yes, netflow was the issue. I had to disable (purge the database) then re-enable the service. Its solved now.
Thanks! :)
Logged

  • Print
Pages: [1]
« previous next »
  • OPNsense Forum »
  • Archive »
  • 22.1 Legacy Series »
  • 22.1.8 sqlite3 eat cpu 99%
 

OPNsense is an OSS project © Deciso B.V. 2015 - 2023 All rights reserved
  • SMF 2.0.19 | SMF © 2021, Simple Machines
    Privacy Policy
    | XHTML | RSS | WAP2