We recently went over 2^31-1 = 2 147 483 647 orders entered. Quite a mind boggling landmark, but unfortunately it's also the largest number PHP can handle

So all of a sudden order IDs are stored in PHP as floats, which causes all sorts of nasty strange problems. This is why these weird problems started appearing all of a sudden for no apparent reason


There have been ~2 billion orders entered but there are only ~10000 active orders being entered at the moment, so the ID used for orders was knocked down to something PHP can handle

I've also checked other tables for similar problems and we were nearing the 4 billion limit for game messages, so that got bumped up too

7543, 7063, 7623, 7581 - These games had units which could retreat to places other units were already occupying, and were all moved back to the retreat phase where there were problems, and now the correct retreats are given

6258, 6720 - These games had the no units map problem, but the changes from yesterday caught the problem and after moving the order IDs back they processed correctly

There might be some games I missed, but I'm pretty confident this time that the problem itself is taken care of

Laoban; what problem happened during unit placement that needs the game to be turned back? The problem with turning it back any further is that you'll have to re-do a Diplomacy phase, which means you'll all know what each other did last time

Ah... One of the reasons I use GUIDs for transactional identifiers. It's amazing how quickly you can exceed even a double int.

For those who were around for the downtime; I tried to compact the IDs in a few tables, so that it'd be longer before we get back to 2^31-1 again, but something messed up so I restored from a backup I took after I got everything working

There has been a lot of downtime in the last couple of days but I think that's all over now, and in the next version there'll be more checks and redundancy (I'd rather be coding than just maintaining phpDip), sorry for the delays and thanks to the mods for pausing games etc while this was going on

Also 6 hours have been added onto games process times to account for the downtime

Thanks much for all the hard work.

Well Done

Which means old games have had their orders deleted?

Nope, old orders are archived in a different table, only the active orders table needs IDs so that they can be referred to and updated, old orders are just read to draw the map so no ID# is stored

We only have ~10000 active orders, but their ID# goes up one by one even as old orders are moved to the archive table, so they still had ID#s going over 2 billion

Its the same thing with game messages, we have almost 4 billion of those but because they dont need to be referred to by their ID# there's no problem

Did we do another one of those rewind-the-clock dealios?

Either that, or I'm finally going crazy.

Yes, but not by much, and Kestas added more time so people wouldn't miss moves they wouldn't have normally missed.

As far as I can tell it was only an hour or so, and so very few people will have lost out. The rollback was made at aproximately 0700GMT

haha, I guess I just had really terrible timing for all of my indepth ingame messages. :P

Thanks Kestas. Good job.