in a server that was installed as a fresh 1.6.2 i see these rows in the ids table:
mysql> select * from ids;
+--------+--------------------+----------------+--------+
| nodeid | table_name | field_name | nextid |
+--------+--------------------+----------------+--------+
| 0 | acknowledges | acknowledgeid | 260 |
| 0 | applications | applicationid | 1011 |
| 0 | auditlog | auditid | 371 |
| 0 | events | eventid | 62970 |
| 0 | functions | functionid | 19325 |
| 0 | graphs | graphid | 842 |
| 0 | graphs_items | gitemid | 2657 |
| 0 | groups | groupid | 5 |
| 0 | hosts | hostid | 10184 |
| 0 | hosts_groups | hostgroupid | 209 |
| 0 | hosts_templates | hosttemplateid | 278 |
| 0 | housekeeper | housekeeperid | 37614 |
| 0 | items | itemid | 28837 |
| 0 | items_applications | itemappid | 10112 |
| 0 | profiles | profileid | 289 |
| 0 | rights | rightid | 2 |
| 0 | services | serviceid | 2239 |
| 0 | services_links | linkid | 2214 |
| 0 | service_alarms | servicealarmid | 3409 |
| 0 | triggers | triggerid | 16923 |
| 0 | trigger_depends | triggerdepid | 489 |
| 0 | users | userid | 2307 |
| 0 | users_groups | id | 4443 |
| 0 | usrgrp | usrgrpid | 11 |
+--------+--------------------+----------------+--------+
24 rows in set (0.00 sec)
in one that was upgraded from 1.4.6 i see these:
mysql> select * from ids;
+--------+-----------------+----------------+--------+
| nodeid | table_name | field_name | nextid |
+--------+-----------------+----------------+--------+
| 0 | auditlog | auditid | 2782 |
| 0 | events | eventid | 197443 |
| 0 | functions | functionid | 20935 |
| 0 | graphs | graphid | 782 |
| 0 | graphs_items | gitemid | 10299 |
| 0 | hosts | hostid | 10220 |
| 0 | hosts_groups | hostgroupid | 1950 |
| 0 | hosts_templates | hosttemplateid | 476 |
| 0 | housekeeper | housekeeperid | 216 |
| 0 | items | itemid | 30654 |
| 0 | media_type | mediatypeid | 4 |
| 0 | profiles | profileid | 124 |
| 0 | scripts | scriptid | 2 |
| 0 | services | serviceid | 9818 |
| 0 | services_links | linkid | 9426 |
| 0 | service_alarms | servicealarmid | 31937 |
| 0 | triggers | triggerid | 16277 |
| 0 | usrgrp | usrgrpid | 10 |
+--------+-----------------+----------------+--------+
18 rows in set (0.00 sec)
i seem to be missing 7 of them: acknowledges, applications, groups, items_applications, rights, trigger_depends, and users_groups
is that expected or not?
mysql> select * from ids;
+--------+--------------------+----------------+--------+
| nodeid | table_name | field_name | nextid |
+--------+--------------------+----------------+--------+
| 0 | acknowledges | acknowledgeid | 260 |
| 0 | applications | applicationid | 1011 |
| 0 | auditlog | auditid | 371 |
| 0 | events | eventid | 62970 |
| 0 | functions | functionid | 19325 |
| 0 | graphs | graphid | 842 |
| 0 | graphs_items | gitemid | 2657 |
| 0 | groups | groupid | 5 |
| 0 | hosts | hostid | 10184 |
| 0 | hosts_groups | hostgroupid | 209 |
| 0 | hosts_templates | hosttemplateid | 278 |
| 0 | housekeeper | housekeeperid | 37614 |
| 0 | items | itemid | 28837 |
| 0 | items_applications | itemappid | 10112 |
| 0 | profiles | profileid | 289 |
| 0 | rights | rightid | 2 |
| 0 | services | serviceid | 2239 |
| 0 | services_links | linkid | 2214 |
| 0 | service_alarms | servicealarmid | 3409 |
| 0 | triggers | triggerid | 16923 |
| 0 | trigger_depends | triggerdepid | 489 |
| 0 | users | userid | 2307 |
| 0 | users_groups | id | 4443 |
| 0 | usrgrp | usrgrpid | 11 |
+--------+--------------------+----------------+--------+
24 rows in set (0.00 sec)
in one that was upgraded from 1.4.6 i see these:
mysql> select * from ids;
+--------+-----------------+----------------+--------+
| nodeid | table_name | field_name | nextid |
+--------+-----------------+----------------+--------+
| 0 | auditlog | auditid | 2782 |
| 0 | events | eventid | 197443 |
| 0 | functions | functionid | 20935 |
| 0 | graphs | graphid | 782 |
| 0 | graphs_items | gitemid | 10299 |
| 0 | hosts | hostid | 10220 |
| 0 | hosts_groups | hostgroupid | 1950 |
| 0 | hosts_templates | hosttemplateid | 476 |
| 0 | housekeeper | housekeeperid | 216 |
| 0 | items | itemid | 30654 |
| 0 | media_type | mediatypeid | 4 |
| 0 | profiles | profileid | 124 |
| 0 | scripts | scriptid | 2 |
| 0 | services | serviceid | 9818 |
| 0 | services_links | linkid | 9426 |
| 0 | service_alarms | servicealarmid | 31937 |
| 0 | triggers | triggerid | 16277 |
| 0 | usrgrp | usrgrpid | 10 |
+--------+-----------------+----------------+--------+
18 rows in set (0.00 sec)
i seem to be missing 7 of them: acknowledges, applications, groups, items_applications, rights, trigger_depends, and users_groups
is that expected or not?