Hello ,
after many year Centreon v. 21.10.15 don’t running anymore…
I have look the log file here:
/var/log/centreon-broker
And i have found this:
[2024-03-19T11:37:06.939+01:00] [core] [info] /var/log/centreon-broker//central-broker-master.log : log started
[2024-03-19T11:37:06.939+01:00] [core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/50-tcp.so' which is already loaded
[2024-03-19T11:37:06.939+01:00] [core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/80-sql.so' which is already loaded
[2024-03-19T11:37:06.939+01:00] [core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/20-storage.so' which is already loaded
[2024-03-19T11:37:06.939+01:00] [core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/15-stats.so' which is already loaded
[2024-03-19T11:37:06.939+01:00] [core] [info] multiplexing: engine started
[2024-03-19T11:47:21.008+01:00] [tcp] [error] Error while reading on socket: End of file
[2024-03-19T11:47:21.107+01:00] [core] [error] feeder 'central-broker-master-input-3' error:Attempt to read data from peer 127.0.0.1:49442 on a closing socket
[2024-03-19T11:47:21.107+01:00] [core] [info] bbdo stream stopped with 0 events acknowledged
[2024-03-19T11:47:21.107+01:00] [core] [info] feeder: queue files of client 'central-broker-master-input-3' removed
[2024-03-19T11:47:21.108+01:00] [core] [info] feeder: thread of client 'central-broker-master-input-3' will exit
[2024-03-19T11:47:21.990+01:00] [core] [info] main: termination request received by process
[2024-03-19T11:47:22.573+01:00] [core] [info] removing 'central-broker-master-input-3' from acceptor 'central-broker-master-input'
[2024-03-19T11:47:22.573+01:00] [core] [info] Destroying muxer central-broker-master-input-3: number of events in the queue: 0
[2024-03-19T11:47:22.573+01:00] [core] [info] processing acceptor 'central-broker-master-input' finished
[2024-03-19T11:47:22.574+01:00] [core] [info] multiplexing: stopping engine
[2024-03-19T11:47:22.574+01:00] [core] [info] multiplexing: sending events to muxers for the last time
[2024-03-19T11:47:22.713+01:00] [core] [info] bbdo stream stopped with 0 events acknowledged
[2024-03-19T11:47:22.713+01:00] [tcp] [error] Error while reading on socket: Operation aborted.
[2024-03-19T11:47:22.714+01:00] [core] [info] Destroying muxer centreon-broker-master-rrd: number of events in the queue: 0
[2024-03-19T11:47:22.771+01:00] [core] [info] sql stream stopped with 0 ackowledged events
[2024-03-19T11:47:22.772+01:00] [core] [info] Destroying muxer central-broker-master-sql: number of events in the queue: 100000
[2024-03-19T11:47:25.350+01:00] [core] [info] storage stream stopped with 0 acknowledged events
[2024-03-19T11:47:25.350+01:00] [core] [info] Destroying muxer central-broker-master-perfdata: number of events in the queue: 0
[2024-03-19T11:47:25.350+01:00] [core] [info] modules: closing '/usr/share/centreon/lib/centreon-broker/80-sql.so'
[2024-03-19T11:47:25.350+01:00] [core] [info] protocols: unregistering protocol 'SQL'
[2024-03-19T11:47:25.350+01:00] [core] [info] modules: closing '/usr/share/centreon/lib/centreon-broker/60-tls.so'
[2024-03-19T11:47:25.350+01:00] [core] [info] protocols: unregistering protocol 'TLS'
[2024-03-19T11:47:25.351+01:00] [core] [info] modules: closing '/usr/share/centreon/lib/centreon-broker/50-tcp.so'
[2024-03-19T11:47:25.351+01:00] [core] [info] protocols: unregistering protocol 'TCP'
[2024-03-19T11:47:25.351+01:00] [core] [info] modules: closing '/usr/share/centreon/lib/centreon-broker/20-storage.so'
[2024-03-19T11:47:25.351+01:00] [core] [info] protocols: unregistering protocol 'storage'
[2024-03-19T11:47:25.351+01:00] [core] [info] modules: closing '/usr/share/centreon/lib/centreon-broker/15-stats.so'
[2024-03-19T11:47:25.412+01:00] [core] [info] modules: closing '/usr/share/centreon/lib/centreon-broker/10-neb.so'
[2024-03-19T11:47:25.412+01:00] [core] [info] protocols: unregistering protocol 'BBDO'
[2024-03-19T11:47:25.412+01:00] [core] [info] protocols: unregistering protocol 'compression'
[2024-03-19T11:47:25.412+01:00] [core] [info] protocols: unregistering protocol 'file'
[2024-03-19T11:47:25.412+01:00] [core] [info] protocols: destruction (0 protocols still registered)
[2024-03-19T11:47:25.412+01:00] [core] [info] pool: the latency check encountered an error: Operation aborted.
[2024-03-19T11:47:25.414+01:00] [core] [info] log finished
[2024-03-19T11:47:59.610+01:00] [core] [info] /var/log/centreon-broker//central-broker-master.log : log started
[2024-03-19T11:47:59.611+01:00] [core] [info] Starting the TCP thread pool of 8 threads
[2024-03-19T11:47:59.613+01:00] [core] [info] protocols: registering protocol ('file' (layers 1-3)
[2024-03-19T11:47:59.613+01:00] [core] [info] protocols: registering protocol ('compression' (layers 6-6)
[2024-03-19T11:47:59.613+01:00] [core] [info] protocols: registering protocol ('BBDO' (layers 7-7)
[2024-03-19T11:47:59.613+01:00] [core] [info] modules: attempt to load module '/usr/share/centreon/lib/centreon-broker/50-tcp.so'
[2024-03-19T11:47:59.637+01:00] [core] [info] modules: attempt to load module '/usr/share/centreon/lib/centreon-broker/10-neb.so'
[2024-03-19T11:47:59.638+01:00] [core] [info] NEB: module for Centreon Broker 21.10.5
[2024-03-19T11:47:59.638+01:00] [core] [info] modules: attempt to load module '/usr/share/centreon/lib/centreon-broker/60-tls.so'
[2024-03-19T11:47:59.644+01:00] [core] [info] protocols: registering protocol ('TLS' (layers 5-5)
[2024-03-19T11:47:59.644+01:00] [core] [info] protocols: registering protocol ('TCP' (layers 1-4)
[2024-03-19T11:47:59.644+01:00] [core] [info] modules: attempt to load module '/usr/share/centreon/lib/centreon-broker/80-sql.so'
[2024-03-19T11:47:59.644+01:00] [core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/10-neb.so' which is already loaded
[2024-03-19T11:47:59.644+01:00] [core] [info] modules: attempt to load module '/usr/share/centreon/lib/centreon-broker/20-storage.so'
[2024-03-19T11:47:59.645+01:00] [core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/10-neb.so' which is already loaded
[2024-03-19T11:47:59.645+01:00] [core] [info] protocols: registering protocol ('storage' (layers 1-7)
[2024-03-19T11:47:59.645+01:00] [core] [info] protocols: registering protocol ('SQL' (layers 1-7)
[2024-03-19T11:47:59.645+01:00] [core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/20-storage.so' which is already loaded
[2024-03-19T11:47:59.645+01:00] [core] [info] modules: attempt to load module '/usr/share/centreon/lib/centreon-broker/15-stats.so'
[2024-03-19T11:47:59.659+01:00] [core] [info] Destroying muxer central-broker-master-input: number of events in the queue: 0
[2024-03-19T11:47:59.887+01:00] [core] [info] Available connections cleaning: Operation aborted.
[2024-03-19T11:47:59.895+01:00] [core] [info] New incoming connection 'central-broker-master-input-1'
[2024-03-19T11:48:00.251+01:00] [core] [info] multiplexing: engine started
[2024-03-19T11:48:00.600+01:00] [sql] [error] mysql_connection: could not store service: Out of range value for column 'notification_number' at row 1
[2024-03-19T11:48:00.601+01:00] [sql] [error] mysql_connection: could not store service: Out of range value for column 'notification_number' at row 1
[2024-03-19T11:48:00.603+01:00] [sql] [error] mysql_connection: could not store service: Out of range value for column 'notification_number' at row 1
[2024-03-19T11:48:00.605+01:00] [sql] [error] mysql_connection: could not store service: Out of range value for column 'notification_number' at row 1
[2024-03-19T11:48:00.620+01:00] [sql] [error] conflict_manager: error in the main loop: could not prepare insertion query for event 'host_group_member' in table 'hosts_hostgroups': could not store service: Out of range value for column 'notification_number' at row 1
[2024-03-19T11:48:00.758+01:00] [sql] [error] SQL: host group 18 does not exist - insertion before insertion of members
[2024-03-19T11:48:00.761+01:00] [sql] [error] SQL: host group 18 does not exist - insertion before insertion of members
[2024-03-19T11:48:00.763+01:00] [sql] [error] SQL: host group 18 does not exist - insertion before insertion of members
[2024-03-19T11:48:00.763+01:00] [sql] [error] SQL: host group 18 does not exist - insertion before insertion of members
[2024-03-19T11:48:00.765+01:00] [sql] [error] SQL: host group 18 does not exist - insertion before insertion of members
[2024-03-19T11:48:00.766+01:00] [sql] [error] SQL: host group 18 does not exist - insertion before insertion of members
[2024-03-19T11:48:01.306+01:00] [sql] [error] mysql_connection: could not store service: Out of range value for column 'notification_number' at row 1
[2024-03-19T11:48:01.306+01:00] [sql] [error] conflict_manager: error in the main loop: could not store service: Out of range value for column 'notification_number' at row 1
I’ve found and apply this URL… but I think that the table to fix is hosts_hostgroups; and I am not an expert mysql...can someone suggest me a fix?
Best answer by grydan
View original