The GameSparks platform is continually monitored both automatically, and manually by the platform team.
When a query is identified, which is regularly run and would benefit from an index which is not present, that index is added to improve the performance of your application.
Really appreciated that. So we don't need a mongodb expert.
However, there is an index with 2 array fields created by your team.
And it hit the limitation descried here https://docs.mongodb.com/manual/core/index-multikey/#compound-multikey-indexes
So we couldn't insert or modify any doc containing those 2 arrays.
After dropping the index, everything's back to normal.
I think it might be a potential issue, especially in LIVE environment.
Any how to avoid this happen again?
I've passed this issue to our Operations team to investigate.
As title, is there any automatically index building mechanism?