Group Service settings not applying, sort of...
-
Server
- Version: 46/5956 (RC11 branch)
- OS: Cent OS 7
Client
- Version: 0.11.5
- OS: Win 10 LTSB
Description
When I go to a group and go to adjust the service settings to enable all the features for example I see a few default options set as shown here.
I click the select all button and hit update and get a confirmation that it updated and it goes back to the default selections.
I then go check some of the hosts in that group and find that only those original 4 default options are selected on every host’s service settings. If I manually update the service settings on the host level it updates successfully.
-
Found the issue and it appears to be related to some rc11 changes to how inserts happen. There was a minor mistake on my part in that I wasn’t cleaning up a variable that desperately needed it, but this issue would have still happened just to how the query is passed. To prevent the issues specifically to module updates from groups, for now, I’ve made the insert occur in 500 item chunks, though I will likely do this for the method as a whole as mass inserting can be problematic if you just dump a ton of data anyway. The largest of these happens to be service settings and probably the only thing to notice these issues any way.
-
After further testing realized this only happens on larger groups. It worked on groups of 8 and 18 members, but it does happen on a group with 160 members.
-
@Senior-Developers Updated and tried it again. Still broken.
-
@JJ-Fullmer please check the groupMembers table. I have. Suspicion of 0 host ids somewhere
-
Or group ids
-
@Tom-Elliott 0 host id’s?
So like go into command line and search for host id’s with 0 in the id? -
@JJ-Fullmer On the groupMembers table yes
-
MariaDB [fog]> select * from groupMembers; +------+----------+-----------+ | gmID | gmHostID | gmGroupID | +------+----------+-----------+ | 1 | 17 | 10 | | 100 | 1493 | 3 | | 72 | 128 | 15 | | 4 | 153 | 13 | | 5 | 154 | 13 | | 6 | 42 | 5 | | 7 | 93 | 4 | | 8 | 9 | 4 | | 9 | 126 | 15 | | 10 | 155 | 13 | | 11 | 129 | 15 | | 12 | 156 | 11 | | 13 | 157 | 11 | | 79 | 448 | 16 | | 78 | 69 | 16 | | 16 | 151 | 11 | | 17 | 152 | 11 | | 18 | 158 | 11 | | 19 | 150 | 11 | | 20 | 280 | 11 | | 21 | 302 | 11 | | 22 | 317 | 3 | | 77 | 395 | 16 | | 76 | 197 | 16 | | 75 | 1458 | 16 | | 26 | 145 | 7 | | 27 | 107 | 7 | | 28 | 1062 | 3 | | 29 | 1062 | 7 | | 30 | 1456 | 3 | | 31 | 34 | 3 | | 32 | 34 | 7 | | 33 | 1457 | 3 | | 34 | 1457 | 12 | | 35 | 135 | 3 | | 36 | 135 | 1 | | 37 | 1458 | 3 | | 74 | 358 | 16 | | 73 | 143 | 16 | | 40 | 89 | 3 | | 41 | 89 | 6 | | 42 | 1459 | 2 | | 43 | 1459 | 3 | | 44 | 106 | 3 | | 45 | 106 | 15 | | 49 | 1463 | 3 | | 47 | 1461 | 3 | | 50 | 1464 | 3 | | 51 | 1465 | 3 | | 52 | 48 | 3 | | 53 | 48 | 5 | | 54 | 139 | 3 | | 55 | 139 | 5 | | 56 | 98 | 3 | | 57 | 98 | 15 | | 59 | 10 | 15 | | 60 | 29 | 10 | | 61 | 21 | 10 | | 62 | 113 | 10 | | 63 | 31 | 10 | | 64 | 94 | 10 | | 99 | 1492 | 10 | | 66 | 112 | 10 | | 107 | 82 | 3 | | 68 | 28 | 10 | | 69 | 15 | 3 | | 70 | 1470 | 11 | | 81 | 1475 | 11 | | 80 | 1473 | 11 | | 82 | 1476 | 11 | | 83 | 1477 | 11 | | 84 | 1478 | 11 | | 85 | 1479 | 11 | | 86 | 1480 | 11 | | 87 | 1481 | 11 | | 88 | 1482 | 16 | | 89 | 1474 | 11 | | 94 | 1488 | 3 | | 95 | 1488 | 10 | | 96 | 7 | 13 | | 97 | 7 | 3 | | 98 | 140 | 8 | | 101 | 1493 | 10 | | 102 | 1494 | 3 | | 103 | 1494 | 10 | | 104 | 97 | 3 | | 105 | 97 | 7 | | 108 | 82 | 5 | | 109 | 83 | 3 | | 110 | 14 | 3 | | 111 | 26 | 3 | | 112 | 138 | 3 | | 113 | 78 | 3 | | 114 | 77 | 3 | | 115 | 32 | 3 | | 116 | 1485 | 3 | | 117 | 147 | 3 | | 118 | 1467 | 3 | | 119 | 1466 | 3 | | 120 | 1490 | 3 | | 121 | 1495 | 3 | | 122 | 10 | 3 | | 123 | 1469 | 3 | | 124 | 109 | 3 | | 125 | 36 | 3 | | 126 | 101 | 3 | | 127 | 11 | 3 | | 128 | 144 | 3 | | 129 | 110 | 3 | | 130 | 33 | 3 | | 131 | 1468 | 3 | | 132 | 6 | 3 | | 133 | 155 | 3 | | 134 | 154 | 3 | | 135 | 153 | 3 | | 136 | 57 | 3 | | 137 | 44 | 3 | | 138 | 107 | 3 | | 139 | 143 | 3 | | 140 | 151 | 3 | | 141 | 156 | 3 | | 142 | 152 | 3 | | 143 | 158 | 3 | | 144 | 157 | 3 | | 145 | 150 | 3 | | 146 | 1470 | 3 | | 147 | 85 | 3 | | 148 | 76 | 3 | | 149 | 72 | 3 | | 150 | 130 | 3 | | 151 | 137 | 3 | | 152 | 16 | 3 | | 153 | 86 | 3 | | 154 | 91 | 3 | | 155 | 42 | 3 | | 156 | 358 | 3 | | 157 | 141 | 3 | | 158 | 100 | 3 | | 159 | 302 | 3 | | 160 | 1477 | 3 | | 161 | 1478 | 3 | | 162 | 1479 | 3 | | 163 | 65 | 3 | | 164 | 93 | 3 | | 165 | 9 | 3 | | 166 | 20 | 3 | | 167 | 19 | 3 | | 168 | 92 | 3 | | 169 | 108 | 3 | | 170 | 142 | 3 | | 171 | 124 | 3 | | 172 | 127 | 3 | | 173 | 50 | 3 | | 174 | 1489 | 3 | | 175 | 24 | 3 | | 176 | 125 | 3 | | 177 | 102 | 3 | | 178 | 118 | 3 | | 179 | 41 | 3 | | 180 | 132 | 3 | | 181 | 103 | 3 | | 182 | 22 | 3 | | 183 | 35 | 3 | | 184 | 80 | 3 | | 185 | 84 | 3 | | 186 | 136 | 3 | | 187 | 27 | 3 | | 188 | 18 | 3 | | 189 | 280 | 3 | | 190 | 66 | 3 | | 191 | 95 | 3 | | 192 | 1472 | 3 | | 193 | 133 | 3 | | 194 | 51 | 3 | | 195 | 96 | 3 | | 196 | 47 | 3 | | 197 | 197 | 3 | | 198 | 1481 | 3 | | 199 | 1480 | 3 | | 200 | 120 | 3 | | 201 | 111 | 3 | | 202 | 395 | 3 | | 203 | 105 | 3 | | 204 | 1482 | 3 | | 205 | 140 | 3 | | 206 | 131 | 3 | | 207 | 25 | 3 | | 208 | 17 | 3 | | 209 | 69 | 3 | | 210 | 145 | 3 | | 211 | 1474 | 3 | | 212 | 1473 | 3 | | 213 | 1476 | 3 | | 214 | 1475 | 3 | | 215 | 104 | 3 | | 216 | 448 | 3 | | 217 | 134 | 3 | | 218 | 43 | 3 | | 219 | 121 | 3 | | 220 | 13 | 3 | | 221 | 1492 | 3 | | 222 | 112 | 3 | | 223 | 21 | 3 | | 224 | 28 | 3 | | 225 | 1491 | 3 | | 226 | 31 | 3 | | 227 | 128 | 3 | | 228 | 94 | 3 | | 229 | 113 | 3 | | 230 | 29 | 3 | | 231 | 119 | 3 | | 232 | 12 | 3 | | 233 | 122 | 3 | | 234 | 116 | 3 | | 235 | 37 | 3 | | 236 | 129 | 3 | | 237 | 126 | 3 | | 238 | 64 | 3 | | 239 | 79 | 3 | | 240 | 90 | 3 | | 241 | 88 | 3 | | 242 | 108 | 6 | | 243 | 142 | 6 | | 244 | 124 | 6 | | 245 | 127 | 6 | | 246 | 50 | 6 | | 247 | 147 | 17 | | 259 | 110 | 13 | | 249 | 1466 | 17 | | 250 | 1490 | 17 | | 251 | 1495 | 17 | | 252 | 10 | 17 | | 253 | 1469 | 17 | | 254 | 109 | 17 | | 255 | 1496 | 3 | | 256 | 1496 | 9 | | 257 | 1497 | 3 | | 258 | 1497 | 6 | | 260 | 33 | 13 | | 261 | 1468 | 13 | | 262 | 6 | 13 | | 263 | 105 | 13 | | 264 | 1498 | 10 | | 265 | 1498 | 3 | +------+----------+-----------+ 244 rows in set (0.00 sec) MariaDB [fog]> select * from groupMembers where gmHostID=0; Empty set (0.00 sec) MariaDB [fog]> select * from groupMembers where gmID=0; Empty set (0.00 sec) MariaDB [fog]> select * from groupMembers where gmGroupID=0; Empty set (0.00 sec) -
MariaDB [fog]> select * from groupMembers where gmHostID not in (select hostID from hosts); Empty set (0.00 sec) -
I never understood why hosts can’t have a zero for their ID.
-
Found the issue and it appears to be related to some rc11 changes to how inserts happen. There was a minor mistake on my part in that I wasn’t cleaning up a variable that desperately needed it, but this issue would have still happened just to how the query is passed. To prevent the issues specifically to module updates from groups, for now, I’ve made the insert occur in 500 item chunks, though I will likely do this for the method as a whole as mass inserting can be problematic if you just dump a ton of data anyway. The largest of these happens to be service settings and probably the only thing to notice these issues any way.
-
@Wayne-Workman it isn’t a valid ‘real’ auto increment number in SQL, therefore the only way to get a 0 is a bad call or manually define it.
-
@Tom-Elliott Updated and confirmed working
