Netflow flowd database corruption on power failure

[dinguz]

On several occasions, I noticed flowd not starting after a power failure. This seems to originate from database corruption, which can't be repaired by a 'repair Netflow data' in the GUI. If I reset the Netflow data and restart flowd, all is well.
Is there something I can do to make Netflow more resilient to power outages? Can switching to ZFS - if possible - help with this?

[GDixon]

A UPS will solve the issue completely and should be used regardless.

A UPS can be inexpensive or expensive that's up to what you need or want. But it is always less expensive than replacing equipment.

[dinguz]

I see your point, but keeping in mind that I use OPNsense for home/hobby purpose, I was hoping to be able to solve this in system configuration, not by adding new hardware

[GDixon]

I had the same problem and the only way i solved it was adding another ups.

My original one was a bit overloaded and marginal for what i was asking it to do.

I never had the data base so corrupted it couldn't be fixed though.

I agree adding more equipment does suck but i know no other way to keep a data base from being corrupted by a sudden shut down.

This is one of the times that adding something in the way of equipment or a UPS is the way to remedy the situation unfortunately.