<!--IssueSummary start--> <details> <summary> Everyone can contribute. [Help move this issue forward](https://handbook.gitlab.com/handbook/marketing/developer-relations/contributor-success/community-contributors-workflows/#contributor-links) while earning points, leveling up and collecting rewards. </summary> - [Label this issue](https://contributors.gitlab.com/manage-issue?action=label&projectId=278964&issueIid=568186) </details> <!--IssueSummary end--> There are records in `user_group_member_roles` (custom role assignment through direct membership) that do not have a matching record (`member_role_id IS NOT NULL`) in `members` table These records make up around 0.5% of `user_group_member_roles` total number of rows. ### Query used in postgres.ai ```sql select ugmr.id, m.id from user_group_member_roles ugmr left join members m on m.user_id = ugmr.user_id and m.member_role_id = ugmr.member_role_id and m.source_id = ugmr.group_id and m.source_type = 'Namespace' where ugmr.shared_with_group_id IS NULL and m.id IS NULL ``` <details> <summary>Click to expand</summary> ```sh query = <<~SQL select ugmr.id as ugmr_id, m.id as member_id from user_group_member_roles ugmr left join members m on m.user_id = ugmr.user_id and m.member_role_id = ugmr.member_role_id and m.source_id = ugmr.group_id and m.source_type = 'Namespace' where ugmr.shared_with_group_id IS NULL and m.id IS NULL [ gprd ] production> SQL => "select\n ugmr.id as ugmr_id,\n m.id as member_id\nfrom user_group_member_roles ugmr\n left join members m\n on m.user_id = ugmr.user_id\n and m.member_role_id = ugmr.member_rol... [ gprd ] production> ApplicationRecord.connection.select_all(query).to_a [ gprd ] production> r => [{"ugmr_id"=>85467, "member_id"=>nil}, {"ugmr_id"=>19940, "member_id"=>nil}, {"ugmr_id"=>4539, "member_id"=>nil}, {"ugmr_id"=>16736, "member_id"=>nil}, {"ugmr_id"=>53326, "member_id"=>nil}, {"ugmr_id"=>19519, "member_id"=>nil}, {"ugmr_id"=>19520, "member_id"=>nil}, {"ugmr_id"=>19521, "member_id"=>nil}, {"ugmr_id"=>19522, "member_id"=>nil}, {"ugmr_id"=>53327, "member_id"=>nil}, {"ugmr_id"=>53330, "member_id"=>nil}, {"ugmr_id"=>85353, "member_id"=>nil}, {"ugmr_id"=>183530, "member_id"=>nil}, {"ugmr_id"=>183531, "member_id"=>nil}, {"ugmr_id"=>183532, "member_id"=>nil}, {"ugmr_id"=>10357, "member_id"=>nil}, {"ugmr_id"=>11072, "member_id"=>nil}, {"ugmr_id"=>27004, "member_id"=>nil}, {"ugmr_id"=>27331, "member_id"=>nil}, {"ugmr_id"=>2962, "member_id"=>nil}, {"ugmr_id"=>15834, "member_id"=>nil}, {"ugmr_id"=>4007, "member_id"=>nil}, {"ugmr_id"=>4008, "member_id"=>nil}, {"ugmr_id"=>5067, "member_id"=>nil}, {"ugmr_id"=>5068, "member_id"=>nil}, {"ugmr_id"=>83790, "member_id"=>nil}, {"ugmr_id"=>11401, "member_id"=>nil}, {"ugmr_id"=>11775, "member_id"=>nil}, {"ugmr_id"=>13545, "member_id"=>nil}, {"ugmr_id"=>15832, "member_id"=>nil}, {"ugmr_id"=>16892, "member_id"=>nil}, {"ugmr_id"=>16893, "member_id"=>nil}, {"ugmr_id"=>21506, "member_id"=>nil}, {"ugmr_id"=>85667, "member_id"=>nil}, {"ugmr_id"=>18338, "member_id"=>nil}, {"ugmr_id"=>135098, "member_id"=>nil}, {"ugmr_id"=>16298, "member_id"=>nil}, {"ugmr_id"=>16299, "member_id"=>nil}, {"ugmr_id"=>12433, "member_id"=>nil}, {"ugmr_id"=>135018, "member_id"=>nil}, {"ugmr_id"=>15546, "member_id"=>nil}, {"ugmr_id"=>135019, "member_id"=>nil}, {"ugmr_id"=>15706, "member_id"=>nil}, {"ugmr_id"=>2963, "member_id"=>nil}, {"ugmr_id"=>83789, "member_id"=>nil}, {"ugmr_id"=>18339, "member_id"=>nil}, {"ugmr_id"=>85666, "member_id"=>nil}, {"ugmr_id"=>3765, "member_id"=>nil}, {"ugmr_id"=>3766, "member_id"=>nil}, {"ugmr_id"=>146835, "member_id"=>nil}, {"ugmr_id"=>146836, "member_id"=>nil}, {"ugmr_id"=>146837, "member_id"=>nil}, {"ugmr_id"=>153969, "member_id"=>nil}, {"ugmr_id"=>153970, "member_id"=>nil}, {"ugmr_id"=>191848, "member_id"=>nil}, {"ugmr_id"=>4352, "member_id"=>nil}, {"ugmr_id"=>4357, "member_id"=>nil}, {"ugmr_id"=>4360, "member_id"=>nil}, {"ugmr_id"=>4361, "member_id"=>nil}, {"ugmr_id"=>4394, "member_id"=>nil}, {"ugmr_id"=>13106, "member_id"=>nil}, {"ugmr_id"=>4353, "member_id"=>nil}, {"ugmr_id"=>4354, "member_id"=>nil}, {"ugmr_id"=>4356, "member_id"=>nil}, {"ugmr_id"=>4358, "member_id"=>nil}, {"ugmr_id"=>4349, "member_id"=>nil}, {"ugmr_id"=>4350, "member_id"=>nil}, {"ugmr_id"=>4392, "member_id"=>nil}, {"ugmr_id"=>191830, "member_id"=>nil}, {"ugmr_id"=>4367, "member_id"=>nil}, {"ugmr_id"=>4368, "member_id"=>nil}, {"ugmr_id"=>4369, "member_id"=>nil}, {"ugmr_id"=>4370, "member_id"=>nil}, {"ugmr_id"=>4372, "member_id"=>nil}, {"ugmr_id"=>4382, "member_id"=>nil}, {"ugmr_id"=>4389, "member_id"=>nil}, {"ugmr_id"=>4390, "member_id"=>nil}, {"ugmr_id"=>4391, "member_id"=>nil}, {"ugmr_id"=>4393, "member_id"=>nil}, {"ugmr_id"=>4395, "member_id"=>nil}, {"ugmr_id"=>4396, "member_id"=>nil}, {"ugmr_id"=>191834, "member_id"=>nil}, {"ugmr_id"=>4404, "member_id"=>nil}, {"ugmr_id"=>4409, "member_id"=>nil}, {"ugmr_id"=>4411, "member_id"=>nil}, {"ugmr_id"=>4412, "member_id"=>nil}, {"ugmr_id"=>4416, "member_id"=>nil}, {"ugmr_id"=>191867, "member_id"=>nil}, {"ugmr_id"=>191889, "member_id"=>nil}, {"ugmr_id"=>4362, "member_id"=>nil}, {"ugmr_id"=>191847, "member_id"=>nil}, {"ugmr_id"=>191879, "member_id"=>nil}, {"ugmr_id"=>4366, "member_id"=>nil}, {"ugmr_id"=>4388, "member_id"=>nil}, {"ugmr_id"=>4386, "member_id"=>nil}, {"ugmr_id"=>61373, "member_id"=>nil}, {"ugmr_id"=>191878, "member_id"=>nil}, {"ugmr_id"=>4397, "member_id"=>nil}, {"ugmr_id"=>191890, "member_id"=>nil}, {"ugmr_id"=>157419, "member_id"=>nil}, {"ugmr_id"=>4383, "member_id"=>nil}, {"ugmr_id"=>4384, "member_id"=>nil}, {"ugmr_id"=>4387, "member_id"=>nil}, {"ugmr_id"=>4380, "member_id"=>nil}, {"ugmr_id"=>4364, "member_id"=>nil}, {"ugmr_id"=>4355, "member_id"=>nil}, {"ugmr_id"=>4400, "member_id"=>nil}, {"ugmr_id"=>165298, "member_id"=>nil}, {"ugmr_id"=>4401, "member_id"=>nil}, {"ugmr_id"=>64076, "member_id"=>nil}, {"ugmr_id"=>4381, "member_id"=>nil}, {"ugmr_id"=>4351, "member_id"=>nil}, {"ugmr_id"=>10510, "member_id"=>nil}, {"ugmr_id"=>10512, "member_id"=>nil}, {"ugmr_id"=>10513, "member_id"=>nil}, {"ugmr_id"=>10514, "member_id"=>nil}, {"ugmr_id"=>10515, "member_id"=>nil}, {"ugmr_id"=>10516, "member_id"=>nil}, {"ugmr_id"=>10518, "member_id"=>nil}, {"ugmr_id"=>10519, "member_id"=>nil}, {"ugmr_id"=>10521, "member_id"=>nil}, {"ugmr_id"=>10522, "member_id"=>nil}, {"ugmr_id"=>10540, "member_id"=>nil}, {"ugmr_id"=>10559, "member_id"=>nil}, {"ugmr_id"=>11361, "member_id"=>nil}, {"ugmr_id"=>12236, "member_id"=>nil}, {"ugmr_id"=>11499, "member_id"=>nil}, {"ugmr_id"=>12407, "member_id"=>nil}, {"ugmr_id"=>19070, "member_id"=>nil}, {"ugmr_id"=>23822, "member_id"=>nil}, {"ugmr_id"=>163200, "member_id"=>nil}, {"ugmr_id"=>10978, "member_id"=>nil}, {"ugmr_id"=>17644, "member_id"=>nil}, {"ugmr_id"=>53289, "member_id"=>nil}, {"ugmr_id"=>83382, "member_id"=>nil}, {"ugmr_id"=>190654, "member_id"=>nil}, {"ugmr_id"=>194489, "member_id"=>nil}, {"ugmr_id"=>194575, "member_id"=>nil}, {"ugmr_id"=>194606, "member_id"=>nil}, {"ugmr_id"=>194663, "member_id"=>nil}, {"ugmr_id"=>194509, "member_id"=>nil}, {"ugmr_id"=>194558, "member_id"=>nil}, {"ugmr_id"=>194592, "member_id"=>nil}, {"ugmr_id"=>194609, "member_id"=>nil}, {"ugmr_id"=>194624, "member_id"=>nil}, {"ugmr_id"=>194574, "member_id"=>nil}, {"ugmr_id"=>194584, "member_id"=>nil}, {"ugmr_id"=>194755, "member_id"=>nil}, {"ugmr_id"=>194798, "member_id"=>nil}, {"ugmr_id"=>194862, "member_id"=>nil}, {"ugmr_id"=>194474, "member_id"=>nil}, {"ugmr_id"=>194525, "member_id"=>nil}, {"ugmr_id"=>194668, "member_id"=>nil}, {"ugmr_id"=>194536, "member_id"=>nil}, {"ugmr_id"=>194546, "member_id"=>nil}, {"ugmr_id"=>194572, "member_id"=>nil}, {"ugmr_id"=>194604, "member_id"=>nil}, {"ugmr_id"=>194644, "member_id"=>nil}, {"ugmr_id"=>194768, "member_id"=>nil}, {"ugmr_id"=>194841, "member_id"=>nil}, {"ugmr_id"=>194491, "member_id"=>nil}, {"ugmr_id"=>194680, "member_id"=>nil}, {"ugmr_id"=>194738, "member_id"=>nil}, {"ugmr_id"=>194806, "member_id"=>nil}, {"ugmr_id"=>194463, "member_id"=>nil}, {"ugmr_id"=>194480, "member_id"=>nil}, {"ugmr_id"=>194519, "member_id"=>nil}, {"ugmr_id"=>194527, "member_id"=>nil}, {"ugmr_id"=>194556, "member_id"=>nil}, {"ugmr_id"=>194647, "member_id"=>nil}, {"ugmr_id"=>194787, "member_id"=>nil}, {"ugmr_id"=>194838, "member_id"=>nil}, {"ugmr_id"=>194875, "member_id"=>nil}, {"ugmr_id"=>194517, "member_id"=>nil}, {"ugmr_id"=>194550, "member_id"=>nil}, {"ugmr_id"=>194494, "member_id"=>nil}, {"ugmr_id"=>194551, "member_id"=>nil}, {"ugmr_id"=>194600, "member_id"=>nil}, {"ugmr_id"=>194449, "member_id"=>nil}, {"ugmr_id"=>194462, "member_id"=>nil}, {"ugmr_id"=>194641, "member_id"=>nil}, {"ugmr_id"=>194878, "member_id"=>nil}, {"ugmr_id"=>194450, "member_id"=>nil}, {"ugmr_id"=>194697, "member_id"=>nil}, {"ugmr_id"=>194744, "member_id"=>nil}, {"ugmr_id"=>194751, "member_id"=>nil}, {"ugmr_id"=>194786, "member_id"=>nil}, {"ugmr_id"=>194844, "member_id"=>nil}, {"ugmr_id"=>194868, "member_id"=>nil}, {"ugmr_id"=>194877, "member_id"=>nil}, {"ugmr_id"=>194499, "member_id"=>nil}, {"ugmr_id"=>194506, "member_id"=>nil}, {"ugmr_id"=>194561, "member_id"=>nil}, {"ugmr_id"=>194617, "member_id"=>nil}, {"ugmr_id"=>194731, "member_id"=>nil}, {"ugmr_id"=>194819, "member_id"=>nil}, {"ugmr_id"=>194453, "member_id"=>nil}, {"ugmr_id"=>194573, "member_id"=>nil}, {"ugmr_id"=>194675, "member_id"=>nil}, {"ugmr_id"=>194709, "member_id"=>nil}, {"ugmr_id"=>194721, "member_id"=>nil}, {"ugmr_id"=>194456, "member_id"=>nil}, {"ugmr_id"=>194457, "member_id"=>nil}, {"ugmr_id"=>194473, "member_id"=>nil}, {"ugmr_id"=>194458, "member_id"=>nil}, {"ugmr_id"=>194585, "member_id"=>nil}, {"ugmr_id"=>194569, "member_id"=>nil}, {"ugmr_id"=>194460, "member_id"=>nil}, {"ugmr_id"=>194495, "member_id"=>nil}, {"ugmr_id"=>194507, "member_id"=>nil}, {"ugmr_id"=>194688, "member_id"=>nil}, {"ugmr_id"=>194746, "member_id"=>nil}, {"ugmr_id"=>194466, "member_id"=>nil}, {"ugmr_id"=>194504, "member_id"=>nil}, {"ugmr_id"=>194513, "member_id"=>nil}, {"ugmr_id"=>194514, "member_id"=>nil}, {"ugmr_id"=>194565, "member_id"=>nil}, {"ugmr_id"=>194652, "member_id"=>nil}, {"ugmr_id"=>194659, "member_id"=>nil}, {"ugmr_id"=>194764, "member_id"=>nil}, {"ugmr_id"=>194881, "member_id"=>nil}, {"ugmr_id"=>194650, "member_id"=>nil}, {"ugmr_id"=>26217, "member_id"=>nil}, {"ugmr_id"=>194863, "member_id"=>nil}, {"ugmr_id"=>194485, "member_id"=>nil}, {"ugmr_id"=>194469, "member_id"=>nil}, {"ugmr_id"=>194625, "member_id"=>nil}, {"ugmr_id"=>194470, "member_id"=>nil}, {"ugmr_id"=>194686, "member_id"=>nil}, {"ugmr_id"=>194471, "member_id"=>nil}, {"ugmr_id"=>194720, "member_id"=>nil}, {"ugmr_id"=>194754, "member_id"=>nil}, {"ugmr_id"=>194475, "member_id"=>nil}, {"ugmr_id"=>194476, "member_id"=>nil}, {"ugmr_id"=>194667, "member_id"=>nil}, {"ugmr_id"=>194478, "member_id"=>nil}, {"ugmr_id"=>194583, "member_id"=>nil}, {"ugmr_id"=>194631, "member_id"=>nil}, {"ugmr_id"=>60311, "member_id"=>nil}, {"ugmr_id"=>194479, "member_id"=>nil}, {"ugmr_id"=>194500, "member_id"=>nil}, {"ugmr_id"=>194872, "member_id"=>nil}, {"ugmr_id"=>194481, "member_id"=>nil}, {"ugmr_id"=>194488, "member_id"=>nil}, {"ugmr_id"=>194482, "member_id"=>nil}, {"ugmr_id"=>194483, "member_id"=>nil}, {"ugmr_id"=>194670, "member_id"=>nil}, {"ugmr_id"=>194487, "member_id"=>nil}, {"ugmr_id"=>194490, "member_id"=>nil}, {"ugmr_id"=>194526, "member_id"=>nil}, {"ugmr_id"=>194567, "member_id"=>nil}, {"ugmr_id"=>194714, "member_id"=>nil}, {"ugmr_id"=>194732, "member_id"=>nil}, {"ugmr_id"=>194492, "member_id"=>nil}, {"ugmr_id"=>194528, "member_id"=>nil}, {"ugmr_id"=>194549, "member_id"=>nil}, {"ugmr_id"=>194581, "member_id"=>nil}, {"ugmr_id"=>194582, "member_id"=>nil}, {"ugmr_id"=>194891, "member_id"=>nil}, {"ugmr_id"=>194493, "member_id"=>nil}, {"ugmr_id"=>194502, "member_id"=>nil}, {"ugmr_id"=>194689, "member_id"=>nil}, {"ugmr_id"=>194710, "member_id"=>nil}, {"ugmr_id"=>194718, "member_id"=>nil}, {"ugmr_id"=>194497, "member_id"=>nil}, {"ugmr_id"=>194501, "member_id"=>nil}, {"ugmr_id"=>194548, "member_id"=>nil}, {"ugmr_id"=>194608, "member_id"=>nil}, {"ugmr_id"=>194642, "member_id"=>nil}, {"ugmr_id"=>194707, "member_id"=>nil}, {"ugmr_id"=>194777, "member_id"=>nil}, {"ugmr_id"=>194503, "member_id"=>nil}, {"ugmr_id"=>194542, "member_id"=>nil}, {"ugmr_id"=>194510, "member_id"=>nil}, {"ugmr_id"=>194511, "member_id"=>nil}, {"ugmr_id"=>194515, "member_id"=>nil}, {"ugmr_id"=>194518, "member_id"=>nil}, {"ugmr_id"=>194529, "member_id"=>nil}, {"ugmr_id"=>194540, "member_id"=>nil}, {"ugmr_id"=>194620, "member_id"=>nil}, {"ugmr_id"=>194702, "member_id"=>nil}, {"ugmr_id"=>194712, "member_id"=>nil}, {"ugmr_id"=>194762, "member_id"=>nil}, {"ugmr_id"=>194880, "member_id"=>nil}, {"ugmr_id"=>194535, "member_id"=>nil}, {"ugmr_id"=>194576, "member_id"=>nil}, {"ugmr_id"=>194588, "member_id"=>nil}, {"ugmr_id"=>194757, "member_id"=>nil}, {"ugmr_id"=>194825, "member_id"=>nil}, {"ugmr_id"=>194520, "member_id"=>nil}, {"ugmr_id"=>194544, "member_id"=>nil}, {"ugmr_id"=>194621, "member_id"=>nil}, {"ugmr_id"=>194521, "member_id"=>nil}, {"ugmr_id"=>194810, "member_id"=>nil}, {"ugmr_id"=>194522, "member_id"=>nil}, {"ugmr_id"=>194607, "member_id"=>nil}, {"ugmr_id"=>194730, "member_id"=>nil}, {"ugmr_id"=>194761, "member_id"=>nil}, {"ugmr_id"=>194807, "member_id"=>nil}, {"ugmr_id"=>194821, "member_id"=>nil}, {"ugmr_id"=>194843, "member_id"=>nil}, {"ugmr_id"=>194523, "member_id"=>nil}, {"ugmr_id"=>194690, "member_id"=>nil}, {"ugmr_id"=>194524, "member_id"=>nil}, {"ugmr_id"=>194537, "member_id"=>nil}, {"ugmr_id"=>194560, "member_id"=>nil}, {"ugmr_id"=>194530, "member_id"=>nil}, {"ugmr_id"=>194532, "member_id"=>nil}, {"ugmr_id"=>194533, "member_id"=>nil}, {"ugmr_id"=>194595, "member_id"=>nil}, {"ugmr_id"=>194623, "member_id"=>nil}, {"ugmr_id"=>194637, "member_id"=>nil}, {"ugmr_id"=>194534, "member_id"=>nil}, {"ugmr_id"=>194589, "member_id"=>nil}, {"ugmr_id"=>194646, "member_id"=>nil}, {"ugmr_id"=>194695, "member_id"=>nil}, {"ugmr_id"=>194767, "member_id"=>nil}, {"ugmr_id"=>194780, "member_id"=>nil}, {"ugmr_id"=>194538, "member_id"=>nil}, {"ugmr_id"=>194674, "member_id"=>nil}, {"ugmr_id"=>194704, "member_id"=>nil}, {"ugmr_id"=>194775, "member_id"=>nil}, {"ugmr_id"=>194547, "member_id"=>nil}, {"ugmr_id"=>194571, "member_id"=>nil}, {"ugmr_id"=>194599, "member_id"=>nil}, {"ugmr_id"=>194728, "member_id"=>nil}, {"ugmr_id"=>194553, "member_id"=>nil}, {"ugmr_id"=>194632, "member_id"=>nil}, {"ugmr_id"=>194655, "member_id"=>nil}, {"ugmr_id"=>194577, "member_id"=>nil}, {"ugmr_id"=>194737, "member_id"=>nil}, {"ugmr_id"=>194739, "member_id"=>nil}, {"ugmr_id"=>194555, "member_id"=>nil}, {"ugmr_id"=>194715, "member_id"=>nil}, {"ugmr_id"=>194729, "member_id"=>nil}, {"ugmr_id"=>194842, "member_id"=>nil}, {"ugmr_id"=>194557, "member_id"=>nil}, {"ugmr_id"=>194559, "member_id"=>nil}, {"ugmr_id"=>194562, "member_id"=>nil}, {"ugmr_id"=>194564, "member_id"=>nil}, {"ugmr_id"=>194658, "member_id"=>nil}, {"ugmr_id"=>194676, "member_id"=>nil}, {"ugmr_id"=>194677, "member_id"=>nil}, {"ugmr_id"=>194568, "member_id"=>nil}, {"ugmr_id"=>194579, "member_id"=>nil}, {"ugmr_id"=>194580, "member_id"=>nil}, {"ugmr_id"=>194587, "member_id"=>nil}, {"ugmr_id"=>194596, "member_id"=>nil}, {"ugmr_id"=>194713, "member_id"=>nil}, {"ugmr_id"=>194593, "member_id"=>nil}, {"ugmr_id"=>194612, "member_id"=>nil}, {"ugmr_id"=>194635, "member_id"=>nil}, {"ugmr_id"=>194817, "member_id"=>nil}, {"ugmr_id"=>194594, "member_id"=>nil}, {"ugmr_id"=>194597, "member_id"=>nil}, {"ugmr_id"=>194611, "member_id"=>nil}, {"ugmr_id"=>194782, "member_id"=>nil}, {"ugmr_id"=>194790, "member_id"=>nil}, {"ugmr_id"=>194598, "member_id"=>nil}, {"ugmr_id"=>194601, "member_id"=>nil}, {"ugmr_id"=>194760, "member_id"=>nil}, {"ugmr_id"=>194602, "member_id"=>nil}, {"ugmr_id"=>194639, "member_id"=>nil}, {"ugmr_id"=>194640, "member_id"=>nil}, {"ugmr_id"=>194605, "member_id"=>nil}, {"ugmr_id"=>194643, "member_id"=>nil}, {"ugmr_id"=>194666, "member_id"=>nil}, {"ugmr_id"=>194613, "member_id"=>nil}, {"ugmr_id"=>194846, "member_id"=>nil}, {"ugmr_id"=>194614, "member_id"=>nil}, {"ugmr_id"=>194615, "member_id"=>nil}, {"ugmr_id"=>194629, "member_id"=>nil}, {"ugmr_id"=>194656, "member_id"=>nil}, {"ugmr_id"=>194664, "member_id"=>nil}, {"ugmr_id"=>194616, "member_id"=>nil}, {"ugmr_id"=>194618, "member_id"=>nil}, {"ugmr_id"=>194797, "member_id"=>nil}, {"ugmr_id"=>194622, "member_id"=>nil}, {"ugmr_id"=>194628, "member_id"=>nil}, {"ugmr_id"=>194630, "member_id"=>nil}, {"ugmr_id"=>194633, "member_id"=>nil}, {"ugmr_id"=>194679, "member_id"=>nil}, {"ugmr_id"=>194784, "member_id"=>nil}, {"ugmr_id"=>194645, "member_id"=>nil}, {"ugmr_id"=>194678, "member_id"=>nil}, {"ugmr_id"=>194723, "member_id"=>nil}, {"ugmr_id"=>194727, "member_id"=>nil}, {"ugmr_id"=>194649, "member_id"=>nil}, {"ugmr_id"=>194657, "member_id"=>nil}, {"ugmr_id"=>194653, "member_id"=>nil}, {"ugmr_id"=>194660, "member_id"=>nil}, {"ugmr_id"=>194661, "member_id"=>nil}, {"ugmr_id"=>194694, "member_id"=>nil}, {"ugmr_id"=>194741, "member_id"=>nil}, {"ugmr_id"=>194771, "member_id"=>nil}, {"ugmr_id"=>194654, "member_id"=>nil}, {"ugmr_id"=>194662, "member_id"=>nil}, {"ugmr_id"=>194763, "member_id"=>nil}, {"ugmr_id"=>194836, "member_id"=>nil}, {"ugmr_id"=>194665, "member_id"=>nil}, {"ugmr_id"=>194691, "member_id"=>nil}, {"ugmr_id"=>194669, "member_id"=>nil}, {"ugmr_id"=>194692, "member_id"=>nil}, {"ugmr_id"=>194671, "member_id"=>nil}, {"ugmr_id"=>194701, "member_id"=>nil}, {"ugmr_id"=>194672, "member_id"=>nil}, {"ugmr_id"=>194673, "member_id"=>nil}, {"ugmr_id"=>194700, "member_id"=>nil}, {"ugmr_id"=>194681, "member_id"=>nil}, {"ugmr_id"=>194770, "member_id"=>nil}, {"ugmr_id"=>194818, "member_id"=>nil}, {"ugmr_id"=>194830, "member_id"=>nil}, {"ugmr_id"=>194682, "member_id"=>nil}, {"ugmr_id"=>194856, "member_id"=>nil}, {"ugmr_id"=>194867, "member_id"=>nil}, {"ugmr_id"=>194683, "member_id"=>nil}, {"ugmr_id"=>194684, "member_id"=>nil}, {"ugmr_id"=>194687, "member_id"=>nil}, {"ugmr_id"=>194735, "member_id"=>nil}, {"ugmr_id"=>194783, "member_id"=>nil}, {"ugmr_id"=>194696, "member_id"=>nil}, {"ugmr_id"=>194698, "member_id"=>nil}, {"ugmr_id"=>194705, "member_id"=>nil}, {"ugmr_id"=>194717, "member_id"=>nil}, {"ugmr_id"=>194837, "member_id"=>nil}, {"ugmr_id"=>194719, "member_id"=>nil}, {"ugmr_id"=>194804, "member_id"=>nil}, {"ugmr_id"=>194722, "member_id"=>nil}, {"ugmr_id"=>194724, "member_id"=>nil}, {"ugmr_id"=>194742, "member_id"=>nil}, {"ugmr_id"=>194800, "member_id"=>nil}, {"ugmr_id"=>194725, "member_id"=>nil}, {"ugmr_id"=>194774, "member_id"=>nil}, {"ugmr_id"=>194788, "member_id"=>nil}, {"ugmr_id"=>194736, "member_id"=>nil}, {"ugmr_id"=>194808, "member_id"=>nil}, {"ugmr_id"=>194831, "member_id"=>nil}, {"ugmr_id"=>194740, "member_id"=>nil}, {"ugmr_id"=>194743, "member_id"=>nil}, {"ugmr_id"=>194859, "member_id"=>nil}, {"ugmr_id"=>194884, "member_id"=>nil}, {"ugmr_id"=>194750, "member_id"=>nil}, {"ugmr_id"=>194749, "member_id"=>nil}, {"ugmr_id"=>194778, "member_id"=>nil}, {"ugmr_id"=>194870, "member_id"=>nil}, {"ugmr_id"=>194752, "member_id"=>nil}, {"ugmr_id"=>194753, "member_id"=>nil}, {"ugmr_id"=>194758, "member_id"=>nil}, {"ugmr_id"=>194860, "member_id"=>nil}, {"ugmr_id"=>194795, "member_id"=>nil}, {"ugmr_id"=>194802, "member_id"=>nil}, {"ugmr_id"=>194851, "member_id"=>nil}, {"ugmr_id"=>194814, "member_id"=>nil}, {"ugmr_id"=>194816, "member_id"=>nil}, {"ugmr_id"=>194820, "member_id"=>nil}, {"ugmr_id"=>194823, "member_id"=>nil}, {"ugmr_id"=>194882, "member_id"=>nil}, {"ugmr_id"=>194824, "member_id"=>nil}, {"ugmr_id"=>194839, "member_id"=>nil}, {"ugmr_id"=>194847, "member_id"=>nil}, {"ugmr_id"=>194845, "member_id"=>nil}, {"ugmr_id"=>194892, "member_id"=>nil}, {"ugmr_id"=>194861, "member_id"=>nil}, {"ugmr_id"=>194869, "member_id"=>nil}, {"ugmr_id"=>194879, "member_id"=>nil}, {"ugmr_id"=>194888, "member_id"=>nil}, {"ugmr_id"=>194940, "member_id"=>nil}, {"ugmr_id"=>194894, "member_id"=>nil}, {"ugmr_id"=>194948, "member_id"=>nil}, {"ugmr_id"=>194895, "member_id"=>nil}, {"ugmr_id"=>194922, "member_id"=>nil}, {"ugmr_id"=>194898, "member_id"=>nil}, {"ugmr_id"=>194899, "member_id"=>nil}, {"ugmr_id"=>194900, "member_id"=>nil}, {"ugmr_id"=>194905, "member_id"=>nil}, {"ugmr_id"=>194953, "member_id"=>nil}, {"ugmr_id"=>194906, "member_id"=>nil}, {"ugmr_id"=>194908, "member_id"=>nil}, {"ugmr_id"=>194911, "member_id"=>nil}, {"ugmr_id"=>194914, "member_id"=>nil}, {"ugmr_id"=>194910, "member_id"=>nil}, {"ugmr_id"=>194913, "member_id"=>nil}, {"ugmr_id"=>194915, "member_id"=>nil}, {"ugmr_id"=>194916, "member_id"=>nil}, {"ugmr_id"=>194964, "member_id"=>nil}, {"ugmr_id"=>194921, "member_id"=>nil}, {"ugmr_id"=>194925, "member_id"=>nil}, {"ugmr_id"=>194927, "member_id"=>nil}, {"ugmr_id"=>194933, "member_id"=>nil}, {"ugmr_id"=>194949, "member_id"=>nil}, {"ugmr_id"=>194965, "member_id"=>nil}, {"ugmr_id"=>194938, "member_id"=>nil}, {"ugmr_id"=>194943, "member_id"=>nil}, {"ugmr_id"=>194946, "member_id"=>nil}, {"ugmr_id"=>194970, "member_id"=>nil}, {"ugmr_id"=>194950, "member_id"=>nil}, {"ugmr_id"=>194951, "member_id"=>nil}, {"ugmr_id"=>194956, "member_id"=>nil}, {"ugmr_id"=>194966, "member_id"=>nil}, {"ugmr_id"=>194967, "member_id"=>nil}, {"ugmr_id"=>194963, "member_id"=>nil}, {"ugmr_id"=>194971, "member_id"=>nil}, {"ugmr_id"=>194972, "member_id"=>nil}, {"ugmr_id"=>4236, "member_id"=>nil}, {"ugmr_id"=>16758, "member_id"=>nil}, {"ugmr_id"=>18649, "member_id"=>nil}, {"ugmr_id"=>16414, "member_id"=>nil}, {"ugmr_id"=>19031, "member_id"=>nil}, {"ugmr_id"=>20497, "member_id"=>nil}, {"ugmr_id"=>104102, "member_id"=>nil}, {"ugmr_id"=>50713, "member_id"=>nil}, {"ugmr_id"=>50714, "member_id"=>nil}, {"ugmr_id"=>4229, "member_id"=>nil}, {"ugmr_id"=>184439, "member_id"=>nil}, {"ugmr_id"=>26866, "member_id"=>nil}, {"ugmr_id"=>21915, "member_id"=>nil}, {"ugmr_id"=>163013, "member_id"=>nil}, {"ugmr_id"=>198969, "member_id"=>nil}, {"ugmr_id"=>197565, "member_id"=>nil}, {"ugmr_id"=>197566, "member_id"=>nil}, {"ugmr_id"=>197567, "member_id"=>nil}, {"ugmr_id"=>62687, "member_id"=>nil}, {"ugmr_id"=>191605, "member_id"=>nil}, {"ugmr_id"=>82389, "member_id"=>nil}, {"ugmr_id"=>27589, "member_id"=>nil}, {"ugmr_id"=>83079, "member_id"=>nil}, {"ugmr_id"=>83076, "member_id"=>nil}, {"ugmr_id"=>83077, "member_id"=>nil}, {"ugmr_id"=>83078, "member_id"=>nil}, {"ugmr_id"=>83080, "member_id"=>nil}, {"ugmr_id"=>83081, "member_id"=>nil}, {"ugmr_id"=>83083, "member_id"=>nil}, {"ugmr_id"=>83082, "member_id"=>nil}, {"ugmr_id"=>61573, "member_id"=>nil}, {"ugmr_id"=>61571, "member_id"=>nil}, {"ugmr_id"=>157324, "member_id"=>nil}, {"ugmr_id"=>177244, "member_id"=>nil}, {"ugmr_id"=>3189, "member_id"=>nil}, {"ugmr_id"=>87353, "member_id"=>nil}, {"ugmr_id"=>10958, "member_id"=>nil}, {"ugmr_id"=>184262, "member_id"=>nil}, {"ugmr_id"=>171389, "member_id"=>nil}, {"ugmr_id"=>171390, "member_id"=>nil}, {"ugmr_id"=>191414, "member_id"=>nil}, {"ugmr_id"=>191415, "member_id"=>nil}, {"ugmr_id"=>6989, "member_id"=>nil}, {"ugmr_id"=>4514, "member_id"=>nil}, {"ugmr_id"=>4515, "member_id"=>nil}, {"ugmr_id"=>4516, "member_id"=>nil}, {"ugmr_id"=>4517, "member_id"=>nil}, {"ugmr_id"=>195022, "member_id"=>nil}, {"ugmr_id"=>197464, "member_id"=>nil}] ``` </details> ### Causes Currently, when SAML groups are synced, the users' `user_group_member_roles` records are only correctly updated when they're not yet a member of the group ([1](https://gitlab.com/gitlab-org/gitlab/-/blob/master/ee/app/services/groups/sync_service.rb#L83), [2](https://gitlab.com/gitlab-org/gitlab/-/blob/master/ee/app/services/ee/members/groups/creator_service.rb#L12)). However, when existing memberships are updated during sync, the `user_group_member_roles` records are not updated.