# Server Issues - An Explanation

**URL:** https://community.gemsofwar.com/t/server-issues-an-explanation/19275
**Category:** Official News
**Created:** [January 31, 2017, 6:40am UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275 "2017-01-31T06:40:26Z")
**Posts on this page:** 20
**Page:** 1

<div class="post-metadata">

### Author: ![Sirrian](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/sirrian/32/35758_2.png) [@Sirrian](https://community.gemsofwar.com/u/Sirrian)
#### Post date: [January 31, 2017, 6:40am UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/1 "2017-01-31T06:40:26Z")

</div>

Hi All,

As you all know, the servers had some errors!

I wanted to share exactly what happened… a TL;DR version, and then a longer version for the tech folks out there, just to keep you all informed.

## **TL;DR**

Our new servers behave differently during login to our old servers… they create a bunch of stuff and don’t delete it… we missed that it was happening, and our database grew too large, ate up all our memory, and caused a problem.

## **Longer (Technical) Version**

We were previously using a service for our servers called Parse. Parse closed down today, but we had successfully migrated off of it… the database was moved off last May to the infamous MongoDB (which is actually pretty awesome… MongoDB errors you have received have actually been an issue with the servers, not Mongo), and the actual servers were moved away over the last 2 weeks to something called “Parse Server” - written by the guys who made Parse to emulate how Parse operates.

What we didn’t realise is that Parse Server, during the LOGIN operation creates an object and _doesn’t delete it._  
Parse also created an object during LOGIN, but was automatically revoking it on the next LOGIN.  
This was undocumented, and frankly for most applications they don’t get enough logins to matter… GEMS OF WAR ON THE OTHER HAND has rather a lot of users, 10’s upon 10’s of thousands of them logging in every day, in many cases multiple times!

As any of you who work with databases will know, you have a LOT of telemetry to examine to ensure your database is healthy. We have access to all of that and look at it regularly… we’d been a little concerned about the increase of disk space, but hadn’t figured out what was causing it, thought perhaps maybe it was the new server storing some extra data… made a note to investigate it if it kept growing… and then BAM! we started causing page faults like crazy last night… turns out that one table SESSIONS, which we hadn’t looked at, because it had never been a problem, had almost 50 million entries, and its indices were filling our memory.

## Finally…

We haven’t solved the problem yet… though our tech leads assure us it’s well underway. We’ve added extra memory to our database servers while we fix this over the next couple of days, and we’ll keep you all posted how it goes.

I apologize that we weren’t around to keep you filled in last night… I’d seen the initial spikes at 2am, done some maintenance, watched them go back down and called it a day. We’ll try to keep a presence online a little more regularly while we’re fixing things this week.

---

<div class="post-metadata">

### Author: ![Jainus](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/jainus/32/34949_2.png) [@Jainus](https://community.gemsofwar.com/u/Jainus)
#### Post date: [January 31, 2017, 7:13am UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/3 "2017-01-31T07:13:30Z")

</div>

> [@Sirrian](#):
>
> I apologize that we weren’t around to keep you filled in last night…

The militancy of some players towards this has been pretty shameful, in my view. The staff should be allowed to sleep some time… this game is _free_ for the majority of players.

However, it’s human nature to get angry and frustrated when we can’t get what we want when we want it. I was at work around 12 hours yesterday, so the server issues only affected me on my 40 minute train home - but if I’d been on leave, or been travelling (I often have 5-6 hours in a day on a train going oop north) I’d have been pretty frustrated at the lack of gems. Angry enough to cuss the team and threaten to quit? Dunno.

Surely this game is now big and successful enough to justify the cost of increased tech support, and overnight support. Without the _creative lead_ spending his nights doing it.

---

<div class="post-metadata">

### Author: ![en9nhcet](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/en9nhcet/32/1673_2.png) [@en9nhcet](https://community.gemsofwar.com/u/en9nhcet)
#### Post date: [January 31, 2017, 7:20am UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/4 "2017-01-31T07:20:10Z")

</div>

![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/4/1/41c93da7a32a4bbd975ca5799d06dabc87ea347d.PNG)

…😅

---

<div class="post-metadata">

### Author: ![Zelfore](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/zelfore/32/22295_2.png) [@Zelfore](https://community.gemsofwar.com/u/Zelfore)
#### Post date: [January 31, 2017, 7:21am UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/5 "2017-01-31T07:21:03Z")

</div>

> [@Jainus](#):
>
> Surely this game is now big and successful enough to justify the cost of increased tech support, and overnight support. Without the creative lead spending his nights doing it.

It does seem they’re working on increasing their staff numbers. (E.g. Saltypatra)  
How many are going into tech/support staff? Dunno, but I wouldn’t be surprised if their members have gone up from even a month ago.

* * *

Thanks for the update Sirrian! I’ve taken the liberty of quoting you for the Steam side of things.  
Hope things can be resolved shortly for all your’s sakes.

---

<div class="post-metadata">

### Author: ![ogunther](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ogunther/32/1464_2.png) [@ogunther](https://community.gemsofwar.com/u/ogunther)
#### Post date: [January 31, 2017, 7:24am UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/6 "2017-01-31T07:24:40Z")

</div>

I can only imagine you’re speaking about me, (in addition to others) but I’d really appreciate it if you didn’t misquote and exaggerate what I write while you’re busy kissing ass. I never said the staff shouldn’t sleep; far from it. I stated that they should have someone scheduled for the time when the rest of the team is off which is pretty standard stuff.

> [@Sirrian](#):
>
> We’ll try to keep a presence online a little more regularly while we’re fixing things this week

Thanks, @Sirrian; that is all I’ve been wanting and I appreciate you addressing it. Fingers crossed it’s not necessary and everything goes smoothly with the rest of the database work.

---

<div class="post-metadata">

### Author: ![Ebreg](https://avatars.discourse-cdn.com/v4/letter/e/96bed5/32.png) [@Ebreg](https://community.gemsofwar.com/u/Ebreg)
#### Post date: [January 31, 2017, 7:25am UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/7 "2017-01-31T07:25:47Z")

</div>

Oh Sirrian 🙂

Nothing really happend 🙂

Nothing which could not be fixed by giving free mythic to everyone 🙂 (I would appreciate Pharos Ra)

---

<div class="post-metadata">

### Author: ![yonizaf](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/yonizaf/32/1435_2.png) [@yonizaf](https://community.gemsofwar.com/u/yonizaf)
#### Post date: [January 31, 2017, 7:32am UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/8 "2017-01-31T07:32:24Z")

</div>

Mythics aside, I won’t be surprised if that’s the reason they created that Mongo fellow, so they can give him as compensation next time the servers misbehave.

---

<div class="post-metadata">

### Author: ![Ebreg](https://avatars.discourse-cdn.com/v4/letter/e/96bed5/32.png) [@Ebreg](https://community.gemsofwar.com/u/Ebreg)
#### Post date: [January 31, 2017, 7:42am UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/9 "2017-01-31T07:42:22Z")

</div>

Technical City - where all developers live as a units + several bugs as a monsters. Imagine Sirrian as a legendary troop. With banhammer as a legendary skill. And skill called “Login Issues” as a theme :  
“Login Issue” - affected troop is “AFK” - it disappears from the team until effect vanish. If the other troops are killed while unit is AFK you loose.

---

<div class="post-metadata">

### Author: ![Annaerith](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/annaerith/32/13840_2.png) [@Annaerith](https://community.gemsofwar.com/u/Annaerith)
#### Post date: [January 31, 2017, 7:54am UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/11 "2017-01-31T07:54:57Z")

</div>

thank you for the explanation, feels better to see you guys care about us enough to share the info 🙂

the positive aspect of those server issues is/was - i got to actually try a daemon summoning dec xD if not the errors id never considering it haha even with this event

i hope you will fix it soon 🙂

---

<div class="post-metadata">

### Author: ![Eika](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/eika/32/103088_2.png) [@Eika](https://community.gemsofwar.com/u/Eika)
#### Post date: [January 31, 2017, 8:28am UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/12 "2017-01-31T08:28:25Z")

</div>

Eventho the server was pain in the ass yesterday I managed to get 150 snot stones. I just did the last 50 now. Thanks for the explanations, and the game has been great here since I woke up.

---

<div class="post-metadata">

### Author: ![collectorofgems](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/collectorofgems/32/38138_2.png) [@collectorofgems](https://community.gemsofwar.com/u/collectorofgems)
#### Post date: [January 31, 2017, 8:53am UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/13 "2017-01-31T08:53:13Z")

</div>

@Sirrian thank you for your’s and the rest of the dev team’s tireless effort to keep those 10’s and 10’s of thousands of us crazy players that can’t get through a day without matching those pretty little circles. I appreciate everything you bunch do just as so many others do as well.

Keep up the good work. 👍

---

<div class="post-metadata">

### Author: ![shurikvz](https://avatars.discourse-cdn.com/v4/letter/s/94ad74/32.png) [@shurikvz](https://community.gemsofwar.com/u/shurikvz)
#### Post date: [January 31, 2017, 9:16am UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/14 "2017-01-31T09:16:24Z")

</div>

@Sirrian although this is not exact my area of experience and I do not know what kind of functionality of [parse.com](http://parse.com) you used and what is your future plans, but just in case you did not seen - the list of alternatives: [GitHub - relatedcode/GraphQLite: Rapid GraphQL prototyping, development, and testing. Core Server, Admin Console, iOS SDK, Web SDK.](https://github.com/relatedcode/ParseAlternatives)

---

<div class="post-metadata">

### Author: ![Spherix](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/spherix/32/2388_2.png) [@Spherix](https://community.gemsofwar.com/u/Spherix)
#### Post date: [January 31, 2017, 11:53am UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/15 "2017-01-31T11:53:55Z")

</div>

Wait… You’re only now using MongoDB? What were you using before? Or was that hidden behind Parse, so you never had to deal with it directly?

---

<div class="post-metadata">

### Author: ![Isis\_Kitty](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/isis_kitty/32/9189_2.png) [@Isis\_Kitty](https://community.gemsofwar.com/u/Isis_Kitty)
#### Post date: [January 31, 2017, 12:28pm UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/16 "2017-01-31T12:28:30Z")

</div>

Just want to add my thanks for the team’s hard work and dedication. If we didn’t love this game, we wouldn’t really care, so KUDOS!

---

<div class="post-metadata">

### Author: ![Raito](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/raito/32/17635_2.png) [@Raito](https://community.gemsofwar.com/u/Raito)
#### Post date: [January 31, 2017, 12:38pm UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/17 "2017-01-31T12:38:15Z")

</div>

I agree. Some users act extremely childish here, entitled even. Sure, it sucks when Servers go down, but my god, if you have any idea or experience with online games at all, you’d know that the GoW devs handled it pretty well and fix stuff quickly. Honestly, devs, don’t beat yourself up over it. Lots of people nowadays like to get outraged at every single little thing that goes wrong.

---

<div class="post-metadata">

### Author: ![DonBoba](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/donboba/32/25457_2.png) [@DonBoba](https://community.gemsofwar.com/u/DonBoba)
#### Post date: [January 31, 2017, 12:41pm UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/18 "2017-01-31T12:41:13Z")

</div>

> [@Raito](#):
>
> Lots of people nowadays like to get outraged at every single little thing that goes wrong.

Like someone raging about being kicked from a guild because they werent playing?

---

<div class="post-metadata">

### Author: ![Ebreg](https://avatars.discourse-cdn.com/v4/letter/e/96bed5/32.png) [@Ebreg](https://community.gemsofwar.com/u/Ebreg)
#### Post date: [January 31, 2017, 1:13pm UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/20 "2017-01-31T13:13:30Z")

</div>

> [@DonBoba](#):
>
> Like someone raging about being kicked from a guild because they werent playing?

Serious stuff 🙂

---

<div class="post-metadata">

### Author: ![Eika](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/eika/32/103088_2.png) [@Eika](https://community.gemsofwar.com/u/Eika)
#### Post date: [January 31, 2017, 1:21pm UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/21 "2017-01-31T13:21:25Z")

</div>

> [@DonBoba](#):
>
> Like someone raging about being kicked from a guild because they werent playing?

![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/6/1/611dc9618c224dc393566c4b504e0aad132bcd3c.gif)

---

<div class="post-metadata">

### Author: ![UKresistance](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ukresistance/32/7558_2.png) [@UKresistance](https://community.gemsofwar.com/u/UKresistance)
#### Post date: [January 31, 2017, 2:11pm UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/22 "2017-01-31T14:11:39Z")

</div>

I work 3rd shit computer operations, so I’m there too look out for the scary night problems that crash databases and websites. Which means I surf the Web and play gems when nothing is broke 🙂

When stuff does break ☹

---

<div class="post-metadata">

### Author: ![ogunther](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ogunther/32/1464_2.png) [@ogunther](https://community.gemsofwar.com/u/ogunther)
#### Post date: [January 31, 2017, 3:03pm UTC](https://community.gemsofwar.com/t/server-issues-an-explanation/19275/24 "2017-01-31T15:03:26Z")

</div>

> [@UKresistance](#):
>
> I work 3rd shit computer operations

Lol not sure if typo or perfect description of 3rd shift

[Next page](https://community.gemsofwar.com/t/server-issues-an-explanation/19275.md?page=2)
