Poller not running

Question

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?

grydan · Accepted Answer

Solved with this command:ALTER TABLE centreon_storage.services MODIFY notification_number bigint(20) DEFAULT NULL;ALTER TABLE centreon_storage.hosts MODIFY notification_number bigint(20) DEFAULT NULL;

Laurent · Answer

Hi @grydando you have retention in broker? maybe you delete hostgroup with ID 18 and broker try to update database but it fail.Maybe stop broker process (cbd), remove retention and restart cbd.

Reply

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded