About Storj DB malformed

[Alexey]

Hello @alvin ,

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

Used_serial.db malformed

It’s much simpler than you thought: docker run -it --rm --mount type=tmpfs,destination=/ramdisk,tmpfs-size=1.5G --mount type=bind,src=Y:\storagenode2\storage\,dst=/data sstc/sqlite3 sh /data # cp used_serial.db /ramdisk/ /data # sqlite3 /ramdisk/used_serial.db sqlite> .mode insert sqlite> .output /ramdisk/dump_all.sql sqlite> .dump sqlite> .exit /data # rm /ramdisk/used_serial.db /data # cat /ramdisk/dump_all.sql | grep -v TRANSACTION | grep -v ROLLBACK | grep -v COMMIT >/ramdisk/dump_all_notra…

If the storagenode throws an error

@alvin

“bandwidthdb: disk I/O error: no such file or directory”

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