Unable to create Groups (Duplicate entry)

[gginley]

Complete zabbix novice here

Version we are running is 1.8.4 / mysql

Trying to create a test host group through web front end and receiving this error message when saving

Error in query [INSERT INTO groups (name,groupid) VALUES ('Test',22)] [Duplicate entry '22' for key 1]

At first I thought perhaps that sql was using autoincrement on the groupid table and had lost its seed value. Looking at the table however suggests its not using autoincrement

mysql -u root -p zabbix -e "SELECT auto_increment FROM INFORMATION_SCHEMA.TABLES WHERE table_name = 'groups'"

+----------------+
| auto_increment |
+----------------+
| NULL |
+----------------+

Sure enough when I look at the table there is a groupid of 22 and another @ 23.

 mysql -u root -p zabbix -e "select * from groups where groupid >= 22 order by groupid"

+---------+----------------+----------+
| groupid | name | internal |
+---------+----------------+----------+
| 22 | PlaceHolderName1 | 0 |
| 23 | PlaceHolderName2 | 0 |
+---------+----------------+----------+

Am I too assume that zabbix is responsible for creating the ID? Again I am a novice and was creating groups to learn and am apprehensive to remove and recreate groups to test if it resolves the issue. Also considered manually creating the group directly in the database but don't understand the implication of that action.

Was also hoping to find some corresponding logs that may point me to something more useful. I'm not NIX guy but looking through dmesg / messages / zabbix_server.log using grep 'Duplicate' did not produce any results.

Hoping for a little help