The game has been lagging pretty badly, for at leas the last 5 or 6 hours. Quite a few people are complaining about it, so I know it's not just me.
http://forums.cardhunter.com/threads/game-freeze.5453/ Already covered in that thread. But it's likely more of a support issue than a bug one, so maybe we should move it. I sent a message to Jon about this, but it's still early in Australia.
Found the problem, not sure what the cause is yet, but will be rebooting the server shortly which should fix it for the moment.
SP is working normally, thanks for the fix! What was the second fix, if that's not too much inside baseball?
MP seems to work much better than normal as I just killed all three of Cardotron2000's characters with a pure melee party without it getting in a single point of damage against mine .
We have a pre-defined database query that we use to keep the DB connections alive. A long time ago we used SELECT COUNT(*) from player, which counts how many players are in the player table. That was sort of pointless and expensive, so we replaced it with SELECT 1, which does nothing much more cheaply. For some reason, we deployed that fix to the test server, but never live (I think it was a fix we made last year when we launched and we were kind of swamped with stuff to do). It was all OK though until, presumably, our player table got too big. We added one too many new players and it started really slowing things down.
Thanks for elaborating! Yeah, that'd do it. I write a lot of SQL queries for a living so I feel your pain.
Turns out that there's still a problem that may crop up. We'll look into it further in the coming week and it may require some more server reboots.
