[Bug]: Some games are ranked multiple times

[p2004a]

Describe the Bug

Run into it when I was performing data analysis. There are matches that contain multiple entries in teiserver_game_rating_logs for the same match, for example match_id=2283667 from 2024-03-09. There are 120 games like this, one game is even rated 4 times.

Reproduce the bug

Query to run e.g. on integration server to pull match ids:

WITH
dups AS (
    SELECT
        count(*) AS c,
        match_id,
        user_id
    FROM
        teiserver_game_rating_logs tgrl
    GROUP BY
        match_id,
        user_id
    HAVING
        count(*) > 1
),
dups_per_match AS (
    SELECT
        max(c) AS c,
        match_id
    FROM
        dups
    GROUP BY
        match_id
),
top_dup_matches AS (
    SELECT
        tbm.id,
        tbm.started,
        c AS duplicates
    FROM
        dups_per_match dpm
    JOIN teiserver_battle_matches tbm ON
        dpm.match_id = tbm.id
    ORDER BY
        duplicates DESC,
        tbm.started DESC
)
SELECT
    *
FROM
    top_dup_matches;

Screenshots

No response

Additional context

No response

[L-e-x-o-n]

As discussed on Discord, constraints should be added so teiserver_game_rating_logs can't contain multiple logs for the same match