I recently had a Unity Connection Publisher go down and my Subscriber go down as well. When they came back up a realized that they were not communicating with each other due to a bad DNS record. I changed cluster settings to find the subscriber using an IP address and they are now acting as intended, Publisher/Subscriber. However when trying to modify some user information(mainly resetting passwords) I recieve the error " A subquery has returned not exactly one row." Any ideas? I'm leaning towards this being a database issue. Is there a way to repair the database?
UPDATE: I cannot make any changes to said users. When I try to change anything on them I get thrown a "database.error.-284".