Skip to content

Bug: leak in username sorted set #477

@SHAcollision

Description

@SHAcollision

It looks like the same pubky_id could show up twice in the Sorted:Users:Name Sorted Set. As far as I remember, users that changed their username used to be a problem (they duplicated in this sorted set), but we fixed this. In any case, there seems to be still some ways a user could end up showing more than once under different usernames in this Sorted Set, needs debugging, possibly changing your username under some scenario can still trigger this.

Image

Image

Another case:
Image

And case here
Image
Searching for "`jo" should not yield a result anymore, since John changed his username to remove the quote marking. Yet it does

Image

I have manually cleaned up the production database and I deleted:

  • 4 instances of duplicated user_id in the sorted set
  • 1 instance of a non-existing user anymore still existing in this sorted set.

Metadata

Metadata

Assignees

Labels

🐞 bugSomething isn't working👀 watcherNexus indexer related operations

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions