After a month of working, I had a fancy idea, --> let’s check storage databases sizes
And one of the files (orders.db) is 700MB big… I think it is too big comparing to other files…
Is it normal size for a node at around 2GB of capacity?
I checked logs and there is an error popping up that ordersdb is malformed.
This error in storagenode log doesn’t prevent storagenode from starting - maybe this is an error to raise as a bug?
I tried to use your fix of database
It is really slow … don’t know why it reads files very slow - like 1 MB / minute
I tried to modify last insert
from point 13
sqlite3 /storage/bandwidth.db “.read /storage/dump_all_notrans.sql”
i used it like this - using sqlite client and now it reads it in much faster - whole 700MB in less than a minute
(i think that it has some problems when BEGIN TRANSACTION is upper case.
but in the end it reports some errors at some point, trying to do some inserts with null values
and then it reports error trying to create UNIQUE INDEX on unsent_order table, one of the last lines:
CREATE UNIQUE INDEX idx_orders ON unsent_order(satellite_id, serial_number);
Is this database really important? Can it be somehow repaired? dropped and recreated empty?
Or should i start thinking about dropping the node?
Thanx if anyone can help…