centreon / centreon-archived

Centreon is a network, system and application monitoring tool. Centreon is the only AIOps Platform Providing Holistic Visibility to Complex IT Workflows from Cloud to Edge.
https://www.centreon.com
GNU General Public License v2.0
574 stars 240 forks source link

Reporting error, lot of UNDETERMINED status #7738

Open wackou72 opened 5 years ago

wackou72 commented 5 years ago

Versions centreon-widget-live-top10-memory-usage-19.04.0-5.el7.centos.noarch centreon-widget-global-health-19.04.0-5.el7.centos.noarch centreon-common-19.04.3-6.el7.centos.noarch centreon-database-19.04.3-6.el7.centos.noarch centreon-plugin-Hardware-Ups-Standard-Rfc1628-Snmp-20190704-123459.el7.centos.noarch centreon-web-19.04.3-6.el7.centos.noarch centreon-clib-19.04.0-1.el7.centos.x86_64 centreon-engine-19.04.1-9.el7.centos.x86_64 centreon-pp-manager-19.04.0-3.el7.centos.noarch centreon-plugin-Applications-Protocol-Dns-20190704-123459.el7.centos.noarch centreon-plugin-Hardware-Printers-Generic-Snmp-20190704-123459.el7.centos.noarch centreon-broker-storage-19.04.0-2.el7.centos.x86_64 centreon-connector-perl-19.04.0-2.el7.centos.x86_64 centreon-widget-servicegroup-monitoring-19.04.0-7.el7.centos.noarch centreon-plugin-Applications-Monitoring-Centreon-Map4-Jmx-20190704-123459.el7.centos.noarch centreon-plugin-Applications-Protocol-Ftp-20190704-123459.el7.centos.noarch centreon-plugin-Applications-Protocol-Ldap-20190704-123459.el7.centos.noarch centreon-plugin-Operatingsystems-Linux-Snmp-20190704-123459.el7.centos.noarch centreon-19.04.3-6.el7.centos.noarch centreon-broker-core-19.04.0-2.el7.centos.x86_64 centreon-broker-cbd-19.04.0-2.el7.centos.x86_64 centreon-plugins-base-1.18-2.el7.centos.noarch centreon-license-manager-common-19.04.0-1.el7.centos.noarch centreon-widget-hostgroup-monitoring-19.04.0-5.el7.centos.noarch centreon-widget-live-top10-cpu-usage-19.04.0-5.el7.centos.noarch centreon-trap-19.04.3-6.el7.centos.noarch centreon-plugin-Applications-Monitoring-Centreon-Central-20190704-123459.el7.centos.noarch centreon-plugin-Applications-Monitoring-Centreon-Database-20190704-123459.el7.centos.noarch centreon-plugin-Applications-Databases-Mysql-20190704-123459.el7.centos.noarch centreon-poller-centreon-engine-19.04.3-6.el7.centos.noarch centreon-widget-service-monitoring-19.04.1-1.el7.centos.noarch centreon-plugin-Virtualization-Vmware2-Connector-Plugin-20190704-123459.el7.centos.noarch centreon-broker-19.04.0-2.el7.centos.x86_64 centreon-broker-cbmod-19.04.0-2.el7.centos.x86_64 centreon-connector-19.04.0-2.el7.centos.x86_64 centreon-auto-discovery-server-19.04.0-4.el7.centos.x86_64 centreon-widget-graph-monitoring-19.04.0-5.el7.centos.noarch centreon-plugin-Applications-Monitoring-Centreon-Poller-20190704-123459.el7.centos.noarch centreon-plugin-Network-Cisco-Standard-Snmp-20190704-123459.el7.centos.noarch centreon-widget-host-monitoring-19.04.1-1.el7.centos.noarch centreon-plugin-Virtualization-VMWare-daemon-3.0.3-20190704131142.el7.centos.noarch centreon-release-19.04-1.el7.centos.noarch centreon-engine-daemon-19.04.1-9.el7.centos.x86_64 centreon-connector-ssh-19.04.0-2.el7.centos.x86_64 centreon-widget-engine-status-19.04.0-5.el7.centos.noarch centreon-widget-tactical-overview-19.04.0-7.el7.centos.noarch centreon-widget-httploader-19.04.0-5.el7.centos.noarch centreon-perl-libs-19.04.3-6.el7.centos.noarch centreon-plugin-Applications-Protocol-Http-20190704-123459.el7.centos.noarch centreon-plugin-Operatingsystems-Windows-Snmp-20190704-123459.el7.centos.noarch centreon-base-config-centreon-engine-19.04.3-6.el7.centos.noarch centreon-widget-grid-map-19.04.0-5.el7.centos.noarch centreon-engine-extcommands-19.04.1-9.el7.centos.x86_64 centreon-license-manager-19.04.0-1.el7.centos.noarch

Operating System

CentOS Linux release 7.6.1810 (Core)

Browser used

Version: 19.04.3

Virtual VM (ESXi)

Description

When seeing the reporting dashboard, I have some hosts with the UNDERTIMENIED status. Checking direcly the host events logs, everything is fine. Dashboard reporting is empty on some days, this can explain the issue. Running the following command rebuild the data and everything is working as expected : /usr/share/centreon/cron/eventReportBuilder -r /usr/share/centreon/cron/dashboardBuilder -r

See attached file for example, also output.txt for the history of the command to rebuild data.

Additional relevant information (e.g. frequency, ...)

NOK_HOSTGROUP NOK_HOST OK_HOSTGROUP OK_HOST Output.txt

lpinsivy commented 5 years ago

Hi @wackou72 do you have the same errors with the isssue #7000?

wackou72 commented 5 years ago

Hi @lpinsivy , the issue is not exactly the same, my issue is on the reporting dashboard, not on the Hard State Duration

kozfelipe commented 5 years ago

Hi

7000 is not about hard state duration anymore. The issue regards duplicate entries on eventReportBuilder job

magicbret commented 4 years ago

Hi, Same issue for me on v2.8.24

What is strange is that if i select, for a host, a report

I don't really understand.

Is that bug still under investigation ?

wackou72 commented 4 years ago

Hello, If I remember, I changed something regarding the DB memory. Because the internal process take too much time to calculate the status. Try to search on the git. Regards

wackou72 commented 4 years ago

Hello @lpinsivy The bug is still their since the upgrade to 20.04. When changing the file /etc/my.cnf.d/centreon.cnf and removing these two lines :

# For 8 Go Ram
innodb_additional_mem_pool_size=1G
innodb_buffer_pool_size=1G

Then I got the exact situation, reporting are not calculated and I need to rebuild manually.

I understand that these options were deprecated, but how this can be solved ?

Have a nice day.

Regards.

wackou72 commented 4 years ago

Hello @lpinsivy This is the same error as #7837 Any news about this ? Regards

tobiasschon commented 4 years ago

image it doesnt feel good when the events only are dated back to august.

saharawolf commented 4 years ago

It seems that this error is still not corrected. Is there any reply from CENTREON Devs ?

kozfelipe commented 3 years ago

Hi, there.

I have this undetermined status issue since 18.x and I decided to create a brand new installation from the 21.04.0 ova image. I got only the native central server host collecting this whole week and it cannot get yesterday's status.

image

image

could this be related to my timezone or location?

https://github.com/centreon/centreon/issues/4056 https://github.com/centreon/centreon/issues/7738 https://github.com/centreon/centreon/issues/7000 https://github.com/centreon/centreon/issues/8494

Edit:

I got it fix by