Etchesketch wrote: »Etchesketch wrote: »I am confused here, they said char rollback not only would not happen, but were not possible.... What?? Does this mean they don't back up chars individually? In this day and age how is that possible?
No MMO's back up characters individually. The server as a whole is backed up, and things that happen are referenced through database transactions. There is no way to just say "roll this character back to this date", because the data is not saved that way. Think of it this way.
On a game like Skyrim, you have a save file that holds all your progress. If something happens to the save file, or you get yourself into a bad situation/etc, you can load an earlier save file, "reverting" your character back to that point.
On an MMO, it doesn't happen that way. The server *as a whole* has snapshot backups like that, but not individual characters. Individual characters are a series of database transactions. Character looted this item, sold this item, crafted this item, bought bank space, logged off, logged on, now bank space is gone and items missing. They go back to what the logs say happened before the bank space went missing, and send you those items and fix your bank. Now, a lot of this is done through SQL scripts and not manually.
My explanation has been VASTLY simplified as to what actually happens and what's recorded in the logs, but it should give you an idea. In addition, WOW treats characters and backups *exactly* like this game does, and Blizzard doesn't have any issue restoring stuff after a compromise or a bug for the most part. In fact, WOW had a similar bug after the launch of Wrath of the Lich King. Lots of people lost ALL their pets and mounts. And they were all restored when the issue was fixed. It's comparable to what's happened here, although perhaps not *quite* as game breaking. Yes, I agree that this needs to be fixed yesterday, but I'm giving them the benefit of the doubt and letting them fix it.
Thanks for taking the time.. like I say, I was confused on what they meant. I know I've had chars reset and stuff replaced in many games.
To lighten it up for Zen a little here, I remember one weekend in A/C where there were some problems and that Monday they rolled the servers back to the Friday backup..
Every single person lost the entire weekend of play time, lol was there a forum frenzy for that one.
I guess by back up individually, I mean the logs, cause obviously they keep some kind of track of what you have.
No MMO's back up characters individually. The server as a whole is backed up, and things that happen are referenced through database transactions. There is no way to just say "roll this character back to this date", because the data is not saved that way. Think of it this way.
On a game like Skyrim, you have a save file that holds all your progress. If something happens to the save file, or you get yourself into a bad situation/etc, you can load an earlier save file, "reverting" your character back to that point.
On an MMO, it doesn't happen that way. The server *as a whole* has snapshot backups like that, but not individual characters. Individual characters are a series of database transactions. Character looted this item, sold this item, crafted this item, bought bank space, logged off, logged on, now bank space is gone and items missing. They go back to what the logs say happened before the bank space went missing, and send you those items and fix your bank. Now, a lot of this is done through SQL scripts and not manually.
My explanation has been VASTLY simplified as to what actually happens and what's recorded in the logs, but it should give you an idea. In addition, WOW treats characters and backups *exactly* like this game does, and Blizzard doesn't have any issue restoring stuff after a compromise or a bug for the most part. In fact, WOW had a similar bug after the launch of Wrath of the Lich King. Lots of people lost ALL their pets and mounts. And they were all restored when the issue was fixed. It's comparable to what's happened here, although perhaps not *quite* as game breaking. Yes, I agree that this needs to be fixed yesterday, but I'm giving them the benefit of the doubt and letting them fix it.
Etchesketch wrote: »Etchesketch wrote: »I am confused here, they said char rollback not only would not happen, but were not possible.... What?? Does this mean they don't back up chars individually? In this day and age how is that possible?
No MMO's back up characters individually. The server as a whole is backed up, and things that happen are referenced through database transactions. There is no way to just say "roll this character back to this date", because the data is not saved that way. Think of it this way.
On a game like Skyrim, you have a save file that holds all your progress. If something happens to the save file, or you get yourself into a bad situation/etc, you can load an earlier save file, "reverting" your character back to that point.
On an MMO, it doesn't happen that way. The server *as a whole* has snapshot backups like that, but not individual characters. Individual characters are a series of database transactions. Character looted this item, sold this item, crafted this item, bought bank space, logged off, logged on, now bank space is gone and items missing. They go back to what the logs say happened before the bank space went missing, and send you those items and fix your bank. Now, a lot of this is done through SQL scripts and not manually.
My explanation has been VASTLY simplified as to what actually happens and what's recorded in the logs, but it should give you an idea. In addition, WOW treats characters and backups *exactly* like this game does, and Blizzard doesn't have any issue restoring stuff after a compromise or a bug for the most part. In fact, WOW had a similar bug after the launch of Wrath of the Lich King. Lots of people lost ALL their pets and mounts. And they were all restored when the issue was fixed. It's comparable to what's happened here, although perhaps not *quite* as game breaking. Yes, I agree that this needs to be fixed yesterday, but I'm giving them the benefit of the doubt and letting them fix it.
Thanks for taking the time.. like I say, I was confused on what they meant. I know I've had chars reset and stuff replaced in many games.
To lighten it up for Zen a little here, I remember one weekend in A/C where there were some problems and that Monday they rolled the servers back to the Friday backup..
Every single person lost the entire weekend of play time, lol was there a forum frenzy for that one.
I guess by back up individually, I mean the logs, cause obviously they keep some kind of track of what you have.
Yes...MMO's (and SQL databases in general actually) have a very specific definition for "rollback" that does not fit what most people think the word means. It's really just a..."this word means exactly this and only this when dealing with an SQL database and what you said isn't technically a rollback".
The reason they don't want people thinking it is a rollback, is because if your character were *actually* rolled back, you would lose all progress you made since the bug happened, and I don't think anyone wants that. What they are going to do is not a rollback in the technical sense of the word, instead they are going to restore what you are missing.
Etchesketch wrote: »Etchesketch wrote: »I am confused here, they said char rollback not only would not happen, but were not possible.... What?? Does this mean they don't back up chars individually? In this day and age how is that possible?
No MMO's back up characters individually. The server as a whole is backed up, and things that happen are referenced through database transactions. There is no way to just say "roll this character back to this date", because the data is not saved that way. Think of it this way.
On a game like Skyrim, you have a save file that holds all your progress. If something happens to the save file, or you get yourself into a bad situation/etc, you can load an earlier save file, "reverting" your character back to that point.
On an MMO, it doesn't happen that way. The server *as a whole* has snapshot backups like that, but not individual characters. Individual characters are a series of database transactions. Character looted this item, sold this item, crafted this item, bought bank space, logged off, logged on, now bank space is gone and items missing. They go back to what the logs say happened before the bank space went missing, and send you those items and fix your bank. Now, a lot of this is done through SQL scripts and not manually.
My explanation has been VASTLY simplified as to what actually happens and what's recorded in the logs, but it should give you an idea. In addition, WOW treats characters and backups *exactly* like this game does, and Blizzard doesn't have any issue restoring stuff after a compromise or a bug for the most part. In fact, WOW had a similar bug after the launch of Wrath of the Lich King. Lots of people lost ALL their pets and mounts. And they were all restored when the issue was fixed. It's comparable to what's happened here, although perhaps not *quite* as game breaking. Yes, I agree that this needs to be fixed yesterday, but I'm giving them the benefit of the doubt and letting them fix it.
Thanks for taking the time.. like I say, I was confused on what they meant. I know I've had chars reset and stuff replaced in many games.
To lighten it up for Zen a little here, I remember one weekend in A/C where there were some problems and that Monday they rolled the servers back to the Friday backup..
Every single person lost the entire weekend of play time, lol was there a forum frenzy for that one.
I guess by back up individually, I mean the logs, cause obviously they keep some kind of track of what you have.
Yes...MMO's (and SQL databases in general actually) have a very specific definition for "rollback" that does not fit what most people think the word means. It's really just a..."this word means exactly this and only this when dealing with an SQL database and what you said isn't technically a rollback".
The reason they don't want people thinking it is a rollback, is because if your character were *actually* rolled back, you would lose all progress you made since the bug happened, and I don't think anyone wants that. What they are going to do is not a rollback in the technical sense of the word, instead they are going to restore what you are missing.
How exactly are they going to do this in a timely fashion? (If you have any idea, which you may or may not).
Also, why would this take several days to fix?
Heh, I have SQL scripts at my job that are hundreds of queries grouped together, thousands of lines long.
BTW, the DB doesn't necessarily have to be offline to do this kind of work, it merely makes it a LOT easier on the person doing the work.
If I had to guess, since my account got reset back to "new" status, some "get char info" query timed out, the info requested wasn't sent up, and then something caused the app server to "save", and since part of it was never filled in, it saved that part incorrectly overtop the real data. Thus the bank gets truncated at 60, emails were resent since the char looked new, etc. At least, that's what my version of this bug looks like. There could be many if the people designing/programming the thing didn't know what they were doing.