After this update i have some zeros

After this update i have some zeros.
Any one else with the same prob.?

Please, check your databases:

1 Like

Please, check it first, then try to repair, if something corrupted.

i see a lot of these:

Page 4045 is never used
Page 4046 is never used
Page 4048 is never used
Page 4049 is never used
non-unique entry in index sqlite_autoindex_bandwidth_usage_rollups_1
row 100958 missing from index sqlite_autoindex_bandwidth_usage_rollups_1
row 100959 missing from index sqlite_autoindex_bandwidth_usage_rollups_1
row 100960 missing from index sqlite_autoindex_bandwidth_usage_rollups_1

I see. Seems at least bandwidth.db is corrupted. Please follow the manual further

What does it mean “Open a shell” ?
I’m on commanc line. what is that shell and how to open it?

/data#

looks like a shell already opened.
Please, continue from p.9.

  1. Now run the following commands in the shell. You need to repeat steps 9 to 14 for each corrupted sqlite3 database:
cp /storage/bandwidth.db /storage/bandwidth.db.bak
sqlite3 /storage/bandwidth.db

node@usr:~$ docker run --rm -it --mount type=bind,source=/home/usr/storj/storage/,destination=/storage sstc/sqlite3 sh
/data # cp /storage/bandwidth.db /storage/bandwidth.db.bak
/data # sqlite3 /storage/bandwidth.db
SQLite version 3.30.1 2019-10-10 20:19:45
Enter “.help” for usage hints.
sqlite>

somehow it does not look that it done something :expressionless:

Please, take a look on p.10, it’s follow by p.9

  1. You will see a prompt from sqlite3. Run this SQL script:
.mode insert
.output /storage/dump_all.sql
.dump
.exit

Should I copy paste every point from the guide?
Can you open it and follow step by step?

I follow, but i don’t understand is my command correct? Why it prints sqlite version for me, after i type this " /data # sqlite3 /storage/bandwidth.db"

:slight_smile:
It’s sqlite>
Do you see it?
If so, please, continue with p.10

Ok, looks like i managed to start sqlite, but it gives error:

sqlite> .mode insert
sqlite> .output /storage/dump_all.sql
Error: cannot open “/storage/dump_all.sql”
Error: cannot write to “/storage/dump_all.sql”
sqlite>

Seems this path is not writable for your user.

Please, check it. Also, do you run your storagenode with sudo? If so, then use the sudo to run a container with sqlite3.
To exit from the sqlite prompt you can type the command .exit and hit Enter.
To exit from the shell you can type the command exit and hit Enter.

I’ve added docker to sudo group, and everytime i run node, i run docker without sudo.
while now, i’ve tried run sqlite with sudo and without sudo. same story

I updated doing the process described at: https://documentation.storj.io/setup/cli/software-updates#automatic-updates And not problem in restart! Just right now I’m working with the 1.12.3 version in storj node.

today is not my day… definetely .
Even EXIT is not working :frowning:

node@usr:~$ sqlite3 /home/usr/storj/storage/bandwidth.db
SQLite version 3.22.0 2018-01-22 18:45:57
Enter “.help” for usage hints.
sqlite> exit
…>
…>
…>
…> ^C^C
…> .exit
…>
…> exit
…> .exit
…>
…> exit
…> .exit
…>
…>
…>
…>
…>

Try…

.quit

This might help a bit to navigate sqlite:

https://simplecheatsheet.com/tag/sqlite-cheat-sheet/

With or without sudo it does not working.

node@usr:~$ sqlite3 /home/usr/storj/storage/bandwidth.db
SQLite version 3.22.0 2018-01-22 18:45:57
Enter “.help” for usage hints.
sqlite> .mode insert
sqlite> .output /storage/dump_all.sql
Error: cannot open “/storage/dump_all.sql”
Error: cannot write to “/storage/dump_all.sql”
sqlite> .exit

node@usr:~ sudo sqlite3 /home/usr/storj/storage/bandwidth.db [sudo] password for usr: SQLite version 3.22.0 2018-01-22 18:45:57 Enter ".help" for usage hints. sqlite> .mode insert sqlite> .output /storage/dump_all.sql Error: cannot open "/storage/dump_all.sql" Error: cannot write to "/storage/dump_all.sql" sqlite> .exit node@usr:~

is this file should be on the drive? dump_all.sql
or should sqlite create it ?

There probably isn’t a directory /storage on your system.

Try .output dump_all.sql