Node suspended at restart windows 10

Node Operators troubleshooting
, ,
1

Hi
Due to the upgrade on the pc, I had to turn off the node for 8 hours, now when turning it on I get this error.
I should mention that windows 10 made some errors when starting and loaded a previous version, apparently with a version where the node was not updated.
Any solution to return to life this time or do I already give it up for lost?

2020-09-16T00:10:14.925-0300    FATAL   Unrecoverable error     {"error": "Error during preflight check for storagenode databases: preflight: database \"reputation\": expected schema does not match actual:   &dbschema.Schema{\n  \tTables: []*dbschema.Table{\n  \t\t&{\n  \t\t\tName: \"reputation\",\n  \t\t\tColumns: []*dbschema.Column{\n  \t\t\t\t... // 6 identical elements\n  \t\t\t\t&{Name: \"audit_unknown_reputation_beta\", Type: \"REAL\"},\n  \t\t\t\t&{Name: \"audit_unknown_reputation_score\", Type: \"REAL\"},\n  \t\t\t\t&{\n- \t\t\t\t\tName:       \"disqualified\",\n+ \t\t\t\t\tName:       \"disqualified_at\",\n  \t\t\t\t\tType:       \"TIMESTAMP\",\n  \t\t\t\t\tIsNullable: true,\n  \t\t\t\t\t... // 2 identical fields\n  \t\t\t\t},\n  \t\t\t\t&{Name: \"joined_at\", Type: \"TIMESTAMP\"},\n+ \t\t\t\ts\"Name: offline_suspended_at\\nType: TIMESTAMP\\nNullable: true\\nDefault: \\\"\\\"\\nReference: nil\",\n+ \t\t\t\ts\"Name: offline_under_review_at\\nType: TIMESTAMP\\nNullable: true\\nDefault: \\\"\\\"\\nReference: nil\",\n+ \t\t\t\ts\"Name: online_score\\nType: REAL\\nNullable: false\\nDefault: \\\"\\\"\\nReference: nil\",\n  \t\t\t\t&{Name: \"satellite_id\", Type: \"BLOB\"},\n  \t\t\t\t&{\n- \t\t\t\t\tName:       \"suspended\",\n+ \t\t\t\t\tName:       \"suspended_at\",\n  \t\t\t\t\tType:       \"TIMESTAMP\",\n  \t\t\t\t\tIsNullable: true,\n  \t\t\t\t\t... // 2 identical fields\n  \t\t\t\t},\n  \t\t\t\t&{Name: \"updated_at\", Type: \"TIMESTAMP\"},\n  \t\t\t\t&{Name: \"uptime_reputation_alpha\", Type: \"REAL\"},\n  \t\t\t\t... // 4 identical elements\n  \t\t\t},\n  \t\t\tPrimaryKey: []string{\"satellite_id\"},\n  \t\t\tUnique:     nil,\n  \t\t},\n  \t},\n  \tIndexes: nil,\n  }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:437\n\tmain.cmdRun:194\n\tstorj.io/private/process.cleanup.func1.4:353\n\tstorj.io/private/process.cleanup.func1:371\n\tgithub.com/spf13/cobra.(*Command).execute:840\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:945\n\tgithub.com/spf13/cobra.(*Command).Execute:885\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:66\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57", "errorVerbose": "Error during preflight check for storagenode databases: preflight: database \"reputation\": expected schema does not match actual:   &dbschema.Schema{\n  \tTables: []*dbschema.Table{\n  \t\t&{\n  \t\t\tName: \"reputation\",\n  \t\t\tColumns: []*dbschema.Column{\n  \t\t\t\t... // 6 identical elements\n  \t\t\t\t&{Name: \"audit_unknown_reputation_beta\", Type: \"REAL\"},\n  \t\t\t\t&{Name: \"audit_unknown_reputation_score\", Type: \"REAL\"},\n  \t\t\t\t&{\n- \t\t\t\t\tName:       \"disqualified\",\n+ \t\t\t\t\tName:       \"disqualified_at\",\n  \t\t\t\t\tType:       \"TIMESTAMP\",\n  \t\t\t\t\tIsNullable: true,\n  \t\t\t\t\t... // 2 identical fields\n  \t\t\t\t},\n  \t\t\t\t&{Name: \"joined_at\", Type: \"TIMESTAMP\"},\n+ \t\t\t\ts\"Name: offline_suspended_at\\nType: TIMESTAMP\\nNullable: true\\nDefault: \\\"\\\"\\nReference: nil\",\n+ \t\t\t\ts\"Name: offline_under_review_at\\nType: TIMESTAMP\\nNullable: true\\nDefault: \\\"\\\"\\nReference: nil\",\n+ \t\t\t\ts\"Name: online_score\\nType: REAL\\nNullable: false\\nDefault: \\\"\\\"\\nReference: nil\",\n  \t\t\t\t&{Name: \"satellite_id\", Type: \"BLOB\"},\n  \t\t\t\t&{\n- \t\t\t\t\tName:       \"suspended\",\n+ \t\t\t\t\tName:       \"suspended_at\",\n  \t\t\t\t\tType:       \"TIMESTAMP\",\n  \t\t\t\t\tIsNullable: true,\n  \t\t\t\t\t... // 2 identical fields\n  \t\t\t\t},\n  \t\t\t\t&{Name: \"updated_at\", Type: \"TIMESTAMP\"},\n  \t\t\t\t&{Name: \"uptime_reputation_alpha\", Type: \"REAL\"},\n  \t\t\t\t... // 4 identical elements\n  \t\t\t},\n  \t\t\tPrimaryKey: []string{\"satellite_id\"},\n  \t\t\tUnique:     nil,\n  \t\t},\n  \t},\n  \tIndexes: nil,\n  }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:437\n\tmain.cmdRun:194\n\tstorj.io/private/process.cleanup.func1.4:353\n\tstorj.io/private/process.cleanup.func1:371\n\tgithub.com/spf13/cobra.(*Command).execute:840\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:945\n\tgithub.com/spf13/cobra.(*Command).Execute:885\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:66\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57\n\tmain.cmdRun:196\n\tstorj.io/private/process.cleanup.func1.4:353\n\tstorj.io/private/process.cleanup.func1:371\n\tgithub.com/spf13/cobra.(*Command).execute:840\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:945\n\tgithub.com/spf13/cobra.(*Command).Execute:885\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:66\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57"}
2
  1. Stop the storagenode
  2. Make a backup of reputation.db
  3. Execute with sqlite3 (local or docker version), replace /path/to/reputation.db to the actual one:
sqlite3 /path/to/reputation.db
  1. When you see the sqlite prompt sqlite>, execute:
delete from versions where version = 45;
.exit
  1. Try to start storagenode
  2. Check your logs
3

SQLite version 3.33.0 2020-08-14 13:23:32
Enter “.help” for usage hints.
sqlite> delete from versions where version = 45;
sqlite> .exit

E:\storjnodo>

2020-09-16T09:44:50.013-0300    INFO    db.migration    Database Version        {"version": 43}


2020-09-16T09:44:51.420-0300    FATAL   Unrecoverable error     {"error": "Error during preflight check for storagenode databases: preflight: database \"reputation\": expected schema does not match actual:   &dbschema.Schema{\n  \tTables: []*dbschema.Table{\n  \t\t&{\n  \t\t\tName: \"reputation\",\n  \t\t\tColumns: []*dbschema.Column{\n  \t\t\t\t... // 6 identical elements\n  \t\t\t\t&{Name: \"audit_unknown_reputation_beta\", Type: \"REAL\"},\n  \t\t\t\t&{Name: \"audit_unknown_reputation_score\", Type: \"REAL\"},\n  \t\t\t\t&{\n- \t\t\t\t\tName:       \"disqualified\",\n+ \t\t\t\t\tName:       \"disqualified_at\",\n  \t\t\t\t\tType:       \"TIMESTAMP\",\n  \t\t\t\t\tIsNullable: true,\n  \t\t\t\t\t... // 2 identical fields\n  \t\t\t\t},\n  \t\t\t\t&{Name: \"joined_at\", Type: \"TIMESTAMP\"},\n+ \t\t\t\ts\"Name: offline_suspended_at\\nType: TIMESTAMP\\nNullable: true\\nDefault: \\\"\\\"\\nReference: nil\",\n+ \t\t\t\ts\"Name: offline_under_review_at\\nType: TIMESTAMP\\nNullable: true\\nDefault: \\\"\\\"\\nReference: nil\",\n+ \t\t\t\ts\"Name: online_score\\nType: REAL\\nNullable: false\\nDefault: \\\"\\\"\\nReference: nil\",\n  \t\t\t\t&{Name: \"satellite_id\", Type: \"BLOB\"},\n  \t\t\t\t&{\n- \t\t\t\t\tName:       \"suspended\",\n+ \t\t\t\t\tName:       \"suspended_at\",\n  \t\t\t\t\tType:       \"TIMESTAMP\",\n  \t\t\t\t\tIsNullable: true,\n  \t\t\t\t\t... // 2 identical fields\n  \t\t\t\t},\n  \t\t\t\t&{Name: \"updated_at\", Type: \"TIMESTAMP\"},\n  \t\t\t\t&{Name: \"uptime_reputation_alpha\", Type: \"REAL\"},\n  \t\t\t\t... // 4 identical elements\n  \t\t\t},\n  \t\t\tPrimaryKey: []string{\"satellite_id\"},\n  \t\t\tUnique:     nil,\n  \t\t},\n  \t},\n  \tIndexes: nil,\n  }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:437\n\tmain.cmdRun:194\n\tstorj.io/private/process.cleanup.func1.4:353\n\tstorj.io/private/process.cleanup.func1:371\n\tgithub.com/spf13/cobra.(*Command).execute:840\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:945\n\tgithub.com/spf13/cobra.(*Command).Execute:885\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:66\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57", "errorVerbose": "Error during preflight check for storagenode databases: preflight: database \"reputation\": expected schema does not match actual:   &dbschema.Schema{\n  \tTables: []*dbschema.Table{\n  \t\t&{\n  \t\t\tName: \"reputation\",\n  \t\t\tColumns: []*dbschema.Column{\n  \t\t\t\t... // 6 identical elements\n  \t\t\t\t&{Name: \"audit_unknown_reputation_beta\", Type: \"REAL\"},\n  \t\t\t\t&{Name: \"audit_unknown_reputation_score\", Type: \"REAL\"},\n  \t\t\t\t&{\n- \t\t\t\t\tName:       \"disqualified\",\n+ \t\t\t\t\tName:       \"disqualified_at\",\n  \t\t\t\t\tType:       \"TIMESTAMP\",\n  \t\t\t\t\tIsNullable: true,\n  \t\t\t\t\t... // 2 identical fields\n  \t\t\t\t},\n  \t\t\t\t&{Name: \"joined_at\", Type: \"TIMESTAMP\"},\n+ \t\t\t\ts\"Name: offline_suspended_at\\nType: TIMESTAMP\\nNullable: true\\nDefault: \\\"\\\"\\nReference: nil\",\n+ \t\t\t\ts\"Name: offline_under_review_at\\nType: TIMESTAMP\\nNullable: true\\nDefault: \\\"\\\"\\nReference: nil\",\n+ \t\t\t\ts\"Name: online_score\\nType: REAL\\nNullable: false\\nDefault: \\\"\\\"\\nReference: nil\",\n  \t\t\t\t&{Name: \"satellite_id\", Type: \"BLOB\"},\n  \t\t\t\t&{\n- \t\t\t\t\tName:       \"suspended\",\n+ \t\t\t\t\tName:       \"suspended_at\",\n  \t\t\t\t\tType:       \"TIMESTAMP\",\n  \t\t\t\t\tIsNullable: true,\n  \t\t\t\t\t... // 2 identical fields\n  \t\t\t\t},\n  \t\t\t\t&{Name: \"updated_at\", Type: \"TIMESTAMP\"},\n  \t\t\t\t&{Name: \"uptime_reputation_alpha\", Type: \"REAL\"},\n  \t\t\t\t... // 4 identical elements\n  \t\t\t},\n  \t\t\tPrimaryKey: []string{\"satellite_id\"},\n  \t\t\tUnique:     nil,\n  \t\t},\n  \t},\n  \tIndexes: nil,\n  }\n\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).Preflight:437\n\tmain.cmdRun:194\n\tstorj.io/private/process.cleanup.func1.4:353\n\tstorj.io/private/process.cleanup.func1:371\n\tgithub.com/spf13/cobra.(*Command).execute:840\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:945\n\tgithub.com/spf13/cobra.(*Command).Execute:885\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:66\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57\n\tmain.cmdRun:196\n\tstorj.io/private/process.cleanup.func1.4:353\n\tstorj.io/private/process.cleanup.func1:371\n\tgithub.com/spf13/cobra.(*Command).execute:840\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:945\n\tgithub.com/spf13/cobra.(*Command).Execute:885\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.(*service).Execute.func1:66\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:57"}
4

I add this error when I try to run the updater.

C:\Program Files\Storj1\Storage Node>storagenode-updater.exe run
2020-09-16T13:21:57.741-0300    INFO    Invalid configuration file value for key        {"Key": "log.output"}
2020-09-16T13:21:57.783-0300    INFO    Downloading versions.   {"Server Address": "https://version.storj.io"}
2020-09-16T13:21:58.581-0300    INFO    Download started.       {"From": "https://github.com/storj/storj/releases/download/v1.12.3/storagenode_windows_amd64.exe.zip", "To": "C:\\Users\\Saiber\\AppData\\Local\\Temp\\storagenode_windows_amd64.exe.025694467.zip"}
2020-09-16T13:22:02.226-0300    ERROR   Error updating service. {"Service": "storagenode", "error": "open storagenode.1.12.3.exe: Acceso denegado.", "errorVerbose": "open storagenode.1.12.3.exe: Acceso denegado.\n\tmain.downloadBinary:62\n\tmain.update:44\n\tmain.loopFunc:30\n\tstorj.io/common/sync2.(*Cycle).Run:92\n\tmain.cmdRun:113\n\tstorj.io/private/process.cleanup.func1.4:353\n\tstorj.io/private/process.cleanup.func1:371\n\tgithub.com/spf13/cobra.(*Command).execute:840\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:945\n\tgithub.com/spf13/cobra.(*Command).Execute:885\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.main:36\n\truntime.main:203"}
2020-09-16T13:22:02.227-0300    INFO    Download started.       {"From": "https://github.com/storj/storj/releases/download/v1.12.3/storagenode-updater_windows_amd64.exe.zip", "To": "C:\\Users\\Saiber\\AppData\\Local\\Temp\\storagenode-updater_windows_amd64.exe.646754438.zip"}
2020-09-16T13:22:04.373-0300    ERROR   Error updating service. {"Service": "storagenode-updater", "error": "open storagenode-updater.1.12.3.exe: Acceso denegado.", "errorVerbose": "open storagenode-updater.1.12.3.exe: Acceso denegado.\n\tmain.downloadBinary:62\n\tmain.updateSelf:64\n\tmain.loopFunc:36\n\tstorj.io/common/sync2.(*Cycle).Run:92\n\tmain.cmdRun:113\n\tstorj.io/private/process.cleanup.func1.4:353\n\tstorj.io/private/process.cleanup.func1:371\n\tgithub.com/spf13/cobra.(*Command).execute:840\n\tgithub.com/spf13/cobra.(*Command).ExecuteC:945\n\tgithub.com/spf13/cobra.(*Command).Execute:885\n\tstorj.io/private/process.ExecWithCustomConfig:88\n\tstorj.io/private/process.Exec:65\n\tmain.main:36\n\truntime.main:203"}

using administrator cmd:

C:\Program Files\Storj1\Storage Node>storagenode-updater.exe run
2020-09-16T13:39:01.842-0300    INFO    Downloading versions.   {"Server Address": "https://version.storj.io"}
2020-09-16T13:39:02.624-0300    INFO    Download started.       {"From": "https://github.com/storj/storj/releases/download/v1.12.3/storagenode_windows_amd64.exe.zip", "To": "C:\\Users\\Saiber\\AppData\\Local\\Temp\\storagenode_windows_amd64.exe.877715791.zip"}
2020-09-16T13:39:05.794-0300    INFO    Download finished.      {"From": "https://github.com/storj/storj/releases/download/v1.12.3/storagenode_windows_amd64.exe.zip", "To": "C:\\Users\\Saiber\\AppData\\Local\\Temp\\storagenode_windows_amd64.exe.877715791.zip"}
2020-09-16T13:39:05.957-0300    INFO    Restarting service.     {"Service": "storagenode"}
2020-09-16T13:39:06.686-0300    INFO    Service restarted successfully. {"Service": "storagenode"}
2020-09-16T13:39:06.689-0300    INFO    Download started.       {"From": "https://github.com/storj/storj/releases/download/v1.12.3/storagenode-updater_windows_amd64.exe.zip", "To": "C:\\Users\\Saiber\\AppData\\Local\\Temp\\storagenode-updater_windows_amd64.exe.729078370.zip"}
2020-09-16T13:39:07.715-0300    INFO    Download finished.      {"From": "https://github.com/storj/storj/releases/download/v1.12.3/storagenode-updater_windows_amd64.exe.zip", "To": "C:\\Users\\Saiber\\AppData\\Local\\Temp\\storagenode-updater_windows_amd64.exe.729078370.zip"}
2020-09-16T13:39:07.890-0300    INFO    Restarting service.     {"Service": "storagenode-updater"}
2020-09-16T13:39:49.085-0300    INFO    Got a signal from the OS: "interrupt"

then i tried to power up the node and it got a different error so i used the reputation.db file alexy said to backup, copy it again and try power up and it worked!
The node is alive!