Node Docker Error Creating tables for master database

Node Operators troubleshooting
1

hey, i got the following error message in my docker:

Error: Error creating tables for master database on storagenode: migrate: no such table: satellites
        storj.io/storj/private/migrate.SQL.Run:296
        storj.io/storj/private/migrate.(*Migration).Run.func1:197
        storj.io/private/dbutil/txutil.withTxOnce:75
        storj.io/private/dbutil/txutil.WithTx:36
        storj.io/storj/private/migrate.(*Migration).Run:196
        storj.io/storj/storagenode/storagenodedb.(*DB).MigrateToLatest:347
        main.cmdRun:226
        storj.io/private/process.cleanup.func1.4:378
        storj.io/private/process.cleanup.func1:396
        github.com/spf13/cobra.(*Command).execute:852
        github.com/spf13/cobra.(*Command).ExecuteC:960
        github.com/spf13/cobra.(*Command).Execute:897
        storj.io/private/process.ExecWithCustomConfigAndLogger:93
        main.main:478
        runtime.main:255
2022-11-03 23:12:23,471 INFO exited: storagenode (exit status 1; not expected)```
2

Seems you lost satellites.db database somehow. Please, try to recreate it:

3

still the same error :frowning:

4

i just did all like the link, but i dont realy understand why should i move backed up databases, because i only delete “satellites.db” the other databases stays untouched.
so can i skip that part?
or am i missing sth?

5

You have to follow the instructions as written. If you don’t move all the databases then the node won’t recreate the database you need.

1 Like
6

ahh i see my mistake.
I did not read correctly.
i thought the remaining databases are only copied and not moved completely, then it makes sense to move the backup back in afterwards.
thanks for the help

3 Likes