24.09.2011, 05:22 UTC+2

Sie sind nicht angemeldet.

Mysql Duplicate Table Entries

EagleDelta1

Anfänger

Beiträge: 8

Geburtstag: 02.04.1984 (27)

Geschlecht: Männlich

Wohnort: Omaha, NE, USA

Beruf: IT Infrastructure Coordinator

Anzahl Nagios-Server: 2

Nagios-Version(en): 3.0

Icinga-Version(en): Icinga 1.4.0

Verteiltes Monitoring: Nein

Redundantes Monitoring: Ja

Anzahl-Hosts: 24

Anzahl Services: 210

Betriebssystem(e): Ubuntu Server 10.04.2

Plugin-Version(en): 1.4.15

1

06.09.2011, 21:21

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?

EagleDelta1

Anfänger

Beiträge: 8

Geburtstag: 02.04.1984 (27)

Geschlecht: Männlich

Wohnort: Omaha, NE, USA

Beruf: IT Infrastructure Coordinator

Anzahl Nagios-Server: 2

Nagios-Version(en): 3.0

Icinga-Version(en): Icinga 1.4.0

Verteiltes Monitoring: Nein

Redundantes Monitoring: Ja

Anzahl-Hosts: 24

Anzahl Services: 210

Betriebssystem(e): Ubuntu Server 10.04.2

Plugin-Version(en): 1.4.15

2

16.09.2011, 19:39

Anybody got any ideas?

I started with a fresh database and ran into the same problem - I've got duplicated database entries for every checked host(and it's services) that is checked by a distributed server. Each host/service has one entry pertaining to the config on the main server (Active checks ARE disabled) and then one for the checks coming from the into the main server from distro servers.

Am I supposed to have idoutils disabled on distributed servers? Is that where I'm running into problems?

EagleDelta1

Anfänger

Beiträge: 8

Geburtstag: 02.04.1984 (27)

Geschlecht: Männlich

Wohnort: Omaha, NE, USA

Beruf: IT Infrastructure Coordinator

Anzahl Nagios-Server: 2

Nagios-Version(en): 3.0

Icinga-Version(en): Icinga 1.4.0

Verteiltes Monitoring: Nein

Redundantes Monitoring: Ja

Anzahl-Hosts: 24

Anzahl Services: 210

Betriebssystem(e): Ubuntu Server 10.04.2

Plugin-Version(en): 1.4.15

3

19.09.2011, 23:16

Ok, some help would be appreciated here, I've tried everything I can think of and am at a standstill. I can't do accurate reporting or use icinga-web accurately right now and I'm not even getting anyone to ask for more information.

Even an "I don't know" would be help - better than nothing. I've tried multiple forums and mailing groups - a little help would be nice

dnsmichi

Meister

Beiträge: 2 531

Geburtstag: 30.05.1983 (28)

Geschlecht: Männlich

Wohnort: Wien

Beruf: DNS & Monitoring Developer

Anzahl Nagios-Server: 4x Icinga prod, 2x test/dev

Nagios-Version(en): s/nagios/icinga/

Icinga-Version(en): 1.5.1 / GIT

Verteiltes Monitoring: Ja

Redundantes Monitoring: Ja

Anzahl-Hosts: 1000+

Anzahl Services: 15000+

Betriebssystem(e): RHEL 5.7 / 6 x64

Plugin-Version(en): 1.4.15

IDO-Version: 1.5.1 / GIT MySQL/Postgresql/Oracle

Sonstige Addon's: PNP 0.6.11, check_mk GIT

4

20.09.2011, 09:11

don't panic - not everyone has can read masses of text and then understand what you are saying.

i would prefer some configs and a drawing what exactly you are doing / what happens. i can guess what happens but that won't be enough / would confuse you even more. so please, provide accurate information.
Icinga 1.5 MySQL,PGSQL,Oracle and IPv6

Demos

http://docs.icinga.org
https://wiki.icinga.org
https://dev.icinga.org

* egrep -v "^#|^$" configfile

Join us online!
irc.freenode.net #icinga-devel

Using Icinga? Tell us!


Fork me on

Ähnliche Themen