About Storj DB malformed

Hello Alexey,

I found my node encountered database malformed.
The problematic node may be disqualified because it takes too long to repair.

Can I just move the bandwidth.db file to another server(with SSD) for repair?

In addition, if there is “bandwidthdb: disk I/O error: no such file or directory” after repair, which file needs to be repaired at the same time?

On the other hand, I tried to fix the malformed database.db a long time ago.
After the repair, I use sqlite3 command to check and the result showed “ok”, but there is still a record of “database disk image is malformed” in the node log. How can I fix this problem?

Thank you for your help.

Hello @alvin ,

If you have enough RAM, you can use this method for malformed database:

If the storagenode throws an error

then you have deleted bandwidth.db and have not saved a repaired version in place.

If you do not care about statistic on your dashboard you can re-create it using this guide: https://support.storj.io/hc/en-us/articles/4403032417044-How-to-fix-database-file-is-not-a-database-error