Group Service settings not applying, sort of...

Tom Elliott

@JJ-Fullmer please check the groupMembers table. I have. Suspicion of 0 host ids somewhere

Tom Elliott

Or group ids

JJ Fullmer

@Tom-Elliott 0 host id’s?
So like go into command line and search for host id’s with 0 in the id?

Tom Elliott

@JJ-Fullmer On the groupMembers table yes

JJ Fullmer

@Tom-Elliott

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)

JJ Fullmer

@Tom-Elliott

MariaDB [fog]> select * from groupMembers where gmHostID not in (select hostID from hosts);
Empty set (0.00 sec)

Wayne Workman

I never understood why hosts can’t have a zero for their ID.

Tom Elliott

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.

Tom Elliott

@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.

JJ Fullmer

@Tom-Elliott Updated and confirmed working

Group Service settings not applying, sort of...

141

11.7k

17.2k

154.7k