Used_serial: expected schema does not match actual

biniu28 · May 11, 2020, 2:30pm

I have repaired this database twice from backup and the same error twice.

Alexey · May 11, 2020, 2:53pm

Please, let the storagenode to rebuild stat from the disk before the launching of dashboard (it could take a time), check your logs instead

docker logs --tail 10 storagenode

biniu28 · May 11, 2020, 2:59pm

C:\Users\Ryzen7>docker logs --tail 10 storagenode
main.cmdRun:199
storj.io/private/process.cleanup.func1.4:344
storj.io/private/process.cleanup.func1:362
github.com/spf13/cobra.(*Command).execute:840
github.com/spf13/cobra.(*Command).ExecuteC:945
github.com/spf13/cobra.(*Command).Execute:885
storj.io/private/process.ExecWithCustomConfig:86
storj.io/private/process.ExecCustomDebug:68
main.main:329
runtime.main:203

Alexey · May 11, 2020, 3:17pm

Ok, it happens to have some error, then please, show the more lines, 40-50 I would believe will be enough

biniu28 · May 11, 2020, 3:31pm

Alexey · May 11, 2020, 3:40pm

Stop the storagenode
Run

sqlite3 /path/to/used_serial.db
select hex(satellite_id), hex(serial_number), count(*) cc from used_serial_ group by satellite_id, serial_number having cc > 1;

biniu28 · May 11, 2020, 4:24pm

84A74C2CD43C5BA76535E1F42F5DF7C287ED68D33522782F4AFABFDB40000000|4798E5FBFAAE4D03AA498B6DB5402FB9|2
84A74C2CD43C5BA76535E1F42F5DF7C287ED68D33522782F4AFABFDB40000000|4CFC6C6B31094DA7A1455C37E8E02B72|2
A28B4F04E10BAE85D67F4C6CB82BF8D4C0F0F47A8EA72627524DEB6EC0000000|A52BBAEA46704DEDA977F9F4F67E2C7D|2
A28B4F04E10BAE85D67F4C6CB82BF8D4C0F0F47A8EA72627524DEB6EC0000000|A8D56A8702E04561A23710682F656C8F|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|0F06832600AD4532B612EDCE08B86336|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|1000BD09BE3B4F808E439F4E4FCCB470|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|1224D2CD3F774F079D93022606312116|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|1302A320551348CE9BC23BB5B917CDC3|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|138A43F79CD54DD680493E35BE982253|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|33A3A0EFBA014030995FFB89A12F0C17|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|429C3EAFC1F041589D7AB47A254658DB|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|4D5700B15BA44457AE161BF4EF68371C|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|61B83F031C93474A9D891B011704B449|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|6C28EB9E82DE4A4094A7CEC235294BBC|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|73A7E32D93C74749AE0C96EC13BEC058|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|834BF97EF24D435DB70B25E148E0C79D|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|8B1CD0A918704BA980DC2379192E1F1B|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|8E9272026A804B76AF15FFFE404124D9|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|90B9D6A9B9E54C0CBF7700836C16B336|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|964FFADAD345477887571883C51C4C32|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|9828CC848C684DADA47AE9E54F3214F1|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|9B049033E91745B38786B79ABD5CAA1A|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|A0B4D2A6BD2C4DB29C17427B3DA21F4D|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|AD274728275F4B81A23FE0B231E4D2FC|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|CEF10EE7ECA94E16829AE3EBB4800879|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|CF14F63D5F69409FBE82BFA314692EAC|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|D6DC3856B8AE436D8B547E9A2C988776|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|E149C9BAD3384F26A1AD1733B47C75D8|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|E9D52D963DBA49A2BB2F6EBB49A43A7C|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|EAF6F105F0C14E8D9E3467F7E85EE778|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|EE419073AD5E4B13B873DDE32A6B5BB9|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|F00F1C67A9214E259F5B9FD849AF10CC|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|F6C4C0E5A99C4260A6EE2D2182199D83|2
F474535A19DB00DB4F8071A1BE6C2551F4DED6A6E38F0818C68C68D000000000|FB026BD8E180418499ADD8D3266B9340|2

Alexey · May 11, 2020, 5:42pm

continue with sqlite3:

sqlite3 /path/to/used_serial.db
delete from used_serial_ as us where exists(select satellite_id, serial_number, count(*) cc from used_serial_ where satellite_id = us.satellite_id and serial_number = us.serial_number group by satellite_id, serial_number having cc >1);

CREATE UNIQUE INDEX pk_used_serial_ ON used_serial_(satellite_id, serial_number);
CREATE INDEX idx_used_serial_ ON used_serial_(expiration);
.exit

biniu28 · May 11, 2020, 8:24pm

Works, should I check something else?
thank you for your help

Alexey · May 13, 2020, 9:26pm

No, just make sure that you do not have any other errors in your logs