server icon indicating copy to clipboard operation
server copied to clipboard

Event Updates broken?

Open Brutus5000 opened this issue 3 years ago • 3 comments

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.

Brutus5000 avatar Aug 07 '21 12:08 Brutus5000

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

Askaholic avatar Sep 25 '21 07:09 Askaholic

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

Askaholic avatar Sep 25 '21 07:09 Askaholic

Well then how do you explain the massive difference in the numbers?

Brutus5000 avatar Sep 25 '21 20:09 Brutus5000