I have the same issue on my realm since 1.17.31
For Xbox one Bedrock edition
No that is not a fix. Issues not on the user's side is on the server side no matter how many times I The Host join which was only one time and now it doesn't accept anybody even after closing the realm and reopening it or uninstalling the application or game however you'd like to phrase it the realm does not work
Is there an update on this ticket, or any compensation for the realm owners as this issue persists?