Autoregistration fails with "Duplicate entry" after server made master node
Hello,
I just set up a new Zabbix server to move from single-server to a proxy enviroment. After the initial build from source I set up auto registration which worked well for my two test-hosts, then I ran
which also only worked after i dropped the contents of the events table.
After that I created a virtual host for aggregated data which also worked.
Now I wanted to add more of my machines to this Server and found their auto registration would fail with:
100100000010107 is the hostid of my newly created virtual host.
The server version is: Zabbix server v2.2.6
Any suggestions/help would be much appreciated!
cz
I just set up a new Zabbix server to move from single-server to a proxy enviroment. After the initial build from source I set up auto registration which worked well for my two test-hosts, then I ran
zabbix_server -n 1 -c /usr/local/etc/zabbix_server.conf
After that I created a virtual host for aggregated data which also worked.
Now I wanted to add more of my machines to this Server and found their auto registration would fail with:
28006:20141008:110850.470 [Z3005] query failed: [1062] Duplicate entry '100100000010107' for key 'PRIMARY' [insert into hosts (hostid,proxy_hostid,host,name) values (100100000010107,null,'XXX-XXXX-BL05','XXX-XXXX-BL05')]
28006:20141008:110850.477 cannot send list of active checks to [yyy.xxx.zzzz.yyy]: host [XXX-XXXX-BL05] not found
28006:20141008:110850.477 cannot send list of active checks to [yyy.xxx.zzzz.yyy]: host [XXX-XXXX-BL05] not found
The server version is: Zabbix server v2.2.6
Any suggestions/help would be much appreciated!
cz