Some matches are missing players

[GraylinKim]

See the query below. I discovered this while searching for the cause of the issues seen on this forum thread. I've patched the view to no longer expect two players for each match but its a crappy fix. Perhaps the root issue can be caused and fixed and the matches repaired?

mysql> select MatchId, clientId, count(*) as num_players from match_result_players group by matchId having num_players < 2;
+---------+----------+-------------+
| MatchId | clientId | num_players |
+---------+----------+-------------+
|    7013 |      202 |           1 |
|    7028 |      202 |           1 |
|    7038 |     1572 |           1 |
|    7057 |     1614 |           1 |
|    7058 |     1614 |           1 |
|    7250 |     1594 |           1 |
|    7267 |     1013 |           1 |
|    8045 |     1165 |           1 |
|    8052 |      424 |           1 |
|    8059 |     1794 |           1 |
|    8229 |      403 |           1 |
|    8626 |      762 |           1 |
|    8627 |      762 |           1 |
|    8629 |     1794 |           1 |
|    8630 |      279 |           1 |
|    8631 |      279 |           1 |
|    8655 |     1878 |           1 |
|    9203 |      115 |           1 |
|    9207 |     1229 |           1 |
|   10787 |     2129 |           1 |
|   10789 |     1304 |           1 |
|   10792 |     1304 |           1 |
|   10794 |     1964 |           1 |
|   10795 |      273 |           1 |
|   10796 |      571 |           1 |
|   10797 |     1964 |           1 |
|   10798 |     1964 |           1 |
|   10799 |     1964 |           1 |
|   10800 |       96 |           1 |
|   12386 |      125 |           1 |
|   12587 |      796 |           1 |
|   12588 |      796 |           1 |
|   12589 |      303 |           1 |
|   12618 |      571 |           1 |
|   12628 |     2326 |           1 |
|   12631 |      268 |           1 |
+---------+----------+-------------+
36 rows in set (0.02 sec)