Node Dienst wird immer wieder beendet, FATAL Error im Log

Node Operators troubleshooting
1

Hallo zusamenn, ich hatte gestern ein Problem mit meinem Laufwerk und musste es mit chkdsk auf fehler überprüfen und reparieren lassen.

Nun Startet der dienst immer wieder Neu. Im Log sehe ich diesen Error, was kann ich tun um den fehler zu beheben?

2022-11-16T19:32:42.227+0100 FATAL Unrecoverable error {“error”: “Error creating tables for master database on storagenode: migrate: no such table: piece_expirations\n\tstorj.io/storj/private/migrate.SQL.Run:296\n\tstorj.io/storj/private/migrate.(*Migration).Run.func1:197\n\tstorj.io/private/dbutil/txutil.withTxOnce:75\n\tstorj.io/private/dbutil/txutil.WithTx:36\n\tstorj.io/storj/private/migrate.(*Migration).Run:196\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).MigrateToLatest:347\n\tmain.cmdRun:226\n\tstorj.io/private/process.cleanup.func1.4:377\n\tstorj.io/private/process.cleanup.func1:395\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.ExecWithCustomConfigAndLogger:92\n\tstorj.io/private/process.ExecWithCustomConfig:74\n\tstorj.io/private/process.Exec:64\n\tmain.(*service).Execute.func1:61\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:75”, “errorVerbose”: “Error creating tables for master database on storagenode: migrate: no such table: piece_expirations\n\tstorj.io/storj/private/migrate.SQL.Run:296\n\tstorj.io/storj/private/migrate.(*Migration).Run.func1:197\n\tstorj.io/private/dbutil/txutil.withTxOnce:75\n\tstorj.io/private/dbutil/txutil.WithTx:36\n\tstorj.io/storj/private/migrate.(*Migration).Run:196\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).MigrateToLatest:347\n\tmain.cmdRun:226\n\tstorj.io/private/process.cleanup.func1.4:377\n\tstorj.io/private/process.cleanup.func1:395\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.ExecWithCustomConfigAndLogger:92\n\tstorj.io/private/process.ExecWithCustomConfig:74\n\tstorj.io/private/process.Exec:64\n\tmain.(*service).Execute.func1:61\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:75\n\tmain.cmdRun:228\n\tstorj.io/private/process.cleanup.func1.4:377\n\tstorj.io/private/process.cleanup.func1:395\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.ExecWithCustomConfigAndLogger:92\n\tstorj.io/private/process.ExecWithCustomConfig:74\n\tstorj.io/private/process.Exec:64\n\tmain.(*service).Execute.func1:61\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:75”}

Vielen Dank für die Hilfe und ich hoffe das die Node nich verloren ist.

2

Hi @CubeFan
Please show more of the log from just before the FATAL message. We should be able to resolve the issue as it points to a database error.

You can post the log between three backticks

```
Logs
```
3

Hey, there is not a lot more information

2022-11-16T19:44:59.143+0100	INFO	Configuration loaded	{"Location": "C:\\Program Files\\Storj2\\Storage Node\\config.yaml"}
2022-11-16T19:44:59.144+0100	INFO	Anonymized tracing enabled
2022-11-16T19:44:59.145+0100	INFO	Operator email	{"Address": "xxx@xxxl.de"}
2022-11-16T19:44:59.145+0100	INFO	Operator wallet	{"Address": "xxxx"}
2022-11-16T19:45:00.012+0100	INFO	Telemetry enabled	{"instance ID": "xxxxa"}
2022-11-16T19:45:00.012+0100	INFO	Event collection enabled	{"instance ID": "xxx"}
2022-11-16T19:45:00.031+0100	INFO	db.migration.26	Add Trash column to pieceExpirationDB
2022-11-16T19:45:00.036+0100	FATAL	Unrecoverable error	{"error": "Error creating tables for master database on storagenode: migrate: no such table: piece_expirations\n\tstorj.io/storj/private/migrate.SQL.Run:296\n\tstorj.io/storj/private/migrate.(*Migration).Run.func1:197\n\tstorj.io/private/dbutil/txutil.withTxOnce:75\n\tstorj.io/private/dbutil/txutil.WithTx:36\n\tstorj.io/storj/private/migrate.(*Migration).Run:196\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).MigrateToLatest:347\n\tmain.cmdRun:226\n\tstorj.io/private/process.cleanup.func1.4:377\n\tstorj.io/private/process.cleanup.func1:395\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.ExecWithCustomConfigAndLogger:92\n\tstorj.io/private/process.ExecWithCustomConfig:74\n\tstorj.io/private/process.Exec:64\n\tmain.(*service).Execute.func1:61\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:75", "errorVerbose": "Error creating tables for master database on storagenode: migrate: no such table: piece_expirations\n\tstorj.io/storj/private/migrate.SQL.Run:296\n\tstorj.io/storj/private/migrate.(*Migration).Run.func1:197\n\tstorj.io/private/dbutil/txutil.withTxOnce:75\n\tstorj.io/private/dbutil/txutil.WithTx:36\n\tstorj.io/storj/private/migrate.(*Migration).Run:196\n\tstorj.io/storj/storagenode/storagenodedb.(*DB).MigrateToLatest:347\n\tmain.cmdRun:226\n\tstorj.io/private/process.cleanup.func1.4:377\n\tstorj.io/private/process.cleanup.func1:395\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.ExecWithCustomConfigAndLogger:92\n\tstorj.io/private/process.ExecWithCustomConfig:74\n\tstorj.io/private/process.Exec:64\n\tmain.(*service).Execute.func1:61\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:75\n\tmain.cmdRun:228\n\tstorj.io/private/process.cleanup.func1.4:377\n\tstorj.io/private/process.cleanup.func1:395\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.ExecWithCustomConfigAndLogger:92\n\tstorj.io/private/process.ExecWithCustomConfig:74\n\tstorj.io/private/process.Exec:64\n\tmain.(*service).Execute.func1:61\n\tgolang.org/x/sync/errgroup.(*Group).Go.func1:75"}
4

Great. This is the line…

Your piece_expirations.db is either damaged or corrupt. Try to fix it first - https://support.storj.io/hc/en-us/articles/360029309111. If it won’t fix then recreate it - https://support.storj.io/hc/en-us/articles/4403032417044-How-to-fix-database-file-is-not-a-database-error

1 Like
5

Thx, i hope my node is not too long offline.

6

Currently a node can be offline for 12 days in a 30 day window so you have time to resolve the issue properly, so don’t rush and possibly make a mistake.