host status: Out of range value for column 'notification_number' in broker after fix 21.10.12 #11999
Description
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
- Google Chrome
- Firefox
- Internet Explorer IE11
- Safari
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