Update to v0.33.4 causes error: Error during preflight check for storagenode databases

Stop the storagenode.
Make sure, that you open database from the proper location:

sqlite3 satellites.db
drop table test_table;
.exit
sqlite3 storage_usage.db
CREATE TABLE storage_usage (
                                                satellite_id BLOB NOT NULL,
                                                at_rest_total REAL NOT NUll,
                                                interval_start TIMESTAMP NOT NULL,
                                                PRIMARY KEY (satellite_id, interval_start)
                                        );
.exit
sqlite3 reputation.db
CREATE TABLE reputation (
                                                satellite_id BLOB NOT NULL,
                                                uptime_success_count INTEGER NOT NULL,
                                                uptime_total_count INTEGER NOT NULL,
                                                uptime_reputation_alpha REAL NOT NULL,
                                                uptime_reputation_beta REAL NOT NULL,
                                                uptime_reputation_score REAL NOT NULL,
                                                audit_success_count INTEGER NOT NULL,
                                                audit_total_count INTEGER NOT NULL,
                                                audit_reputation_alpha REAL NOT NULL,
                                                audit_reputation_beta REAL NOT NULL,
                                                audit_reputation_score REAL NOT NULL,
                                                disqualified TIMESTAMP,
                                                updated_at TIMESTAMP NOT NULL,
                                                PRIMARY KEY (satellite_id)
                                        );
.exit

You have too many errors with databases. How is your HDD connected to the PC?
If it’s a network connected drive, then it will not work. Only local connected drives are supported.
The only working network protocol is iSCSI, but the latency will lead to lose the race for pieces. And with any network problem your node can be disqualified.

1 Like