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 2025 times)
didibo
Newbie
Posts: 30
Karma: 1
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
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