[Complete] Unscheduled Server Maintenance - December 7, 2013

http://maplestory.nexon.net/news/mainten...nts/00HO1/

We will be performing an unscheduled server maintenance on December 7, 2013. It will last approximately two hours.

Thanks for your patience!

Time:
Saturday, December 7, 2013
Pacific: 8:00 AM - 10:00 AM
Eastern: 11:00 AM - 1:00 PM


What will be unavailable:

• All MapleStory game servers.
  

Changes and Updates:

• A fix will be applied for a bug that can cause characters to get stuck while revisiting Maple Island.
  
• Characters stuck in Snail Park will be moved to Lith Harbor.
  

Fixing bugs like that takes that long?
Or are there a lot of people to move from Snail Park to Lith Harbor?

at least they're fixing it

I don't know much about database junk, but if it works anything like most search queries it'll have to look at each and every character that exists, compare a map id, and then change that and the respawn point if a match is found.
Taking a while is likely the result of having so many dang characters that need looked at.

Edit: There are approximately 21,486,244 characters, and that's only counting the ones that show up in the rankings.
Yeesh.

Hooray, no more Hot Time for me.

I don't know much about database junk, but if it works anything like most search queries it'll have to look at each and every character that exists, compare a map id, and then change that and the respawn point if a match is found.
Taking a while is likely the result of having so many dang characters that need looked at.

Edit: There are approximately 21,486,244 characters, and that's only counting the ones that show up in the rankings.
Yeesh.

They should do a wipe

Fixing bugs like that takes that long?
Or are there a lot of people to move from Snail Park to Lith Harbor?

Most people can run out. It's just the 0.5% of MS or less that is stuck there. Quest fanatics get pulled down under.

Fixing bugs like that takes that long?
Or are there a lot of people to move from Snail Park to Lith Harbor?

They explained at some point that just taking the servers down and bringing them back up again takes about that long.

I don't know much about database junk, but if it works anything like most search queries it'll have to look at each and every character that exists, compare a map id, and then change that and the respawn point if a match is found.
Taking a while is likely the result of having so many dang characters that need looked at.

Edit: There are approximately 21,486,244 characters, and that's only counting the ones that show up in the rankings.
Yeesh.

Not that hard to just add a WHERE clause and make it only search for characters above level 10. Suddenly the results in that query go down to... a lot less.

Not that hard to just add a WHERE clause and make it only search for characters above level 10. Suddenly the results in that query go down to... a lot less.

Doesn't help much if that field is not an index. Also, the 21 million on rankings are all above level 10.

Doesn't help much if that field is not an index. Also, the 21 million on rankings are all above level 10.

Bingo. Non-indexed queries take exponentially longer than indexed queries.

Doesn't help much if that field is not an index. Also, the 21 million on rankings are all above level 10.

That's why they're only querying for characters above level 10 that are on a few specific maps (The first few on maple island, which is where my adventurer is stuck at)

Though yes, non-indexed queries would take a loooooot longer. Never seen their database, so I wouldn't know.

After I spend 3 hours trying to get GMS to work I finally have everything set up and this happens. Oh well.

I wonder what's gonna be ninja patch'd this time.

Hoping that they don't "fix" the spawn rate.

I wonder what's gonna be ninja patch'd this time.

Hoping that they don't "fix" the spawn rate.

I have the horrible feeling that Gollux's body parts will stop dropping green coins again.

"R" Ice Cube or indirectly Love Letters would be my guess, definitely more pressing compared to Gollux Coins which I assume are still limited by the six entrances and further limited to three in observation that Keys either do not drop or drop at a significantly lower rate.

just when I wanted to set up my main for the hot time... ty obama

I have the horrible feeling that Gollux's body parts will stop dropping green coins again.

Just tested it, they still drop.

[url][/url]

[Complete] The maintenance is complete as of 9:20 AM Pacific (12:20 PM Eastern). Cash items in your inventories have been extended to cover the amount of the time the game was under maintenance.

We will be performing an unscheduled server maintenance on December 7, 2013. It will last approximately two hours.

Thanks for your patience!

Time:
Saturday, December 7, 2013
Pacific: 8:00 AM - 10:00 AM
Eastern: 11:00 AM - 1:00 PM


What will be unavailable:

• All MapleStory game servers.
  

Changes and Updates:

• A fix will be applied for a bug that can cause characters to get stuck while revisiting Maple Island.
  
• Characters stuck in Snail Park will be moved to Lith Harbor.
  

SO what did they fix/broke?