Hello together, only some months ago I started a new node and it has already ~200 MB of the piece_expiration.db. Can somebody explain the high growth rate and how to shrink it? The filewalker is not active. [grafik] Thanks and kind regards,

I can’t check my nodes, so don’t take my silence as a NO :). I believe @Ruskiem said something about locked db-es in other thread.

Perhaps it could be a lazy filewalker process? It’s a separate Storagenode instance

2023-12-23T03:07:19Z WARN retain failed to delete piece {"process": "storagenode", "Satellite ID": "12EayRS2V1kEsWESU9QMRseFhdxYxKicsiFmxrsLZHeLUtdps3S", "Piece ID": "YT4EZ34ZRG3V2DW7JFMOGWP7YGYUR6QS7QWVMDOHEYBX6QUUE5WA", "error": "pieces error: pieceexpirationdb: database is locked", "error…

[image] nerdatwork: database is locked seems you need to move databases to the SSD…

Also an usb flashdrive seems to work fine! I use this [Samsung USB-Stick Typ-A BAR Plus (MUF-128BE4/APC), 128 GB]

You gave me an ideea… to use flash drives on my Synology’s for db-es. I think there was a discussion about this, and the conclusion was that they can’t handle the I/O; but if it works for you, maybe it’s a good solution.

Reexamining my db sizes on all nodes, I just realised that on the old nodes they are ~530MB, except one, which is ~330MB. What is the difference between them? On this one, I ran the FW with lazy off. On the others, the lazy was on. So, it seems that the lazy fw has something to do with the piece_ex…

[image] snorkel: What is the difference between them? You could run the SQL commands over the db to see what it holds. Copy the db file to another location then execute SQL commands on it.

Just take a decent one. (i chose the samsung because of the 5y warranty and i did read a test) i reformated them to 4k ntfs.(i use windows) [image] snorkel: and the conclusion was that they can’t handle the I/O maybe the realy old ones? with fat32 or exfat? but an CMR drive can? doubt. in…

What commands? I’m not familiar with SQL queries.

Storj Community Forum (official)

Quick growth of piece_expiration.db

Node Operators troubleshooting

database

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled