Bandwidth Error After Upgrade to 31.9

It looks that there was some problem with any of the bandwidth database migration in your SNs.

I think that there wasn’t any bandwidth database migration in the last release, but I will ask for confirming it.

What it has been changed in this last version is that that the database schema check is enabled by default and that’s causing your nodes to fail and exit.

In the meantime, you can disable such check adding to your node configuration file preflight.database-check: false.

This database check verifies that the databases have the expected schema, which means that all the migrations have been running fine (unless that there is some bug somewhere).

Please, disable the check and let us know if your nodes run again.

On the other hand, please do the following instructions to know how the schema of your bandwidth databases looks like:

$ sqlite3 {storage_dir}/storage/bandwidth.db
SQLite version 3.16.2 2017-01-06 16:32:41
Enter ".help" for usage hints.
sqlite> .output bandwidth-schema.sql
sqlite> .schema
sqlite> .quit

You’ll get a new file bandwidth-schema.sql in the directory that you executed the sqlite3 command.
Open the file and paste the content in a response in the thread.

1 Like