Database does not exist

Developer Discussions FAQ
, , ,
1

Hello there,

I have ran storj-sim all working fine,

But in logs (looping in console - storj-sim run command) I got these errors.

| INFO   db      storagenodedb/database.go:302   database does not exist {"Process": "storagenode", "database": "info"}                                                        | INFO   db      storagenodedb/database.go:302   database does not exist {"Process": "storagenode", "database": "bandwidth"}                                                                                                                                                                                                                                  | INFO   db      storagenodedb/database.go:302   database does not exist {"Process": "storagenode", "database": "orders"}                                                                                                                                                                                                                                     | INFO   db      storagenodedb/database.go:302   database does not exist {"Process": "storagenode", "database": "piece_expiration"}                                                                                                                                                                                                                           | INFO   db      storagenodedb/database.go:302   database does not exist {"Process": "storagenode", "database": "pieceinfo"}                                                                                                                                                                                                                                  | INFO   db      storagenodedb/database.go:302   database does not exist {"Process": "storagenode", "database": "piece_spaced_used"}                                                                                                                                                                                                                          | INFO   db      storagenodedb/database.go:302   database does not exist {"Process": "storagenode", "database": "reputation"}                                                                                                                                                                                                                                 | INFO   db      storagenodedb/database.go:302   database does not exist {"Process": "storagenode", "database": "storage_usage"}                                                                                                                                                                                                                              | INFO   db      storagenodedb/database.go:302   database does not exist {"Process": "storagenode", "database": "used_serial"}                                                                                                                                                                                                                                | INFO   db      storagenodedb/database.go:302   database does not exist {"Process": "storagenode", "database": "satellites"}                                                                                                                                                                                                                                 | INFO   db      storagenodedb/database.go:302   database does not exist {"Process": "storagenode", "database": "notifications"}                                                                                                                                                                                                                              | INFO   db      storagenodedb/database.go:302   database does not exist {"Process": "storagenode", "database": "heldamount"}                                                                                                                                                                                                                                 | INFO   db      storagenodedb/database.go:302   database does not exist {"Process": "storagenode", "database": "pricing"}                                                                                                                                                                                                                                    | INFO   db      storagenodedb/database.go:302   database does not exist {"Process": "storagenode", "database": "secret"}

And I also check in db (pgAdmin) these are not present.
Am I skipped something?

And why these tables are not created in db though others are there…

@Alexey
@jeremy

2

These are SQLite databases - each own directory with database files and they are created automatically if no one of them are exist.
These are INFO messages, not ERROR, so they are fine.

1 Like
3

Okay …

So they are part of storage node db, if I am not wrong?

How to get rid of this should I manually have to do something?

@Alexey

What they used for?

4

this in not a single database, each node uses several SQLite database files. If they are not exist, they will be recreated, otherwise they will be used.

do not destroy them, that’s all. If they are removed, they will be re-created on the next run (nodes will lose a local stat though), but it doesn’t prevent them from working.

local stat for the storagenode’s dashboard and history, also cache for pieces mapping and disk usage.

1 Like
5

Alright ,

I have got the location of these dbs.

But when I open there is 0 value in reputation.db → reputation table → column = audit_success_count, audit_total_count

Why is that so ?

So there is not running audit service in storj-sim?

Or there is specified time for audit start…

Please let me know.

@Alexey

6

Audits and repair workers are running in an infinity loop across all segments.
Do you store something to have segments and audits?

Storagenodes are check-in on the satellite every hour by default, but the reputation databases on storagenodes updated not so often, it’s likely when the segments loop would be finished. In the production it takes around 12 hours.

1 Like
7

I have created buckets and stored some data just for testing but I didn’t see any audit or reputation related activity (entries) in database, that’s why I was confused…!

Any idea about test network(storj-sim)?

8

depends on amount of data. Since you have only 10 nodes by default, thus RS settings are different from production (for production you need at least 110 nodes), so amount of data on nodes is different too.

So, not, I do not know. But likely you will know soon.