2021-05-13T19:36:01.407+0200 INFO Configuration loaded {“Location”: “C:\Program Files\Storj\Storage Node\config.yaml”}
2021-05-13T19:36:01.430+0200 INFO Operator email {“Address”: “gerardit4@gmail.com”}
2021-05-13T19:36:01.430+0200 INFO Operator wallet {“Address”: “0xC1E4aD79C6F4FD21C2e09a09639E57D002552Dc5”}
2021-05-13T19:36:01.460+0200 INFO db database does not exists {“database”: “bandwidth”}
2021-05-13T19:36:02.189+0200 INFO Telemetry enabled {“instance ID”: “12ozBa8YJgYxHVs1VesmzE8tWftBBJc2uh5KCgcnPni6mLokTbb”}
2021-05-13T19:36:02.380+0200 INFO db.migration Database Version {“version”: 51}
2021-05-13T19:36:02.395+0200 FATAL Unrecoverable error {“error”: “Error during preflight check for storagenode databases: preflight: database “bandwidth”: expected schema does not match actual: &dbschema.Schema{\n- \tTables: *dbschema.Table{\n- \t\t(\n- \t\t\ts”""\n- \t\t\tName: bandwidth_usage\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: created_at\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t\t(\n- \t\t\ts"""\n- \t\t\tName: bandwidth_usage_rollups\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: interval_start\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t},\n+ \tTables: nil,\n- \tIndexes: *dbschema.Index{\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_created, Columns: created_at, Unique: false, Partial: \"\">
,\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_satellite, Columns: satellite_id, Unique: false, Partial: \"\">
,\n- \t},\n+ \tIndexes: nil,\n }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).preflight:405\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:352\n\tmain.cmdRun:208\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57", “errorVerbose”: “Error during preflight check for storagenode databases: preflight: database “bandwidth”: expected schema does not match actual: &dbschema.Schema{\n- \tTables: *dbschema.Table{\n- \t\t(\n- \t\t\ts”""\n- \t\t\tName: bandwidth_usage\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: created_at\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t\t(\n- \t\t\ts"""\n- \t\t\tName: bandwidth_usage_rollups\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: interval_start\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t},\n+ \tTables: nil,\n- \tIndexes: *dbschema.Index{\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_created, Columns: created_at, Unique: false, Partial: \"\">
,\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_satellite, Columns: satellite_id, Unique: false, Partial: \"\">
,\n- \t},\n+ \tIndexes: nil,\n }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).preflight:405\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:352\n\tmain.cmdRun:208\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57\n\tmain.cmdRun:210\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57"}
2021-05-13T19:36:52.609+0200 INFO Configuration loaded {“Location”: “C:\Program Files\Storj\Storage Node\config.yaml”}
2021-05-13T19:36:52.630+0200 INFO Operator email {“Address”: “gerardit4@gmail.com”}
2021-05-13T19:36:52.630+0200 INFO Operator wallet {“Address”: “0xC1E4aD79C6F4FD21C2e09a09639E57D002552Dc5”}
2021-05-13T19:36:53.344+0200 INFO Telemetry enabled {“instance ID”: “12ozBa8YJgYxHVs1VesmzE8tWftBBJc2uh5KCgcnPni6mLokTbb”}
2021-05-13T19:36:53.395+0200 INFO db.migration Database Version {“version”: 51}
2021-05-13T19:36:53.408+0200 FATAL Unrecoverable error {“error”: “Error during preflight check for storagenode databases: preflight: database “bandwidth”: expected schema does not match actual: &dbschema.Schema{\n- \tTables: *dbschema.Table{\n- \t\t(\n- \t\t\ts”""\n- \t\t\tName: bandwidth_usage\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: created_at\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t\t(\n- \t\t\ts"""\n- \t\t\tName: bandwidth_usage_rollups\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: interval_start\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t},\n+ \tTables: nil,\n- \tIndexes: *dbschema.Index{\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_created, Columns: created_at, Unique: false, Partial: \"\">
,\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_satellite, Columns: satellite_id, Unique: false, Partial: \"\">
,\n- \t},\n+ \tIndexes: nil,\n }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).preflight:405\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:352\n\tmain.cmdRun:208\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57", “errorVerbose”: “Error during preflight check for storagenode databases: preflight: database “bandwidth”: expected schema does not match actual: &dbschema.Schema{\n- \tTables: *dbschema.Table{\n- \t\t(\n- \t\t\ts”""\n- \t\t\tName: bandwidth_usage\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: created_at\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t\t(\n- \t\t\ts"""\n- \t\t\tName: bandwidth_usage_rollups\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: interval_start\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t},\n+ \tTables: nil,\n- \tIndexes: *dbschema.Index{\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_created, Columns: created_at, Unique: false, Partial: \"\">
,\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_satellite, Columns: satellite_id, Unique: false, Partial: \"\">
,\n- \t},\n+ \tIndexes: nil,\n }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).preflight:405\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:352\n\tmain.cmdRun:208\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57\n\tmain.cmdRun:210\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57"}
2021-05-13T19:37:05.156+0200 INFO Configuration loaded {“Location”: “C:\Program Files\Storj\Storage Node\config.yaml”}
2021-05-13T19:37:05.177+0200 INFO Operator email {“Address”: “gerardit4@gmail.com”}
2021-05-13T19:37:05.178+0200 INFO Operator wallet {“Address”: “0xC1E4aD79C6F4FD21C2e09a09639E57D002552Dc5”}
2021-05-13T19:37:05.789+0200 INFO Telemetry enabled {“instance ID”: “12ozBa8YJgYxHVs1VesmzE8tWftBBJc2uh5KCgcnPni6mLokTbb”}
2021-05-13T19:37:05.842+0200 INFO db.migration Database Version {“version”: 51}
2021-05-13T19:37:07.029+0200 FATAL Unrecoverable error {“error”: “Error during preflight check for storagenode databases: preflight: database “bandwidth”: expected schema does not match actual: &dbschema.Schema{\n- \tTables: *dbschema.Table{\n- \t\t(\n- \t\t\ts”""\n- \t\t\tName: bandwidth_usage\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: created_at\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t\t(\n- \t\t\ts"""\n- \t\t\tName: bandwidth_usage_rollups\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: interval_start\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t},\n+ \tTables: nil,\n- \tIndexes: *dbschema.Index{\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_created, Columns: created_at, Unique: false, Partial: \"\">
,\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_satellite, Columns: satellite_id, Unique: false, Partial: \"\">
,\n- \t},\n+ \tIndexes: nil,\n }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).preflight:405\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:352\n\tmain.cmdRun:208\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57", “errorVerbose”: “Error during preflight check for storagenode databases: preflight: database “bandwidth”: expected schema does not match actual: &dbschema.Schema{\n- \tTables: *dbschema.Table{\n- \t\t(\n- \t\t\ts”""\n- \t\t\tName: bandwidth_usage\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: created_at\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t\t(\n- \t\t\ts"""\n- \t\t\tName: bandwidth_usage_rollups\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: interval_start\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t},\n+ \tTables: nil,\n- \tIndexes: *dbschema.Index{\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_created, Columns: created_at, Unique: false, Partial: \"\">
,\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_satellite, Columns: satellite_id, Unique: false, Partial: \"\">
,\n- \t},\n+ \tIndexes: nil,\n }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).preflight:405\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:352\n\tmain.cmdRun:208\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57\n\tmain.cmdRun:210\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57"}
2021-05-13T19:38:59.358+0200 INFO Configuration loaded {“Location”: “C:\Program Files\Storj\Storage Node\config.yaml”}
2021-05-13T19:38:59.380+0200 INFO Operator email {“Address”: “gerardit4@gmail.com”}
2021-05-13T19:38:59.380+0200 INFO Operator wallet {“Address”: “0xC1E4aD79C6F4FD21C2e09a09639E57D002552Dc5”}
2021-05-13T19:39:00.009+0200 INFO Telemetry enabled {“instance ID”: “12ozBa8YJgYxHVs1VesmzE8tWftBBJc2uh5KCgcnPni6mLokTbb”}
2021-05-13T19:39:00.060+0200 INFO db.migration Database Version {“version”: 51}
2021-05-13T19:39:00.899+0200 FATAL Unrecoverable error {“error”: “Error during preflight check for storagenode databases: preflight: database “bandwidth”: expected schema does not match actual: &dbschema.Schema{\n- \tTables: *dbschema.Table{\n- \t\t(\n- \t\t\ts”""\n- \t\t\tName: bandwidth_usage\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: created_at\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t\t(\n- \t\t\ts"""\n- \t\t\tName: bandwidth_usage_rollups\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: interval_start\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t},\n+ \tTables: nil,\n- \tIndexes: *dbschema.Index{\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_created, Columns: created_at, Unique: false, Partial: \"\">
,\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_satellite, Columns: satellite_id, Unique: false, Partial: \"\">
,\n- \t},\n+ \tIndexes: nil,\n }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).preflight:405\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:352\n\tmain.cmdRun:208\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57", “errorVerbose”: “Error during preflight check for storagenode databases: preflight: database “bandwidth”: expected schema does not match actual: &dbschema.Schema{\n- \tTables: *dbschema.Table{\n- \t\t(\n- \t\t\ts”""\n- \t\t\tName: bandwidth_usage\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: created_at\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t\t(\n- \t\t\ts"""\n- \t\t\tName: bandwidth_usage_rollups\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: interval_start\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t},\n+ \tTables: nil,\n- \tIndexes: *dbschema.Index{\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_created, Columns: created_at, Unique: false, Partial: \"\">
,\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_satellite, Columns: satellite_id, Unique: false, Partial: \"\">
,\n- \t},\n+ \tIndexes: nil,\n }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).preflight:405\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:352\n\tmain.cmdRun:208\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57\n\tmain.cmdRun:210\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57"}
2021-05-13T19:39:10.399+0200 INFO Configuration loaded {“Location”: “C:\Program Files\Storj\Storage Node\config.yaml”}
2021-05-13T19:39:10.420+0200 INFO Operator email {“Address”: “gerardit4@gmail.com”}
2021-05-13T19:39:10.420+0200 INFO Operator wallet {“Address”: “0xC1E4aD79C6F4FD21C2e09a09639E57D002552Dc5”}
2021-05-13T19:39:11.001+0200 INFO Telemetry enabled {“instance ID”: “12ozBa8YJgYxHVs1VesmzE8tWftBBJc2uh5KCgcnPni6mLokTbb”}
2021-05-13T19:39:11.052+0200 INFO db.migration Database Version {“version”: 51}
2021-05-13T19:39:12.261+0200 FATAL Unrecoverable error {“error”: “Error during preflight check for storagenode databases: preflight: database “bandwidth”: expected schema does not match actual: &dbschema.Schema{\n- \tTables: *dbschema.Table{\n- \t\t(\n- \t\t\ts”""\n- \t\t\tName: bandwidth_usage\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: created_at\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t\t(\n- \t\t\ts"""\n- \t\t\tName: bandwidth_usage_rollups\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: interval_start\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t},\n+ \tTables: nil,\n- \tIndexes: *dbschema.Index{\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_created, Columns: created_at, Unique: false, Partial: \"\">
,\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_satellite, Columns: satellite_id, Unique: false, Partial: \"\">
,\n- \t},\n+ \tIndexes: nil,\n }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).preflight:405\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:352\n\tmain.cmdRun:208\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57", “errorVerbose”: “Error during preflight check for storagenode databases: preflight: database “bandwidth”: expected schema does not match actual: &dbschema.Schema{\n- \tTables: *dbschema.Table{\n- \t\t(\n- \t\t\ts”""\n- \t\t\tName: bandwidth_usage\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: created_at\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t\t(\n- \t\t\ts"""\n- \t\t\tName: bandwidth_usage_rollups\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: interval_start\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t},\n+ \tTables: nil,\n- \tIndexes: *dbschema.Index{\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_created, Columns: created_at, Unique: false, Partial: \"\">
,\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_satellite, Columns: satellite_id, Unique: false, Partial: \"\">
,\n- \t},\n+ \tIndexes: nil,\n }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).preflight:405\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:352\n\tmain.cmdRun:208\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57\n\tmain.cmdRun:210\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57"}
2021-05-13T19:42:00.479+0200 INFO Configuration loaded {“Location”: “C:\Program Files\Storj\Storage Node\config.yaml”}
2021-05-13T19:42:00.500+0200 INFO Operator email {“Address”: “gerardit4@gmail.com”}
2021-05-13T19:42:00.500+0200 INFO Operator wallet {“Address”: “0xC1E4aD79C6F4FD21C2e09a09639E57D002552Dc5”}
2021-05-13T19:42:00.545+0200 INFO db database does not exists {“database”: “bandwidth”}
2021-05-13T19:42:01.133+0200 INFO Telemetry enabled {“instance ID”: “12ozBa8YJgYxHVs1VesmzE8tWftBBJc2uh5KCgcnPni6mLokTbb”}
2021-05-13T19:42:01.312+0200 INFO db.migration Database Version {“version”: 51}
2021-05-13T19:42:02.377+0200 FATAL Unrecoverable error {“error”: “Error during preflight check for storagenode databases: preflight: database “bandwidth”: expected schema does not match actual: &dbschema.Schema{\n- \tTables: *dbschema.Table{\n- \t\t(\n- \t\t\ts”""\n- \t\t\tName: bandwidth_usage\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: created_at\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t\t(\n- \t\t\ts"""\n- \t\t\tName: bandwidth_usage_rollups\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: interval_start\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t},\n+ \tTables: nil,\n- \tIndexes: *dbschema.Index{\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_created, Columns: created_at, Unique: false, Partial: \"\">
,\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_satellite, Columns: satellite_id, Unique: false, Partial: \"\">
,\n- \t},\n+ \tIndexes: nil,\n }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).preflight:405\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:352\n\tmain.cmdRun:208\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57", “errorVerbose”: “Error during preflight check for storagenode databases: preflight: database “bandwidth”: expected schema does not match actual: &dbschema.Schema{\n- \tTables: *dbschema.Table{\n- \t\t(\n- \t\t\ts”""\n- \t\t\tName: bandwidth_usage\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: created_at\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t\t(\n- \t\t\ts"""\n- \t\t\tName: bandwidth_usage_rollups\n- \t\t\tColumns:\n- \t\t\t\tName: action\n- \t\t\t\tType: INTEGER\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: amount\n- \t\t\t\tType: BIGINT\n- \t\t\t\tNullable: false\n- \t\t\t\tDefault: “”\n- \t\t\t\tReference: nil\n- \t\t\t\tName: interval_start\n- \t\t\t\tType: TIMESTAMP\n- \t\t\t\tNullable: false\n- \t\t\t… // 10 elided lines\n- \t\t\ts"""\n- \t\t),\n- \t},\n+ \tTables: nil,\n- \tIndexes: *dbschema.Index{\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_created, Columns: created_at, Unique: false, Partial: \"\">
,\n- \t\tsIndex<Table: bandwidth_usage, Name: idx_bandwidth_usage_satellite, Columns: satellite_id, Unique: false, Partial: \"\">
,\n- \t},\n+ \tIndexes: nil,\n }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).preflight:405\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:352\n\tmain.cmdRun:208\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57\n\tmain.cmdRun:210\n\tstorj.io/private/process.cleanup.func1.4:363\n\tstorj.io/private/process.cleanup.func1:381\n\tgithub.com/spf13/cobra.(*Command).execute:852\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:960\n\tgithub.com/spf13/cobra.(*Command).Execute:897\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:64\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57"}
Seen something like this when the new node is an older version than the old one. Might be worth checking until an expert turns up!
So what i have to do try to update it?
What I can see you are running it on windows download the latest version from here: https://github.com/storj/storj/releases/download/v1.29.3/storagenode_windows_amd64.msi.zip
It contains the normal installer and when run it will have an update button.
Good luck.
ok thanks im gonna try it out
I tried and when i run it it only gives me the remove button
can you take a screen shot, never seen that
Ok so the errors seems to be the bandwidtdb, you might need to repair it. I had a similar issue so i can direct you to topic that finished few days ago. I’m not sure if it is going to work for you but you might want to try
Recovering bandwidth.db on windows after power failure (Solved) - Node Operators - Storj Community Forum (official)
It is already solved, Just follow it in order. Mabey it will work maybe not. I’m not an expert on databases.
ok thanks for the info
ok i’ve followed the guid from storj that was link and when i arrive to the step where i put the pragma integrity check it says that the database is ok so i suppose thats not the problem I have?
The problem is that version of database is not matched version of storagenode.
- Stop the storagenode service either from the Services applet or from the elevated powershell:
Stop-Service storagenode
- Delete
bandwidth.db
- Move all remained
*.db
to the backup folder - Start the storagenode either from the Services applet or from the elevated powershell:
Restart-Service storagenode
This should create all databases, but they will be empty.
- Stop the storagenode service.
- Restore backed up databases with replace
- Start the storagenode service
- Check your logs
Continue having the same problem
Please, post the next error.
If it’s the same - then you missed one of the steps. For example - forgot to remove bandwodth.db
or did not move databases out of storage location before restart of storagenode.
I think i’ve done everything i’ve doner another time and its the same error
deleted bandwitdh move .db to another folder ,start the service ,stop and then paste again the db that we paste before
Please, copy the error
Now error is different
2021-05-14T17:41:45.472+0200 ERROR preflight:localtime system clock is out of sync with satellite {"Satellite ID": "12L9ZFwhzVpuEKMUNUqkaTLGzwY9G24tbiigLiXpmZWKwmcNDDs", "error": "system clock is out of sync: clock off by 120.010935 minutes", "errorVerbose": "system clock is out of sync: clock off by 120.010935 minutes\n\tstorj.io/storj/storagenode/preflight.(*LocalTime).checkSatelliteTime:132\n\tstorj.io/storj/storagenode/preflight.(*LocalTime).Check.func1:74\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57"}
Please, install https://www.timesynctool.com/ and sync your system clocks.
If this is VM, then enable sync clocks from the host. The host must have synced clock as well.
ok yes now its working lots of thanks