transaction leak
nostr:npub180cvv07tjdrrgpa0j7j7tmnyl2yr6yr7l8j4s3evf6u64th6gkwsyjh6w6 why is my LMDB database for my groups-relay ( https://github.com/max21dev/groups-relay ) 275 GB when it only has 540 events in it?
I used https://github.com/PowerDNS/lmdbnav and cant find whats taking up all the space
https://cdn.hzrd149.com/5f3e2508f12ebad7bd4f6ee5ba9dbc351705a07a87ae89973dd72e60be0bc396.webp
Discussion
This concept does not make sense to a JavaScript developer like me :)
so its code somewhere in the groups-relay that is forgetting to cleanup db transactions?
They are opening a DB transaction then never closing it presumably
Old revision pages are discarded and reused after all transactions on that version is closed.
But if they aren’t, each new version needs new pages, as the others are held by transactions, and so the database needs more storage