[kbs666]

I've found that if a realm starts giving me consistent trouble deleting the local db and letting RW sync down the whole thing from the cloud has solved things several times.

You need to make sure that the cloud is up to date of course. and be prepared for how long this will take if you have a lot or big realms.