Archive > 19.1 Legacy Series

SOLVED vnstat (Database load failed)

(1/1)

GDixon:
I'm using


--- Code: ---OPNsense 19.1.b_306-amd64
FreeBSD 11.2-RELEASE-p4-HBSD
OpenSSL 1.0.2q 20 Nov 2018
--- End code ---

vnstat has been working just fine until today. No changes made by me, nothing I know of changed.
I tried restating the service, no help. I tried rebooting, no help. I deleted the plugin and reinstalled, no help.


--- Code: ---vnstatd[51566]: Error: Database load failed even when using backup (Permission denied). Aborting.
--- End code ---

mimugmail:
rm -f /var/lib/vnstat/*

Then restart the service via GUI. Seems your database is corrupt.

I'll try to add a delete button via GUI the next weeks ...

GDixon:
That worked and a button would be wonderful.

Now the question is why did it get corrupted?

Possibly dropped power? I have the box set to resume after a loss of power so I could have missed it.

 I do have a UPS but it's old. I'm thinking I may need to do a real world test on the UPS. ( unplug from electrical service and let it run to see if the OPNsense box shuts down gracefully still or crashes from a bad UPS battery)

GDixon:
had a power outage the night before and yep the battery died before the OPNsense box could do a graceful shutdown.

Batteries ordered to solve the problem!

Thank you for the help :)

Navigation

[0] Message Index

Go to full version