Preflight database error: info: expected schema does not match actual

Node Operators troubleshooting
,
1

Node not start, or start and stop. windows GUI
log show very small information

2020-03-18T23:03:54.307+0200 INFO Configuration loaded from: C:\Program Files\Storj\Storage Node\config.yaml
2020-03-18T23:03:54.321+0200 INFO Operator email: vadim@nvp.ee
2020-03-18T23:03:54.322+0200 INFO operator wallet: 0x0D53d36A422d3Dd841EBaC8508d839259bA0668f
2020-03-18T23:03:54.934+0200 INFO version running on version v0.34.6
2020-03-18T23:03:54.956+0200 INFO db.migration Database Version {“version”: 31}

2

Make sure that your log is pointed to the right place.
Please, enable debug level or start it from a CLI with --log.output stdout

3

ok got the error
2020-03-18T23:20:49.410+0200 DEBUG Unrecoverable error {“error”: “Error during preflight check for storagenode databases: storage node preflight database error: info: expected schema does not match actual: &dbschema.Schema{\n- \tTables: nil,\n+ \tTables: *dbschema.Table{\n+ \t\t&{\n+ \t\t\tName: “test_table”,\n+ \t\t\tColumns: *dbschema.Column{\n+ \t\t\t\t&{Name: “id”, Type: “int”},\n+ \t\t\t\t&{Name: “name”, Type: “varchar(30)”, IsNullable: true},\n+ \t\t\t},\n+ \t\t\tPrimaryKey: string{“id”},\n+ \t\t},\n+ \t},\n \tIndexes: nil,\n }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:301\n\tmain.cmdRun:198\n\tstorj.io/storj/pkg/process.cleanup.func1.2:312\n\tstorj.io/storj/pkg/process.cleanup.func1:330\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:84\n\tstorj.io/storj/pkg/process.Exec:61\n\tmain.(*service).Execute.func1:66\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57”, “errorVerbose”: “Error during preflight check for storagenode databases: storage node preflight database error: info: expected schema does not match actual: &dbschema.Schema{\n- \tTables: nil,\n+ \tTables: *dbschema.Table{\n+ \t\t&{\n+ \t\t\tName: “test_table”,\n+ \t\t\tColumns: *dbschema.Column{\n+ \t\t\t\t&{Name: “id”, Type: “int”},\n+ \t\t\t\t&{Name: “name”, Type: “varchar(30)”, IsNullable: true},\n+ \t\t\t},\n+ \t\t\tPrimaryKey: string{“id”},\n+ \t\t},\n+ \t},\n \tIndexes: nil,\n }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:301\n\tmain.cmdRun:198\n\tstorj.io/storj/pkg/process.cleanup.func1.2:312\n\tstorj.io/storj/pkg/process.cleanup.func1:330\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:84\n\tstorj.io/storj/pkg/process.Exec:61\n\tmain.(*service).Execute.func1:66\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57\n\tmain.cmdRun:200\n\tstorj.io/storj/pkg/process.cleanup.func1.2:312\n\tstorj.io/storj/pkg/process.cleanup.func1:330\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:84\n\tstorj.io/storj/pkg/process.Exec:61\n\tmain.(*service).Execute.func1:66\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57”}

4
  1. Stop the storagenode
  2. Execute either with a local installed sqlite3 or with a docker container (for ref. : https://support.storj.io/hc/en-us/articles/360029309111-How-to-fix-a-database-disk-image-is-malformed-)
sqlite3 info.db
drop table test_table;
.exit
  1. Try to start the storagenode and look into logs
5

Thanks it is working.

i used DB Brouser to integrity check, and delete test table.

Not used to use command line, also it cold be helpful for not expirienced users.

6

why this test table apear on some nodet, but not on other?
I have 20 nodes and it is forst with this problem.

7

the migration has been failed at some point and the check is leaving the test table after preflight