How to fix database: file is not a database error

If your node was abruptly terminated due to power failure, the database file could be irreversible corrupted, you can see an error Error starting master database on storagenode: database: file is not a database in your logs.

Find out which database is corrupted

The Storage Node software might not mention which database is corrupted or errors displayed are not immediately understandable to the node operator. In this case we recommend to check all databases, as described in the article How to fix a "database disk image is malformed". Please note - the linked article will not help to recover database in state "file is not a database."

Once you discovered which database is irreversibly corrupted, you can continue with fixing.

Recreate corrupted database(s)

1. Stop the storagenode
2. Delete the corrupted database(s)
3. Move all remaining databases (*.db) to the backup folder (the database files are placed in the storage location by default unless you have changed that)
4. Start the storagenode
   it will re-create all needed databases, but they will be empty.
5. Stop the storagenode
6. Move backed up databases back with replace
7. Start the storagenode
8. Check your logs

Please note - since we recreated the database(s) from scratch, some statistics such as bandwidth or disk usage and payout information for shutdown satellites (like the now deprecated Stefan satellite) could be lost, however it will not prevent the storage node from working.

Still have issues?

Ask on the forum!