Some wrong DB files ? synology, docker, usb3.0 no bandwidth info on dashboard

Hello,
please help with the dashboard stats.


Storj exporter dont see this info too from dashboard

i dont see statistics from satellites, payout,…

sudo docker run --rm -it --mount type=bind,source=/volumeUSB11/usbshare/storage/storage,destination=/data sstc/sqlite3 find . -iname "*.db" -maxdepth 1 -print0 -exec sq                                                                                   lite3 '{}' 'PRAGMA integrity_check;' ';'
./heldamount.dbok
./notifications.dbok
./bandwidth.dbok
./satellites.dbok
./pricing.dbok
./used_serial.dbok
./reputation.dbok
./orders.dbok
./secret.dbok
./pieceinfo.dbok
./storage_usage.db*** in database main ***
On tree page 674 cell 12: Rowid 29126 out of order
On tree page 674 cell 11: Rowid 29126 out of order
On tree page 674 cell 10: Rowid 29126 out of order
On tree page 674 cell 9: Rowid 29126 out of order
On tree page 674 cell 8: Rowid 29126 out of order
On tree page 674 cell 7: Rowid 29126 out of order
On tree page 674 cell 6: Rowid 29126 out of order
On tree page 674 cell 5: Rowid 29126 out of order
On tree page 674 cell 4: Rowid 29126 out of order
On tree page 674 cell 3: Rowid 29126 out of order
On tree page 674 cell 2: Rowid 29126 out of order
On tree page 674 cell 1: Rowid 29126 out of order
On tree page 674 cell 0: Rowid 29126 out of order
On tree page 559 cell 343: Rowid 29126 out of order
On tree page 675 cell 17: Rowid 29126 out of order
On tree page 675 cell 16: Rowid 29126 out of order
On tree page 675 cell 15: Rowid 29126 out of order
On tree page 675 cell 14: Rowid 29126 out of order
On tree page 675 cell 13: Rowid 29126 out of order
On tree page 675 cell 12: Rowid 29126 out of order
On tree page 675 cell 11: Rowid 29126 out of order
On tree page 675 cell 10: Rowid 29126 out of order
On tree page 675 cell 9: Rowid 29126 out of order
On tree page 675 cell 8: Rowid 29126 out of order
On tree page 675 cell 7: Rowid 29126 out of order
On tree page 675 cell 6: Rowid 29127 out of order
On tree page 675 cell 5: Rowid 29127 out of order
On tree page 675 cell 4: Rowid 29127 out of order
On tree page 675 cell 3: Rowid 29127 out of order
On tree page 675 cell 2: Rowid 29127 out of order
On tree page 675 cell 1: Rowid 29127 out of order
On tree page 675 cell 0: Rowid 29127 out of order
On tree page 559 cell 342: Rowid 29127 out of order
On tree page 676 cell 17: Rowid 29127 out of order
On tree page 676 cell 16: Rowid 29127 out of order
On tree page 676 cell 15: Rowid 29127 out of order
On tree page 676 cell 14: Rowid 29127 out of order
On tree page 676 cell 13: Rowid 29127 out of order
On tree page 676 cell 12: Rowid 29128 out of order
On tree page 676 cell 11: Rowid 29128 out of order
On tree page 676 cell 10: Rowid 29128 out of order
On tree page 676 cell 9: Rowid 29128 out of order
On tree page 676 cell 8: Rowid 29128 out of order
On tree page 676 cell 7: Rowid 29128 out of order
On tree page 676 cell 6: Rowid 29128 out of order
On tree page 676 cell 5: Rowid 29128 out of order
On tree page 676 cell 4: Rowid 29128 out of order
On tree page 676 cell 3: Rowid 29128 out of order
On tree page 676 cell 2: Rowid 29128 out of order
On tree page 676 cell 1: Rowid 29143 out of order
On tree page 676 cell 0: Rowid 29144 out of order
On tree page 559 cell 341: Rowid 29144 out of order
On tree page 677 cell 17: Rowid 29144 out of order
On tree page 677 cell 16: Rowid 29144 out of order
On tree page 677 cell 15: Rowid 29144 out of order
On tree page 677 cell 14: Rowid 29144 out of order
On tree page 677 cell 13: Rowid 29144 out of order
On tree page 677 cell 12: Rowid 29144 out of order
On tree page 677 cell 11: Rowid 29144 out of order
On tree page 677 cell 10: Rowid 29144 out of order
On tree page 677 cell 9: Rowid 29144 out of order
On tree page 677 cell 8: Rowid 29144 out of order
On tree page 677 cell 7: Rowid 29144 out of order
On tree page 677 cell 6: Rowid 29145 out of order
On tree page 677 cell 5: Rowid 29145 out of order
On tree page 677 cell 4: Rowid 29145 out of order
On tree page 677 cell 3: Rowid 29145 out of order
On tree page 677 cell 2: Rowid 29145 out of order
On tree page 677 cell 1: Rowid 29145 out of order
On tree page 677 cell 0: Rowid 29145 out of order
On tree page 559 cell 340: Rowid 29145 out of order
On tree page 678 cell 16: Rowid 29145 out of order
On tree page 678 cell 15: Rowid 29145 out of order
On tree page 678 cell 14: Rowid 29145 out of order
On tree page 678 cell 13: Rowid 29145 out of order
On tree page 678 cell 12: Rowid 29145 out of order
On tree page 678 cell 11: Rowid 29146 out of order
On tree page 678 cell 10: Rowid 29146 out of order
On tree page 678 cell 9: Rowid 29146 out of order
On tree page 678 cell 8: Rowid 29146 out of order
On tree page 678 cell 7: Rowid 29146 out of order
On tree page 678 cell 6: Rowid 29146 out of order
On tree page 678 cell 5: Rowid 29146 out of order
On tree page 678 cell 4: Rowid 29146 out of order
On tree page 678 cell 3: Rowid 29146 out of order
On tree page 678 cell 2: Rowid 29146 out of order
On tree page 678 cell 1: Rowid 29146 out of order
On tree page 678 cell 0: Rowid 29146 out of order
On tree page 559 cell 339: Rowid 29146 out of order
On tree page 679 cell 17: Rowid 29146 out of order
On tree page 679 cell 16: Rowid 29146 out of order
On tree page 679 cell 15: Rowid 29146 out of order
On tree page 679 cell 14: Rowid 29146 out of order
On tree page 679 cell 13: Rowid 29146 out of order
On tree page 679 cell 12: Rowid 29146 out of order
On tree page 679 cell 11: Rowid 29146 out of order
On tree page 679 cell 10: Rowid 29146 out of order
On tree page 679 cell 9: Rowid 29146 out of order
On tree page 679 cell 8: Rowid 29146 out of order
On tree page 679 cell 7: Rowid 29146 out of order
./piece_expiration.dbrow 17577 missing from index idx_piece_expirations_trashed
row 17577 missing from index idx_piece_expirations_deletion_failed_at
row 17577 missing from index idx_piece_expirations_piece_expiration
row 17577 missing from index sqlite_autoindex_piece_expirations_1
row 17679 missing from index idx_piece_expirations_trashed
row 17679 missing from index idx_piece_expirations_deletion_failed_at
row 17679 missing from index idx_piece_expirations_piece_expiration
row 17679 missing from index sqlite_autoindex_piece_expirations_1
row 17682 missing from index idx_piece_expirations_trashed
row 17682 missing from index idx_piece_expirations_deletion_failed_at
row 17682 missing from index idx_piece_expirations_piece_expiration
row 17682 missing from index sqlite_autoindex_piece_expirations_1
row 17685 missing from index idx_piece_expirations_trashed
row 17685 missing from index idx_piece_expirations_deletion_failed_at
row 17685 missing from index idx_piece_expirations_piece_expiration
row 17685 missing from index sqlite_autoindex_piece_expirations_1
row 17686 missing from index idx_piece_expirations_trashed
row 17686 missing from index idx_piece_expirations_deletion_failed_at
row 17686 missing from index idx_piece_expirations_piece_expiration
row 17686 missing from index sqlite_autoindex_piece_expirations_1
row 17687 missing from index idx_piece_expirations_trashed
row 17687 missing from index idx_piece_expirations_deletion_failed_at
row 17687 missing from index idx_piece_expirations_piece_expiration
row 17687 missing from index sqlite_autoindex_piece_expirations_1
row 17688 missing from index idx_piece_expirations_trashed
row 17688 missing from index idx_piece_expirations_deletion_failed_at
row 17688 missing from index idx_piece_expirations_piece_expiration
row 17688 missing from index sqlite_autoindex_piece_expirations_1
row 17689 missing from index idx_piece_expirations_trashed
row 17689 missing from index idx_piece_expirations_deletion_failed_at
row 17689 missing from index idx_piece_expirations_piece_expiration
row 17689 missing from index sqlite_autoindex_piece_expirations_1
row 17690 missing from index idx_piece_expirations_trashed
row 17690 missing from index idx_piece_expirations_deletion_failed_at
row 17690 missing from index idx_piece_expirations_piece_expiration
row 17690 missing from index sqlite_autoindex_piece_expirations_1
row 17691 missing from index idx_piece_expirations_trashed
row 17691 missing from index idx_piece_expirations_deletion_failed_at
row 17691 missing from index idx_piece_expirations_piece_expiration
row 17691 missing from index sqlite_autoindex_piece_expirations_1
wrong # of entries in index idx_piece_expirations_trashed
wrong # of entries in index idx_piece_expirations_deletion_failed_at
wrong # of entries in index idx_piece_expirations_piece_expiration
wrong # of entries in index sqlite_autoindex_piece_expirations_1
./info.dbok
./piece_spaced_used.dbok

my setup
Synology DS918+
HDD 8TB, 7200, enterprise class connected via USB3.0

Thanks

Try these steps on databases that have issues.

If that doesn’t work, recreate the broken db files you were unable to fix. This will make you lose some stats held in those db files, so try the above link first.

2 Likes

Thanks,
so i have problem with DB storage_usage.db and piece_expiration.db - I didn’t see it at first sight

storage_usage.db - repair with error
Error: near line 16727: UNIQUE constraint failed: storage_usage.timestamp, storage_usage.satellite_id

piece_expiration.db
repair

now all DBs are OK

Thank you @BrightSilence

1 Like

Awesome! You can ignore that unique constraint error. That duplicate actually caused the original issue. Glad to see you’re up and running again with all stats back as they should be.

1 Like