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?
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