server
server copied to clipboard
Event Updates broken?
I looked into this issue https://github.com/FAForever/faf-java-api/issues/198 and the data is in the database.
However, when I query for something like SELECT * FROM player_events WHERE event_id = '7be6fdc5-7867-4467-98ce-f7244a66625a' and update_time > '2021-08-01'
and it returns only 268 rows it makes me seriously wonder if we only had 268 winning uefs factions in one week of games.
Then I ran this query:
select * from game_stats gs inner join game_player_stats gps on gs.id = gps.gameId
where gs.validity = 0 and gs.endTime > '2021-08-01'
and gps.faction = 1
and gps.result = 'VICTORY'
and it gives me 4566 rows of players who won a UEF game.
Looks like sending updates does not work properly.
I'm not seeing anything suspicious in the server logs. The event/achievement reporting is not throwing any exceptions, but I'm not logging the API response codes so it's possible that the API is returning with some error codes and we're just ignoring them... Should add that
Oh wait, I take it back. It does log anything that's not a 200 response. So I looks to me like there aren't any issues
Well then how do you explain the massive difference in the numbers?