Thanks for the reply. I grabbed Alexy’s replacement bandwidth database file and used that one. Killed all of my storagenode statistics but my node is now back up and running.
Here is the full error:
2020-01-30T15:20:19.140Z DEBUG Unrecoverable error {“error”: “Error during preflight check for storagenode databases: storage node preflight database error: bandwidth: expected schema does not match actual: &dbschema.Schema{\n \tTables: *dbschema.Table{\n \t\t&{Name: “bandwidth_usage”, Columns: *dbschema.Column{&{Name: “action”, Type: “INTEGER”}, &{Name: “amount”, Type: “BIGINT”}, &{Name: “created_at”, Type: “TIMESTAMP”}, &{Name: “satellite_id”, Type: “BLOB”}}},\n \t\t&{Name: “bandwidth_usage_rollups”, Columns: *dbschema.Column{&{Name: “action”, Type: “INTEGER”}, &{Name: “amount”, Type: “BIGINT”}, &{Name: “interval_start”, Type: “TIMESTAMP”}, &{Name: “satellite_id”, Type: “BLOB”}}, PrimaryKey: string{“action”, “interval_start”, “satellite_id”}},\n+ \t\t&{\n+ \t\t\tName: “unsent_order”,\n+ \t\t\tColumns: *dbschema.Column{\n+ \t\t\t\t&{Name: “order_limit_expiration”, Type: “TIMESTAMP”},\n+ \t\t\t\t&{Name: “order_limit_serialized”, Type: “BLOB”},\n+ \t\t\t\t&{Name: “order_serialized”, Type: “BLOB”},\n+ \t\t\t\t&{Name: “satellite_id”, Type: “BLOB”},\n+ \t\t\t\t&{Name: “serial_number”, Type: “BLOB”},\n+ \t\t\t\t&{\n+ \t\t\t\t\tName: “uplink_cert_id”,\n+ \t\t\t\t\tType: “INTEGER”,\n+ \t\t\t\t\tReference: &dbschema.Reference{Table: “certificate”, Column: “cert_id”},\n+ \t\t\t\t},\n+ \t\t\t},\n+ \t\t},\n \t},\n \tIndexes: *dbschema.Index{&{Name: “idx_bandwidth_usage_created”, Table: “bandwidth_usage”, Columns: string{“created_at”}}, &{Name: “idx_bandwidth_usage_satellite”, Table: “bandwidth_usage”, Columns: string{“satellite_id”}}},\n }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:317\n\tmain.cmdRun:196\n\tstorj.io/storj/pkg/process.cleanup.func1.2:299\n\tstorj.io/storj/pkg/process.cleanup.func1:317\n\tgithub.com/spf13/cobra.(*Command).execute:826\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:914\n\tgithub.com/spf13/cobra.(*Command).Execute:864\n\tstorj.io/storj/pkg/process.ExecWithCustomConfig:79\n\tstorj.io/storj/pkg/process.Exec:61\n\tmain.main:326\n\truntime.main:203”, “errorVerbose”: “Error during preflight check for storagenode databases: storage node preflight database error: bandwidth: expected schema does not match actual: &dbschema.Schema{\n \tTables: *dbschema.Table{\n \t\t&{Name: “bandwidth_usage”, Columns: *dbschema.Column{&{Name: “action”, Type: “INTEGER”}, &{Name: “amount”, Type: “BIGINT”}, &{Name: “created_at”, Type: “TIMESTAMP”}, &{Name: “satellite_id”, Type: “BLOB”}}},\n \t\t&{Name: “bandwidth_usage_rollups”, Columns: *dbschema.Column{&{Name: “action”, Type: “INTEGER”}, &{Name: “amount”, Type: “BIGINT”}, &{Name: “interval_start”, Type: “TIMESTAMP”}, &{Name: “satellite_id”, Type: “BLOB”}}, PrimaryKey: string{“action”, “interval_start”, “satellite_id”}},\n+ \t\t&{\n+ \t\t\tName: “unsent_order”,\n+ \t\t\tColumns: *dbschema.Column{\n+ \t\t\t\t&{Name: “order_limit_expiration”, Type: “TIMESTAMP”},\n+ \t\t\t\t&{Name: “order_limit_serialized”, Type: “BLOB”},\n+ \t\t\t\t&{Name: “order_serialized”, Type: “BLOB”},\n+ \t\t\t\t&{Name: “satellite_id”, Type: “BLOB”},\n+ \t\t\t\t&{Name: “serial_number”, Type: “BLOB”},\n+ \t\t\t\t&{\n+ \t\t\t\t\tName: “uplink_cert_id”,\n+ \t\t\t\t\tType: “INTEGER”,\n+ \t\t\t\t\tReference: &dbschema.Reference{Table: “certificate”, Column: “cert_id”},\n+ \t\t\t\t},\n+ \t\t\t},\n+ \t\t},\n \t},\n \tIndexes: *dbschema.Index{&{Name: “idx_bandwidth_usage_created”, Table: “bandwidth_usage”, Columns: string{“created_at”}}, &{Name: “idx_bandwidth_usage_satellite”, Table: “bandwidth_usage”, Columns: string{“satellite_id”}}},\n }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:317\n\tmain.cmdRun:196\n\tstorj.io/storj/pkg/process.cleanup.func1.2:299\n\tstorj.io/storj/pkg/process.cleanup.func1:317\n\tgithub.com/spf13/cobra.(*Command).execute:826\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:914\n\tgithub.com/spf13/cobra.(*Command).Execute:864\n\tstorj.io/storj/pkg/process.ExecWithCustomConfig:79\n\tstorj.io/storj/pkg/process.Exec:61\n\tmain.main:326\n\truntime.main:203\n\tmain.cmdRun:198\n\tstorj.io/storj/pkg/process.cleanup.func1.2:299\n\tstorj.io/storj/pkg/process.cleanup.func1:317\n\tgithub.com/spf13/cobra.(*Command).execute:826\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:914\n\tgithub.com/spf13/cobra.(*Command).Execute:864\n\tstorj.io/storj/pkg/process.ExecWithCustomConfig:79\n\tstorj.io/storj/pkg/process.Exec:61\n\tmain.main:326\n\truntime.main:203”}
Error: Error during preflight check for storagenode databases: storage node preflight database error: bandwidth: expected schema does not match actual: &dbschema.Schema{
Tables: *dbschema.Table{
&{Name: “bandwidth_usage”, Columns: *dbschema.Column{&{Name: “action”, Type: “INTEGER”}, &{Name: “amount”, Type: “BIGINT”}, &{Name: “created_at”, Type: “TIMESTAMP”}, &{Name: “satellite_id”, Type: “BLOB”}}},
&{Name: “bandwidth_usage_rollups”, Columns: *dbschema.Column{&{Name: “action”, Type: “INTEGER”}, &{Name: “amount”, Type: “BIGINT”}, &{Name: “interval_start”, Type: “TIMESTAMP”}, &{Name: “satellite_id”, Type: “BLOB”}}, PrimaryKey: string{“action”, “interval_start”, “satellite_id”}},
-
&{
-
Name: "unsent_order",
-
Columns: []*dbschema.Column{
-
&{Name: "order_limit_expiration", Type: "TIMESTAMP"},
-
&{Name: "order_limit_serialized", Type: "BLOB"},
-
&{Name: "order_serialized", Type: "BLOB"},
-
&{Name: "satellite_id", Type: "BLOB"},
-
&{Name: "serial_number", Type: "BLOB"},
-
&{
-
Name: "uplink_cert_id",
-
Type: "INTEGER",
-
Reference: &dbschema.Reference{Table: "certificate", Column: "cert_id"},
-
},
-
},
-
},
},
Indexes: []*dbschema.Index{&{Name: "idx_bandwidth_usage_created", Table: "bandwidth_usage", Columns: []string{"created_at"}}, &{Name: "idx_bandwidth_usage_satellite", Table: "bandwidth_usage", Columns: []string{"satellite_id"}}},
}
storj.io/storj/storagenode/storagenodedb.(*DB).Preflight:317
main.cmdRun:196
storj.io/storj/pkg/process.cleanup.func1.2:299
storj.io/storj/pkg/process.cleanup.func1:317
github.com/spf13/cobra.(*Command).execute:826
github.com/spf13/cobra.(*Command).ExecuteC:914
github.com/spf13/cobra.(*Command).Execute:864
storj.io/storj/pkg/process.ExecWithCustomConfig:79
storj.io/storj/pkg/process.Exec:61
main.main:326
runtime.main:203