Then i checked both files again with this command: sqlite3 /path/to/storage/bandwidth.db “PRAGMA integrity_check;”
It returns ok for both of them, but when i start the Node im still not able to access the Web Dashboard and Docker Dashboard returns this:
2020-08-03T18:31:15.349Z INFO Configuration loaded {“Location”: “/app/config/config.yaml”}
2020-08-03T18:31:15.372Z INFO Identity loaded. {“Node ID”: “removedmynodeidhere”}
Error: context canceled
Note: The Error message comes from alone after a few seconds, i didn’t cancel it.
You should replace the /path/to/storage/bandwidth.db to the actual path to the bandwidth.db
If database doesn’t exist for this path, the sqlite3 will just create an empty one and of course, the integrity check will be OK
You should replace the /path/to/storage/bandwidth.db to the actual path to the bandwidth.db
I did replace it with my path, just wanted to let you know which command i used.
After correcting the Erros by following the Guide and Checking that sqlites PRAGMA integrity_check returns ok i copied it back to the storage folder and startet the Node again but i get same Errors as before (which is the long block postet above)
This is the Output when run against the “repaired” bandwith.db
CREATE TABLE bandwidth_usage (
satellite_id BLOB NOT NULL,
action INTEGER NOT NULL,
amount BIGINT NOT NULL,
created_at TIMESTAMP NOT NULL
);
CREATE TABLE bandwidth_usage_rollups (
interval_start TIMESTAMP NOT NULL,
satellite_id BLOB NOT NULL,
action INTEGER NOT NULL,
amount BIGINT NOT NULL,
PRIMARY KEY ( interval_start, satellite_id, action )
);
CREATE INDEX idx_bandwidth_usage_satellite ON bandwidth_usage(satellite_id);
CREATE INDEX idx_bandwidth_usage_created ON bandwidth_usage(created_at);
Just checked, when run against the old, damaged bandwith.db its exactly the same Output.
Yes, the schema won’t be changed when you run that repair. It just fixes issues with the actual data inside the tables. I just compared your schema with my db and it’s an exact match. My node isn’t throwing any schema errors. Are you running v1.9.5 yet? My node is.
My Node is Online now and the Dashboard is reachable. I don’t know why its suddenly working again because I only stopped and started it a few times.
However my uptime is still on 100% and i didn’t even fail 1 audit, so it seems like my Node was back Online after fixing the dbs and only the Dashboard didn’t work