Pieces_expiration.db ERROR

Node Operators troubleshooting
1

Hey,

So i have a malformed db error on my windows node running on windows 2012 server.
No problem, found the “how to fix a malformed db error” did a backup, done it etc… but i get this error when i try to run the storagenode:

2021-07-20T22:21:58.371+0300 INFO Telemetry enabled {instance ID: 12LQvULbXrg4Qa7SaitLsCWeWfLECu3ni39dxkqmCHGZY2T9A5v}
2021-07-20T22:21:58.392+0300 INFO db.migration.26 Add Trash column to pieceExpirationDB
2021-07-20T22:21:58.398+0300 FATAL Unrecoverable error {error: Error creating tables for master database on storagenode: migrate: duplicate column name: trash\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:346\n\tmain.cmdRun:193\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 creating tables for master database on storagenode: migrate: duplicate column name: trash\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:346\n\tmain.cmdRun:193\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:195\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}
2

Please, try

  1. Stop the storagenode
  2. Execute with sqlite3 binary or docker version
sqlite3 /path/to/piece_expiration.db "insert into versions values(26, datetime('now', 'utc'));"
  1. Start the storagenode
  2. Check logs