Mysql Duplicate Table Entries
Hello,
I just install Icinga 1.5 onto my main server when it came out and did a weeks worth of testing, then moved the system from a single server system to a distributed system and for the most part it works just fine.
However, I noticed that Icinga-Web is showing Duplicate Services and hosts and decided to look into it. After digging around in the database, I found that several hosts and their services have been inserted into the database twice, can't figure out why. When I went to a distributed system, I created a new Icinga Database and changed the configuration appropriately in order to try and prevent duplicates due to differing instance names.
EDIT: After digging some more, I indeed found that IDOUTILS is generating two entries for each remotely monitored host - one for the primary server's instance and then one for the remote icinga server instance.
For example:
File server for site 3 is assigned to be checked by remote icinga server with instance "site3" and report the results back via send_nsca to the main Icinga server at Site 1 with instance "site1". The File server for site 3 is showing up in the Icinga database twice - once for instance "site3" and once for instance "site1".
Any ideas what I did wrong?