OPNsense
  • Home
  • Help
  • Search
  • Login
  • Register

  • OPNsense Forum »
  • Archive »
  • 20.1 Legacy Series »
  • High IO - sqlite3 process - reset, repair netflow doesn't work
« previous next »
  • Print
Pages: [1]

Author Topic: High IO - sqlite3 process - reset, repair netflow doesn't work  (Read 2032 times)

didibo

  • Newbie
  • *
  • Posts: 30
  • Karma: 1
    • View Profile
High IO - sqlite3 process - reset, repair netflow doesn't work
« on: February 29, 2020, 11:14:59 pm »
The sqlite3 process (/usr/local/bin/sqlite3 /var/netflow/src_addr_086400.sqlite.fix) has started thrashing my disk.
The disk light is on permanently and 'top -m io -o write -s 1' reports 100% utilisation all the time:

PID USERNAME        VCSW  IVCSW   READ  WRITE  FAULT  TOTAL PERCENT COMMAND
58129 root             610      2      0    762      0    762 100.00% sqlite3

I've tried 'Reset Netflow Data' and 'Repair Netflow Data'. I've also tried deleting everything in /var/netflow and rebooting. Every time the server comes back up, this process starts thrashing the disk. The only thing I can do right now is kill -9 the process.

Any ideas on what I can do to fix this?
Logged

didibo

  • Newbie
  • *
  • Posts: 30
  • Karma: 1
    • View Profile
Re: High IO - sqlite3 process - reset, repair netflow doesn't work
« Reply #1 on: March 01, 2020, 12:20:21 am »
I see to have fixed this for now by SSH'ing to the router and selecting '12) Update from console' - when I did that it said it was going to remove the packages '/var/cache/pkg/sqlite-3-3.30.1,1.txz' - after doing that and rebooting the problem seems to have gone away for now, but I will continue to monitor to see if it comes back
Logged

  • Print
Pages: [1]
« previous next »
  • OPNsense Forum »
  • Archive »
  • 20.1 Legacy Series »
  • High IO - sqlite3 process - reset, repair netflow doesn't work
 

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