792:20210408:194012.194 executing housekeeper
   787:20210408:194140.897 slow query: 4.936463 sec, "select i.itemid,i.hostid,i                                                                                        .status,i.type,i.value_type,i.key_,i.snmp_oid,i.ipmi_sensor,i.delay,i.trapper_ho                                                                                        sts,i.logtimefmt,i.params,ir.state,i.authtype,i.username,i.password,i.publickey,                                                                                        i.privatekey,i.flags,i.interfaceid,ir.lastlogsize,ir.mtime,i.history,i.trends,i.                                                                                        inventory_link,i.valuemapid,i.units,ir.error,i.jmx_endpoint,i.master_itemid,i.ti                                                                                        meout,i.url,i.query_fields,i.posts,i.status_codes,i.follow_redirects,i.post_type                                                                                        ,i.http_proxy,i.headers,i.retrieve_mode,i.request_method,i.output_format,i.ssl_c                                                                                        ert_file,i.ssl_key_file,i.ssl_key_password,i.verify_peer,i.verify_host,i.allow_t                                                                                        raps,i.templateid,id.parent_itemid from items i inner join hosts h on i.hostid=h                                                                                        .hostid left join item_discovery id on i.itemid=id.itemid join item_rtdata ir on                                                                                         i.itemid=ir.itemid where h.status in (0,1) and i.flags<>2"
   787:20210408:194248.485 slow query: 4.870252 sec, "select i.itemid,i.hostid,i                                                                                        .status,i.type,i.value_type,i.key_,i.snmp_oid,i.ipmi_sensor,i.delay,i.trapper_ho                                                                                        sts,i.logtimefmt,i.params,ir.state,i.authtype,i.username,i.password,i.publickey,                                                                                        i.privatekey,i.flags,i.interfaceid,ir.lastlogsize,ir.mtime,i.history,i.trends,i.                                                                                        inventory_link,i.valuemapid,i.units,ir.error,i.jmx_endpoint,i.master_itemid,i.ti                                                                                        meout,i.url,i.query_fields,i.posts,i.status_codes,i.follow_redirects,i.post_type                                                                                        ,i.http_proxy,i.headers,i.retrieve_mode,i.request_method,i.output_format,i.ssl_c                                                                                        ert_file,i.ssl_key_file,i.ssl_key_password,i.verify_peer,i.verify_host,i.allow_t                                                                                        raps,i.templateid,id.parent_itemid from items i inner join hosts h on i.hostid=h                                                                                        .hostid left join item_discovery id on i.itemid=id.itemid join item_rtdata ir on                                                                                         i.itemid=ir.itemid where h.status in (0,1) and i.flags<>2"
   787:20210408:194355.341 slow query: 3.794945 sec, "select i.itemid,i.hostid,i                                                                                        .status,i.type,i.value_type,i.key_,i.snmp_oid,i.ipmi_sensor,i.delay,i.trapper_ho                                                                                        sts,i.logtimefmt,i.params,ir.state,i.authtype,i.username,i.password,i.publickey,                                                                                        i.privatekey,i.flags,i.interfaceid,ir.lastlogsize,ir.mtime,i.history,i.trends,i.                                                                                        inventory_link,i.valuemapid,i.units,ir.error,i.jmx_endpoint,i.master_itemid,i.ti                                                                                        meout,i.url,i.query_fields,i.posts,i.status_codes,i.follow_redirects,i.post_type                                                                                        ,i.http_proxy,i.headers,i.retrieve_mode,i.request_method,i.output_format,i.ssl_c                                                                                        ert_file,i.ssl_key_file,i.ssl_key_password,i.verify_peer,i.verify_host,i.allow_t                                                                                        raps,i.templateid,id.parent_itemid from items i inner join hosts h on i.hostid=h                                                                                        .hostid left join item_discovery id on i.itemid=id.itemid join item_rtdata ir on                                                                                         i.itemid=ir.itemid where h.status in (0,1) and i.flags<>2"
   792:20210408:194419.590 housekeeper [deleted 787440 hist/trends, 0 items/trig                                                                                        gers, 42 events, 13 problems, 0 sessions, 0 alarms, 0 audit, 0 records in 247.39                                                                                        5573 sec, idle for 1 hour(s)]
   830:20210408:194615.450 SNMP agent item "ifOutErrors[Eth-Trunk20.408]" on hos                                                                                        t "HUAWEI-DIGITAL" failed: first network error, wait for 15 seconds
   845:20210408:194630.522 resuming SNMP agent checks on host "HUAWEI-DIGITAL":                                                                                         connection restored
   849:20210408:194638.766 SNMP agent item "ifAdminStatus[Eth-Trunk20.1637]" on                                                                                         host "HUAWEI-DIGITAL" failed: first network error, wait for 15 seconds
   846:20210408:194653.765 resuming SNMP agent checks on host "HUAWEI-DIGITAL":                                                                                         connection restored
   843:20210408:194701.906 SNMP agent item "ifInErrors[Eth-Trunk20.945]" on host                                                                                         "HUAWEI-DIGITAL" failed: first network error, wait for 15 seconds
   843:20210408:194716.943 resuming SNMP agent checks on host "HUAWEI-DIGITAL":                                                                                         connection restored
   831:20210408:200548.311 SNMP agent item "100.6.IN" on host "VS38 - CAIXA PRIN                                                                                        CIPAL" failed: first network error, wait for 15 seconds
   847:20210408:200603.237 resuming SNMP agent checks on host "VS38 - CAIXA PRIN                                                                                        CIPAL": connection restored
   792:20210408:204419.848 executing housekeeper
   787:20210408:204459.710 slow query: 3.082259 sec, "select i.itemid,i.hostid,i                                                                                        .status,i.type,i.value_type,i.key_,i.snmp_oid,i.ipmi_sensor,i.delay,i.trapper_ho                                                                                        sts,i.logtimefmt,i.params,ir.state,i.authtype,i.username,i.password,i.publickey,                                                                                        i.privatekey,i.flags,i.interfaceid,ir.lastlogsize,ir.mtime,i.history,i.trends,i.                                                                                        inventory_link,i.valuemapid,i.units,ir.error,i.jmx_endpoint,i.master_itemid,i.ti                                                                                        meout,i.url,i.query_fields,i.posts,i.status_codes,i.follow_redirects,i.post_type                                                                                        ,i.http_proxy,i.headers,i.retrieve_mode,i.request_method,i.output_format,i.ssl_c                                                                                        ert_file,i.ssl_key_file,i.ssl_key_password,i.verify_peer,i.verify_host,i.allow_t                                                                                        raps,i.templateid,id.parent_itemid from items i inner join hosts h on i.hostid=h                                                                                        .hostid left join item_discovery id on i.itemid=id.itemid join item_rtdata ir on                                                                                         i.itemid=ir.itemid where h.status in (0,1) and i.flags<>2"