fiatjaf on Nostr: Oh, now I see what you mean. I don't think that compact stuff is relevant here. The ...

Oh, now I see what you mean. I don't think that compact stuff is relevant here. The thing is that both on Badger and LMDB whenever we got a replaceable event stored twice (apparently because of race conditions) that would break the indexes in some way I forgot, such that it became impossible to delete the older version forever because it would be unreachable. The only way to fix this is to do a full rescan of the database and rebuild all the indexes, which is what LMDB does in its latest migration (well, all the other migrations I deleted because this big rescan makes them unnecessary).

Badger needs that same thing, but I forgot to do it. In any case you can do it manually by copying then nuking the database and then reimporting the events from the old database to the new empty one. I should still write the reindexing migration though.