Corrupted database

[agente]

I don’t need historic data. Can I delete *.db in my storage dir and start again my node?

[Vadim]

you can move it to some sub folder and start, if all ok, then delete old.

[Alexey]

What happens if I would remove databases

They mostly hold data for reporting on the dashboard. Things like bandwidth used, storage used and payout info. They used to hold piece metadata, but that has been moved to the pieces themselves. So it’s all non-critical right now. I believe the only remaining db with a function to the operation of the node is the piece expiration db, which holds expiration dates for pieces. Losing that means your node doesn’t immediately remove expired pieces. However, those pieces will eventually be cleaned up…

[agente]

so if I have a Jbod is a waste of money to buy an UPS. If I corrupt a database after a shortage it’s not a great problem. I’m not going to lose nothing

[Alexey]

jbod… Did you create a RAID0 pool? If so, with one disk failure your node will gone.
If it managed corrupt databases, it likely corrupt pieces, what is your suspension and audit scores?

[arrogantrabbit]

You will lose data. “Data” can be “some minor block nobody will read ever” or it can be “entire filesystem”.

Buy a UPS. Don’t be penny wise pound foolish.

[agente]

No raid jbod. One to one configuration.
If everything stop for electricity shortage maybe I will lose some pieces and some db will be corrupted nothing more. I never lost entire filesystem for a hdd shutdown.
The question is: not too risky to run without UPS?

[Alexey]

It’s up on you, but 5% of loss is enough to be disqualified.
I personally run Raspberry Pi without any UPS though.