At restart Centreon-engine empties some centreon_storage tables

[samyjc]

BUG REPORT INFORMATION

Prerequisites

The opened issue, must be code related. GitHub is not meant for support. Feel free to check the CONTRIBUTING section for more details.

Versions

For the RPM based systems

-- Copy/Paste the result of the following command --

$ rpm -qa | grep centreon

centreon-broker-core-20.04.6-3.el7.centos.x86_64
centreon-poller-centreon-engine-20.04.4-6.el7.centos.noarch
centreon-clib-20.04.0-7.el7.centos.x86_64
centreon-widget-tactical-overview-20.04.0-5.el7.centos.noarch
centreon-plugin-Hardware-Ups-Mge-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Hardware-Printers-Generic-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Network-Switchs-Hp-Procurve-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Network-H3c-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Applications-Monitoring-Centreon-Central-20200602-094050.el7.centos.noarch
centreon-common-20.04.4-6.el7.centos.noarch
centreon-engine-20.04.4-1.el7.centos.x86_64
centreon-20.04.4-6.el7.centos.noarch
centreon-widget-servicegroup-monitoring-20.04.0-5.el7.centos.noarch
centreon-widget-global-health-20.04.0-5.el7.centos.noarch
centreon-license-manager-20.04.2-1.el7.centos.noarch
centreon-plugin-Hardware-Ups-Powerware-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Hardware-Storage-Qnap-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Network-3com-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Network-Firewalls-Fortinet-Fortigate-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Virtualization-Vmware2-Esx-Wsman-20200602-094050.el7.centos.noarch
centreon-plugin-Network-Cisco-Standard-Snmp-20200602-094050.el7.centos.noarch
centreon-gorgone-20.04.3-1.el7.centos.noarch
centreon-broker-20.04.6-3.el7.centos.x86_64
centreon-engine-extcommands-20.04.4-1.el7.centos.x86_64
centreon-auto-discovery-server-20.04.3-3.el7.centos.noarch
centreon-database-20.04.4-6.el7.centos.noarch
centreon-release-20.04-1.el7.centos.noarch
centreon-widget-httploader-20.04.0-5.el7.centos.noarch
centreon-widget-graph-monitoring-20.04.0-5.el7.centos.noarch
centreon-widget-live-top10-cpu-usage-20.04.0-5.el7.centos.noarch
centreon-connector-ssh-20.04.0-2.el7.centos.x86_64
centreon-pp-manager-20.04.1-1.el7.centos.noarch
centreon-plugin-Applications-Protocol-Ftp-20200602-094050.el7.centos.noarch
centreon-plugin-Operatingsystems-Linux-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Hardware-Ups-Hp-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Hardware-Storage-Hitachi-Hnas-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Network-Cisco-Voice-Gateway-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Hardware-Servers-Hp-Blade-Chassis-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Network-Cisco-Wlc-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Hardware-Servers-Cisco-Ucs-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Applications-Databases-Mssql-20200602-094050.el7.centos.noarch
centreon-plugin-Network-Cisco-Prime-Restapi-20200602-094050.el7.centos.noarch
centreon-plugin-Operatingsystems-Windows-Snmp-20200602-094050.el7.centos.noarch
centreon-web-20.04.4-6.el7.centos.noarch
centreon-engine-daemon-20.04.4-1.el7.centos.x86_64
centreon-broker-cbd-20.04.6-3.el7.centos.x86_64
centreon-base-config-centreon-engine-20.04.4-6.el7.centos.noarch
centreon-plugin-Discovery-Nmap-20181019-1.el7.noarch
centreon-widget-hostgroup-monitoring-20.04.0-5.el7.centos.noarch
centreon-connector-20.04.0-2.el7.centos.x86_64
centreon-license-manager-common-20.04.2-1.el7.centos.noarch
centreon-widget-service-monitoring-20.04.2-1.el7.centos.noarch
centreon-plugins-base-1.18-2.el7.centos.noarch
centreon-plugin-Hardware-Ups-Nitram-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Applications-Monitoring-Centreon-Poller-20200602-094050.el7.centos.noarch
centreon-plugin-Hardware-Servers-Ibm-Bladecenter-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Network-Dlink-Standard-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Network-Switchs-Moxa-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Applications-Protocol-Ldap-20200602-094050.el7.centos.noarch
centreon-plugin-Applications-Protocol-Dns-20200602-094050.el7.centos.noarch
centreon-plugin-Network-Switchs-Cisco-Smallbusiness-Standard-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Applications-Protocol-Http-20200602-094050.el7.centos.noarch
centreon-plugin-Virtualization-Vmware2-Connector-Plugin-20200602-094050.el7.centos.noarch
centreon-widget-host-monitoring-20.04.3-2.el7.centos.noarch
centreon-perl-libs-20.04.4-6.el7.centos.noarch
centreon-broker-cbmod-20.04.6-3.el7.centos.x86_64
centreon-widget-live-top10-memory-usage-20.04.0-5.el7.centos.noarch
centreon-widget-engine-status-20.04.1-1.el7.centos.noarch
centreon-plugin-Network-Fortinet-Fortimanager-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Virtualization-VMWare-daemon-3.1.2-20200602093832.el7.centos.noarch
centreon-plugin-Hardware-Ups-Alpha-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Hardware-Ups-Apc-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Hardware-Ups-Standard-Rfc1628-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Hardware-Servers-Dell-IDrac-Snmp-20200602-094050.el7.centos.noarch
centreon-gorgone-centreon-config-20.04.3-1.el7.centos.noarch
centreon-broker-storage-20.04.6-3.el7.centos.x86_64
centreon-trap-20.04.4-6.el7.centos.noarch
centreon-widget-grid-map-20.04.0-5.el7.centos.noarch
centreon-connector-perl-20.04.0-2.el7.centos.x86_64
centreon-plugin-Applications-Monitoring-Centreon-Map4-Jmx-20200602-094050.el7.centos.noarch
centreon-plugin-Hardware-Devices-Video-Axis-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Applications-Monitoring-Centreon-Database-20200602-094050.el7.centos.noarch
centreon-plugin-Network-Cisco-Callmanager-Snmp-20200602-094050.el7.centos.noarch
centreon-plugin-Applications-Databases-Mysql-20200602-094050.el7.centos.noarch
Operating System

CentOS, Debian ...
CentOS Linux release 7.8.2003 (Core)
How the the component has been installed and versions

• From sources, from packages
• components versions

Version: --

Additional environment details (AWS, VirtualBox, physical, etc.):

Description

-- Describe the encountered issue --

Each time Centreon-engine is restarted after hostgroupe, host or service add/delete/modify or whatever, at least tables hostsgroups and hosts_hostgroups are found empty.

files under /etc/centreon-engine/ seems to be OK
Hostgroups under Configuration/Hosts are present with right content and were helpful (with /etc/centreon-engine/hostsgroups.cfg) to refuel tables.

Steps to Reproduce

Please describe precisely the steps to reproduce the encountered issue.

1. I logged in Centreon
2. modify IP of an existing Host via Configuration/Hosts/Select a Host
3. Restart collector via Configuration/Collectors with Collector Central, export configuration
   
4. After taking somes time Poller is UP but Hostgroups are missing and both tables at least, don't really know or seen for other tables, hostgroups and hosts_hostgroups are empty

Describe the received result

No Hostgroups present

Describe the expected result

Must be hostgroups

Logs

PHP error logs

tail -f /var/opt/rh/rh-php72/log/php-fpm/centreon-error.log

[06-Jul-2020 08:59:57 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[06-Jul-2020 09:32:41 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[06-Jul-2020 10:02:28 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[06-Jul-2020 10:20:03 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[06-Jul-2020 13:30:04 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[06-Jul-2020 21:00:44 Africa/Tunis] PHP Notice: Undefined index: current in /usr/share/centreon/www/install/step_upgrade/process/process_step5.php on line 77
[06-Jul-2020 21:05:32 Africa/Tunis] PHP Notice: Element 'rrdcached_enable' does not exist in /usr/share/centreon/www/lib/HTML/QuickForm/HTML_QuickFormCustom.php on line 188
[06-Jul-2020 21:05:32 Africa/Tunis] PHP Notice: Element 'rrdcached_port' does not exist in /usr/share/centreon/www/lib/HTML/QuickForm/HTML_QuickFormCustom.php on line 188
[06-Jul-2020 21:05:32 Africa/Tunis] PHP Notice: Element 'rrdcached_port' does not exist in /usr/share/centreon/www/lib/HTML/QuickForm/HTML_QuickFormCustom.php on line 183
[07-Jul-2020 08:03:45 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[07-Jul-2020 08:19:07 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[07-Jul-2020 10:19:06 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[07-Jul-2020 12:20:20 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[07-Jul-2020 12:23:14 Africa/Tunis] PHP Notice: Undefined index: centreon in /usr/share/centreon/www/include/monitoring/status/Services/xml/makeXMLForOneService.php on line 50
[08-Jul-2020 08:55:10 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[08-Jul-2020 08:56:16 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[08-Jul-2020 10:23:55 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[08-Jul-2020 10:24:21 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[08-Jul-2020 10:25:06 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[08-Jul-2020 10:25:09 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[08-Jul-2020 10:25:50 Africa/Tunis] PHP Warning: require(NagVisErrorException.php): failed to open stream: No such file or directory in /usr/share/nagvis/share/server/core/functions/autoload.php on line 40
[08-Jul-2020 10:25:50 Africa/Tunis] PHP Warning: require(NagVisErrorException.php): failed to open stream: No such file or directory in /usr/share/nagvis/share/server/core/functions/autoload.php on line 40
[08-Jul-2020 10:25:50 Africa/Tunis] PHP Fatal error: require(): Failed opening required 'NagVisErrorException.php' (include_path='/usr/share/centreon/vendor/pear/pear_exception:/usr/share/centreon/vendor/pear/console_getopt:/usr/share/centreon/vendor/pear/pear-core-minimal/src:/usr/share/centreon/www/class:/usr/share/centreon/www/lib:.:/opt/rh/rh-php72/root/usr/share/pear:/opt/rh/rh-php72/root/usr/share/php:../../server/core/classes:../../server/core/classes/objects:../../server/core/ext/php-gettext-1.0.9') in /usr/share/nagvis/share/server/core/functions/autoload.php on line 40
[08-Jul-2020 10:31:04 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[09-Jul-2020 08:54:46 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[09-Jul-2020 09:26:38 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[09-Jul-2020 09:32:25 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[09-Jul-2020 10:22:44 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[10-Jul-2020 07:37:05 Africa/Tunis] PHP Notice: Undefined index: x-centreon-token in /usr/share/centreon/www/lib/HTML/QuickForm/HTML_QuickFormCustom.php on line 119
[10-Jul-2020 07:37:05 Africa/Tunis] PHP Warning: in_array() expects parameter 2 to be array, null given in /usr/share/centreon/www/lib/HTML/QuickForm/HTML_QuickFormCustom.php on line 119
[10-Jul-2020 07:37:05 Africa/Tunis] PHP Notice: Undefined index: x-centreon-token-generated-at in /usr/share/centreon/www/lib/HTML/QuickForm/HTML_QuickFormCustom.php on line 152
[10-Jul-2020 07:37:05 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/lib/HTML/QuickForm/HTML_QuickFormCustom.php on line 152
[10-Jul-2020 14:35:00 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[10-Jul-2020 15:34:09 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
[10-Jul-2020 23:54:42 Africa/Tunis] PHP Warning: Invalid argument supplied for foreach() in /usr/share/centreon/www/include/monitoring/status/Services/service.php on line 81
centreon-engine logs (if needed)

tail -f /var/log/centreon-engine/centengine.log

centreon-broker logs (if needed)

tail -f /var/log/centreon-broker/central-broker-master.log

centcore logs (if needed)

tail -f /var/log/centreon/centcore.log

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

[samyjc]

Hi,

it seems that there is an issue between Centreon & MySQL.
In Fact, after a reboot, both hostgroups and host_hostgroups table of Centreon_storage are found empty but I also noticed that when I have to change some Host IP, it is modified on /etc/centreon-engine/hosts.cfg but not on address row of table hosts of Centreon_storage table but in another hand, check elements of same table are changed.

Please advise

Best Regards
Samy J. Chapoutot

[lpinsivy]

Can you try to update all component (web, engine, broker).

Regards

[samyjc]

All components have already been updated. Still facing the same issue. Each time we restart Centreon Engine, at least both hostgroups and hosts_hostgroups tables from centreon_storage database are emptied.

Regards