Mariadb bulk operations not supported

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] 0sql] lerror] connection fail to execute statement 0x7f3bd0023a20: could not store service status: errno=0 Server doesn't support function 'Bulk operation'
r2023-08-10T21:46:25.012+02:00] 0sql] qerror] mysql_connection 0x7f3bd0023a20 attempts 2: could not store service status: errno=0 Server doesn't support function 'Bulk operation'
b2023-08-10T21:46:25.012+02:00] :sql] serror] 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] 2sql] [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.

Page 1 / 1

Hi @patvad

I have the same problem:

e2023-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] 0sql] lerror] mysql_connection 0x7a609c009eb0 attempts 2: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'

r2023-08-19T03:15:11.575-03:00] 0sql] qerror] connection fail to execute statement 0x7a609c009eb0: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
b2023-08-19T03:15:11.575-03:00] :sql] serror] 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 ??

Hi, which DBMS do you use?

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 ??

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”

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 !! :-(

d2023-08-29T14:58:26.787-03:00] 0core] einfo] main: configuration update requested
 2023-08-29T14:58:26.789-03:00] 0core] einfo] 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] 0core] einfo] 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] 0core] einfo] 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] 0core] einfo] multiplexing: engine started
 2023-08-29T14:58:26.825-03:00] 0sql] linfo] unified_sql stream update
 2023-08-29T14:58:26.825-03:00] 0sql] linfo] unified_sql: starting DB cleanup
 2023-08-29T14:58:26.825-03:00] 0sql] ldebug] mysql_connection 0x77b9e8022d00: run query: SELECT id FROM index_data WHERE to_delete=1
 2023-08-29T14:58:26.828-03:00] 0sql] ldebug] mysql_connection 0x77b9e8022d00: run query: SELECT metric_id FROM metrics WHERE to_delete=1
 2023-08-29T14:58:26.835-03:00] 0sql] linfo] Something to remove?
 2023-08-29T14:58:26.835-03:00] 0sql] ldebug] mysql_connection 0x77b9e8022d00: run query: SELECT id FROM index_data WHERE must_be_rebuild='1'
 2023-08-29T14:58:26.835-03:00] 0sql] linfo] Something to rebuild?
 2023-08-29T14:58:26.835-03:00] 0sql] ldebug] mysql_connection 0x77b9e8022d00 : commit
 2023-08-29T14:58:26.935-03:00] 0sql] linfo] 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' )
r2023-08-29T14:58:26.935-03:00] 0sql] qinfo] 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
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:27.337-03:00] 0sql] qinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
r2023-08-29T14:58:28.340-03:00] 0sql] qinfo] SQL: processing service status event (host: 82, service: 1108, last check: 1693331901, state (0, 1))
r2023-08-29T14:58:28.341-03:00] 0sql] qdebug] mysql_connection 0x77b9e8022d00 : commit
r2023-08-29T14:58:28.644-03:00] 0sql] qinfo] SQL: processing service status event (host: 164, service: 1568, last check: 1693331904, state (0, 1))
r2023-08-29T14:58:28.646-03:00] 0sql] qdebug] mysql_connection 0x77b9e8022d00 : commit
r2023-08-29T14:58:28.725-03:00] 0sql] qdebug] Sending 58 perfdata on connection 0
r2023-08-29T14:58:28.725-03:00] 0sql] qerror] connection fail to execute statement 0x77b9e8022d00: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
b2023-08-29T14:58:28.725-03:00] :sql] serror] 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] 3sql] [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] 3sql] [debug] 27 new logs inserted
<2023-08-29T14:58:28.725-03:00] 3sql] [debug] SQL: 27 items sent in bulk
<2023-08-29T14:58:28.727-03:00] 3sql] [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] 0sql]  debug] mysql_connection 0x77b9e8022d00 : commit
t2023-08-29T14:58:28.949-03:00] 0sql]  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] 0sql]  debug] unified sql: checking for outdated instances instance_timeout=300
02023-08-29T14:58:30.352-03:00] 0sql]  info] SQL: processing service status event (host: 78, service: 799, last check: 1693331905, state (0, 1))
)2023-08-29T14:58:30.354-03:00] 0sql]  debug] mysql_connection 0x77b9e8022d00 : commit
t2023-08-29T14:58:30.455-03:00] 0sql]  info] SQL: processing poller status event (id: 2, last alive: 1693331910)
)2023-08-29T14:58:30.457-03:00] 0sql]  debug] mysql_connection 0x77b9e8022d00 : commit
t2023-08-29T14:58:30.558-03:00] 0sql]  info] processing host status event (host: 35, last check: 1693331905, state (0, 1))
)2023-08-29T14:58:30.559-03:00] 0sql]  info] processing host status event (host: 35, last check: 1693331905, state (0, 1))
)2023-08-29T14:58:30.559-03:00] 0sql]  info] SQL: processing service status event (host: 34, service: 740, last check: 1693331901, state (0, 1))
)2023-08-29T14:58:30.561-03:00] 0sql]  debug] mysql_connection 0x77b9e8022d00 : commit
t2023-08-29T14:58:30.563-03:00] 0sql]  info] SQL: processing poller status event (id: 2, last alive: 1693331910)
)2023-08-29T14:58:30.564-03:00] 0sql]  debug] mysql_connection 0x77b9e8022d00 : commit
t2023-08-29T14:58:31.367-03:00] 0sql]  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
42023-08-29T14:58:31.969-03:00] 0sql]  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] 0sql]  info] SQL: processing poller status event (id: 6, last alive: 1693331912)
)2023-08-29T14:58:32.371-03:00] 0sql]  debug] mysql_connection 0x77b9e8022d00 : commit
t2023-08-29T14:58:32.773-03:00] 0sql]  info] SQL: processing service status event (host: 152, service: 1433, last check: 1693331904, state (0, 1))
)2023-08-29T14:58:32.775-03:00] 0sql]  debug] mysql_connection 0x77b9e8022d00 : commit
t2023-08-29T14:58:32.877-03:00] 0sql]  info] SQL: processing service status event (host: 88, service: 1336, last check: 1693331904, state (0, 1))
)2023-08-29T14:58:32.877-03:00] 0sql]  info] SQL: processing service status event (host: 146, service: 1411, last check: 1693331899, state (0, 1))
)2023-08-29T14:58:32.877-03:00] 0sql]  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
12023-08-29T14:58:32.879-03:00] 0sql]  debug] mysql_connection 0x77b9e8022d00 : commit
t2023-08-29T14:58:33.282-03:00] 0sql]  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] 0sql]  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] 0sql]  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)
12023-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
i2023-08-29T14:58:36.295-03:00] -sql] ]info] SQL: processing poller status event (id: 2, last alive: 1693331916)
62023-08-29T14:58:36.296-03:00] -sql] ]info] SQL: processing poller status event (id: 6, last alive: 1693331916)
62023-08-29T14:58:36.297-03:00] -sql] ]debug] mysql_connection 0x77b9e8022d00 : commit
i2023-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)
82023-08-29T14:58:36.899-03:00] -sql] ]info] SQL: processing poller status event (id: 4, last alive: 1693331916)
62023-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
i2023-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)
r2023-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] 3sql] :info] SQL: processing poller status event (id: 6, last alive: 1693331918)
12023-08-29T14:58:38.304-03:00] 3sql] :info] SQL: processing service status event (host: 168, service: 1615, last check: 1693331904, state (0, 1))
,2023-08-29T14:58:38.306-03:00] 3sql] :debug] mysql_connection 0x77b9e8022d00 : commit
o2023-08-29T14:58:38.508-03:00] 5sql] :info] processing host status event (host: 165, last check: 1693331911, state (0, 1))
,2023-08-29T14:58:38.509-03:00] 5sql] :debug] mysql_connection 0x77b9e8022d00 : commit
o2023-08-29T14:58:38.611-03:00] 6sql] :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' )
52023-08-29T14:58:38.726-03:00] .sql] 3debug] Sending 47 perfdata on connection 0
t2023-08-29T14:58:38.726-03:00] .sql] 3error] connection fail to execute statement 0x77b9e8022d00: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
r2023-08-29T14:58:38.726-03:00] 8sql] 0error] mysql_connection 0x77b9e8022d00 attempts 2: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
e2023-08-29T14:58:38.727-03:00] 3sql] -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)
t2023-08-29T14:58:39.012-03:00] 3sql] -debug] mysql_connection 0x77b9e8022d00 : commit
:2023-08-29T14:58:39.113-03:00] 3sql] -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%)
22023-08-29T14:58:39.114-03:00] 3sql] -debug] mysql_connection 0x77b9e8022d00 : commit
:2023-08-29T14:58:39.616-03:00] 3sql] -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)
x2023-08-29T14:58:39.817-03:00] 3sql] -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='' )
i2023-08-29T14:58:39.817-03:00] :sql] 7info] SQL: processing service status event (host: 51, service: 265, last check: 1693331915, state (0, 1))
e2023-08-29T14:58:39.818-03:00] :sql] 8debug] mysql_connection 0x77b9e8022d00 : commit
 2023-08-29T14:58:40.121-03:00] :sql] 1info] SQL: processing service status event (host: 48, service: 749, last check: 1693331917, state (0, 1))
e2023-08-29T14:58:40.122-03:00] :sql] 2debug] mysql_connection 0x77b9e8022d00 : commit
 2023-08-29T14:58:40.224-03:00] :sql] 4info] SQL: processing service status event (host: 99, service: 657, last check: 1693331916, state (0, 1))
e2023-08-29T14:58:40.224-03:00] :sql] 4info] SQL: processing log of poller 'TTT' generated at 1693331920 (type 0)
 2023-08-29T14:58:40.225-03:00] :sql] 5debug] mysql_connection 0x77b9e8022d00 : commit
 2023-08-29T14:58:40.225-03:00] :sql] 5info] SQL: processing poller status event (id: 2, last alive: 1693331920)
92023-08-29T14:58:40.226-03:00] :sql] 6debug] mysql_connection 0x77b9e8022d00 : commit
 2023-08-29T14:58:40.327-03:00] :sql] 7info] SQL: processing service status event (host: 78, service: 797, last check: 1693331913, state (0, 1))
e2023-08-29T14:58:40.329-03:00] :sql] 9debug] mysql_connection 0x77b9e8022d00 : commit
 2023-08-29T14:58:40.632-03:00] :sql] 2info] 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")
k2023-08-29T14:58:41.134-03:00] :sql] 4info] 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] 8sql] 3info] 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' )
l2023-08-29T14:58:41.234-03:00] 5sql] 2info] 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] 5sql] 6info] 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
02023-08-29T14:58:42.137-03:00] 5sql] 1info] SQL: processing poller status event (id: 2, last alive: 1693331922)
12023-08-29T14:58:42.138-03:00] 5sql] 1debug] mysql_connection 0x77b9e8022d00 : commit
02023-08-29T14:58:42.239-03:00] 5sql] 2info] 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)
52023-08-29T14:58:42.339-03:00] 4sql] 2info] 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='' )
s2023-08-29T14:58:42.339-03:00] 1sql] 4info] SQL: processing poller status event (id: 15, last alive: 1693331922)
e2023-08-29T14:58:42.340-03:00] 1sql] 4debug] mysql_connection 0x77b9e8022d00 : commit
22023-08-29T14:58:42.541-03:00] 1sql] 4info] 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)
i2023-08-29T14:58:42.642-03:00] 9sql] 8info] processing host status event (host: 63, last check: 1693331912, state (0, 1))
22023-08-29T14:58:42.642-03:00] 9sql] 8info] SQL: processing service status event (host: 88, service: 413, last check: 1693331914, state (0, 1))
42023-08-29T14:58:42.642-03:00] 9sql] 8info] SQL: processing service status event (host: 93, service: 1465, last check: 1693331918, state (0, 1))
82023-08-29T14:58:42.642-03:00] 9sql] 8info] SQL: processing service status event (host: 58, service: 388, last check: 1693331915, state (0, 1))
52023-08-29T14:58:42.645-03:00] 9sql] 8debug] mysql_connection 0x77b9e8022d00 : commit
82023-08-29T14:58:42.746-03:00] 9sql] 8info] SQL: processing service status event (host: 140, service: 1356, last check: 1693331920, state (0, 1))
02023-08-29T14:58:42.747-03:00] 9sql] 8info] processing host status event (host: 58, last check: 1693331921, state (0, 1))
12023-08-29T14:58:42.747-03:00] 9sql] 8info] 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)
c2023-08-29T14:58:42.748-03:00] 2sql] 5debug] mysql_connection 0x77b9e8022d00 : commit
e2023-08-29T14:58:42.849-03:00] 2sql] 5info] 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)
C2023-08-29T14:58:43.351-03:00] 2sql] 5info] 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' )
c2023-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')
e2023-08-29T14:58:44.154-03:00] 0sql] 1info] 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] 0sql] 1info] SQL: processing poller status event (id: 1, last alive: 1693331924)
t2023-08-29T14:58:44.356-03:00] 0sql] 1info] SQL: processing poller status event (id: 6, last alive: 1693331924)
t2023-08-29T14:58:44.357-03:00] 0sql] 1debug] mysql_connection 0x77b9e8022d00 : commit
72023-08-29T14:58:44.659-03:00] 0sql] 1info] 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)
w2023-08-29T14:58:45.061-03:00] 0sql] 1info] 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)
02023-08-29T14:58:45.262-03:00] 0sql] 1info] SQL: processing service status event (host: 52, service: 980, last check: 1693331919, state (0, 1))

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 !! :-(



b2023-08-29T14:58:26.787-03:00] :core] oinfo] main: configuration update requested
b2023-08-29T14:58:26.789-03:00] :core] oinfo] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/50-tcp.so' which is already loaded
b2023-08-29T14:58:26.789-03:00] :core] oinfo] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/20-unified_sql.so' which is already loaded
b2023-08-29T14:58:26.789-03:00] :core] oinfo] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/15-stats.so' which is already loaded
b2023-08-29T14:58:26.789-03:00] :core] oinfo] multiplexing: engine started
b2023-08-29T14:58:26.825-03:00] :sql] sinfo] unified_sql stream update
b2023-08-29T14:58:26.825-03:00] :sql] sinfo] unified_sql: starting DB cleanup
b2023-08-29T14:58:26.825-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00: run query: SELECT id FROM index_data WHERE to_delete=1
b2023-08-29T14:58:26.828-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00: run query: SELECT metric_id FROM metrics WHERE to_delete=1
b2023-08-29T14:58:26.835-03:00] :sql] sinfo] Something to remove?
b2023-08-29T14:58:26.835-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00: run query: SELECT id FROM index_data WHERE must_be_rebuild='1'
b2023-08-29T14:58:26.835-03:00] :sql] sinfo] Something to rebuild?
b2023-08-29T14:58:26.835-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:26.935-03:00] :sql] sinfo] 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' )
b2023-08-29T14:58:26.935-03:00] :sql] sinfo] 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
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:27.337-03:00] :sql] sinfo] SQL: processing log of poller 'Central' generated at 1693331907 (type 5)
b2023-08-29T14:58:28.340-03:00] :sql] sinfo] SQL: processing service status event (host: 82, service: 1108, last check: 1693331901, state (0, 1))
b2023-08-29T14:58:28.341-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:28.644-03:00] :sql] sinfo] SQL: processing service status event (host: 164, service: 1568, last check: 1693331904, state (0, 1))
b2023-08-29T14:58:28.646-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:28.725-03:00] :sql] sdebug] Sending 58 perfdata on connection 0
b2023-08-29T14:58:28.725-03:00] :sql] serror] connection fail to execute statement 0x77b9e8022d00: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
b2023-08-29T14:58:28.725-03:00] :sql] serror] mysql_connection 0x77b9e8022d00 attempts 2: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
b2023-08-29T14:58:28.725-03:00] :sql] sdebug] 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)
b2023-08-29T14:58:28.725-03:00] :sql] sdebug] 27 new logs inserted
b2023-08-29T14:58:28.725-03:00] :sql] sdebug] SQL: 27 items sent in bulk
b2023-08-29T14:58:28.727-03:00] :sql] sdebug] 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.')
b2023-08-29T14:58:28.747-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:28.949-03:00] :sql] sinfo] 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)
b2023-08-29T14:58:29.809-03:00] :sql] sdebug] unified sql: checking for outdated instances instance_timeout=300
b2023-08-29T14:58:30.352-03:00] :sql] sinfo] SQL: processing service status event (host: 78, service: 799, last check: 1693331905, state (0, 1))
b2023-08-29T14:58:30.354-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:30.455-03:00] :sql] sinfo] SQL: processing poller status event (id: 2, last alive: 1693331910)
b2023-08-29T14:58:30.457-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:30.558-03:00] :sql] sinfo] processing host status event (host: 35, last check: 1693331905, state (0, 1))
b2023-08-29T14:58:30.559-03:00] :sql] sinfo] processing host status event (host: 35, last check: 1693331905, state (0, 1))
b2023-08-29T14:58:30.559-03:00] :sql] sinfo] SQL: processing service status event (host: 34, service: 740, last check: 1693331901, state (0, 1))
b2023-08-29T14:58:30.561-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:30.563-03:00] :sql] sinfo] SQL: processing poller status event (id: 2, last alive: 1693331910)
b2023-08-29T14:58:30.564-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:31.367-03:00] :sql] sinfo] SQL: processing host check event (host: 165, command: /usr/lib/nagios/plugins/check_tcp -H xxxxxxxxx.xxxxxxxxx.mmm -p 80 -w 2 -c 4
b2023-08-29T14:58:31.969-03:00] :sql] sinfo] SQL: processing service check event (host: 166, service: 1584, command: /usr/lib/nagios/plugins/check_hhhhhhhh.sh -H hhhhhhhh.xxxxxxx.cc -M99 -m98)
b2023-08-29T14:58:32.370-03:00] :sql] sinfo] SQL: processing poller status event (id: 6, last alive: 1693331912)
b2023-08-29T14:58:32.371-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:32.773-03:00] :sql] sinfo] SQL: processing service status event (host: 152, service: 1433, last check: 1693331904, state (0, 1))
b2023-08-29T14:58:32.775-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:32.877-03:00] :sql] sinfo] SQL: processing service status event (host: 88, service: 1336, last check: 1693331904, state (0, 1))
b2023-08-29T14:58:32.877-03:00] :sql] sinfo] SQL: processing service status event (host: 146, service: 1411, last check: 1693331899, state (0, 1))
b2023-08-29T14:58:32.877-03:00] :sql] sinfo] 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
b2023-08-29T14:58:32.879-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:33.282-03:00] :sql] sinfo] 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)
b2023-08-29T14:58:34.785-03:00] :sql] sinfo] 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% )
b2023-08-29T14:58:34.985-03:00] :sql] sinfo] 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' )
b2023-08-29T14:58:35.787-03:00] :sql] sinfo] 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)
b2023-08-29T14:58:35.887-03:00] :sql] sinfo] 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% )
b2023-08-29T14:58:35.987-03:00] :sql] sinfo] processing host status event (host: 159, last check: 1693331906, state (0, 1))
b2023-08-29T14:58:35.988-03:00] :sql] sinfo] SQL: processing service status event (host: 166, service: 1587, last check: 1693331906, state (0, 1))
b2023-08-29T14:58:35.988-03:00] :sql] sinfo] SQL: processing service status event (host: 123, service: 238, last check: 1693331908, state (0, 1))
b2023-08-29T14:58:35.988-03:00] :sql] sinfo] SQL: processing service status event (host: 166, service: 1584, last check: 1693331911, state (0, 1))
b2023-08-29T14:58:35.989-03:00] :sql] sinfo] SQL: processing service status event (host: 55, service: 944, last check: 1693331914, state (0, 1))
b2023-08-29T14:58:35.993-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:36.295-03:00] :sql] sinfo] SQL: processing poller status event (id: 2, last alive: 1693331916)
b2023-08-29T14:58:36.296-03:00] :sql] sinfo] SQL: processing poller status event (id: 6, last alive: 1693331916)
b2023-08-29T14:58:36.297-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:36.398-03:00] :sql] sinfo] SQL: processing service check event (host: 99, service: 657, command: /usr/lib/nagios/plugins/check_hhhhhhhh.sh -H hhhhhhhh.kkkkkkk.kkk -M99 -m98)
b2023-08-29T14:58:36.899-03:00] :sql] sinfo] SQL: processing poller status event (id: 4, last alive: 1693331916)
b2023-08-29T14:58:36.899-03:00] :sql] sinfo] 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% )
b2023-08-29T14:58:36.900-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:37.101-03:00] :sql] sinfo] 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)
b2023-08-29T14:58:37.903-03:00] :sql] sinfo] 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)
b2023-08-29T14:58:38.304-03:00] :sql] sinfo] SQL: processing poller status event (id: 6, last alive: 1693331918)
b2023-08-29T14:58:38.304-03:00] :sql] sinfo] SQL: processing service status event (host: 168, service: 1615, last check: 1693331904, state (0, 1))
b2023-08-29T14:58:38.306-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:38.508-03:00] :sql] sinfo] processing host status event (host: 165, last check: 1693331911, state (0, 1))
b2023-08-29T14:58:38.509-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:38.611-03:00] :sql] sinfo] 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' )
b2023-08-29T14:58:38.726-03:00] :sql] sdebug] Sending 47 perfdata on connection 0
b2023-08-29T14:58:38.726-03:00] :sql] serror] connection fail to execute statement 0x77b9e8022d00: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
b2023-08-29T14:58:38.726-03:00] :sql] serror] mysql_connection 0x77b9e8022d00 attempts 2: could not insert data in data_bin:  errno=0 Server doesn't support function 'Bulk operation'
b2023-08-29T14:58:38.727-03:00] :sql] sdebug] 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)
b2023-08-29T14:58:39.012-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:39.113-03:00] :sql] sinfo] 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%)
b2023-08-29T14:58:39.114-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:39.616-03:00] :sql] sinfo] 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)
b2023-08-29T14:58:39.817-03:00] :sql] sinfo] 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='' )
b2023-08-29T14:58:39.817-03:00] :sql] sinfo] SQL: processing service status event (host: 51, service: 265, last check: 1693331915, state (0, 1))
b2023-08-29T14:58:39.818-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:40.121-03:00] :sql] sinfo] SQL: processing service status event (host: 48, service: 749, last check: 1693331917, state (0, 1))
b2023-08-29T14:58:40.122-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:40.224-03:00] :sql] sinfo] SQL: processing service status event (host: 99, service: 657, last check: 1693331916, state (0, 1))
b2023-08-29T14:58:40.224-03:00] :sql] sinfo] SQL: processing log of poller 'TTT' generated at 1693331920 (type 0)
b2023-08-29T14:58:40.225-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:40.225-03:00] :sql] sinfo] SQL: processing poller status event (id: 2, last alive: 1693331920)
b2023-08-29T14:58:40.226-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:40.327-03:00] :sql] sinfo] SQL: processing service status event (host: 78, service: 797, last check: 1693331913, state (0, 1))
b2023-08-29T14:58:40.329-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:40.632-03:00] :sql] sinfo] 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")
b2023-08-29T14:58:41.134-03:00] :sql] sinfo] 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='' )
b2023-08-29T14:58:41.234-03:00] :sql] sinfo] 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' )
b2023-08-29T14:58:41.234-03:00] :sql] sinfo] SQL: processing service check event (host: 139, service: 1350, command: /usr/lib/nagios/plugins/check_nginx_status.pl -H xxx.xxx.x.201)
b2023-08-29T14:58:41.635-03:00] :sql] sinfo] 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
b2023-08-29T14:58:42.137-03:00] :sql] sinfo] SQL: processing poller status event (id: 2, last alive: 1693331922)
b2023-08-29T14:58:42.138-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:42.239-03:00] :sql] sinfo] 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)
b2023-08-29T14:58:42.239-03:00] :sql] sinfo] 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)
b2023-08-29T14:58:42.339-03:00] :sql] sinfo] 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='' )
b2023-08-29T14:58:42.339-03:00] :sql] sinfo] SQL: processing poller status event (id: 15, last alive: 1693331922)
b2023-08-29T14:58:42.340-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:42.541-03:00] :sql] sinfo] 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)
b2023-08-29T14:58:42.642-03:00] :sql] sinfo] processing host status event (host: 63, last check: 1693331912, state (0, 1))
b2023-08-29T14:58:42.642-03:00] :sql] sinfo] SQL: processing service status event (host: 88, service: 413, last check: 1693331914, state (0, 1))
b2023-08-29T14:58:42.642-03:00] :sql] sinfo] SQL: processing service status event (host: 93, service: 1465, last check: 1693331918, state (0, 1))
b2023-08-29T14:58:42.642-03:00] :sql] sinfo] SQL: processing service status event (host: 58, service: 388, last check: 1693331915, state (0, 1))
b2023-08-29T14:58:42.645-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:42.746-03:00] :sql] sinfo] SQL: processing service status event (host: 140, service: 1356, last check: 1693331920, state (0, 1))
b2023-08-29T14:58:42.747-03:00] :sql] sinfo] processing host status event (host: 58, last check: 1693331921, state (0, 1))
b2023-08-29T14:58:42.747-03:00] :sql] sinfo] 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)
b2023-08-29T14:58:42.748-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:42.849-03:00] :sql] sinfo] 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)
b2023-08-29T14:58:43.351-03:00] :sql] sinfo] 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' )
b2023-08-29T14:58:43.652-03:00] :sql] sinfo] 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')
b2023-08-29T14:58:44.154-03:00] :sql] sinfo] 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)
b2023-08-29T14:58:44.355-03:00] :sql] sinfo] SQL: processing poller status event (id: 1, last alive: 1693331924)
b2023-08-29T14:58:44.356-03:00] :sql] sinfo] SQL: processing poller status event (id: 6, last alive: 1693331924)
b2023-08-29T14:58:44.357-03:00] :sql] sdebug] mysql_connection 0x77b9e8022d00 : commit
b2023-08-29T14:58:44.659-03:00] :sql] sinfo] 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)
b2023-08-29T14:58:45.061-03:00] :sql] sinfo] 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)
b2023-08-29T14:58:45.262-03:00] :sql] sinfo] SQL: processing service status event (host: 52, service: 980, last check: 1693331919, state (0, 1))

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

Thank you for feedback, can you execute:

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

And give us the result?

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
m2023-08-29T14:49:12.548-03:00] 0sql]  info] unified_sql stream update
e2023-08-29T14:52:52.147-03:00] 0sql]  info] unified_sql stream update
e2023-08-29T14:58:26.825-03:00] 0sql]  info] unified_sql stream update
e2023-08-29T23:22:01.774-03:00] 0core] [info] bbdo stream stopped with 0 events acknowledged
d2023-08-30T02:22:03.782-03:00] 0core] [info] bbdo stream stopped with 0 events acknowledged
d2023-08-30T02:22:04.184-03:00] 0core] [info] bbdo stream stopped with 0 events acknowledged
d2023-08-30T02:22:05.689-03:00] 0core] [info] bbdo stream stopped with 0 events acknowledged
d2023-08-30T03:22:00.979-03:00] 0core] [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

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 -

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

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 earch=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 earch=amd64,arm64] https://dlm.mariadb.com/repo/maxscale/latest/apt bullseye main


# MariaDB Tools
deb earch=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
cclient-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
cmariadb-client]
nmariadb-upgrade]
dmariadb-admin]
imariadb-binlog]
omariadb-check]
cmariadb-dump]
mmariadb-import]
rmariadb-show]
omariadb-slap]


#filename: /etc/mysql/mariadb.conf.d/50-server.cnf
cserver]
emariadbd]
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]
emariadbd]
bmariadb-11.0]


#filename: /etc/mysql/mariadb.conf.d/80-centreon.cnf
cserver]
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
cgalera]
filename: /etc/mysql/mariadb.conf.d/50-client.cnf
cclient]
nclient-mariadb]


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


#filename: /etc/mysql/mariadb.conf.d/99-enable-encryption.cnf.preset/enable_encryption.preset
smariadb]
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
cclient]
host     = localhost
user     = root
omysql_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
cmysqldump]
quick
quote-names
max_allowed_packet	= 16M


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

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

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] 0core] [info] main: configuration update requested
d2023-09-13T11:18:51.337-03:00] 0core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/50-tcp.so' which is already loaded
d2023-09-13T11:18:51.337-03:00] 0core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/20-unified_sql.so' which is already loaded
d2023-09-13T11:18:51.337-03:00] 0core] [info] modules: attempt to load '/usr/share/centreon/lib/centreon-broker/15-stats.so' which is already loaded
d2023-09-13T11:18:51.337-03:00] 0core] [info] multiplexing: engine started
d2023-09-13T11:18:52.378-03:00] 0tls]  error] TLS session is terminated
d2023-09-13T11:18:52.379-03:00] 0core] [error] feeder 'central-broker-master-input-52' error:TLS session is terminated 
 2023-09-13T11:18:52.379-03:00] 0core] [info] bbdo stream stopped with 0 events acknowledged
d2023-09-13T11:18:52.379-03:00] 0core] [warning] There is currently no poller 0 connected
d2023-09-13T11:18:52.380-03:00] 0tcp]  error] Error while reading on socket: End of file
e2023-09-13T11:18:52.429-03:00] 0core] [info] feeder: queue files of client 'central-broker-master-input-52' removed
d2023-09-13T11:18:52.429-03:00] 0core] [info] multiplexing: '/var/lib/centreon-broker//central-broker-master.queue.central-broker-master-input-52' removed
d2023-09-13T11:18:52.429-03:00] 0core] [info] feeder: thread of client 'central-broker-master-input-52' will exit
t2023-09-13T11:18:52.812-03:00] 0core] [info] Poller '' with id 0 connected
d2023-09-13T11:18:52.812-03:00] 0core] [info] New incoming connection 'central-broker-master-input-54'
'2023-09-13T11:18:52.812-03:00] 0core] [info] multiplexing: 'central-broker-master-input-54' starts with 0 in queue and the queue file is disable
e2023-09-13T11:18:52.813-03:00] 0core] [info] removing 'central-broker-master-input-52' from acceptor 'central-broker-master-input'
'2023-09-13T11:18:52.813-03:00] 0core] [info] Destroying muxer central-broker-master-input-52: number of events in the queue: 0
02023-09-13T11:18:53.358-03:00] 0tls]  error] TLS session is terminated
d2023-09-13T11:18:53.358-03:00] 0core] [error] feeder 'central-broker-master-input-47' error:TLS session is terminated 
 2023-09-13T11:18:53.358-03:00] 0core] [info] bbdo stream stopped with 0 events acknowledged
d2023-09-13T11:18:53.358-03:00] 0core] [info] Poller '' with id 0 just disconnected
d2023-09-13T11:18:53.408-03:00] 0tcp]  error] Error while reading on socket: End of file
e2023-09-13T11:18:53.408-03:00] 0core] [info] feeder: queue files of client 'central-broker-master-input-47' removed
d2023-09-13T11:18:53.408-03:00] 0core] [info] multiplexing: '/var/lib/centreon-broker//central-broker-master.queue.central-broker-master-input-47' removed
d2023-09-13T11:18:53.409-03:00] 0core] [info] feeder: thread of client 'central-broker-master-input-47' will exit
t2023-09-13T11:18:53.836-03:00] 0tcp]  error] Error while reading on socket: End of file
e2023-09-13T11:18:53.860-03:00] 0core] [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] 0core] [info] bbdo stream stopped with 0 events acknowledged
d2023-09-13T11:18:53.860-03:00] 0core] [warning] There is currently no poller 0 connected
d2023-09-13T11:18:53.860-03:00] 0core] [info] feeder: queue files of client 'central-broker-master-input-51' removed
d2023-09-13T11:18:53.860-03:00] 0core] [info] multiplexing: '/var/lib/centreon-broker//central-broker-master.queue.central-broker-master-input-51' removed
d2023-09-13T11:18:53.861-03:00] 0core] [info] feeder: thread of client 'central-broker-master-input-51' will exit
t2023-09-13T11:18:54.488-03:00] 0tls]  error] TLS session is terminated
d2023-09-13T11:18:54.488-03:00] 0core] [error] feeder 'central-broker-master-input-53' error:TLS session is terminated 
 2023-09-13T11:18:54.488-03:00] 0core] [info] bbdo stream stopped with 0 events acknowledged
d2023-09-13T11:18:54.488-03:00] 0core] [warning] There is currently no poller 0 connected
d2023-09-13T11:18:54.538-03:00] 0core] [info] feeder: queue files of client 'central-broker-master-input-53' removed
d2023-09-13T11:18:54.538-03:00] 0core] [info] multiplexing: '/var/lib/centreon-broker//central-broker-master.queue.central-broker-master-input-53' removed
d2023-09-13T11:18:54.538-03:00] 0core] [info] feeder: thread of client 'central-broker-master-input-53' will exit
t2023-09-13T11:18:54.538-03:00] 0tcp]  error] Error while reading on socket: Operation aborted.
.2023-09-13T11:18:54.738-03:00] 0core] [info] Available connections cleaning: Operation aborted.
.2023-09-13T11:18:54.738-03:00] 0core] [info] Poller '' with id 0 connected
d2023-09-13T11:18:54.738-03:00] 0core] [info] New incoming connection 'central-broker-master-input-55'
'2023-09-13T11:18:54.739-03:00] 0core] [info] multiplexing: 'central-broker-master-input-55' starts with 0 in queue and the queue file is disable
e2023-09-13T11:18:54.739-03:00] 0core] [info] removing 'central-broker-master-input-47' from acceptor 'central-broker-master-input'
'2023-09-13T11:18:54.739-03:00] 0core] [info] Destroying muxer central-broker-master-input-47: number of events in the queue: 0
02023-09-13T11:18:54.739-03:00] 0core] [info] removing 'central-broker-master-input-51' from acceptor 'central-broker-master-input'
'2023-09-13T11:18:54.739-03:00] 0core] [info] Destroying muxer central-broker-master-input-51: number of events in the queue: 0
02023-09-13T11:18:54.739-03:00] 0core] [info] removing 'central-broker-master-input-53' from acceptor 'central-broker-master-input'
'2023-09-13T11:18:54.739-03:00] 0core] [info] Destroying muxer central-broker-master-input-53: number of events in the queue: 0
02023-09-13T11:18:55.781-03:00] 0core] [info] Available connections cleaning: Operation aborted.
.2023-09-13T11:18:55.869-03:00] 0core] [info] Available connections cleaning: Operation aborted.
.2023-09-13T11:18:55.979-03:00] 0tls]  error] TLS session is terminated
d2023-09-13T11:18:55.979-03:00] 0core] [error] feeder 'central-broker-master-input-48' error:TLS session is terminated 
 2023-09-13T11:18:55.979-03:00] 0core] [info] bbdo stream stopped with 0 events acknowledged
d2023-09-13T11:18:55.979-03:00] 0core] [info] Poller '' with id 0 just disconnected
d2023-09-13T11:18:56.030-03:00] 0core] [info] feeder: queue files of client 'central-broker-master-input-48' removed
d2023-09-13T11:18:56.030-03:00] 0core] [info] multiplexing: '/var/lib/centreon-broker//central-broker-master.queue.central-broker-master-input-48' removed
d2023-09-13T11:18:56.030-03:00] 0tcp]  error] Error while reading on socket: Operation aborted.
.2023-09-13T11:18:56.030-03:00] 0core] [info] feeder: thread of client 'central-broker-master-input-48' will exit
t2023-09-13T11:18:56.373-03:00] 0core] [info] Poller '' with id 0 connected
d2023-09-13T11:18:56.373-03:00] 0core] [info] New incoming connection 'central-broker-master-input-56'
'2023-09-13T11:18:56.374-03:00] 0core] [info] multiplexing: 'central-broker-master-input-56' starts with 0 in queue and the queue file is disable
e2023-09-13T11:18:56.375-03:00] 0core] [info] removing 'central-broker-master-input-48' from acceptor 'central-broker-master-input'
'2023-09-13T11:18:56.375-03:00] 0core] [info] Destroying muxer central-broker-master-input-48: number of events in the queue: 0
02023-09-13T11:18:56.504-03:00] 0core] [warning] Poller '' with id 0 already known as connected. Replacing it with ''
'2023-09-13T11:18:56.504-03:00] 0core] [info] New incoming connection 'central-broker-master-input-57'
'2023-09-13T11:18:56.505-03:00] 0core] [info] multiplexing: 'central-broker-master-input-57' starts with 0 in queue and the queue file is disable
e2023-09-13T11:18:57.571-03:00] 0sql]  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] 0sql]  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] 0core] [info] Available connections cleaning: Operation aborted.
.2023-09-13T11:18:59.708-03:00] 0core] [warning] Poller '' with id 0 already known as connected. Replacing it with ''
'2023-09-13T11:18:59.708-03:00] 0core] [info] New incoming connection 'central-broker-master-input-58'
'2023-09-13T11:18:59.709-03:00] 0core] [info] multiplexing: 'central-broker-master-input-58' starts with 0 in queue and the queue file is disable
e2023-09-13T11:19:00.305-03:00] 0sql]  error] mysql_connection: Duplicate entry '1-0' for key 'tags_id_type_uindex'
'2023-09-13T11:19:00.465-03:00] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0tls]  error] TLS session is terminated
d2023-09-13T11:19:02.554-03:00] 0core] [error] feeder 'central-broker-master-input-49' error:TLS session is terminated 
 2023-09-13T11:19:02.554-03:00] 0core] [info] bbdo stream stopped with 0 events acknowledged
d2023-09-13T11:19:02.554-03:00] 0core] [info] Poller '' with id 0 just disconnected
d2023-09-13T11:19:02.604-03:00] 0core] [info] feeder: queue files of client 'central-broker-master-input-49' removed
d2023-09-13T11:19:02.605-03:00] 0core] [info] multiplexing: '/var/lib/centreon-broker//central-broker-master.queue.central-broker-master-input-49' removed
d2023-09-13T11:19:02.604-03:00] 0tcp]  error] Error while reading on socket: Operation aborted.
.2023-09-13T11:19:02.605-03:00] 0core] [info] feeder: thread of client 'central-broker-master-input-49' will exit
t2023-09-13T11:19:02.709-03:00] 0core] [info] removing 'central-broker-master-input-49' from acceptor 'central-broker-master-input'
'2023-09-13T11:19:02.709-03:00] 0core] [info] Destroying muxer central-broker-master-input-49: number of events in the queue: 0
02023-09-13T11:19:03.492-03:00] 0core] [info] Available connections cleaning: Operation aborted.
.2023-09-13T11:19:04.468-03:00] 0core] [info] Poller '' with id 0 connected
d2023-09-13T11:19:04.468-03:00] 0core] [info] New incoming connection 'central-broker-master-input-59'
'2023-09-13T11:19:04.470-03:00] 0core] [info] multiplexing: 'central-broker-master-input-59' starts with 0 in queue and the queue file is disable
e2023-09-13T11:19:05.381-03:00] 0sql]  error] mysql_connection: Duplicate entry '1-0' for key 'tags_id_type_uindex'
'2023-09-13T11:19:05.381-03:00] 0sql]  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] 0sql]  error] mysql_connection: Duplicate entry '13-0' for key 'tags_id_type_uindex'
'2023-09-13T11:19:05.485-03:00] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  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] 0sql]  error] mysql_connection 0x77b9e8022d00 attempts 2: could not store host status:  errno=0 Server doesn't support function 'Bulk operation'

Reply

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded