aletson / votefinder-web

Web-based vote parser for use on various web forums.
http://votefinder.org
GNU General Public License v3.0
2 stars 1 forks source link

game stuck, can't refresh #205

Closed aletson closed 4 years ago

aletson commented 4 years ago

Dennis Lee's Food Crime Mafia is in a weird state. Can't refresh the game to read posts. Game thinks there are no players (added one manually to see what would happen). Posts for game in VF shows the OP twice. Did add factions at some point, removing them did nothing. - reported by Epsilon

rjmagley commented 4 years ago

game is https://votefinder.org/game/dennis-lees-food-crime thread is https://forums.somethingawful.com/showthread.php?threadid=3933420

attempting to refresh leads to this image (waited half an hour for it to resolve): image

can't access any logs to check or anything but it feels like it just doesn't know what to do, something in the OP is maybe causing some issues?

rjmagley commented 4 years ago

setting the OP to the phrase "testing" and trying to update again leads to the same behavior, so it's not choking on some formatting in the OP

rjmagley commented 4 years ago

the only other game on VF right now (a BNR game) refreshes without issue. other games were doing okay today?

rjmagley commented 4 years ago

suggested to close/reopen the thread and to disable autohammer, no dice. maybe check what's in the DB for this game? slug is "dennis-lees-food-crime"

e. works fine in beta, idk what the current difference between the codebases is but comparing their DB entries may be informative

aletson commented 4 years ago

i killed the game and readded it from the admin panel, nothing

aletson commented 4 years ago

may be fixed

aletson commented 4 years ago

specifically: related to add games. when there are duplicate post ids in the database, updates stop working because it sees duplicate posts on a Post.get() call which throws a 500

aletson commented 4 years ago

hypothesis is that add_game got pinged twice which brought in posts twice because add_game uses Game.get_or_create(), perhaps?

aletson commented 4 years ago

closed in 3.6.2a