Initially I thought the install of the node software that runs the Windows service was damaged and the service was not running for some reason. I uninstalled and reinstalled Storj several times and each time provided the backed-up identity, payout address and email address, then provided the shared storage location. The node would not come back up.
I then checked the log file and found an error stating that a file was not a database. I have tried to follow the instructions on repairing the one database that is affected. Only one file is apparently malformed and that’s orders.db. I followed the Windows Power Shell commands right up to repopulating the new file but it errored leaving the new orders.db file at zero length. Is there any hope for this node? Can anyone help me reconstruct the order.db file please? Is this file able to be replaced and regenerated by Storj node service somehow?
Please, stop the storagenode service from the elevated PowerShell:
Stop-Service storagenode
Remove the corrupted orders.db file
Execute either with a local installed sqlite3 or a docker version from the mentioned guide (replace the path “/path/to/storage/with/orders.db” to the right one):
sqlite3 /path/to/storage/with/orders.db
CREATE TABLE unsent_order (
satellite_id BLOB NOT NULL,
serial_number BLOB NOT NULL,
order_limit_serialized BLOB NOT NULL, -- serialized pb.OrderLimit
order_serialized BLOB NOT NULL, -- serialized pb.Order
order_limit_expiration TIMESTAMP NOT NULL, -- when is the deadline for sending it
uplink_cert_id INTEGER NOT NULL,
FOREIGN KEY(uplink_cert_id) REFERENCES certificate(cert_id)
);
CREATE TABLE order_archive_ (
satellite_id BLOB NOT NULL,
serial_number BLOB NOT NULL,
order_limit_serialized BLOB NOT NULL,
order_serialized BLOB NOT NULL,
uplink_cert_id INTEGER NOT NULL,
status INTEGER NOT NULL,
archived_at TIMESTAMP NOT NULL,
FOREIGN KEY(uplink_cert_id) REFERENCES certificate(cert_id)
);
CREATE UNIQUE INDEX idx_orders ON unsent_order(satellite_id, serial_number);
CREATE TABLE versions (version int, commited_at text);
.exit