Game Freezes / Infinite loading screen glitch

"ObiDarthYoda;c-2385323" wrote:

"StarSon;c-2385291" wrote:

"ObiDarthYoda;c-2385283" wrote:

"PeachyPeachSWGOH;c-2385235" wrote:
I'm pretty sure nobody would want to rollback the database for this, if we understood the consequences of a database rollback.

Agreed though that the issue does have wider impact and cause more serious damage in TB and Conquest.

Rollback can be for just one 'transaction' - it's not for an entire database.
https://www.techopedia.com/definition/9229/rollback

JUST like banks, etc. do w/ATMs: if the connection is 'cut' in the middle of depositing or withdrawing money, then the transaction is not completed, and nothing is updated in the field(s).

And for EA/CG, who I assume are using mySQL, here ya' go:
The ROLLBACK operation undoes all the changes done by the current transaction i.e. If you invoke this statement, all the modifications are reverted until the last commit or the START TRANSACTION statement.
https://www.tutorialspoint.com/mysql/mysql_rollback.htm

I don't think you really understand what you're saying. You don't even know that it's a database issue, which is honestly unlikely, since it seems to be related to memory usage based on device settings. If it were a database issue it would be much more widespread.

Also, at this point you can't just rollback. It's weeks of play time for hundreds of thousands of players.

I DO know what I'm saying - and if you read my post, it is for ONE 'transaction' at a time - which means ONE battle, etc. Rollback just means the 'transaction' is not 'committed' since there was zero activity. It is NOT for everyone, for all time.

You didn't now how it works. What data storage used on your device, what sort of communications with remote database used(orm, web services, etc). You didn't know if its relation db at all(and I think it's not, better to process this dataflow with queues). Even when you start battle there is no guarantee that game server receive anything except flag - battle started(in raids even this didn't received and you could restart anytime you want).
And also, if speak on transaction level it should be opened when battle started and should continue during all battle. Where this transaction should be stored? On device? That will a pleasure for cheats.Create small temporary db for all players? It's expensive. And all this fantasies mean nothing without knowing real project structure.