I have a strategy game with 30-60 simultaneous players online at any moment.
The game will run perfectly for weeks, and then BigDB will suddenly completely fail to save for all players in a room. BigDB still loads properly and the game runs normally otherwise, but all saves fail. This will cripple rooms constantly for a period of several days to a week before the problem mysteriously goes away. Sometimes only some rooms will have this issue while others will work.
I close the impacted rooms and the game functions fine when players log back in.
This is pretty serious because you need to save in BigDB in order to use most of the game features. What conditions would cause a room to completely break BigDB's save command?
Any insight into this issue would be appreciated.