Question

Mariadb bulk operations not supported

  • 10 August 2023
  • 13 replies
  • 157 views
P
Badge

Hello,

I am trying to run Centreon 23.04.6 on a Debian 11 server.

I followed instructions from documentation but it seems not to work normaly.

In log file /var/log/centreon-broker/central-broker-master.log  i can find a lot of errors as :

[2023-08-10T21:46:25.011+02:00] [sql] [error] connection fail to execute statement 0x7f3bd0023a20: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-08-10T21:46:25.011+02:00] [sql] [error] mysql_connection 0x7f3bd0023a20 attempts 2: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-08-10T21:46:25.012+02:00] [sql] [error] connection fail to execute statement 0x7f3bd0023a20: could not store service status:  errno=0 Server doesn't support function 'Bulk operation'
[2023-08-10T21:46:25.012+02:00] [sql] [error] mysql_connection 0x7f3bd0023a20 attempts 2: could not store service status:  errno=0 Server doesn't support function 'Bulk operation'
[2023-08-10T21:46:25.012+02:00] [sql] [error] connection fail to execute statement 0x7f3bd0023a20: could not store service status:  errno=0 Server doesn't support function 'Bulk operation'
[2023-08-10T21:46:25.012+02:00] [sql] [error] mysql_connection 0x7f3bd0023a20 attempts 2: could not store service status:  errno=0 Server doesn't support function 'Bulk operation'

Is it a known issue ?

Thanks for your help.

 

13 replies

S
Userlevel 1
Badge +6

Hi @patvad 

 

I have the same problem:

[2023-08-19T03:15:06.574-03:00] [sql] [error] connection fail to execute statement 0x7a609c009eb0: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-08-19T03:15:06.574-03:00] [sql] [error] mysql_connection 0x7a609c009eb0 attempts 2: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'

[2023-08-19T03:15:11.575-03:00] [sql] [error] connection fail to execute statement 0x7a609c009eb0: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-08-19T03:15:11.575-03:00] [sql] [error] mysql_connection 0x7a609c009eb0 attempts 2: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'


In my case, that started after a migration from a CentOS 7 with centreon 21.10 to a Debian Bullseye with version 23.04, following the guide https://docs.centreon.com/docs/migrate/migrate-from-el-to-debian/#step-3-retrieve-the-databases

 

Did you have any progress to fix this ?? 

Laurent
Rank
Userlevel 6
Badge +19

Hi, which DBMS do you use?

S
Userlevel 1
Badge +6

Hi,

 

In my case, first I have installed the version (10.05) mentioned on the documentation 

https://docs.centreon.com/docs/installation/installation-of-a-central-server/using-packages/#install-the-repositories

 

Then, I have tried to disable strict mode and the same… So, I revert this change.

After, I have upgrade it to the last version 10.11 and the same issue.

Finally, I have upgrade it to version 11.0 (11.0.3 is the version that Im current using ) and the error persists.

 

Any suggestion ??

Laurent
Rank
Userlevel 6
Badge +19

Hi,

Can you downgrade to supported MariaDB 10.5 version and enable Centreon Broker logs for SQL through “Configuration  >  Pollers  >  Broker configuration” menu, select “central-broker-master” definition, select info level for “sql”, Save and Generate/export configuration.

Then give use logs like: “Unified sql stream connected”

 

S
Userlevel 1
Badge +6

Hi,

Sorry, for the delay, had some issue making the downgrade.

Attached the logs in debug mode, I have waited for the issue happen twice on it.

I got a quick look, but can’t find anything strange.

Thanks and attentive.

mmm.. cant attached files on this forum !! :-( 

Have to cut the log in two, because the forum only allow 30.000 worlds !! :-(

[2023-08-29T14:58:26.787-03:00] [core] [info] main: configuration update requested
[2023-08-29T14:58:26.789-03:00] [core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/50-tcp.so' which is already loaded
[2023-08-29T14:58:26.789-03:00] [core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/20-unified_sql.so' which is already loaded
[2023-08-29T14:58:26.789-03:00] [core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/15-stats.so' which is already loaded
[2023-08-29T14:58:26.789-03:00] [core] [info] multiplexing: engine started
[2023-08-29T14:58:26.825-03:00] [sql] [info] unified_sql stream update
[2023-08-29T14:58:26.825-03:00] [sql] [info] unified_sql: starting DB cleanup
[2023-08-29T14:58:26.825-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00: run query: SELECT id FROM index_data WHERE to_delete=1
[2023-08-29T14:58:26.828-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00: run query: SELECT metric_id FROM metrics WHERE to_delete=1
[2023-08-29T14:58:26.835-03:00] [sql] [info] Something to remove?
[2023-08-29T14:58:26.835-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00: run query: SELECT id FROM index_data WHERE must_be_rebuild='1'
[2023-08-29T14:58:26.835-03:00] [sql] [info] Something to rebuild?
[2023-08-29T14:58:26.835-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:26.935-03:00] [sql] [info] SQL: processing service check event (host: 166, service: 1587, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=cpu --hostname=hhhhhhhh.xxxxxxx.cc --snmp-version='1' --snmp-community='hhhhhhhh'  --warning-average='80' --critical-average='90' )
[2023-08-29T14:58:26.935-03:00] [sql] [info] SQL: processing host check event (host: 159, command: /usr/lib/nagios/plugins/check_icmp -H xxx.xxx.x0.251 -w 3000.0,80% -c 5000.0,100% -p 1
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:28.340-03:00] [sql] [info] SQL: processing service status event (host: 82, service: 1108, last check: 1693331901, state (0, 1))
[2023-08-29T14:58:28.341-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:28.644-03:00] [sql] [info] SQL: processing service status event (host: 164, service: 1568, last check: 1693331904, state (0, 1))
[2023-08-29T14:58:28.646-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:28.725-03:00] [sql] [debug] Sending 58 perfdata on connection 0
[2023-08-29T14:58:28.725-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-08-29T14:58:28.725-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-08-29T14:58:28.725-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00: run query: INSERT INTO metrics (metric_id, unit_name, warn, warn_low, warn_threshold_mode, crit, crit_low, crit_threshold_mode, min, max, current_value) VALUES (6578,'b/s',NULL,NULL,'0',NULL,NULL,'0',0,NULL,1590.45),(6577,'b/s',8000000,0,'0',9000000,0,'0',0,10000000,7264777.79),(6576,'b/s',8000000,0,'0',9000000,0,'0',0,10000000,7264777.79),(2063,'B',92064301711,0,'0',96249042698,0,'0',0,104618524672,43532279808),(583,'s',NULL,NULL,'0',NULL,NULL,'0',0,10,0.00111),(3777,'B',NULL,NULL,'0',NULL,NULL,'0',0,NULL,13172736),(3776,'%',NULL,NULL,'0',NULL,NULL,'0',0,100,36.58),(2168,'B',9208339824,0,'0',9626900725,0,'0',0,10464022528,6081945600),(1165,'IO/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,3.6),(3775,'B',NULL,NULL,'0',NULL,NULL,'0',0,520945664,330366976),(353,'%',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,37),(5196,'b/s',NULL,NULL,'0',NULL,NULL,'0',0,NULL,28853.97),(1164,'IO/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,293),(5195,'b/s',8000000,0,'0',9000000,0,'0',0,10000000,56479.31),(1338,'Bits/s',800000000,0,'0',900000000,0,'0',0,1000000000,231106.1),(514,'B',NULL,NULL,'0',NULL,NULL,'0',0,520945664,190578688),(1163,'MB/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.04),(3778,'B',NULL,NULL,'0',NULL,NULL,'0',0,NULL,303235072),(5194,'b/s',8000000,0,'0',9000000,0,'0',0,10000000,56479.31),(1337,'Bits/s',800000000,0,'0',900000000,0,'0',0,1000000000,31330),(1162,'MB/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,13.59),(2379,'',2,0,'0',4,0,'0',0,NULL,0),(2263,'%',80,0,'0',90,0,'0',0,100,6),(4061,'ms',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.322),(6579,'b/s',NULL,NULL,'0',NULL,NULL,'0',0,NULL,6807.44),(3275,'%',NULL,NULL,'0',NULL,NULL,'0',0,100,6),(2377,'',4,0,'0',6,0,'0',0,NULL,0.01),(2318,'b/s',800000000,0,'0',900000000,0,'0',0,1000000000,163886.29),(7392,'ms',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.232),(5507,'B',NULL,NULL,'0',NULL,NULL,'0',0,NULL,72523776),(2316,'b/s',8000000,0,'0',9000000,0,'0',0,10000000,521405.71),(2317,'b/s',800000000,0,'0',900000000,0,'0',0,1000000000,84358.13),(7391,'ms',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,1.038),(4060,'ms',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.719),(2378,'',3,0,'0',5,0,'0',0,NULL,0.03),(5505,'B',NULL,NULL,'0',NULL,NULL,'0',0,959717376,549314560),(1166,'IO/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,296.6),(5197,'b/s',NULL,NULL,'0',NULL,NULL,'0',0,NULL,26282.93),(2315,'b/s',8000000,0,'0',9000000,0,'0',0,10000000,521405.71),(7389,'ms',200,0,'0',400,0,'0',0,NULL,0.411),(3965,'B',NULL,NULL,'0',NULL,NULL,'0',0,959717376,410402816) ON DUPLICATE KEY UPDATE unit_name=VALUES(unit_name), warn=VALUES(warn), warn_low=VALUES(warn_low), warn_threshold_mode=VALUES(warn_threshold_mode), crit=VALUES(crit), crit_low=VALUES(crit_low), crit_threshold_mode=VALUES(crit_threshold_mode), min=VALUES(min), max=VALUES(max), current_value=VALUES(current_value)
[2023-08-29T14:58:28.725-03:00] [sql] [debug] 27 new logs inserted
[2023-08-29T14:58:28.725-03:00] [sql] [debug] SQL: 27 items sent in bulk
[2023-08-29T14:58:28.727-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00: run query: INSERT INTO logs (ctime,host_id,service_id,host_name,instance_name,type,msg_type,notification_cmd,notification_contact,retry,service_description,status,output) VALUES (1693331900,34,745,'TTT-TTT-TTT,'TTT',1,0,'','',1,'UPS LineVolt',0,'OK - Line Voltage:  Volts'),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Need reload.'),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Reloading...'),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Starting to reload configuration.'),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Reading main configuration file \'/etc/centreon-engine/centengine.cfg\'.'),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/hostTemplates.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/hosts.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/serviceTemplates.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/services.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/commands.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/contactgroups.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/contacts.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/hostgroups.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/servicegroups.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/timeperiods.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/escalations.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/dependencies.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/connectors.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/meta_commands.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/meta_timeperiod.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/meta_host.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/meta_services.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/tags.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/severities.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Reading resource file \'/etc/centreon-engine/resource.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Configuration reloaded, main loop continuing.'),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Reload configuration finished.')
[2023-08-29T14:58:28.747-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:28.949-03:00] [sql] [info] SQL: processing service check event (host: 123, service: 238, command: /usr/lib/nagios/plugins/check_apcupsd_ng -h xxx.xxx.x0.254 -w 210 -c 235 linev)
[2023-08-29T14:58:29.809-03:00] [sql] [debug] unified sql: checking for outdated instances instance_timeout=300
[2023-08-29T14:58:30.352-03:00] [sql] [info] SQL: processing service status event (host: 78, service: 799, last check: 1693331905, state (0, 1))
[2023-08-29T14:58:30.354-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:30.455-03:00] [sql] [info] SQL: processing poller status event (id: 2, last alive: 1693331910)
[2023-08-29T14:58:30.457-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:30.558-03:00] [sql] [info] processing host status event (host: 35, last check: 1693331905, state (0, 1))
[2023-08-29T14:58:30.559-03:00] [sql] [info] processing host status event (host: 35, last check: 1693331905, state (0, 1))
[2023-08-29T14:58:30.559-03:00] [sql] [info] SQL: processing service status event (host: 34, service: 740, last check: 1693331901, state (0, 1))
[2023-08-29T14:58:30.561-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:30.563-03:00] [sql] [info] SQL: processing poller status event (id: 2, last alive: 1693331910)
[2023-08-29T14:58:30.564-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:31.367-03:00] [sql] [info] SQL: processing host check event (host: 165, command: /usr/lib/nagios/plugins/check_tcp -H xxxxxxxxx.xxxxxxxxx.mmm -p 80 -w 2 -c 4
[2023-08-29T14:58:31.969-03:00] [sql] [info] SQL: processing service check event (host: 166, service: 1584, command: /usr/lib/nagios/plugins/check_hhhhhhhh.sh -H hhhhhhhh.xxxxxxx.cc -M99 -m98)
[2023-08-29T14:58:32.370-03:00] [sql] [info] SQL: processing poller status event (id: 6, last alive: 1693331912)
[2023-08-29T14:58:32.371-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:32.773-03:00] [sql] [info] SQL: processing service status event (host: 152, service: 1433, last check: 1693331904, state (0, 1))
[2023-08-29T14:58:32.775-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:32.877-03:00] [sql] [info] SQL: processing service status event (host: 88, service: 1336, last check: 1693331904, state (0, 1))
[2023-08-29T14:58:32.877-03:00] [sql] [info] SQL: processing service status event (host: 146, service: 1411, last check: 1693331899, state (0, 1))
[2023-08-29T14:58:32.877-03:00] [sql] [info] SQL: processing host check event (host: 63, command: /usr/lib/nagios/plugins/check_icmp -H 200.10.208.4 -w 3000.0,80% -c 5000.0,100% -p 1
[2023-08-29T14:58:32.879-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:33.282-03:00] [sql] [info] SQL: processing service check event (host: 78, service: 797, command: /usr/lib/nagios/plugins/check_diskio_ucd -H localhost -d vda -w 100 -c 150 -C xxxxxxxxx -s 1)
[2023-08-29T14:58:34.785-03:00] [sql] [info] SQL: processing service check event (host: 88, service: 413, command: /usr/lib/nagios/plugins/check_icmp -H 200.10.208.253 -n 5 -w 200,20% -c 400,50% )
[2023-08-29T14:58:34.985-03:00] [sql] [info] SQL: processing service check event (host: 55, service: 944, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=cpu --hostname=vpn --snmp-version='1' --snmp-community='xxxxxxxxx'  --warning-average='80' --critical-average='90' )
[2023-08-29T14:58:35.787-03:00] [sql] [info] SQL: processing service check event (host: 58, service: 388, command: /usr/lib/nagios/plugins/check_diskio_ucd -H 200.10.208.3 -d drbd1 -w 100 -c 200 -C xxxxxxxxx -s 1)
[2023-08-29T14:58:35.887-03:00] [sql] [info] SQL: processing service check event (host: 51, service: 265, command: /usr/lib/nagios/plugins/check_icmp -H 10.0.0.10 -n 3 -w 200,20% -c 400,50% )
[2023-08-29T14:58:35.987-03:00] [sql] [info] processing host status event (host: 159, last check: 1693331906, state (0, 1))
[2023-08-29T14:58:35.988-03:00] [sql] [info] SQL: processing service status event (host: 166, service: 1587, last check: 1693331906, state (0, 1))
[2023-08-29T14:58:35.988-03:00] [sql] [info] SQL: processing service status event (host: 123, service: 238, last check: 1693331908, state (0, 1))
[2023-08-29T14:58:35.988-03:00] [sql] [info] SQL: processing service status event (host: 166, service: 1584, last check: 1693331911, state (0, 1))
[2023-08-29T14:58:35.989-03:00] [sql] [info] SQL: processing service status event (host: 55, service: 944, last check: 1693331914, state (0, 1))
[2023-08-29T14:58:35.993-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:36.295-03:00] [sql] [info] SQL: processing poller status event (id: 2, last alive: 1693331916)
[2023-08-29T14:58:36.296-03:00] [sql] [info] SQL: processing poller status event (id: 6, last alive: 1693331916)
[2023-08-29T14:58:36.297-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:36.398-03:00] [sql] [info] SQL: processing service check event (host: 99, service: 657, command: /usr/lib/nagios/plugins/check_hhhhhhhh.sh -H hhhhhhhh.kkkkkkk.kkk -M99 -m98)
[2023-08-29T14:58:36.899-03:00] [sql] [info] SQL: processing poller status event (id: 4, last alive: 1693331916)
[2023-08-29T14:58:36.899-03:00] [sql] [info] SQL: processing service check event (host: 55, service: 224, command: /usr/lib/nagios/plugins/check_icmp -H vpn -n 3 -w 200,20% -c 400,50% )
[2023-08-29T14:58:36.900-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:37.101-03:00] [sql] [info] SQL: processing service check event (host: 48, service: 749, command: /usr/lib/nagios/plugins/check_nrpe -H kkkkkkk.kkkkkkk.kkk -n -c check_kkkkkkk_spell_checker)
[2023-08-29T14:58:37.903-03:00] [sql] [info] SQL: processing service check event (host: 159, service: 1502, command: /usr/lib/nagios/plugins/centreon_plugins.pl --plugin=apps::protocols::x509::plugin --custommode https --mode certificate --hostname=box.xxxxxxx.cc  --warning-status='%{expiration}  < 10' --critical-status='%{expiration}  < 5' --port=443)
[2023-08-29T14:58:38.304-03:00] [sql] [info] SQL: processing poller status event (id: 6, last alive: 1693331918)
[2023-08-29T14:58:38.304-03:00] [sql] [info] SQL: processing service status event (host: 168, service: 1615, last check: 1693331904, state (0, 1))
[2023-08-29T14:58:38.306-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:38.508-03:00] [sql] [info] processing host status event (host: 165, last check: 1693331911, state (0, 1))
[2023-08-29T14:58:38.509-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:38.611-03:00] [sql] [info] SQL: processing service check event (host: 93, service: 1465, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=load --hostname=xxx.xxx.x50.248 --snmp-version='1' --snmp-community='xxxxxxxxx'  --warning='4,3,2' --critical='6,5,4' )
[2023-08-29T14:58:38.726-03:00] [sql] [debug] Sending 47 perfdata on connection 0
[2023-08-29T14:58:38.726-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-08-29T14:58:38.726-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-08-29T14:58:38.727-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00: run query: INSERT INTO metrics (metric_id, unit_name, warn, warn_low, warn_threshold_mode, crit, crit_low, crit_threshold_mode, min, max, current_value) VALUES (7194,'MB/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.01),(6869,'"%',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,87.32),(7196,'IO/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.8),(1570,'b/s',8000000,0,'0',9000000,0,'0',0,10000000,1336300.53),(7197,'IO/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.8),(1571,'b/s',8000000,0,'0',9000000,0,'0',0,10000000,1336300.53),(1572,'b/s',NULL,NULL,'0',NULL,NULL,'0',0,NULL,130320.72),(1573,'b/s',NULL,NULL,'0',NULL,NULL,'0',0,NULL,63935.89),(1158,'MB/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.06),(1160,'IO/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,7.2),(6867,'%',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,12.67),(1161,'IO/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,7.2),(4097,'b/s',NULL,NULL,'0',NULL,NULL,'0',0,NULL,41320.93),(4098,'b/s',NULL,NULL,'0',NULL,NULL,'0',0,NULL,1547.81),(6853,'',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.04),(6831,'%',80,0,'0',90,0,'0',0,100,7),(6832,'%',NULL,NULL,'0',NULL,NULL,'0',0,100,7) ON DUPLICATE KEY UPDATE unit_name=VALUES(unit_name), warn=VALUES(warn), warn_low=VALUES(warn_low), warn_threshold_mode=VALUES(warn_threshold_mode), crit=VALUES(crit), crit_low=VALUES(crit_low), crit_threshold_mode=VALUES(crit_threshold_mode), min=VALUES(min), max=VALUES(max), current_value=VALUES(current_value)
[2023-08-29T14:58:39.012-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:39.113-03:00] [sql] [info] SQL: processing service check event (host: 52, service: 980, command: /usr/lib/nagios/plugins/check_centreon_ping -H ffff.ffffffff.ccc -n 3 -w 700,60% -c 1200,70%)
[2023-08-29T14:58:39.114-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:39.616-03:00] [sql] [info] SQL: processing service check event (host: 58, service: 384, command: /usr/lib/nagios/plugins/check_diskio_ucd -H 200.10.208.3 -d sda -w 100 -c 200 -C xxxxxxxxx -s 1)
[2023-08-29T14:58:39.817-03:00] [sql] [info] SQL: processing service check event (host: 46, service: 1272, command: /usr/lib/centreon/plugins/centreon_windows_snmp.pl --plugin=os::windows::snmp::plugin --mode=swap --hostname=xxx.xxx.x0.5 --snmp-version='2c' --snmp-community='xxxxxxxxx'  --warning='' --critical='' )
[2023-08-29T14:58:39.817-03:00] [sql] [info] SQL: processing service status event (host: 51, service: 265, last check: 1693331915, state (0, 1))
[2023-08-29T14:58:39.818-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:40.121-03:00] [sql] [info] SQL: processing service status event (host: 48, service: 749, last check: 1693331917, state (0, 1))
[2023-08-29T14:58:40.122-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:40.224-03:00] [sql] [info] SQL: processing service status event (host: 99, service: 657, last check: 1693331916, state (0, 1))
[2023-08-29T14:58:40.224-03:00] [sql] [info] SQL: processing log of poller 'TTT' generated at 1693331920 (type 0)
[2023-08-29T14:58:40.225-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:40.225-03:00] [sql] [info] SQL: processing poller status event (id: 2, last alive: 1693331920)
[2023-08-29T14:58:40.226-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:40.327-03:00] [sql] [info] SQL: processing service status event (host: 78, service: 797, last check: 1693331913, state (0, 1))
[2023-08-29T14:58:40.329-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:40.632-03:00] [sql] [info] SQL: processing service check event (host: 140, service: 1356, command: /usr/lib/nagios/plugins//check_by_ssh -E -H xxx.xxx.x50.251 -p 22 -C "/root/scripts/check_hpasm")
[2023-08-29T14:58:41.134-03:00] [sql] [info] SQL: processing service check event (host: 139, service: 1344, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=swap --hostname=xxx.xxx.x.201 --snmp-version='2c' --snmp-community='xxxxxxxxx'  --warning-usage-prct='' --critical-usage-prct='' )
[2023-08-29T14:58:41.234-03:00] [sql] [info] SQL: processing service check event (host: 139, service: 1342, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=load --hostname=xxx.xxx.x.201 --snmp-version='2c' --snmp-community='xxxxxxxxx'  --warning='4,3,2' --critical='6,5,4' )
[2023-08-29T14:58:41.234-03:00] [sql] [info] SQL: processing service check event (host: 139, service: 1350, command: /usr/lib/nagios/plugins/check_nginx_status.pl -H xxx.xxx.x.201)
[2023-08-29T14:58:41.635-03:00] [sql] [info] SQL: processing host check event (host: 58, command: /usr/lib/nagios/plugins/check_icmp -H 200.10.208.3 -w 3000.0,80% -c 5000.0,100% -p 1
[2023-08-29T14:58:42.137-03:00] [sql] [info] SQL: processing poller status event (id: 2, last alive: 1693331922)
[2023-08-29T14:58:42.138-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:42.239-03:00] [sql] [info] SQL: processing service check event (host: 48, service: 759, command: /usr/lib/centreon/plugins/centreon_plugins.pl --plugin=apps::protocols::x509::plugin --mode=validity --hostname=kkkkkkk.kkkkkkk.kkk --validity-mode=expiration --warning-date=@10  --critical-date=@5 --port=443)
[2023-08-29T14:58:42.239-03:00] [sql] [info] SQL: processing service check event (host: 99, service: 836, command: /usr/lib/centreon/plugins/centreon_plugins.pl --plugin=apps::protocols::x509::plugin --mode=validity --hostname=hhhhhhhh.kkkkkkk.kkk --validity-mode=expiration --warning-date=@10  --critical-date=@5 --port=443)
[2023-08-29T14:58:42.339-03:00] [sql] [info] SQL: processing service check event (host: 78, service: 610, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=swap --hostname=localhost --snmp-version='2c' --snmp-community='xxxxxxxxx'  --warning-usage-prct='' --critical-usage-prct='' )
[2023-08-29T14:58:42.339-03:00] [sql] [info] SQL: processing poller status event (id: 15, last alive: 1693331922)
[2023-08-29T14:58:42.340-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:42.541-03:00] [sql] [info] SQL: processing service check event (host: 78, service: 1574, command: /usr/lib/nagios/plugins/check_postgres.pl --action=custom_query  --query="SELECT COUNT (retrans_status) AS result,  COUNT (retrans_status) AS retrans_items FROM posinfo INNER JOIN client_info ON posinfo.id = client_info.id WHERE (receive_date > now() - interval '1' day) AND retrans_status NOT IN (1, 3, 10)" --warning=500 --critical=2000 --db=wgpsdb --dbuser=cmonitor --dbpass=iesoh3eezoong3Y)
[2023-08-29T14:58:42.642-03:00] [sql] [info] processing host status event (host: 63, last check: 1693331912, state (0, 1))
[2023-08-29T14:58:42.642-03:00] [sql] [info] SQL: processing service status event (host: 88, service: 413, last check: 1693331914, state (0, 1))
[2023-08-29T14:58:42.642-03:00] [sql] [info] SQL: processing service status event (host: 93, service: 1465, last check: 1693331918, state (0, 1))
[2023-08-29T14:58:42.642-03:00] [sql] [info] SQL: processing service status event (host: 58, service: 388, last check: 1693331915, state (0, 1))
[2023-08-29T14:58:42.645-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:42.746-03:00] [sql] [info] SQL: processing service status event (host: 140, service: 1356, last check: 1693331920, state (0, 1))
[2023-08-29T14:58:42.747-03:00] [sql] [info] processing host status event (host: 58, last check: 1693331921, state (0, 1))
[2023-08-29T14:58:42.747-03:00] [sql] [info] SQL: processing service check event (host: 58, service: 381, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=interfaces --hostname=200.10.208.3 --snmp-version='1' --snmp-community='xxxxxxxxx'  --interface='eth3' --name --add-status --add-traffic --critical-status='' --warning-in-traffic='80' --critical-in-traffic='90' --warning-out-traffic='80' --critical-out-traffic='90' --verbose)
[2023-08-29T14:58:42.748-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:42.849-03:00] [sql] [info] SQL: processing service check event (host: 159, service: 1500, command: /usr/lib/nagios/plugins/check_diskio_ucd -H xxx.xxx.x0.251 -d xvdb -w 100 -c 200 -C xxxxxxxxx -s 1)
[2023-08-29T14:58:43.351-03:00] [sql] [info] SQL: processing service check event (host: 82, service: 1103, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=cpu --hostname=wlocal-ramnode.zzzzzzzzz.mmm --snmp-version='1' --snmp-community='xxxxxxxxx'  --warning-average='90' --critical-average='95' )
[2023-08-29T14:58:43.652-03:00] [sql] [info] SQL: processing service check event (host: 70, service: 353, command: /usr/lib/nagios/plugins/check_http -H 200.10.208.108 -p 8080  -u http://www.google.ccc  -e 'HTTP/1.1 200 OK')
[2023-08-29T14:58:44.154-03:00] [sql] [info] SQL: processing service check event (host: 48, service: 751, command: /usr/lib/nagios/plugins/check_nrpe -H kkkkkkk.kkkkkkk.kkk -n -c check_kkkkkkk_load)
[2023-08-29T14:58:44.355-03:00] [sql] [info] SQL: processing poller status event (id: 1, last alive: 1693331924)
[2023-08-29T14:58:44.356-03:00] [sql] [info] SQL: processing poller status event (id: 6, last alive: 1693331924)
[2023-08-29T14:58:44.357-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:44.659-03:00] [sql] [info] SQL: processing service check event (host: 58, service: 379, command: /usr/lib/nagios/plugins/check_apcupsd_ng -h 200.10.208.3 -w 22 -c 15 timeleft)
[2023-08-29T14:58:45.061-03:00] [sql] [info] SQL: processing service check event (host: 137, service: 1332, command: /usr/lib/nagios/plugins/check_diskio_ucd -H xxx.xxx.x50.105 -d sda -w 100 -c 200 -C xxxxxxxxx -s 1)
[2023-08-29T14:58:45.262-03:00] [sql] [info] SQL: processing service status event (host: 52, service: 980, last check: 1693331919, state (0, 1))

 

S
Userlevel 1
Badge +6

Hi,

Sorry, for the delay, had some issue making the downgrade.

Attached the logs in debug mode, I have waited for the issue happen twice on it.

I got a quick look, but can’t find anything strange.

Thanks and attentive.

mmm.. cant attached files on this forum !! :-( 

Have to cut the log in two, because the forum only allow 30.000 worlds !! :-(
 

 



[2023-08-29T14:58:26.787-03:00] [core] [info] main: configuration update requested
[2023-08-29T14:58:26.789-03:00] [core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/50-tcp.so' which is already loaded
[2023-08-29T14:58:26.789-03:00] [core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/20-unified_sql.so' which is already loaded
[2023-08-29T14:58:26.789-03:00] [core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/15-stats.so' which is already loaded
[2023-08-29T14:58:26.789-03:00] [core] [info] multiplexing: engine started
[2023-08-29T14:58:26.825-03:00] [sql] [info] unified_sql stream update
[2023-08-29T14:58:26.825-03:00] [sql] [info] unified_sql: starting DB cleanup
[2023-08-29T14:58:26.825-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00: run query: SELECT id FROM index_data WHERE to_delete=1
[2023-08-29T14:58:26.828-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00: run query: SELECT metric_id FROM metrics WHERE to_delete=1
[2023-08-29T14:58:26.835-03:00] [sql] [info] Something to remove?
[2023-08-29T14:58:26.835-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00: run query: SELECT id FROM index_data WHERE must_be_rebuild='1'
[2023-08-29T14:58:26.835-03:00] [sql] [info] Something to rebuild?
[2023-08-29T14:58:26.835-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:26.935-03:00] [sql] [info] SQL: processing service check event (host: 166, service: 1587, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=cpu --hostname=hhhhhhhh.xxxxxxx.cc --snmp-version='1' --snmp-community='hhhhhhhh'  --warning-average='80' --critical-average='90' )
[2023-08-29T14:58:26.935-03:00] [sql] [info] SQL: processing host check event (host: 159, command: /usr/lib/nagios/plugins/check_icmp -H xxx.xxx.x0.251 -w 3000.0,80% -c 5000.0,100% -p 1
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:27.337-03:00] [sql] [info] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
[2023-08-29T14:58:28.340-03:00] [sql] [info] SQL: processing service status event (host: 82, service: 1108, last check: 1693331901, state (0, 1))
[2023-08-29T14:58:28.341-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:28.644-03:00] [sql] [info] SQL: processing service status event (host: 164, service: 1568, last check: 1693331904, state (0, 1))
[2023-08-29T14:58:28.646-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:28.725-03:00] [sql] [debug] Sending 58 perfdata on connection 0
[2023-08-29T14:58:28.725-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-08-29T14:58:28.725-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-08-29T14:58:28.725-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00: run query: INSERT INTO metrics (metric_id, unit_name, warn, warn_low, warn_threshold_mode, crit, crit_low, crit_threshold_mode, min, max, current_value) VALUES (6578,'b/s',NULL,NULL,'0',NULL,NULL,'0',0,NULL,1590.45),(6577,'b/s',8000000,0,'0',9000000,0,'0',0,10000000,7264777.79),(6576,'b/s',8000000,0,'0',9000000,0,'0',0,10000000,7264777.79),(2063,'B',92064301711,0,'0',96249042698,0,'0',0,104618524672,43532279808),(583,'s',NULL,NULL,'0',NULL,NULL,'0',0,10,0.00111),(3777,'B',NULL,NULL,'0',NULL,NULL,'0',0,NULL,13172736),(3776,'%',NULL,NULL,'0',NULL,NULL,'0',0,100,36.58),(2168,'B',9208339824,0,'0',9626900725,0,'0',0,10464022528,6081945600),(1165,'IO/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,3.6),(3775,'B',NULL,NULL,'0',NULL,NULL,'0',0,520945664,330366976),(353,'%',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,37),(5196,'b/s',NULL,NULL,'0',NULL,NULL,'0',0,NULL,28853.97),(1164,'IO/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,293),(5195,'b/s',8000000,0,'0',9000000,0,'0',0,10000000,56479.31),(1338,'Bits/s',800000000,0,'0',900000000,0,'0',0,1000000000,231106.1),(514,'B',NULL,NULL,'0',NULL,NULL,'0',0,520945664,190578688),(1163,'MB/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.04),(3778,'B',NULL,NULL,'0',NULL,NULL,'0',0,NULL,303235072),(5194,'b/s',8000000,0,'0',9000000,0,'0',0,10000000,56479.31),(1337,'Bits/s',800000000,0,'0',900000000,0,'0',0,1000000000,31330),(1162,'MB/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,13.59),(2379,'',2,0,'0',4,0,'0',0,NULL,0),(2263,'%',80,0,'0',90,0,'0',0,100,6),(4061,'ms',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.322),(6579,'b/s',NULL,NULL,'0',NULL,NULL,'0',0,NULL,6807.44),(3275,'%',NULL,NULL,'0',NULL,NULL,'0',0,100,6),(2377,'',4,0,'0',6,0,'0',0,NULL,0.01),(2318,'b/s',800000000,0,'0',900000000,0,'0',0,1000000000,163886.29),(7392,'ms',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.232),(5507,'B',NULL,NULL,'0',NULL,NULL,'0',0,NULL,72523776),(2316,'b/s',8000000,0,'0',9000000,0,'0',0,10000000,521405.71),(2317,'b/s',800000000,0,'0',900000000,0,'0',0,1000000000,84358.13),(7391,'ms',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,1.038),(4060,'ms',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.719),(2378,'',3,0,'0',5,0,'0',0,NULL,0.03),(5505,'B',NULL,NULL,'0',NULL,NULL,'0',0,959717376,549314560),(1166,'IO/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,296.6),(5197,'b/s',NULL,NULL,'0',NULL,NULL,'0',0,NULL,26282.93),(2315,'b/s',8000000,0,'0',9000000,0,'0',0,10000000,521405.71),(7389,'ms',200,0,'0',400,0,'0',0,NULL,0.411),(3965,'B',NULL,NULL,'0',NULL,NULL,'0',0,959717376,410402816) ON DUPLICATE KEY UPDATE unit_name=VALUES(unit_name), warn=VALUES(warn), warn_low=VALUES(warn_low), warn_threshold_mode=VALUES(warn_threshold_mode), crit=VALUES(crit), crit_low=VALUES(crit_low), crit_threshold_mode=VALUES(crit_threshold_mode), min=VALUES(min), max=VALUES(max), current_value=VALUES(current_value)
[2023-08-29T14:58:28.725-03:00] [sql] [debug] 27 new logs inserted
[2023-08-29T14:58:28.725-03:00] [sql] [debug] SQL: 27 items sent in bulk
[2023-08-29T14:58:28.727-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00: run query: INSERT INTO logs (ctime,host_id,service_id,host_name,instance_name,type,msg_type,notification_cmd,notification_contact,retry,service_description,status,output) VALUES (1693331900,34,745,'TTT-TTT-TTT,'TTT',1,0,'','',1,'UPS LineVolt',0,'OK - Line Voltage:  Volts'),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Need reload.'),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Reloading...'),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Starting to reload configuration.'),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Reading main configuration file \'/etc/centreon-engine/centengine.cfg\'.'),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/hostTemplates.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/hosts.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/serviceTemplates.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/services.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/commands.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/contactgroups.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/contacts.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/hostgroups.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/servicegroups.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/timeperiods.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/escalations.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/dependencies.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/connectors.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/meta_commands.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/meta_timeperiod.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/meta_host.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/meta_services.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/tags.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Processing object config file \'/etc/centreon-engine/severities.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Reading resource file \'/etc/centreon-engine/resource.cfg\''),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Configuration reloaded, main loop continuing.'),(1693331907,0,0,'','Central',0,5,'','',0,'',0,'Reload configuration finished.')
[2023-08-29T14:58:28.747-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:28.949-03:00] [sql] [info] SQL: processing service check event (host: 123, service: 238, command: /usr/lib/nagios/plugins/check_apcupsd_ng -h xxx.xxx.x0.254 -w 210 -c 235 linev)
[2023-08-29T14:58:29.809-03:00] [sql] [debug] unified sql: checking for outdated instances instance_timeout=300
[2023-08-29T14:58:30.352-03:00] [sql] [info] SQL: processing service status event (host: 78, service: 799, last check: 1693331905, state (0, 1))
[2023-08-29T14:58:30.354-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:30.455-03:00] [sql] [info] SQL: processing poller status event (id: 2, last alive: 1693331910)
[2023-08-29T14:58:30.457-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:30.558-03:00] [sql] [info] processing host status event (host: 35, last check: 1693331905, state (0, 1))
[2023-08-29T14:58:30.559-03:00] [sql] [info] processing host status event (host: 35, last check: 1693331905, state (0, 1))
[2023-08-29T14:58:30.559-03:00] [sql] [info] SQL: processing service status event (host: 34, service: 740, last check: 1693331901, state (0, 1))
[2023-08-29T14:58:30.561-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:30.563-03:00] [sql] [info] SQL: processing poller status event (id: 2, last alive: 1693331910)
[2023-08-29T14:58:30.564-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:31.367-03:00] [sql] [info] SQL: processing host check event (host: 165, command: /usr/lib/nagios/plugins/check_tcp -H xxxxxxxxx.xxxxxxxxx.mmm -p 80 -w 2 -c 4
[2023-08-29T14:58:31.969-03:00] [sql] [info] SQL: processing service check event (host: 166, service: 1584, command: /usr/lib/nagios/plugins/check_hhhhhhhh.sh -H hhhhhhhh.xxxxxxx.cc -M99 -m98)
[2023-08-29T14:58:32.370-03:00] [sql] [info] SQL: processing poller status event (id: 6, last alive: 1693331912)
[2023-08-29T14:58:32.371-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:32.773-03:00] [sql] [info] SQL: processing service status event (host: 152, service: 1433, last check: 1693331904, state (0, 1))
[2023-08-29T14:58:32.775-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:32.877-03:00] [sql] [info] SQL: processing service status event (host: 88, service: 1336, last check: 1693331904, state (0, 1))
[2023-08-29T14:58:32.877-03:00] [sql] [info] SQL: processing service status event (host: 146, service: 1411, last check: 1693331899, state (0, 1))
[2023-08-29T14:58:32.877-03:00] [sql] [info] SQL: processing host check event (host: 63, command: /usr/lib/nagios/plugins/check_icmp -H 200.10.208.4 -w 3000.0,80% -c 5000.0,100% -p 1
[2023-08-29T14:58:32.879-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:33.282-03:00] [sql] [info] SQL: processing service check event (host: 78, service: 797, command: /usr/lib/nagios/plugins/check_diskio_ucd -H localhost -d vda -w 100 -c 150 -C xxxxxxxxx -s 1)
[2023-08-29T14:58:34.785-03:00] [sql] [info] SQL: processing service check event (host: 88, service: 413, command: /usr/lib/nagios/plugins/check_icmp -H 200.10.208.253 -n 5 -w 200,20% -c 400,50% )
[2023-08-29T14:58:34.985-03:00] [sql] [info] SQL: processing service check event (host: 55, service: 944, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=cpu --hostname=vpn --snmp-version='1' --snmp-community='xxxxxxxxx'  --warning-average='80' --critical-average='90' )
[2023-08-29T14:58:35.787-03:00] [sql] [info] SQL: processing service check event (host: 58, service: 388, command: /usr/lib/nagios/plugins/check_diskio_ucd -H 200.10.208.3 -d drbd1 -w 100 -c 200 -C xxxxxxxxx -s 1)
[2023-08-29T14:58:35.887-03:00] [sql] [info] SQL: processing service check event (host: 51, service: 265, command: /usr/lib/nagios/plugins/check_icmp -H 10.0.0.10 -n 3 -w 200,20% -c 400,50% )
[2023-08-29T14:58:35.987-03:00] [sql] [info] processing host status event (host: 159, last check: 1693331906, state (0, 1))
[2023-08-29T14:58:35.988-03:00] [sql] [info] SQL: processing service status event (host: 166, service: 1587, last check: 1693331906, state (0, 1))
[2023-08-29T14:58:35.988-03:00] [sql] [info] SQL: processing service status event (host: 123, service: 238, last check: 1693331908, state (0, 1))
[2023-08-29T14:58:35.988-03:00] [sql] [info] SQL: processing service status event (host: 166, service: 1584, last check: 1693331911, state (0, 1))
[2023-08-29T14:58:35.989-03:00] [sql] [info] SQL: processing service status event (host: 55, service: 944, last check: 1693331914, state (0, 1))
[2023-08-29T14:58:35.993-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:36.295-03:00] [sql] [info] SQL: processing poller status event (id: 2, last alive: 1693331916)
[2023-08-29T14:58:36.296-03:00] [sql] [info] SQL: processing poller status event (id: 6, last alive: 1693331916)
[2023-08-29T14:58:36.297-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:36.398-03:00] [sql] [info] SQL: processing service check event (host: 99, service: 657, command: /usr/lib/nagios/plugins/check_hhhhhhhh.sh -H hhhhhhhh.kkkkkkk.kkk -M99 -m98)
[2023-08-29T14:58:36.899-03:00] [sql] [info] SQL: processing poller status event (id: 4, last alive: 1693331916)
[2023-08-29T14:58:36.899-03:00] [sql] [info] SQL: processing service check event (host: 55, service: 224, command: /usr/lib/nagios/plugins/check_icmp -H vpn -n 3 -w 200,20% -c 400,50% )
[2023-08-29T14:58:36.900-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:37.101-03:00] [sql] [info] SQL: processing service check event (host: 48, service: 749, command: /usr/lib/nagios/plugins/check_nrpe -H kkkkkkk.kkkkkkk.kkk -n -c check_kkkkkkk_spell_checker)
[2023-08-29T14:58:37.903-03:00] [sql] [info] SQL: processing service check event (host: 159, service: 1502, command: /usr/lib/nagios/plugins/centreon_plugins.pl --plugin=apps::protocols::x509::plugin --custommode https --mode certificate --hostname=box.xxxxxxx.cc  --warning-status='%{expiration}  < 10' --critical-status='%{expiration}  < 5' --port=443)
[2023-08-29T14:58:38.304-03:00] [sql] [info] SQL: processing poller status event (id: 6, last alive: 1693331918)
[2023-08-29T14:58:38.304-03:00] [sql] [info] SQL: processing service status event (host: 168, service: 1615, last check: 1693331904, state (0, 1))
[2023-08-29T14:58:38.306-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:38.508-03:00] [sql] [info] processing host status event (host: 165, last check: 1693331911, state (0, 1))
[2023-08-29T14:58:38.509-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:38.611-03:00] [sql] [info] SQL: processing service check event (host: 93, service: 1465, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=load --hostname=xxx.xxx.x50.248 --snmp-version='1' --snmp-community='xxxxxxxxx'  --warning='4,3,2' --critical='6,5,4' )
[2023-08-29T14:58:38.726-03:00] [sql] [debug] Sending 47 perfdata on connection 0
[2023-08-29T14:58:38.726-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-08-29T14:58:38.726-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-08-29T14:58:38.727-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00: run query: INSERT INTO metrics (metric_id, unit_name, warn, warn_low, warn_threshold_mode, crit, crit_low, crit_threshold_mode, min, max, current_value) VALUES (7194,'MB/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.01),(6869,'"%',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,87.32),(7196,'IO/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.8),(1570,'b/s',8000000,0,'0',9000000,0,'0',0,10000000,1336300.53),(7197,'IO/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.8),(1571,'b/s',8000000,0,'0',9000000,0,'0',0,10000000,1336300.53),(1572,'b/s',NULL,NULL,'0',NULL,NULL,'0',0,NULL,130320.72),(1573,'b/s',NULL,NULL,'0',NULL,NULL,'0',0,NULL,63935.89),(1158,'MB/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.06),(1160,'IO/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,7.2),(6867,'%',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,12.67),(1161,'IO/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,7.2),(4097,'b/s',NULL,NULL,'0',NULL,NULL,'0',0,NULL,41320.93),(4098,'b/s',NULL,NULL,'0',NULL,NULL,'0',0,NULL,1547.81),(6853,'',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.04),(6831,'%',80,0,'0',90,0,'0',0,100,7),(6832,'%',NULL,NULL,'0',NULL,NULL,'0',0,100,7) ON DUPLICATE KEY UPDATE unit_name=VALUES(unit_name), warn=VALUES(warn), warn_low=VALUES(warn_low), warn_threshold_mode=VALUES(warn_threshold_mode), crit=VALUES(crit), crit_low=VALUES(crit_low), crit_threshold_mode=VALUES(crit_threshold_mode), min=VALUES(min), max=VALUES(max), current_value=VALUES(current_value)
[2023-08-29T14:58:39.012-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:39.113-03:00] [sql] [info] SQL: processing service check event (host: 52, service: 980, command: /usr/lib/nagios/plugins/check_centreon_ping -H ffff.ffffffff.ccc -n 3 -w 700,60% -c 1200,70%)
[2023-08-29T14:58:39.114-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:39.616-03:00] [sql] [info] SQL: processing service check event (host: 58, service: 384, command: /usr/lib/nagios/plugins/check_diskio_ucd -H 200.10.208.3 -d sda -w 100 -c 200 -C xxxxxxxxx -s 1)
[2023-08-29T14:58:39.817-03:00] [sql] [info] SQL: processing service check event (host: 46, service: 1272, command: /usr/lib/centreon/plugins/centreon_windows_snmp.pl --plugin=os::windows::snmp::plugin --mode=swap --hostname=xxx.xxx.x0.5 --snmp-version='2c' --snmp-community='xxxxxxxxx'  --warning='' --critical='' )
[2023-08-29T14:58:39.817-03:00] [sql] [info] SQL: processing service status event (host: 51, service: 265, last check: 1693331915, state (0, 1))
[2023-08-29T14:58:39.818-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:40.121-03:00] [sql] [info] SQL: processing service status event (host: 48, service: 749, last check: 1693331917, state (0, 1))
[2023-08-29T14:58:40.122-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:40.224-03:00] [sql] [info] SQL: processing service status event (host: 99, service: 657, last check: 1693331916, state (0, 1))
[2023-08-29T14:58:40.224-03:00] [sql] [info] SQL: processing log of poller 'TTT' generated at 1693331920 (type 0)
[2023-08-29T14:58:40.225-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:40.225-03:00] [sql] [info] SQL: processing poller status event (id: 2, last alive: 1693331920)
[2023-08-29T14:58:40.226-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:40.327-03:00] [sql] [info] SQL: processing service status event (host: 78, service: 797, last check: 1693331913, state (0, 1))
[2023-08-29T14:58:40.329-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:40.632-03:00] [sql] [info] SQL: processing service check event (host: 140, service: 1356, command: /usr/lib/nagios/plugins//check_by_ssh -E -H xxx.xxx.x50.251 -p 22 -C "/root/scripts/check_hpasm")
[2023-08-29T14:58:41.134-03:00] [sql] [info] SQL: processing service check event (host: 139, service: 1344, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=swap --hostname=xxx.xxx.x.201 --snmp-version='2c' --snmp-community='xxxxxxxxx'  --warning-usage-prct='' --critical-usage-prct='' )
[2023-08-29T14:58:41.234-03:00] [sql] [info] SQL: processing service check event (host: 139, service: 1342, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=load --hostname=xxx.xxx.x.201 --snmp-version='2c' --snmp-community='xxxxxxxxx'  --warning='4,3,2' --critical='6,5,4' )
[2023-08-29T14:58:41.234-03:00] [sql] [info] SQL: processing service check event (host: 139, service: 1350, command: /usr/lib/nagios/plugins/check_nginx_status.pl -H xxx.xxx.x.201)
[2023-08-29T14:58:41.635-03:00] [sql] [info] SQL: processing host check event (host: 58, command: /usr/lib/nagios/plugins/check_icmp -H 200.10.208.3 -w 3000.0,80% -c 5000.0,100% -p 1
[2023-08-29T14:58:42.137-03:00] [sql] [info] SQL: processing poller status event (id: 2, last alive: 1693331922)
[2023-08-29T14:58:42.138-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:42.239-03:00] [sql] [info] SQL: processing service check event (host: 48, service: 759, command: /usr/lib/centreon/plugins/centreon_plugins.pl --plugin=apps::protocols::x509::plugin --mode=validity --hostname=kkkkkkk.kkkkkkk.kkk --validity-mode=expiration --warning-date=@10  --critical-date=@5 --port=443)
[2023-08-29T14:58:42.239-03:00] [sql] [info] SQL: processing service check event (host: 99, service: 836, command: /usr/lib/centreon/plugins/centreon_plugins.pl --plugin=apps::protocols::x509::plugin --mode=validity --hostname=hhhhhhhh.kkkkkkk.kkk --validity-mode=expiration --warning-date=@10  --critical-date=@5 --port=443)
[2023-08-29T14:58:42.339-03:00] [sql] [info] SQL: processing service check event (host: 78, service: 610, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=swap --hostname=localhost --snmp-version='2c' --snmp-community='xxxxxxxxx'  --warning-usage-prct='' --critical-usage-prct='' )
[2023-08-29T14:58:42.339-03:00] [sql] [info] SQL: processing poller status event (id: 15, last alive: 1693331922)
[2023-08-29T14:58:42.340-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:42.541-03:00] [sql] [info] SQL: processing service check event (host: 78, service: 1574, command: /usr/lib/nagios/plugins/check_postgres.pl --action=custom_query  --query="SELECT COUNT (retrans_status) AS result,  COUNT (retrans_status) AS retrans_items FROM posinfo INNER JOIN client_info ON posinfo.id = client_info.id WHERE (receive_date > now() - interval '1' day) AND retrans_status NOT IN (1, 3, 10)" --warning=500 --critical=2000 --db=wgpsdb --dbuser=cmonitor --dbpass=iesoh3eezoong3Y)
[2023-08-29T14:58:42.642-03:00] [sql] [info] processing host status event (host: 63, last check: 1693331912, state (0, 1))
[2023-08-29T14:58:42.642-03:00] [sql] [info] SQL: processing service status event (host: 88, service: 413, last check: 1693331914, state (0, 1))
[2023-08-29T14:58:42.642-03:00] [sql] [info] SQL: processing service status event (host: 93, service: 1465, last check: 1693331918, state (0, 1))
[2023-08-29T14:58:42.642-03:00] [sql] [info] SQL: processing service status event (host: 58, service: 388, last check: 1693331915, state (0, 1))
[2023-08-29T14:58:42.645-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:42.746-03:00] [sql] [info] SQL: processing service status event (host: 140, service: 1356, last check: 1693331920, state (0, 1))
[2023-08-29T14:58:42.747-03:00] [sql] [info] processing host status event (host: 58, last check: 1693331921, state (0, 1))
[2023-08-29T14:58:42.747-03:00] [sql] [info] SQL: processing service check event (host: 58, service: 381, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=interfaces --hostname=200.10.208.3 --snmp-version='1' --snmp-community='xxxxxxxxx'  --interface='eth3' --name --add-status --add-traffic --critical-status='' --warning-in-traffic='80' --critical-in-traffic='90' --warning-out-traffic='80' --critical-out-traffic='90' --verbose)
[2023-08-29T14:58:42.748-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:42.849-03:00] [sql] [info] SQL: processing service check event (host: 159, service: 1500, command: /usr/lib/nagios/plugins/check_diskio_ucd -H xxx.xxx.x0.251 -d xvdb -w 100 -c 200 -C xxxxxxxxx -s 1)
[2023-08-29T14:58:43.351-03:00] [sql] [info] SQL: processing service check event (host: 82, service: 1103, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=cpu --hostname=wlocal-ramnode.zzzzzzzzz.mmm --snmp-version='1' --snmp-community='xxxxxxxxx'  --warning-average='90' --critical-average='95' )
[2023-08-29T14:58:43.652-03:00] [sql] [info] SQL: processing service check event (host: 70, service: 353, command: /usr/lib/nagios/plugins/check_http -H 200.10.208.108 -p 8080  -u http://www.google.ccc  -e 'HTTP/1.1 200 OK')
[2023-08-29T14:58:44.154-03:00] [sql] [info] SQL: processing service check event (host: 48, service: 751, command: /usr/lib/nagios/plugins/check_nrpe -H kkkkkkk.kkkkkkk.kkk -n -c check_kkkkkkk_load)
[2023-08-29T14:58:44.355-03:00] [sql] [info] SQL: processing poller status event (id: 1, last alive: 1693331924)
[2023-08-29T14:58:44.356-03:00] [sql] [info] SQL: processing poller status event (id: 6, last alive: 1693331924)
[2023-08-29T14:58:44.357-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:44.659-03:00] [sql] [info] SQL: processing service check event (host: 58, service: 379, command: /usr/lib/nagios/plugins/check_apcupsd_ng -h 200.10.208.3 -w 22 -c 15 timeleft)
[2023-08-29T14:58:45.061-03:00] [sql] [info] SQL: processing service check event (host: 137, service: 1332, command: /usr/lib/nagios/plugins/check_diskio_ucd -H xxx.xxx.x50.105 -d sda -w 100 -c 200 -C xxxxxxxxx -s 1)
[2023-08-29T14:58:45.262-03:00] [sql] [info] SQL: processing service status event (host: 52, service: 980, last check: 1693331919, state (0, 1))


 

S
Userlevel 1
Badge +6

second part:

[2023-08-29T14:58:45.263-03:00] [sql] [info] SQL: processing service status event (host: 139, service: 1344, last check: 1693331921, state (0, 1))
[2023-08-29T14:58:45.263-03:00] [sql] [info] SQL: processing service status event (host: 139, service: 1342, last check: 1693331921, state (0, 1))
[2023-08-29T14:58:45.266-03:00] [sql] [info] SQL: processing service status event (host: 139, service: 1350, last check: 1693331921, state (0, 1))
[2023-08-29T14:58:45.267-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:45.369-03:00] [sql] [info] SQL: processing service status event (host: 78, service: 610, last check: 1693331922, state (0, 1))
[2023-08-29T14:58:45.371-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:45.473-03:00] [sql] [info] SQL: processing service status event (host: 48, service: 759, last check: 1693331922, state (0, 1))
[2023-08-29T14:58:45.473-03:00] [sql] [info] SQL: processing service status event (host: 99, service: 836, last check: 1693331922, state (0, 1))
[2023-08-29T14:58:45.473-03:00] [sql] [info] SQL: processing service status event (host: 48, service: 751, last check: 1693331924, state (1, 1))
[2023-08-29T14:58:45.476-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:45.879-03:00] [sql] [info] SQL: processing service status event (host: 55, service: 224, last check: 1693331916, state (0, 1))
[2023-08-29T14:58:45.879-03:00] [sql] [info] SQL: processing service status event (host: 159, service: 1502, last check: 1693331917, state (0, 1))
[2023-08-29T14:58:45.880-03:00] [sql] [info] SQL: processing service status event (host: 46, service: 1272, last check: 1693331919, state (0, 1))
[2023-08-29T14:58:45.882-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:46.285-03:00] [sql] [info] SQL: processing service check event (host: 72, service: 688, command: /usr/lib/nagios/plugins/check_icmp -H kkkkk.kkkkkkk.kkk -n 3 -w 200,20% -c 400,50% )
[2023-08-29T14:58:46.285-03:00] [sql] [info] SQL: processing service check event (host: 27, service: 671, command: /usr/lib/nagios/plugins/check_icmp -H zzzzz.kkkkkkk.kkk -n 3 -w 200,20% -c 400,50% )
[2023-08-29T14:58:46.285-03:00] [sql] [info] SQL: processing service check event (host: 34, service: 736, command: /usr/lib/nagios/plugins/check_apcupsd_ng -h xxx.xxx.x.254 -w 40 -c 20 bcharge)
[2023-08-29T14:58:46.286-03:00] [sql] [info] SQL: processing service check event (host: 31, service: 662, command: /usr/lib/nagios/plugins/check_centreon_snmp_remote_storage -H master.kkkkkkk.kkk -n -d C: -w 90 -c 95 -C xxxxxxxxx -v 1)
[2023-08-29T14:58:46.286-03:00] [sql] [info] SQL: processing service check event (host: 31, service: 659, command: /usr/lib/nagios/plugins/check_centreon_snmp_remote_storage -H master.kkkkkkk.kkk -n -d "Virtual Memory" -w 80 -c 90 -C xxxxxxxxx -v 1)
[2023-08-29T14:58:46.286-03:00] [sql] [info] SQL: processing service check event (host: 72, service: 1193, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=interfaces --hostname=kkkkk.kkkkkkk.kkk --snmp-version='1' --snmp-community='xxxxxxxxx'  --interface='.*' --name --add-status --add-traffic --critical-status='' --warning-in-traffic='80' --critical-in-traffic='90' --warning-out-traffic='80' --critical-out-traffic='90' --verbose)
[2023-08-29T14:58:46.286-03:00] [sql] [info] SQL: processing service check event (host: 72, service: 684, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=storage --hostname=kkkkk.kkkkkkk.kkk --snmp-version='1' --snmp-community='xxxxxxxxx'  --storage '/' --name --display-transform-src='' --display-transform-dst='' --warning-usage='80' --critical-usage='90' )
[2023-08-29T14:58:46.386-03:00] [sql] [info] SQL: processing poller status event (id: 6, last alive: 1693331926)
[2023-08-29T14:58:46.387-03:00] [sql] [info] SQL: processing service check event (host: 48, service: 1248, command: /usr/lib/nagios/plugins/check_diskio_ucd -H kkkkkkk.kkkkkkk.kkk -d xvda -w 100 -c 200 -C xxxxxxxxx -s 1)
[2023-08-29T14:58:46.387-03:00] [sql] [info] SQL: processing service check event (host: 72, service: 1191, command: /usr/lib/nagios/plugins/check_diskio_ucd -H kkkkk.kkkkkkk.kkk -d xvda -w 100 -c 200 -C xxxxxxxxx -s 1)
[2023-08-29T14:58:46.387-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:46.890-03:00] [sql] [info] SQL: processing service check event (host: 46, service: 198, command: /usr/lib/nagios/plugins/check_snmp_load.pl -H xxx.xxx.x0.5 -w 60 -c 90 -C xxxxxxxxx -f)
[2023-08-29T14:58:47.391-03:00] [sql] [info] SQL: processing service check event (host: 27, service: 676, command: /usr/lib/nagios/plugins/check_http -H zzzzz.kkkkkkk.kkk -p 8080  -u http://www.google.ccc  -e 'HTTP/1.1 200 OK')
[2023-08-29T14:58:47.692-03:00] [sql] [info] SQL: processing service check event (host: 137, service: 1330, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=interfaces --hostname=xxx.xxx.x50.105 --snmp-version='2c' --snmp-community='xxxxxxxxx'  --interface='.*' --name --add-status --add-traffic --critical-status='' --warning-in-traffic='80' --critical-in-traffic='90' --warning-out-traffic='80' --critical-out-traffic='90' --verbose)
[2023-08-29T14:58:47.692-03:00] [sql] [info] SQL: processing service check event (host: 29, service: 698, command: /usr/lib/nagios/plugins/check_centreon_snmp_cpu -H softland.kkkkkkk.kkk -v 1 -C xxxxxxxxx -c 80 -w 90)
[2023-08-29T14:58:47.692-03:00] [sql] [info] SQL: processing service check event (host: 29, service: 695, command: /usr/lib/nagios/plugins/check_centreon_snmp_remote_storage -H softland.kkkkkkk.kkk -n -d E: -w 90 -c 95 -C xxxxxxxxx -v 1)
[2023-08-29T14:58:47.692-03:00] [sql] [info] SQL: processing service check event (host: 48, service: 1246, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=storage --hostname=kkkkkkk.kkkkkkk.kkk --snmp-version='2c' --snmp-community='xxxxxxxxx'  --storage '/' --name --display-transform-src='' --display-transform-dst='' --warning-usage='80' --critical-usage='90' )
[2023-08-29T14:58:47.692-03:00] [sql] [info] SQL: processing service check event (host: 29, service: 1299, command: /usr/lib/centreon/plugins/centreon_windows_snmp.pl --plugin=os::windows::snmp::plugin --mode=interfaces --hostname=softland.kkkkkkk.kkk --snmp-version='1' --snmp-community='xxxxxxxxx'  --interface='.*' --name --add-status --add-traffic --critical-status='' --warning-in-traffic='80' --critical-in-traffic='90' --warning-out-traffic='80' --critical-out-traffic='90' --verbose --snmp-autoreduce)
[2023-08-29T14:58:48.294-03:00] [sql] [info] SQL: processing host check event (host: 163, command: /usr/lib/nagios/plugins/check_icmp -H 127.0.0.1 -w 3000.0,80% -c 5000.0,100% -p 1
[2023-08-29T14:58:48.294-03:00] [sql] [info] SQL: processing service status event (host: 82, service: 1103, last check: 1693331923, state (0, 1))
[2023-08-29T14:58:48.295-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:48.396-03:00] [sql] [info] SQL: processing poller status event (id: 2, last alive: 1693331928)
[2023-08-29T14:58:48.396-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:48.699-03:00] [sql] [info] SQL: processing service check event (host: 168, service: 1610, command: /usr/lib/nagios/plugins/check_icmp -H localhost -n 5 -w 200,20% -c 400,50% )
[2023-08-29T14:58:48.699-03:00] [sql] [info] SQL: processing service check event (host: 164, service: 1565, command: /usr/lib/nagios/plugins/check_nginx_status.pl -H ttttt.zzzzzzzzz.ccc)
[2023-08-29T14:58:48.727-03:00] [sql] [debug] Sending 92 perfdata on connection 0
[2023-08-29T14:58:48.727-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-08-29T14:58:48.727-03:00] [sql] [debug] 1 new logs inserted
[2023-08-29T14:58:48.727-03:00] [sql] [debug] SQL: 1 items sent in bulk
[2023-08-29T14:58:48.727-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-08-29T14:58:48.727-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00: run query: INSERT INTO metrics (metric_id, unit_name, warn, warn_low, warn_threshold_mode, crit, crit_low, crit_threshold_mode, min, max, current_value) VALUES (6811,'%',NULL,NULL,'0',NULL,NULL,'0',0,100,3),(2062,'%',90,0,'0',95,0,'0',0,100,1.5),(7229,'%',NULL,NULL,'0',NULL,NULL,'0',0,100,10.23),(1289,'%',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,83.5),(1276,'',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.18),(2708,'ms',700,0,'0',1200,0,'0',0,NULL,67.757),(1274,'',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.2),(7393,'ms',200,0,'0',400,0,'0',0,NULL,0.352),(1272,'',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,1),(7228,'B',NULL,NULL,'0',NULL,NULL,'0',0,2147479552,1927872512),(1269,'',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,94),(7417,'ms',200,0,'0',400,0,'0',0,NULL,0.412),(1275,'',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.2),(7420,'ms',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.253),(3349,'',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,3),(7301,'ms',200,0,'0',400,0,'0',0,NULL,0.33),(7419,'ms',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.629),(7395,'ms',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.903),(1554,'MB/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,1.09),(1287,'%',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,16.49),(3352,'',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.203333),(1268,'',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,570),(83,'B',NULL,NULL,'0',NULL,NULL,'0',0,2147479552,219607040),(1145,'s',NULL,NULL,'0',NULL,NULL,'0',0,10,0.001953),(1558,'IO/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,69.8),(3353,'',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,2.757291),(1143,'',1.5,0,'0',2.5,0,'0',0,NULL,1.78),(1556,'IO/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,43.2),(1144,'',1.5,0,'0',2.5,0,'0',0,NULL,1.58),(1557,'IO/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,26.6),(1142,'',1.5,0,'0',2.5,0,'0',0,NULL,1.8),(1555,'MB/s',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.12),(7396,'ms',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.195),(3313,'',4,0,'0',6,0,'0',0,NULL,0.04),(3314,'',3,0,'0',5,0,'0',0,NULL,0.09),(3315,'',2,0,'0',4,0,'0',0,NULL,0.14),(7303,'ms',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.396),(3350,'',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,4),(2112,'B',NULL,NULL,'0',NULL,NULL,'0',0,3136487424,1210187776),(7304,'ms',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.244),(3351,'',NULL,NULL,'0',NULL,NULL,'0',NULL,NULL,0.556667) ON DUPLICATE KEY UPDATE unit_name=VALUES(unit_name), warn=VALUES(warn), warn_low=VALUES(warn_low), warn_threshold_mode=VALUES(warn_threshold_mode), crit=VALUES(crit), crit_low=VALUES(crit_low), crit_threshold_mode=VALUES(crit_threshold_mode), min=VALUES(min), max=VALUES(max), current_value=VALUES(current_value)
[2023-08-29T14:58:48.730-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00: run query: INSERT INTO logs (ctime,host_id,service_id,host_name,instance_name,type,msg_type,notification_cmd,notification_contact,retry,service_description,status,output) VALUES (1693331920,99,657,'TTT-hhhhhhhh','TTT',1,0,'','',1,'hhhhhhhh',0,'OK')
[2023-08-29T14:58:48.899-03:00] [sql] [info] SQL: processing service check event (host: 55, service: 222, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=memory --hostname=vpn --snmp-version='1' --snmp-community='xxxxxxxxx'  --warning-usage='80' --critical-usage='90' )
[2023-08-29T14:58:48.900-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:49.402-03:00] [sql] [info] SQL: processing service check event (host: 26, service: 173, command: /usr/lib/nagios/plugins/check_disk -w 20 -c 30 -p /)
[2023-08-29T14:58:49.703-03:00] [sql] [info] SQL: processing service check event (host: 58, service: 377, command: /usr/lib/nagios/plugins/check_apcupsd_ng -h 200.10.208.3 -w 60 -c 80 loadpct)
[2023-08-29T14:58:49.904-03:00] [sql] [info] SQL: processing service check event (host: 27, service: 668, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=storage --hostname=zzzzz.kkkkkkk.kkk --snmp-version='2c' --snmp-community='xxxxxxxxx'  --storage '/' --name --display-transform-src='' --display-transform-dst='' --warning-usage='80' --critical-usage='90' )
[2023-08-29T14:58:50.405-03:00] [sql] [info] SQL: processing poller status event (id: 6, last alive: 1693331930)
[2023-08-29T14:58:50.405-03:00] [sql] [info] SQL: processing service status event (host: 72, service: 688, last check: 1693331926, state (0, 1))
[2023-08-29T14:58:50.406-03:00] [sql] [info] SQL: processing service status event (host: 27, service: 671, last check: 1693331926, state (0, 1))
[2023-08-29T14:58:50.407-03:00] [sql] [info] SQL: processing service status event (host: 34, service: 736, last check: 1693331926, state (0, 1))
[2023-08-29T14:58:50.407-03:00] [sql] [info] SQL: processing service status event (host: 31, service: 662, last check: 1693331926, state (0, 1))
[2023-08-29T14:58:50.408-03:00] [sql] [info] SQL: processing service status event (host: 31, service: 659, last check: 1693331926, state (0, 1))
[2023-08-29T14:58:50.409-03:00] [sql] [info] SQL: processing service status event (host: 72, service: 1193, last check: 1693331926, state (0, 1))
[2023-08-29T14:58:50.409-03:00] [sql] [info] SQL: processing service status event (host: 72, service: 684, last check: 1693331926, state (0, 1))
[2023-08-29T14:58:50.410-03:00] [sql] [info] SQL: processing service status event (host: 27, service: 676, last check: 1693331927, state (0, 1))
[2023-08-29T14:58:50.411-03:00] [sql] [info] SQL: processing service status event (host: 48, service: 1246, last check: 1693331927, state (0, 1))
[2023-08-29T14:58:50.411-03:00] [sql] [info] SQL: processing service status event (host: 29, service: 698, last check: 1693331927, state (0, 1))
[2023-08-29T14:58:50.412-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:50.613-03:00] [sql] [info] SQL: processing service status event (host: 29, service: 1299, last check: 1693331927, state (0, 1))
[2023-08-29T14:58:50.614-03:00] [sql] [info] SQL: processing service status event (host: 26, service: 173, last check: 1693331929, state (0, 1))
[2023-08-29T14:58:50.615-03:00] [sql] [info] SQL: processing service status event (host: 27, service: 668, last check: 1693331929, state (0, 1))
[2023-08-29T14:58:50.616-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:50.618-03:00] [sql] [info] SQL: processing poller status event (id: 2, last alive: 1693331930)
[2023-08-29T14:58:50.619-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:50.720-03:00] [sql] [info] SQL: processing service check event (host: 78, service: 608, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=load --hostname=localhost --snmp-version='2c' --snmp-community='xxxxxxxxx'  --warning='4,3,2' --critical='6,5,4' )
[2023-08-29T14:58:52.424-03:00] [sql] [info] SQL: processing service check event (host: 26, service: 165, command: /usr/lib/centreon/plugins/centreon_linux_snmp.pl --plugin=os::linux::snmp::plugin --mode=storage --hostname=127.0.0.1 --snmp-version='1' --snmp-community='xxxxxxxxx'  --storage '/' --name --display-transform-src='' --display-transform-dst='' --warning-usage='80' --critical-usage='90' )
[2023-08-29T14:58:52.725-03:00] [sql] [info] SQL: processing service status event (host: 58, service: 381, last check: 1693331922, state (0, 1))
[2023-08-29T14:58:52.725-03:00] [sql] [info] SQL: processing service status event (host: 70, service: 353, last check: 1693331923, state (0, 1))
[2023-08-29T14:58:52.726-03:00] [sql] [info] SQL: processing service status event (host: 58, service: 379, last check: 1693331924, state (0, 1))
[2023-08-29T14:58:52.726-03:00] [sql] [info] SQL: processing service status event (host: 58, service: 384, last check: 1693331919, state (0, 1))
[2023-08-29T14:58:52.728-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:52.830-03:00] [sql] [info] SQL: processing service status event (host: 137, service: 1330, last check: 1693331927, state (0, 1))
[2023-08-29T14:58:52.831-03:00] [sql] [info] SQL: processing service status event (host: 58, service: 377, last check: 1693331929, state (0, 1))
[2023-08-29T14:58:52.831-03:00] [sql] [info] SQL: processing service status event (host: 137, service: 1332, last check: 1693331924, state (0, 1))
[2023-08-29T14:58:52.833-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:53.236-03:00] [sql] [info] SQL: processing service check event (host: 165, service: 1577, command: /usr/lib/nagios/plugins/check_http -S -H xxxxxxxxx.xxxxxxxxx.mmm -u "/api/consulta/18273637-3c7c-4b7e-930e-428e6e1694df")
[2023-08-29T14:58:53.437-03:00] [sql] [info] SQL: processing service check event (host: 48, service: 752, command: /usr/lib/nagios/plugins/check_nrpe -H kkkkkkk.kkkkkkk.kkk -n -c check_kkkkkkk_pop3s_real)
[2023-08-29T14:58:54.340-03:00] [sql] [info] processing host status event (host: 163, last check: 1693331928, state (0, 1))
[2023-08-29T14:58:54.341-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:54.443-03:00] [sql] [info] SQL: processing poller status event (id: 2, last alive: 1693331934)
[2023-08-29T14:58:54.444-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:54.746-03:00] [sql] [info] SQL: processing poller status event (id: 5, last alive: 1693331934)
[2023-08-29T14:58:54.747-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:55.450-03:00] [sql] [info] SQL: processing service status event (host: 78, service: 608, last check: 1693331930, state (0, 1))
[2023-08-29T14:58:55.451-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit
[2023-08-29T14:58:55.453-03:00] [sql] [info] SQL: processing service status event (host: 48, service: 1248, last check: 1693331926, state (0, 1))
[2023-08-29T14:58:55.453-03:00] [sql] [info] SQL: processing service status event (host: 26, service: 165, last check: 1693331932, state (1, 1))
[2023-08-29T14:58:55.453-03:00] [sql] [info] SQL: processing service status event (host: 29, service: 695, last check: 1693331927, state (0, 1))
[2023-08-29T14:58:55.454-03:00] [sql] [info] SQL: processing service status event (host: 72, service: 1191, last check: 1693331926, state (0, 1))
[2023-08-29T14:58:55.456-03:00] [sql] [debug] mysql_connection 0x77b9e8022d00 : commit


 

Laurent
Rank
Userlevel 6
Badge +19

Thank you for feedback, can you execute:

cat /var/log/centreon-broker/central-broker-master.log | grep stream

And give us the result?

S
Userlevel 1
Badge +6

Hi, 

 

there is no important information with the string “stream”, that was one of the reasons why I put the log in debug and not in info yesterday.. here the requested output in any case:

 

cat /var/log/centreon-broker/central-broker-master.log | grep stream
[2023-08-29T14:49:12.548-03:00] [sql] [info] unified_sql stream update
[2023-08-29T14:52:52.147-03:00] [sql] [info] unified_sql stream update
[2023-08-29T14:58:26.825-03:00] [sql] [info] unified_sql stream update
[2023-08-29T23:22:01.774-03:00] [core] [info] bbdo stream stopped with 0 events acknowledged
[2023-08-30T02:22:03.782-03:00] [core] [info] bbdo stream stopped with 0 events acknowledged
[2023-08-30T02:22:04.184-03:00] [core] [info] bbdo stream stopped with 0 events acknowledged
[2023-08-30T02:22:05.689-03:00] [core] [info] bbdo stream stopped with 0 events acknowledged
[2023-08-30T03:22:00.979-03:00] [core] [info] bbdo stream stopped with 0 events acknowledged

 

note: Today I have reverted the logs to error, but the output include the logs from yesterday when the SQL was in debug mode.

 

Attentive

S
Userlevel 1
Badge +6

Hi, 

 

looks like some of it is OK, but there is still some packages (centreon-connector-* and maybe others) pointing to the incorrect URL:

 

$ curl -i https://packages.centreon.com/apt-standard-23.04-stable/pool/centreon-connector-perl_23.04.2-1_amd64.deb
HTTP/1.1 302 
Date: Wed, 30 Aug 2023 09:27:20 GMT
Transfer-Encoding: chunked
Connection: keep-alive
X-JFrog-Version: Artifactory/7.67.3 76703900
X-Artifactory-Id: a10350b8a8ad316e216d93cbbdbcb7e3a4d2d933
X-Artifactory-Node-Id: a0jsjjoltk1hi-artifactory-primary-1
Location: https://jfrog-prod-euw1-shared-ireland-main.s3.amazonaws.com/aol-a0jsjjoltk1hi/filestore/78/78c2b51b026f027bad09971e970d233fea4b9845?X-Artifactory-username=anonymous&X-Artifactory-repoType=local&X-Artifactory-repositoryKey=apt-standard-23.04-stable&X-Artifactory-packageType=debian&X-Artifactory-artifactPath=pool%2Fcentreon-connector-perl_23.04.2-1_amd64.deb&X-Artifactory-projectKey=default&x-jf-traceId=c91b2ee09516dce&response-content-disposition=attachment%3Bfilename%3D%22centreon-connector-perl_23.04.2-1_amd64.deb%22&response-content-type=application%2Fx-debian-package&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEPL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQDtmIcywl3h2F9%2BkP4NcI%2BI23krtOxChCe2GhXViT7K1gIhAJ8R23TrI3BcH3D4rYld5E8O8mipjoApOZnzhMjzYTJGKpkFCLr%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQABoMMTUyMTUzMDYyMTQxIgxY7yiqsJLreJ3z%2Bccq7QQv7s3%2FLcG7MrYcemWAWj%2F62d%2BwzKPSJzhWKNjh7qJ0Ek5APGSYWrw2mLiWWuSFNLgi0iSk%2F%2BdOwBOazSV7mlg2XZUSwT%2FzfRdc%2BoC90o8SLucWB8g%2Fxbkw09eOBAbMncGxfReq4Ci4IKY%2BV%2BBRRzBhOmq%2Bhj3dB%2FA2%2Fo8XdzebpvXIwbXuyBY%2BihwuFwlWOi1FKnFvYORlRosxSp9ROh9wrqP3NpsKdKNkY%2B3xO7ok1vtjUiFyeOK0fqoWL70NoY8aqZb%2BAhUmCtNEGwTS9w2naa0dpWDYZ0KikV3RUJRNKlOqtHoxBaM7Hj2G3dsvA5y%2F7TrhtTkWRVB%2BMSJ54YP7hKAjYB5O2fzeUA2LzoZql4TBtRGLwSdoJR9CtJesbV7DrDVW4uLecYQCUjzpcO%2FfXkLP4lHcflQbs7Cxt%2F2IFNxjTNnlAcSichCyq%2BXrzNcjm69WnjUlQLH%2BjppEzdCzn0udJOJWKOxhyf0r359Da%2FYg76cIFH2sKyKvF4dghiOWRb4Iaqy6LCpbQ6E6keDUn2aauNYLPRFrQQ7XzyYdz3EbVC5dYnePOpfGhx8ekd9pzdSVu2SLZZlLVcGHIVeoIBQB1sNGBwrjmAb6gfSCuIJ2ygrx81LAYyOlCeM%2F1qjvukmIilNj65sLYho2zYPkjHE2fbK0EFMf8LfQcbS9NH6rbzCkHYjh%2FOeKMLE5mbmJ01AHOaKc4ekOxfun8wmuzhndckyxbZUT%2FEY9z45ozODMAHkKTO%2F6142p7StzK%2FyfRN2HQjDqAaacThRk3NGWA7BgEtDtkByaC%2BeoK4u0gJOueRCHMIr9FcqAl8Yw15K8pwY6mgFe03ye1jsK24IgzGSMHhGeYZOfIUiMDy0wkfD623ZucAHsucEwez37Zbfv4pkZeKgwbeKvSBL1%2B6QtZ5TU%2B9E262uUQc8BtUVXec0X47cB50CyKIv%2FbtMMYWblrQs%2BmmO3k%2BAfxKpi1CyOyauptcKZEV7BeGmP%2BURm5naGF%2Fgp4kVLE9zvn3lPuqY2XhigcAhBndtDXrHgQt9J&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20230830T092720Z&X-Amz-SignedHeaders=host&X-Amz-Expires=59&X-Amz-Credential=ASIASG3IHPL63F2IZLNN%2F20230830%2Feu-west-1%2Fs3%2Faws4_request&X-Amz-Signature=b34d085e41a92a0ffa3fc88d04a6ff16efd0f73a9e7e40f0dccaef618f9b5731
Strict-Transport-Security: max-age=31536000; includeSubDomains
X-Request-ID: 49162ee88c7f2d2a66492b86544fdb36





$ curl -i https://packages.centreon.com/apt-plugins-stable/pool/centreon-plugin-applications-protocol-ftp_20230810-100132_all.deb
HTTP/1.1 200 
Date: Wed, 30 Aug 2023 09:28:03 GMT
Content-Type: application/x-debian-package
Content-Length: 57992
Connection: keep-alive
X-JFrog-Version: Artifactory/7.67.3 76703900
X-Artifactory-Id: a10350b8a8ad316e216d93cbbdbcb7e3a4d2d933
X-Artifactory-Node-Id: a0jsjjoltk1hi-artifactory-primary-1
Last-Modified: Thu, 10 Aug 2023 10:21:06 GMT
ETag: 27ea4a6a8aba9daa3c9086890e818572ab752b93
X-Checksum-Sha1: 27ea4a6a8aba9daa3c9086890e818572ab752b93
X-Checksum-Sha256: 18b528915723a338e6c73a258226e57fb757081982b497e388177707331be67c
X-Checksum-Md5: d236c9d04dbec33ec5cc2e1e95310132
Accept-Ranges: bytes
X-Artifactory-Filename: centreon-plugin-applications-protocol-ftp_20230810-100132_all.deb
Content-Disposition: attachment; filename="centreon-plugin-applications-protocol-ftp_20230810-100132_all.deb"; filename*=UTF-8''centreon-plugin-applications-protocol-ftp_20230810-100132_all.deb
Strict-Transport-Security: max-age=31536000; includeSubDomains
X-Request-ID: 20ded92e87d22fe74f73926bbf481029

 

Here the logs from the proxy too:

1693386848.830   1767 200.10.208.95 TCP_TUNNEL/200 88878 CONNECT packages.centreon.com:443 - HIER_DIRECT/54.195.120.211 -
1693386888.544   1468 200.10.208.95 TCP_TUNNEL/200 63930 CONNECT packages.centreon.com:443 - HIER_DIRECT/54.195.120.211 -
1693386937.554   3660 200.10.208.95 TCP_TUNNEL/200 1327957 CONNECT jfrog-prod-euw1-shared-ireland-main.s3.amazonaws.com:443 - HIER_DIRECT/52.218.44.241 -
1693386937.555   5192 200.10.208.95 TCP_TUNNEL/200 6285 CONNECT packages.centreon.com:443 - HIER_DIRECT/54.155.195.212 -
1693386953.103   1773 200.10.208.95 TCP_TUNNEL/200 246009 CONNECT jfrog-prod-euw1-shared-ireland-main.s3.amazonaws.com:443 - HIER_DIRECT/52.218.44.241 -
1693386953.105   2801 200.10.208.95 TCP_TUNNEL/200 6294 CONNECT packages.centreon.com:443 - HIER_DIRECT/54.155.195.212 -

 

Laurent
Rank
Userlevel 6
Badge +19

Hi, are you using MariaDB from official repo or a custom one?

S
Userlevel 1
Badge +6

Hi,

 

like commented before, I have installed the centreon using theses instructions:

https://docs.centreon.com/docs/installation/installation-of-a-central-server/using-packages/#install-the-repositories

in a new server (debian 11) and after the installation, I have migrate de old database to this new server using theses others instructions:

https://docs.centreon.com/docs/migrate/migrate-from-el-to-debian/

 

here the content of my apt source

$ cat /etc/apt/sources.list.d/mariadb.list

# MariaDB Server
# To use a different major version of the server, or to pin to a specific minor version, change URI below.
deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.5/repo/debian bullseye main


# MariaDB MaxScale
# To use the latest stable release of MaxScale, use "latest" as the version
# To use the latest beta (or stable if no current beta) release of MaxScale, use "beta" as the version
deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/maxscale/latest/apt bullseye main


# MariaDB Tools
deb [arch=amd64] http://downloads.mariadb.com/Tools/debian bullseye main

 

and my mysql configuration’s don’t have any change from the original:
 

# for f in `find /etc/mysql -type f` ; do echo "filename: $f"; cat $f | grep -v \#  | grep [a-z] ; done

#filename: /etc/mysql/mariadb.cnf
[client-server]
socket = /run/mysqld/mysqld.sock
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/


#filename: /etc/mysql/my.cnf.fallback
!includedir /etc/mysql/conf.d/


#filename: /etc/mysql/mariadb.conf.d/50-mariadb-clients.cnf
[mariadb-client]
[mariadb-upgrade]
[mariadb-admin]
[mariadb-binlog]
[mariadb-check]
[mariadb-dump]
[mariadb-import]
[mariadb-show]
[mariadb-slap]


#filename: /etc/mysql/mariadb.conf.d/50-server.cnf
[server]
[mariadbd]
pid-file                = /run/mysqld/mysqld.pid
basedir                 = /usr
bind-address            = 127.0.0.1
expire_logs_days        = 10
character-set-server  = utf8mb4
collation-server      = utf8mb4_general_ci
[embedded]
[mariadbd]
[mariadb-11.0]


#filename: /etc/mysql/mariadb.conf.d/80-centreon.cnf
[server]
innodb_file_per_table=1
open_files_limit = 32000
key_buffer_size = 256M
sort_buffer_size = 32M
join_buffer_size = 4M
thread_cache_size = 64
read_buffer_size = 512K
read_rnd_buffer_size = 256K
max_allowed_packet = 8M


#filename: /etc/mysql/mariadb.conf.d/60-galera.cnf
[galera]
filename: /etc/mysql/mariadb.conf.d/50-client.cnf
[client]
[client-mariadb]


#filename: /etc/mysql/mariadb.conf.d/50-mariadb_safe.cnf
[mariadbd-safe]
nice = 0
skip_log_error
syslog


#filename: /etc/mysql/mariadb.conf.d/99-enable-encryption.cnf.preset/enable_encryption.preset
[mariadb]
aria-encrypt-tables
encrypt-binlog
encrypt-tmp-disk-tables
encrypt-tmp-files
loose-innodb-encrypt-log
loose-innodb-encrypt-tables


#filename: /etc/mysql/debian.cnf
[client]
host     = localhost
user     = root
[mysql_upgrade]
host     = localhost
user     = root


#filename: /etc/mysql/debian-start
source /usr/share/mysql/debian-start.inc.sh
if [ -f /etc/default/mysql ]; then
  . /etc/default/mysql
fi
if [ -f /etc/default/mariadb ]; then
  . /etc/default/mariadb
fi
MARIADB="/usr/bin/mariadb --defaults-file=/etc/mysql/debian.cnf"
MYADMIN="/usr/bin/mariadb-admin --defaults-file=/etc/mysql/debian.cnf"
MYUPGRADE="/usr/bin/mariadb-upgrade --defaults-extra-file=/etc/mysql/debian.cnf --version-check --silent"
MYCHECK="/usr/bin/mariadb-check --defaults-file=/etc/mysql/debian.cnf"
MYCHECK_SUBJECT="WARNING: mariadb-check has found corrupt tables"
MYCHECK_PARAMS="--all-databases --fast --silent"
MYCHECK_RCPT="${MYCHECK_RCPT:-root}"
trap "" SIGHUP
  upgrade_system_tables_if_necessary;
  check_root_accounts;
  check_for_crashed_tables;
exit 0


#filename: /etc/mysql/conf.d/mysqldump.cnf
[mysqldump]
quick
quote-names
max_allowed_packet	= 16M


#filename: /etc/mysql/conf.d/mysql.cnf
[mysql]

 

 

Aditional information: Actually, I have several pollers connected to this Centreon Central, but 3 of they are still running a old centreon-version (Centreon Engine 20.04.4). Can the problem be on this older pollers ?? There is anyway to disable the  'Bulk operation' from centreon side (on the code) ?? 

 

Thanks and attentive

 

S
Userlevel 1
Badge +6

Hello there,

 

today I finalized the upgrade and put all the pollers on the same version and changed the BBDO version from version 2 to 3. After restarting all, I got theses new errors on the central-broker-master.log (see bellow).

Im not sure if the 'Bulk operation' fails because the system can’t update the foreign keys or not. Maybe some one can give me one hand or idea how to fix it ?? 

 

Thanks in advance.

[2023-09-13T11:18:51.336-03:00] [core] [info] main: configuration update requested
[2023-09-13T11:18:51.337-03:00] [core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/50-tcp.so' which is already loaded
[2023-09-13T11:18:51.337-03:00] [core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/20-unified_sql.so' which is already loaded
[2023-09-13T11:18:51.337-03:00] [core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/15-stats.so' which is already loaded
[2023-09-13T11:18:51.337-03:00] [core] [info] multiplexing: engine started
[2023-09-13T11:18:52.378-03:00] [tls] [error] TLS session is terminated
[2023-09-13T11:18:52.379-03:00] [core] [error] feeder 'central-broker-master-input-52' error:TLS session is terminated 
[2023-09-13T11:18:52.379-03:00] [core] [info] bbdo stream stopped with 0 events acknowledged
[2023-09-13T11:18:52.379-03:00] [core] [warning] There is currently no poller 0 connected
[2023-09-13T11:18:52.380-03:00] [tcp] [error] Error while reading on socket: End of file
[2023-09-13T11:18:52.429-03:00] [core] [info] feeder: queue files of client 'central-broker-master-input-52' removed
[2023-09-13T11:18:52.429-03:00] [core] [info] multiplexing: '/var/lib/centreon-broker//central-broker-master.queue.central-broker-master-input-52' removed
[2023-09-13T11:18:52.429-03:00] [core] [info] feeder: thread of client 'central-broker-master-input-52' will exit
[2023-09-13T11:18:52.812-03:00] [core] [info] Poller '' with id 0 connected
[2023-09-13T11:18:52.812-03:00] [core] [info] New incoming connection 'central-broker-master-input-54'
[2023-09-13T11:18:52.812-03:00] [core] [info] multiplexing: 'central-broker-master-input-54' starts with 0 in queue and the queue file is disable
[2023-09-13T11:18:52.813-03:00] [core] [info] removing 'central-broker-master-input-52' from acceptor 'central-broker-master-input'
[2023-09-13T11:18:52.813-03:00] [core] [info] Destroying muxer central-broker-master-input-52: number of events in the queue: 0
[2023-09-13T11:18:53.358-03:00] [tls] [error] TLS session is terminated
[2023-09-13T11:18:53.358-03:00] [core] [error] feeder 'central-broker-master-input-47' error:TLS session is terminated 
[2023-09-13T11:18:53.358-03:00] [core] [info] bbdo stream stopped with 0 events acknowledged
[2023-09-13T11:18:53.358-03:00] [core] [info] Poller '' with id 0 just disconnected
[2023-09-13T11:18:53.408-03:00] [tcp] [error] Error while reading on socket: End of file
[2023-09-13T11:18:53.408-03:00] [core] [info] feeder: queue files of client 'central-broker-master-input-47' removed
[2023-09-13T11:18:53.408-03:00] [core] [info] multiplexing: '/var/lib/centreon-broker//central-broker-master.queue.central-broker-master-input-47' removed
[2023-09-13T11:18:53.409-03:00] [core] [info] feeder: thread of client 'central-broker-master-input-47' will exit
[2023-09-13T11:18:53.836-03:00] [tcp] [error] Error while reading on socket: End of file
[2023-09-13T11:18:53.860-03:00] [core] [error] feeder 'central-broker-master-input-51' error:Attempt to read data from peer 216.155.74.210:36972 on a closing socket 
[2023-09-13T11:18:53.860-03:00] [core] [info] bbdo stream stopped with 0 events acknowledged
[2023-09-13T11:18:53.860-03:00] [core] [warning] There is currently no poller 0 connected
[2023-09-13T11:18:53.860-03:00] [core] [info] feeder: queue files of client 'central-broker-master-input-51' removed
[2023-09-13T11:18:53.860-03:00] [core] [info] multiplexing: '/var/lib/centreon-broker//central-broker-master.queue.central-broker-master-input-51' removed
[2023-09-13T11:18:53.861-03:00] [core] [info] feeder: thread of client 'central-broker-master-input-51' will exit
[2023-09-13T11:18:54.488-03:00] [tls] [error] TLS session is terminated
[2023-09-13T11:18:54.488-03:00] [core] [error] feeder 'central-broker-master-input-53' error:TLS session is terminated 
[2023-09-13T11:18:54.488-03:00] [core] [info] bbdo stream stopped with 0 events acknowledged
[2023-09-13T11:18:54.488-03:00] [core] [warning] There is currently no poller 0 connected
[2023-09-13T11:18:54.538-03:00] [core] [info] feeder: queue files of client 'central-broker-master-input-53' removed
[2023-09-13T11:18:54.538-03:00] [core] [info] multiplexing: '/var/lib/centreon-broker//central-broker-master.queue.central-broker-master-input-53' removed
[2023-09-13T11:18:54.538-03:00] [core] [info] feeder: thread of client 'central-broker-master-input-53' will exit
[2023-09-13T11:18:54.538-03:00] [tcp] [error] Error while reading on socket: Operation aborted.
[2023-09-13T11:18:54.738-03:00] [core] [info] Available connections cleaning: Operation aborted.
[2023-09-13T11:18:54.738-03:00] [core] [info] Poller '' with id 0 connected
[2023-09-13T11:18:54.738-03:00] [core] [info] New incoming connection 'central-broker-master-input-55'
[2023-09-13T11:18:54.739-03:00] [core] [info] multiplexing: 'central-broker-master-input-55' starts with 0 in queue and the queue file is disable
[2023-09-13T11:18:54.739-03:00] [core] [info] removing 'central-broker-master-input-47' from acceptor 'central-broker-master-input'
[2023-09-13T11:18:54.739-03:00] [core] [info] Destroying muxer central-broker-master-input-47: number of events in the queue: 0
[2023-09-13T11:18:54.739-03:00] [core] [info] removing 'central-broker-master-input-51' from acceptor 'central-broker-master-input'
[2023-09-13T11:18:54.739-03:00] [core] [info] Destroying muxer central-broker-master-input-51: number of events in the queue: 0
[2023-09-13T11:18:54.739-03:00] [core] [info] removing 'central-broker-master-input-53' from acceptor 'central-broker-master-input'
[2023-09-13T11:18:54.739-03:00] [core] [info] Destroying muxer central-broker-master-input-53: number of events in the queue: 0
[2023-09-13T11:18:55.781-03:00] [core] [info] Available connections cleaning: Operation aborted.
[2023-09-13T11:18:55.869-03:00] [core] [info] Available connections cleaning: Operation aborted.
[2023-09-13T11:18:55.979-03:00] [tls] [error] TLS session is terminated
[2023-09-13T11:18:55.979-03:00] [core] [error] feeder 'central-broker-master-input-48' error:TLS session is terminated 
[2023-09-13T11:18:55.979-03:00] [core] [info] bbdo stream stopped with 0 events acknowledged
[2023-09-13T11:18:55.979-03:00] [core] [info] Poller '' with id 0 just disconnected
[2023-09-13T11:18:56.030-03:00] [core] [info] feeder: queue files of client 'central-broker-master-input-48' removed
[2023-09-13T11:18:56.030-03:00] [core] [info] multiplexing: '/var/lib/centreon-broker//central-broker-master.queue.central-broker-master-input-48' removed
[2023-09-13T11:18:56.030-03:00] [tcp] [error] Error while reading on socket: Operation aborted.
[2023-09-13T11:18:56.030-03:00] [core] [info] feeder: thread of client 'central-broker-master-input-48' will exit
[2023-09-13T11:18:56.373-03:00] [core] [info] Poller '' with id 0 connected
[2023-09-13T11:18:56.373-03:00] [core] [info] New incoming connection 'central-broker-master-input-56'
[2023-09-13T11:18:56.374-03:00] [core] [info] multiplexing: 'central-broker-master-input-56' starts with 0 in queue and the queue file is disable
[2023-09-13T11:18:56.375-03:00] [core] [info] removing 'central-broker-master-input-48' from acceptor 'central-broker-master-input'
[2023-09-13T11:18:56.375-03:00] [core] [info] Destroying muxer central-broker-master-input-48: number of events in the queue: 0
[2023-09-13T11:18:56.504-03:00] [core] [warning] Poller '' with id 0 already known as connected. Replacing it with ''
[2023-09-13T11:18:56.504-03:00] [core] [info] New incoming connection 'central-broker-master-input-57'
[2023-09-13T11:18:56.505-03:00] [core] [info] multiplexing: 'central-broker-master-input-57' starts with 0 in queue and the queue file is disable
[2023-09-13T11:18:57.571-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-09-13T11:18:57.571-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-09-13T11:18:59.046-03:00] [core] [info] Available connections cleaning: Operation aborted.
[2023-09-13T11:18:59.708-03:00] [core] [warning] Poller '' with id 0 already known as connected. Replacing it with ''
[2023-09-13T11:18:59.708-03:00] [core] [info] New incoming connection 'central-broker-master-input-58'
[2023-09-13T11:18:59.709-03:00] [core] [info] multiplexing: 'central-broker-master-input-58' starts with 0 in queue and the queue file is disable
[2023-09-13T11:19:00.305-03:00] [sql] [error] mysql_connection: Duplicate entry '1-0' for key 'tags_id_type_uindex'
[2023-09-13T11:19:00.465-03:00] [sql] [error] unified sql: unable to insert new tag (1,0): Duplicate entry '1-0' for key 'tags_id_type_uindex'
[2023-09-13T11:19:00.665-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:00.666-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)


DELETED 200-300 lines with the same error


[2023-09-13T11:19:01.151-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:01.151-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:01.152-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:01.153-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:02.554-03:00] [tls] [error] TLS session is terminated
[2023-09-13T11:19:02.554-03:00] [core] [error] feeder 'central-broker-master-input-49' error:TLS session is terminated 
[2023-09-13T11:19:02.554-03:00] [core] [info] bbdo stream stopped with 0 events acknowledged
[2023-09-13T11:19:02.554-03:00] [core] [info] Poller '' with id 0 just disconnected
[2023-09-13T11:19:02.604-03:00] [core] [info] feeder: queue files of client 'central-broker-master-input-49' removed
[2023-09-13T11:19:02.605-03:00] [core] [info] multiplexing: '/var/lib/centreon-broker//central-broker-master.queue.central-broker-master-input-49' removed
[2023-09-13T11:19:02.604-03:00] [tcp] [error] Error while reading on socket: Operation aborted.
[2023-09-13T11:19:02.605-03:00] [core] [info] feeder: thread of client 'central-broker-master-input-49' will exit
[2023-09-13T11:19:02.709-03:00] [core] [info] removing 'central-broker-master-input-49' from acceptor 'central-broker-master-input'
[2023-09-13T11:19:02.709-03:00] [core] [info] Destroying muxer central-broker-master-input-49: number of events in the queue: 0
[2023-09-13T11:19:03.492-03:00] [core] [info] Available connections cleaning: Operation aborted.
[2023-09-13T11:19:04.468-03:00] [core] [info] Poller '' with id 0 connected
[2023-09-13T11:19:04.468-03:00] [core] [info] New incoming connection 'central-broker-master-input-59'
[2023-09-13T11:19:04.470-03:00] [core] [info] multiplexing: 'central-broker-master-input-59' starts with 0 in queue and the queue file is disable
[2023-09-13T11:19:05.381-03:00] [sql] [error] mysql_connection: Duplicate entry '1-0' for key 'tags_id_type_uindex'
[2023-09-13T11:19:05.381-03:00] [sql] [error] unified sql: unable to insert new tag (1,0): Duplicate entry '1-0' for key 'tags_id_type_uindex'
[2023-09-13T11:19:05.485-03:00] [sql] [error] mysql_connection: Duplicate entry '13-0' for key 'tags_id_type_uindex'
[2023-09-13T11:19:05.485-03:00] [sql] [error] unified sql: unable to insert new tag (13,0): Duplicate entry '13-0' for key 'tags_id_type_uindex'
[2023-09-13T11:19:05.624-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:05.624-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:05.633-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:05.634-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:05.634-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:05.634-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:05.660-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:05.660-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:05.848-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:05.849-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:06.073-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:06.075-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:06.111-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:06.112-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert tag in resources_tags table:  errno=1452 Cannot add or update a child row: a foreign key constraint fails (`centreon_storage`.`resources_tags`, CONSTRAINT `resources_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)
[2023-09-13T11:19:07.723-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-09-13T11:19:07.723-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
[2023-09-13T11:19:07.724-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not store host status:  errno=0 Server doesn't support function 'Bulk operation'
[2023-09-13T11:19:07.724-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not store host status:  errno=0 Server doesn't support function 'Bulk operation'
[2023-09-13T11:19:07.724-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not store host status:  errno=0 Server doesn't support function 'Bulk operation'
[2023-09-13T11:19:07.724-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not store host status:  errno=0 Server doesn't support function 'Bulk operation'
[2023-09-13T11:19:17.734-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not store host status:  errno=0 Server doesn't support function 'Bulk operation'
[2023-09-13T11:19:17.735-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not store host status:  errno=0 Server doesn't support function 'Bulk operation'
[2023-09-13T11:19:17.735-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not store host status:  errno=0 Server doesn't support function 'Bulk operation'
[2023-09-13T11:19:17.735-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not store host status:  errno=0 Server doesn't support function 'Bulk operation'
[2023-09-13T11:19:27.735-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not store host status:  errno=0 Server doesn't support function 'Bulk operation'
[2023-09-13T11:19:27.735-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not store host status:  errno=0 Server doesn't support function 'Bulk operation'
[2023-09-13T11:19:27.735-03:00] [sql] [error] connection fail to execute statement 0x77b9e8022d00: could not store host status:  errno=0 Server doesn't support function 'Bulk operation'
[2023-09-13T11:19:27.736-03:00] [sql] [error] mysql_connection 0x77b9e8022d00 attempts 2: could not store host status:  errno=0 Server doesn't support function 'Bulk operation'

 

Reply


Terms & ConditionsCookie settings