Sync of ansible collections fails after update to 3.8/4.10

Problem: Sync of ansible collections fails with duplicate key value violates unique constraint "unique_is_highest"

Expected outcome: Sync works

Foreman and Proxy versions: 3.8.0

Foreman and Proxy plugin versions: Katello 4.10.0

Distribution and version: CentOS Stream 8

Other relevant data:
I already found API Updates Broken: Duplicate key value violates unique constraint "unique_is_highest" · Issue #3267 · ansible/galaxy · GitHub which sounded so similar that I created the package and did an update, but it unfortunately does not fix the issue.