Error during preflight check for storagenode databases: storage node preflight database error: orders: expected schema does not match actual

Node Operators troubleshooting
,
18

We will try to fix it. Stop the storagenode.
Restore the orders.db from the backup (keep the backup for a while).
Open the orders.db with a sqlite3 (you can install it or use the docker version).

sqlite3 orders.db

Apply this SQL script:

drop index idx_orders;
CREATE INDEX idx_orders ON unsent_order(satellite_id, serial_number);
.exit

Then try to start the storagenode

2 Likes