[Self-hosted] Inconsistent behavior when cleaning up duplicate events

[thecatontheflat]

Bug Description

Sometimes duplicate events won't get cleared up, e.g.:

I also noticed some odd behavior. It seems weird, but it looks like:

• when there are only 2 duplicates, nothing happens
• when there are more than 2 duplicates, they get cleared up

For testing purposes I have configured the cron to be executed every minute:

CLEAR_CLICKHOUSE_REMOVED_DATA_SCHEDULE_CRON: '0 * * * *'

Could you please point me in the right direction where to look for errors?

Debug info

- [ ] PostHog Hobby self-hosted with `docker compose`, version/commit: [please provide]

Latest build (same behavior was observed on the image 2 weeks old)