search

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
578 stars 240 forks source link

host status: Out of range value for column 'notification_number' in broker after fix 21.10.12 #11999

Open rmorandell-pgum opened 1 year ago

rmorandell-pgum commented 1 year ago

Versions

centreon-21.10.13-2.el7.centos.noarch centreon-auto-discovery-server-21.10.3-2.el7.centos.noarch centreon-awie-21.10.0-1.el7.centos.noarch centreon-base-config-centreon-engine-21.10.13-2.el7.centos.noarch centreon-broker-21.10.3-3.el7.x86_64 centreon-broker-cbd-21.10.3-3.el7.x86_64 centreon-broker-cbmod-21.10.3-3.el7.x86_64 centreon-broker-core-21.10.3-3.el7.x86_64 centreon-broker-graphite-21.10.3-3.el7.x86_64 centreon-broker-influxdb-21.10.3-3.el7.x86_64 centreon-broker-storage-21.10.3-3.el7.x86_64 centreon-clib-21.10.3-3.el7.x86_64 centreon-common-21.10.13-2.el7.centos.noarch centreon-connector-21.10.3-3.el7.x86_64 centreon-connector-perl-21.10.3-3.el7.x86_64 centreon-connector-ssh-21.10.3-3.el7.x86_64 centreon-database-21.10.13-2.el7.centos.noarch centreon-engine-21.10.3-3.el7.x86_64 centreon-engine-daemon-21.10.3-3.el7.x86_64 centreon-engine-extcommands-21.10.3-3.el7.x86_64 centreon-fingerprint-21.04.0-2.el7.centos.x86_64 centreon-gorgone-21.10.3-1.el7.centos.noarch centreon-gorgone-centreon-config-21.10.3-1.el7.centos.noarch centreon-license-manager-21.10.0-1.el7.centos.noarch centreon-license-manager-common-21.10.0-1.el7.centos.noarch centreon-open-tickets-21.10.1-1.el7.centos.noarch centreon-perl-libs-21.10.13-2.el7.centos.noarch centreon-poller-centreon-engine-21.10.13-2.el7.centos.noarch centreon-pp-manager-21.10.0-2.el7.centos.noarch centreon-release-21.10-5.el7.centos.noarch centreon-trap-21.10.13-2.el7.centos.noarch centreon-web-21.10.13-2.el7.centos.noarch centreon-widget-engine-status-21.10.0-2.el7.centos.noarch centreon-widget-global-health-21.10.1-1.el7.centos.noarch centreon-widget-graph-monitoring-21.10.0-2.el7.centos.noarch centreon-widget-grid-map-21.10.0-2.el7.centos.noarch centreon-widget-hostgroup-monitoring-21.10.0-2.el7.centos.noarch centreon-widget-host-monitoring-21.10.0-2.el7.centos.noarch centreon-widget-httploader-21.10.0-2.el7.centos.noarch centreon-widget-live-top10-cpu-usage-21.10.0-2.el7.centos.noarch centreon-widget-live-top10-memory-usage-21.10.0-2.el7.centos.noarch centreon-widget-servicegroup-monitoring-21.10.0-2.el7.centos.noarch centreon-widget-service-monitoring-21.10.1-1.el7.centos.noarch centreon-widget-tactical-overview-21.10.0-2.el7.centos.noarch

Operating System

CentOS

Browser used

Description

After the fix https://github.com/centreon/centreon/issues?q=notification_number what changes the column in DB to "signed" all old negative values with an fix script has been updated to 0. But it seems that the trigger of the problem that generates the "maybe" negative value on broker poller side still exists. Now the master broker probably has the problem to store negative values. From the Broker Log

[2022-10-16T23:05:47.108+02:00] [sql] [error] mysql_connection: could not store host status:  Out of range value for column 'notification_number' at row 1
[2022-10-16T23:05:47.611+02:00] [sql] [error] conflict_manager: error in the main loop: could not store host status:  Out of range value for column 'notification_number' at row 1

Version installed on the poller

centreon-broker-21.10.3-3.el7.x86_64 centreon-broker-cbmod-21.10.3-3.el7.x86_64 centreon-broker-core-21.10.3-3.el7.x86_64 centreon-broker-storage-21.10.3-3.el7.x86_64 centreon-clib-21.10.3-3.el7.x86_64 centreon-common-21.10.13-2.el7.centos.noarch centreon-connector-21.10.3-3.el7.x86_64 centreon-connector-perl-21.10.3-3.el7.x86_64 centreon-connector-ssh-21.10.3-3.el7.x86_64 centreon-engine-21.10.3-3.el7.x86_64 centreon-engine-daemon-21.10.3-3.el7.x86_64 centreon-engine-extcommands-21.10.3-3.el7.x86_64 centreon-gorgone-21.10.3-1.el7.centos.noarch centreon-gorgone-centreon-config-21.10.3-1.el7.centos.noarch centreon-perl-libs-21.10.13-2.el7.centos.noarch centreon-poller-centreon-engine-21.10.13-2.el7.centos.noarch centreon-release-21.10-5.el7.centos.noarch centreon-trap-21.10.13-2.el7.centos.noarch

hecko commented 1 year ago

I am experiencing the same issue with centreon-web-21.10.13-2.el7.centos.noarch Patching as per https://thewatch.centreon.com/data-usage-and-visualization-38/centreon-22-04-01-service-check-results-not-visibles-in-web-interface-935 fixed the stalled broker.

hecko commented 1 year ago

This has re-surfaced in my env when upgrading from 21.10 to 22.10. i have temporrarily fixed this by changing the fileds from unsigned to signed: 

ALTER TABLE centreon_storage.hosts MODIFY notification_number bigint(20) signed DEFAULT NULL;
ALTER TABLE centreon_storage.services MODIFY notification_number bigint(20) signed DEFAULT NULL;
rmorandell-pgum commented 1 year ago

Yes i did the same