In database technologies, a rollback is an operation which returns the database to some previous state.
https://en.wikipedia.org/wiki/Rollback_(data_management)In database technologies, a rollback is an operation which returns the database to some previous state.
Androconium wrote: »The current situation is not a planned Roll Back operation; it is simply data loss.
Master_Kas wrote: »I just finished a entire zones skyshards & lorebooks, get logged out + rollback and have to do it all again... xD
More probably error in game status. In overland you can probably play for quite some time before getting out of sync.Androconium wrote: »When people say "roll back" is this describing a situation where:
- you get disconnected
- after logging in again, you are at an earlier point in your game play than you were when you got disconnected?
If so, then why is this situation not being described for what it is? i.e. DATA LOSS.
Androconium wrote: »When people say "roll back" is this describing a situation where:
- you get disconnected
- after logging in again, you are at an earlier point in your game play than you were when you got disconnected?
If so, then why is this situation not being described for what it is? i.e. DATA LOSS.
Androconium wrote: »https://en.wikipedia.org/wiki/Rollback_(data_management)In database technologies, a rollback is an operation which returns the database to some previous state.
Yes. I've actually done it.
It's used to remove an upgrade that has failed.
An operation is planned. What is happening here is unplanned.
This symptoms so far suggest that nothing is being "rolled back", simply because it hasn't been captured in the first place.
This is why I asked the question...
The current situation is not a planned Roll Back operation; it is simply data loss.
Master_Kas wrote: »I just finished a entire zones skyshards & lorebooks, get logged out + rollback and have to do it all again... xD
Androconium wrote: »The current situation is not a planned Roll Back operation; it is simply data loss.
What's your point? Every rollback is data lost.
Androconium wrote: »https://en.wikipedia.org/wiki/Rollback_(data_management)In database technologies, a rollback is an operation which returns the database to some previous state.
Yes. I've actually done it.
It's used to remove an upgrade that has failed.
An operation is planned. What is happening here is unplanned.
This symptoms so far suggest that nothing is being "rolled back", simply because it hasn't been captured in the first place.
This is why I asked the question...
The current situation is not a planned Roll Back operation; it is simply data loss.
A few things I guess I could help clear up.
First, an operation doesn't need to be planned. It's not always an operation as in the sense that it is a planned course of action, but can be an operation in the sense of something is operating i.e. something is in effect. In the case of a rollback, the database is what's operating, and in a very specific manner - in a way that "rolls back" data in the database to what the data used to be in the past.
Second, despite how operations don't necessarily need to be planned, a rollback operation actually is planned. All rollback operations are planned. The function that is a rollback - that the data in a database will be set to what it used to be in the past through some specific method of achieving such - is planned in that it must have been programmed to function the way it does at some point. Dynamic rollbacks in the case of critical errors are still planned, because the rollbacks are setup to occur on the condition of the occurrence of a critical error. In other words, both the actual operation of a rollback itself and the condition in which a dynamic rollback will happen are determined at the time of development, thus meaning they are planned. What isn't planned is the literal time when a dynamic rollback will have to take place, since it's impossible to know when critical errors will arise and the conditions for starting the rollback will be met.
To clarify, a rollback is data loss, but it's a very specific type of data loss. The term rollback carries the implications that the data loss was intentional due to circumstances, controlled in how data was lost, and controlled in the scope of data that was lost. Just saying "data loss" doesn't give enough detail as to what actually happened because it lacks these implications. So, the term rollback is used instead of data loss because it better explains exactly what happened.
Also, rollbacks are used for a heck of a lot more than failed updates. It's most commonly used for data corruption, of which failed updates is only one of many causes.
Androconium wrote: »Androconium wrote: »https://en.wikipedia.org/wiki/Rollback_(data_management)In database technologies, a rollback is an operation which returns the database to some previous state.
Yes. I've actually done it.
It's used to remove an upgrade that has failed.
An operation is planned. What is happening here is unplanned.
This symptoms so far suggest that nothing is being "rolled back", simply because it hasn't been captured in the first place.
This is why I asked the question...
The current situation is not a planned Roll Back operation; it is simply data loss.
A few things I guess I could help clear up.
First, an operation doesn't need to be planned. It's not always an operation as in the sense that it is a planned course of action, but can be an operation in the sense of something is operating i.e. something is in effect. In the case of a rollback, the database is what's operating, and in a very specific manner - in a way that "rolls back" data in the database to what the data used to be in the past.
Second, despite how operations don't necessarily need to be planned, a rollback operation actually is planned. All rollback operations are planned. The function that is a rollback - that the data in a database will be set to what it used to be in the past through some specific method of achieving such - is planned in that it must have been programmed to function the way it does at some point. Dynamic rollbacks in the case of critical errors are still planned, because the rollbacks are setup to occur on the condition of the occurrence of a critical error. In other words, both the actual operation of a rollback itself and the condition in which a dynamic rollback will happen are determined at the time of development, thus meaning they are planned. What isn't planned is the literal time when a dynamic rollback will have to take place, since it's impossible to know when critical errors will arise and the conditions for starting the rollback will be met.
To clarify, a rollback is data loss, but it's a very specific type of data loss. The term rollback carries the implications that the data loss was intentional due to circumstances, controlled in how data was lost, and controlled in the scope of data that was lost. Just saying "data loss" doesn't give enough detail as to what actually happened because it lacks these implications. So, the term rollback is used instead of data loss because it better explains exactly what happened.
Also, rollbacks are used for a heck of a lot more than failed updates. It's most commonly used for data corruption, of which failed updates is only one of many causes.
Controlled data loss?
I'm not disputing any of your comments, but I'm also not convinced that 'controlled data loss' is something that would acceptable in the banking industry.
Androconium wrote: »Androconium wrote: »https://en.wikipedia.org/wiki/Rollback_(data_management)In database technologies, a rollback is an operation which returns the database to some previous state.
Yes. I've actually done it.
It's used to remove an upgrade that has failed.
An operation is planned. What is happening here is unplanned.
This symptoms so far suggest that nothing is being "rolled back", simply because it hasn't been captured in the first place.
This is why I asked the question...
The current situation is not a planned Roll Back operation; it is simply data loss.
A few things I guess I could help clear up.
First, an operation doesn't need to be planned. It's not always an operation as in the sense that it is a planned course of action, but can be an operation in the sense of something is operating i.e. something is in effect. In the case of a rollback, the database is what's operating, and in a very specific manner - in a way that "rolls back" data in the database to what the data used to be in the past.
Second, despite how operations don't necessarily need to be planned, a rollback operation actually is planned. All rollback operations are planned. The function that is a rollback - that the data in a database will be set to what it used to be in the past through some specific method of achieving such - is planned in that it must have been programmed to function the way it does at some point. Dynamic rollbacks in the case of critical errors are still planned, because the rollbacks are setup to occur on the condition of the occurrence of a critical error. In other words, both the actual operation of a rollback itself and the condition in which a dynamic rollback will happen are determined at the time of development, thus meaning they are planned. What isn't planned is the literal time when a dynamic rollback will have to take place, since it's impossible to know when critical errors will arise and the conditions for starting the rollback will be met.
To clarify, a rollback is data loss, but it's a very specific type of data loss. The term rollback carries the implications that the data loss was intentional due to circumstances, controlled in how data was lost, and controlled in the scope of data that was lost. Just saying "data loss" doesn't give enough detail as to what actually happened because it lacks these implications. So, the term rollback is used instead of data loss because it better explains exactly what happened.
Also, rollbacks are used for a heck of a lot more than failed updates. It's most commonly used for data corruption, of which failed updates is only one of many causes.
The root cause of the problem here is the disconnects.
It may be that the last valid save point is the actual time of the disconnect from the server; and the client software continues to function. I don't know enough about that.
A database write can be within a transaction that if fails can be auto rolled back
Androconium wrote: »Androconium wrote: »The current situation is not a planned Roll Back operation; it is simply data loss.
What's your point? Every rollback is data lost.
My point is that what you are seeing is not a planned rollback of data. By definition, rollback is a planned process. A decision is actively made to restore a previous software image to mitigate some problem with the current image.
As the disconnection results in data loss, the cause of the problem here is completely different.
Androconium wrote: »Androconium wrote: »The current situation is not a planned Roll Back operation; it is simply data loss.
What's your point? Every rollback is data lost.
My point is that what you are seeing is not a planned rollback of data. By definition, rollback is a planned process. A decision is actively made to restore a previous software image to mitigate some problem with the current image.
As the disconnection results in data loss, the cause of the problem here is completely different.
We don't know whether disconnection is the cause or result of data corruption, but either way, the rollback that follows is a planned countermeasure, an active decision to restore older consistent state.
Androconium wrote: »https://en.wikipedia.org/wiki/Rollback_(data_management)In database technologies, a rollback is an operation which returns the database to some previous state.
Yes. I've actually done it.
It's used to remove an upgrade that has failed.
An operation is planned. What is happening here is unplanned.
This symptoms so far suggest that nothing is being "rolled back", simply because it hasn't been captured in the first place.
This is why I asked the question...
The current situation is not a planned Roll Back operation; it is simply data loss.
Androconium wrote: »Androconium wrote: »Androconium wrote: »The current situation is not a planned Roll Back operation; it is simply data loss.
What's your point? Every rollback is data lost.
My point is that what you are seeing is not a planned rollback of data. By definition, rollback is a planned process. A decision is actively made to restore a previous software image to mitigate some problem with the current image.
As the disconnection results in data loss, the cause of the problem here is completely different.
We don't know whether disconnection is the cause or result of data corruption, but either way, the rollback that follows is a planned countermeasure, an active decision to restore older consistent state.
- The disconnections are happening because the server is overloaded (still); and we all complained about login queues, so they turned them off.
- Your rollback 'feature' is NOT an active decision.
It is not a planned countermeasure; it is a scripted process that runs as part of the character load process.
- Your connection fails at some point.
- Your client continues to function.
- The game stopped processing your activity from the time of the connection failure.
- Your client software finally times out and the game dies.
- When you restart the game; and login; and select ANY character: the game picks up from the last transactions that the server logged.
The problem is that the connection between your desktop client and the server database is cut, for whatever reason.
The data generated by your client software, after the disconnection, but before the client software fails, is LOST.
When you login again, you pick up where there server was at the time of the disconnection.
There is NO technical rollback of any software. For that to occur, as I said earlier, your currently loaded client software image would be overwritten with a previous version, that does not happen here.
Otherwise everyone would downloading new client images; or the server would be offline while the sysadmin were restoring the server image.
This issue is data loss caused by disconnection; it has nothing whatsoever to do with software rollback, active or passive.
For reference, go look up Norton Ghost and see the concepts of software imaging, as every operating system has some facility to enable this concept
Especially when you factor in that other people in the zone all move, see you move, etc. And generally a bunch of people all in the same zone get disconnected at the same time. That _and_ the fact I got rolled back to a different zone (my house actually) means for that same logic means in my disconnected state I changed zone, and was talking to people in that zone.That would seem to imply that the client continued to function despite being disconnected from the server for over 15 minutes, and that seems really far fetched.
I'm not fully convinced server load has a huge amount to do with it. NA never had queues enabled and I was 'rolled back' last night on NA, at around 6am EST (so, dead of the night).Androconium wrote: »
- The disconnections are happening because the server is overloaded (still); and we all complained about login queues, so they turned them off.
- Your rollback 'feature' is NOT an active decision.
A lot of what your client does requires server input. This includes all guild events, chat, inventory, most skills, ultimate, etc. If your server connection is cut, you will not be able to most or all of that stuff. Hence my feeling it's more a consistency issue between your specific server instance and it's database (or when replicating it's local database).The problem is that the connection between your desktop client and the server database is cut, for whatever reason.
The data generated by your client software, after the disconnection, but before the client software fails, is LOST.
Androconium wrote: »Androconium wrote: »Androconium wrote: »The current situation is not a planned Roll Back operation; it is simply data loss.
What's your point? Every rollback is data lost.
My point is that what you are seeing is not a planned rollback of data. By definition, rollback is a planned process. A decision is actively made to restore a previous software image to mitigate some problem with the current image.
As the disconnection results in data loss, the cause of the problem here is completely different.
We don't know whether disconnection is the cause or result of data corruption, but either way, the rollback that follows is a planned countermeasure, an active decision to restore older consistent state.
- The disconnections are happening because the server is overloaded (still); and we all complained about login queues, so they turned them off.
- Your rollback 'feature' is NOT an active decision.
It is not a planned countermeasure; it is a scripted process that runs as part of the character load process.
- Your connection fails at some point.
- Your client continues to function.
- The game stopped processing your activity from the time of the connection failure.
- Your client software finally times out and the game dies.
- When you restart the game; and login; and select ANY character: the game picks up from the last transactions that the server logged.
The problem is that the connection between your desktop client and the server database is cut, for whatever reason.
The data generated by your client software, after the disconnection, but before the client software fails, is LOST.
When you login again, you pick up where there server was at the time of the disconnection.
There is NO technical rollback of any software. For that to occur, as I said earlier, your currently loaded client software image would be overwritten with a previous version, that does not happen here.
Otherwise everyone would downloading new client images; or the server would be offline while the sysadmin were restoring the server image.
This issue is data loss caused by disconnection; it has nothing whatsoever to do with software rollback, active or passive.
For reference, go look up Norton Ghost and see the concepts of software imaging, as every operating system has some facility to enable this concept
That makes sense to me in most cases where the data lost is only of a minute or maybe two minutes of playtime, but what about those who have had "rollbacks" with over 15 minutes of lost playtime? That would seem to imply that the client continued to function despite being disconnected from the server for over 15 minutes, and that seems really far fetched.
Especially when you factor in that other people in the zone all move, see you move, etc. And generally a bunch of people all in the same zone get disconnected at the same time. That _and_ the fact I got rolled back to a different zone (my house actually) means for that same logic means in my disconnected state I changed zone, and was talking to people in that zone.That would seem to imply that the client continued to function despite being disconnected from the server for over 15 minutes, and that seems really far fetched.I'm not fully convinced server load has a huge amount to do with it. NA never had queues enabled and I was 'rolled back' last night on NA, at around 6am EST (so, dead of the night).Androconium wrote: »
- The disconnections are happening because the server is overloaded (still); and we all complained about login queues, so they turned them off.
- Your rollback 'feature' is NOT an active decision.
In reality it seems more like a protection mechanism, possibly within the megaserver architecture where changes from that "shard"/zone/instance don't get merged properly into the global state (I assume this happens periodically rather than continuously), thus that transaction is rolled back/discarded/whateveryouwanttocallit. This does make some assumptions on their server architecture, but from my general observations, the issues tend to be zone specific, and when the disconnections/rollbacks/dataloss happens, it's usually a whole bunch of people from that zone at once.
Edit: Expanding on thisA lot of what your client does requires server input. This includes all guild events, chat, inventory, most skills, ultimate, etc. If your server connection is cut, you will not be able to most or all of that stuff. Hence my feeling it's more a consistency issue between your specific server instance and it's database (or when replicating it's local database).The problem is that the connection between your desktop client and the server database is cut, for whatever reason.
The data generated by your client software, after the disconnection, but before the client software fails, is LOST.
Androconium wrote: »It is not a planned countermeasure; it is a scripted process that runs as part of the character load process.
- Your connection fails at some point.
- Your client continues to function.
- The game stopped processing your activity from the time of the connection failure.
- Your client software finally times out and the game dies.
- When you restart the game; and login; and select ANY character: the game picks up from the last transactions that the server logged.
The problem is that the connection between your desktop client and the server database is cut, for whatever reason.
The data generated by your client software, after the disconnection, but before the client software fails, is LOST.
When you login again, you pick up where there server was at the time of the disconnection.
Androconium wrote: »There is NO technical rollback of any software. For that to occur, as I said earlier, your currently loaded client software image would be overwritten with a previous version, that does not happen here.
Otherwise everyone would downloading new client images; or the server would be offline while the sysadmin were restoring the server image.
Especially when you factor in that other people in the zone all move, see you move, etc. And generally a bunch of people all in the same zone get disconnected at the same time. That _and_ the fact I got rolled back to a different zone (my house actually) means for that same logic means in my disconnected state I changed zone, and was talking to people in that zone.