search

zabbix / zabbix-docker

Official Zabbix Dockerfiles
https://www.zabbix.com
GNU Affero General Public License v3.0
2.32k stars 1.36k forks source link

nodata on server #1060

Closed startips closed 1 year ago

startips commented 1 year ago

When I configure a ping monitoring on the server, no data is displayed. Data is displayed only when I restart the proxy. The log does not show any exception:

server:

services:
  mysql-server:
    image: mysql:8.0
    hostname: mysql-server
    container_name: mysql-server
    privileged: true
    expose:
      - 3306
    command:
      --character-set-server=utf8
      --collation-server=utf8_bin
      --default-authentication-plugin=mysql_native_password
    restart: always
    environment:
      - MYSQL_DATABASE=zabbix
      - MYSQL_USER=zabbix
      - MYSQL_PASSWORD=zbxpasswd
      - MYSQL_ROOT_PASSWORD=zbxpasswd
    volumes:
      - /etc/localtime:/etc/localtime -t
      - /home/docker/mysql/conf:/etc/mysql/conf.d
      - /home/docker/mysql/data/mysql:/var/lib/mysql
    networks:
      zabbix:
        ipv4_address: 192.168.88.9
  zabbix-java-gateway:
    image: zabbix/zabbix-java-gateway:latest
    container_name: zabbix-java-gateway
    restart: always
    volumes:
      - /etc/localtime:/etc/localtime -t
    networks:
      zabbix:
        ipv4_address: 192.168.88.10
  zabbix-server-mysql:
    image: zabbix/zabbix-server-mysql:latest
    container_name: zabbix-server-mysql
    hostname: zabbix-server
    restart: always
    volumes:
      - /etc/localtime:/etc/localtime -t
      - /home/docker/data/zabbix:/usr/lib/zabbix
      - /home/zabbix/alertscripts:/usr/lib/zabbix/alertscripts
      - /home/zabbix/externalscripts:/usr/lib/zabbix/externalscripts
    environment:
      - DB_SERVER_HOST=mysql-server
      - MYSQL_DATABASE=zabbix
      - MYSQL_USER=zabbix
      - MYSQL_PASSWORD=zbxpasswd
      - MYSQL_ROOT_PASSWORD=zbxpasswd
      - ZBX_JAVAGATEWAY=zabbix-java-gateway
      - ZBX_STARTPOLLERS=30
      - ZBX_IPMIPOLLERS=5
      - ZBX_STARTPREPROCESSORS=30
      - ZBX_STARTPOLLERSUNREACHABLE=30
      - ZBX_STARTTRAPPERS=30
      - ZBX_STARTPINGERS=200
      - ZBX_STARTDISCOVERERS=20
      - ZBX_STARTHTTPPOLLERS=20
      - ZBX_STARTTIMERS=20
      - ZBX_STARTESCALATORS=30
      - ZBX_STARTALERTERS=20
    ports:
      - 10051:10051
    depends_on:
      - mysql-server
      - zabbix-java-gateway
    networks:
      zabbix:
        ipv4_address: 192.168.88.11
  zabbix-web-nginx-mysql:
    image: zabbix/zabbix-web-nginx-mysql:latest
    container_name: zabbix-web-nginx-mysql
    restart: always
    volumes:
      - /etc/localtime:/etc/localtime -t
    environment:
      - ZBX_SERVER_HOST=zabbix-server
      - DB_SERVER_HOST=mysql-server
      - MYSQL_DATABASE=zabbix
      - MYSQL_USER=zabbix
      - MYSQL_PASSWORD=zbxpasswd
      - MYSQL_ROOT_PASSWORD=zbxpasswd
    ports:
      - 8080:8080
      - 8443:8443
    depends_on:
      - mysql-server
      - zabbix-java-gateway
    networks:
      zabbix:
        ipv4_address: 192.168.88.12

  zabbix-agent:
    image: zabbix/zabbix-agent:latest
    container_name: zabbix-agent
    restart: always
    environment:
      - ZBX_HOSTNAME=zabbix-agent
      - ZBX_SERVER_HOST=192.168.88.11
      - ZBX_SERVER_PORT=10051
    volumes:
      - /etc/localtime:/etc/localtime -t
      - /home/zabbix/agent/zabbix_agentd.d/:/etc/zabbix/zabbix_agentd.d/
      - /home/zabbix/agent/scripts/:/etc/zabbix/scripts/
    networks:
      zabbix:
        ipv4_address: 192.168.88.13
networks:
  zabbix:
    ipam:
      driver: default
      config:
        - subnet: 192.168.88.0/24

proxy:

version: '3'
services:
  mysql-server:
    image: mysql:8.0
    hostname: mysql-server
    container_name: mysql-server
    privileged: true
    expose:
      - 3306
    command:
      --character-set-server=utf8
      --collation-server=utf8_bin
      --default-authentication-plugin=mysql_native_password
    restart: always
    environment:
      - MYSQL_DATABASE=zabbix_proxy
      - MYSQL_USER=zabbix
      - MYSQL_PASSWORD=zabbix.proxy
      - MYSQL_ROOT_PASSWORD=zbxpasswd
    volumes:
      - /etc/localtime:/etc/localtime -t
      - /home/docker/mysql/conf:/etc/mysql/conf.d
      - /home/docker/mysql/data/mysql:/var/lib/mysql
    networks:
      zabbix:
        ipv4_address: 192.168.88.9

  zabbix-proxy:
    image: zabbix/zabbix-proxy-mysql
    container_name: zabbix-proxy
    restart: always
    volumes:
      - /etc/localtime:/etc/localtime:ro
    networks:
      zabbix:
        ipv4_address: 192.168.88.10
    ports:
      - 10051:10051
    environment:
      - DB_SERVER_HOST=mysql-server
      - MYSQL_DATABASE=zabbix_proxy
      - MYSQL_USER=zabbix
      - MYSQL_PASSWORD=zabbix.proxy
      - ZBX_HOSTNAME=zbx-proxy-002 #需要修改
      - ZBX_SERVER_HOST=10.72.254.40
      - ZBX_STARTPINGERS=100
      - ZBX_ENABLEREMOTECOMMANDS=1
      - ZBX_CONFIGFREQUENCY=60
    depends_on:
      - mysql-server

  zabbix-agent:
    image: zabbix/zabbix-agent:latest
    container_name: zabbix-agent-002
    restart: always
    environment:
      - ZBX_HOSTNAME=zabbix-agent-002 #需要修改
      - ZBX_SERVER_HOST=10.72.254.40
      - ZBX_SERVER_PORT=10051
    ports:
      - 10060:10050
    volumes:
      - /etc/localtime:/etc/localtime -t
      - /home/zabbix/agent/zabbix_agentd.d/:/etc/zabbix/zabbix_agentd.d/
      - /home/zabbix/agent/scripts/:/etc/zabbix/scripts/
    networks:
      zabbix:
        ipv4_address: 192.168.88.13
networks:
  zabbix:
    ipam:
      driver: default
      config:
        - subnet: 192.168.88.0/24
startips commented 1 year ago

proxy status is normal on server webui， jsut cannot be obtained from the proxy. server and proxy version are 6.2.7。

dotneft commented 1 year ago

What item are you talking? Please share Zabbix proxy log.

startips commented 1 year ago

@dotneft

477:20230217:172958.673 fping failed: no output 219:20230217:172959.513 received configuration data from server at "10.72.254.40", datalen 153137 489:20230217:173003.674 fping failed: no output 445:20230217:173008.674 fping failed: no output 443:20230217:173013.675 fping failed: no output 398:20230217:173018.676 fping failed: no output 458:20230217:173023.679 fping failed: no output 475:20230217:173028.677 fping failed: no output 419:20230217:173033.678 fping failed: no output 410:20230217:173038.678 fping failed: no output 456:20230217:173043.683 fping failed: no output 460:20230217:173048.683 fping failed: no output 396:20230217:173053.681 fping failed: no output 409:20230217:173058.682 fping failed: no output 219:20230217:173059.608 received configuration data from server at "10.72.254.40", datalen 153137 479:20230217:173103.685 fping failed: no output 402:20230217:173108.683 fping failed: no output 403:20230217:173113.683 fping failed: no output 488:20230217:173118.684 fping failed: no output 449:20230217:173123.685 fping failed: no output 399:20230217:173128.685 fping failed: no output 491:20230217:173133.686 fping failed: no output 451:20230217:173138.687 fping failed: no output 489:20230217:173143.687 fping failed: no output 486:20230217:173148.688 fping failed: no output 482:20230217:173153.689 fping failed: no output 447:20230217:173158.690 fping failed: no output 219:20230217:173159.720 received configuration data from server at "10.72.254.40", datalen 153137 441:20230217:173203.690 fping failed: no output 454:20230217:173208.691 fping failed: no output 491:20230217:173213.692 fping failed: no output

dotneft commented 1 year ago

if execute manually do you see any output?

dotneft commented 1 year ago

Do you have free space to write result on disk as file inside container?

startips commented 1 year ago

Filesystem Size Used Avail Use% Mounted on tmpfs 1.6G 1.5M 1.6G 1% /run /dev/vda4 288G 17G 272G 6% / tmpfs 7.8G 0 7.8G 0% /dev/shm tmpfs 5.0M 0 5.0M 0% /run/lock /dev/vda2 10G 351M 9.7G 4% /boot tmpfs 1.6G 4.0K 1.6G 1% /run/user/1000

startips commented 1 year ago

95694c553739:/var/lib/zabbix$ fping 10.76.232.62 10.76.232.62 is alive 95694c553739:/var/lib/zabbix$ fping 10.76.232.62 10.76.232.62 is alive 95694c553739:/var/lib/zabbix$ fping 10.76.232.1 10.76.232.1 is alive 95694c553739:/var/lib/zabbix$ fping 10.76.232.2 10.76.232.2 is alive 95694c553739:/var/lib/zabbix$

startips commented 1 year ago

You can use this file to deploy, its can reproduce.

dotneft commented 1 year ago

our compose files work fine :-) Feel free to use them. To check the problem: 1 enable debug for pinger process

  1. check exact command, which pinger process executes
  2. execute manually under the same user
  3. What output? What is inside file?
startips commented 1 year ago 
   197:20230220:145520.222 End of zbx_get_data_from_server():SUCCEED
   197:20230220:145520.222 received configuration data from server at "10.72.254.40", datalen 5712
   197:20230220:145520.222 In process_proxyconfig()
   197:20230220:145520.222 query [txnlev:1] [begin;]
   260:20230220:145520.222 In proxy_set_lastid() [proxy_history.history_lastid:1296]
   260:20230220:145520.222 query [txnlev:1] [select 1 from ids where table_name='proxy_history' and field_name='history_lastid']
   197:20230220:145520.223 In process_proxyconfig_table() table:'globalmacro'
   260:20230220:145520.223 query [txnlev:1] [update ids set nextid=1296 where table_name='proxy_history' and field_name='history_lastid']
   197:20230220:145520.223 query [txnlev:1] [select globalmacroid,macro,value,type from globalmacro]
   260:20230220:145520.223 End of proxy_set_lastid()
   260:20230220:145520.223 query [txnlev:1] [commit;]
   197:20230220:145520.223 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.223 In process_proxyconfig_table() table:'hosts'
   197:20230220:145520.223 query [txnlev:1] [select hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name,tls_connect,tls_accept,tls_issuer,tls_subject,tls_psk_identity,tls_psk from hosts]
   197:20230220:145520.224 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.224 In process_proxyconfig_table() table:'interface'
   197:20230220:145520.224 query [txnlev:1] [select interfaceid,hostid,main,type,useip,ip,dns,port,available from interface]
   197:20230220:145520.225 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.225 In process_proxyconfig_table() table:'interface_snmp'
   197:20230220:145520.225 query [txnlev:1] [select interfaceid,version,bulk,community,securityname,securitylevel,authpassphrase,privpassphrase,authprotocol,privprotocol,contextname from interface_snmp]
   260:20230220:145520.225 End of proxy_data_sender():SUCCEED more:0 flags:0x8002
   260:20230220:145520.225 zbx_setproctitle() title:'data sender [sent 3 values in 0.008421 sec, idle 1 sec]'
   197:20230220:145520.225 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.225 In process_proxyconfig_table() table:'host_inventory'
   197:20230220:145520.225 query [txnlev:1] [select hostid,type,type_full,name,alias,os,os_full,os_short,serialno_a,serialno_b,tag,asset_tag,macaddress_a,macaddress_b,hardware,hardware_full,software,software_full,software_app_a,software_app_b,software_app_c,software_app_d,software_app_e,contact,location,location_lat,location_lon,notes,chassis,model,hw_arch,vendor,contract_number,installer_name,deployment_status,url_a,url_b,url_c,host_networks,host_netmask,host_router,oob_ip,oob_netmask,oob_router,date_hw_purchase,date_hw_install,date_hw_expiry,date_hw_decomm,site_address_a,site_address_b,site_address_c,site_city,site_state,site_country,site_zip,site_rack,site_notes,poc_1_name,poc_1_email,poc_1_phone_a,poc_1_phone_b,poc_1_cell,poc_1_screen,poc_1_notes,poc_2_name,poc_2_email,poc_2_phone_a,poc_2_phone_b,poc_2_cell,poc_2_screen,poc_2_notes from host_inventory]
   197:20230220:145520.226 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.226 In process_proxyconfig_table() table:'hosts_templates'
   197:20230220:145520.226 query [txnlev:1] [select hosttemplateid,hostid,templateid,link_type from hosts_templates]
   197:20230220:145520.227 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.227 In process_proxyconfig_table() table:'hostmacro'
   197:20230220:145520.227 query [txnlev:1] [select hostmacroid,hostid,macro,value,type,automatic from hostmacro]
   197:20230220:145520.228 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.228 In process_proxyconfig_table() table:'items'
   197:20230220:145520.228 query [txnlev:1] [select itemid,type,snmp_oid,hostid,key_,delay,history,status,value_type,trapper_hosts,logtimefmt,params,ipmi_sensor,authtype,username,password,publickey,privatekey,flags,interfaceid,inventory_link,jmx_endpoint,master_itemid,timeout,url,query_fields,posts,status_codes,follow_redirects,post_type,http_proxy,headers,retrieve_mode,request_method,output_format,ssl_cert_file,ssl_key_file,ssl_key_password,verify_peer,verify_host,allow_traps from items]
   197:20230220:145520.228 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.228 In process_proxyconfig_table() table:'item_rtdata'
   197:20230220:145520.229 query [txnlev:1] [select itemid,lastlogsize,mtime from item_rtdata]
   197:20230220:145520.229 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.229 In process_proxyconfig_table() table:'item_preproc'
   197:20230220:145520.229 query [txnlev:1] [select item_preprocid,itemid,step,type,params,error_handler,error_handler_params from item_preproc]
   197:20230220:145520.230 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.230 In process_proxyconfig_table() table:'item_parameter'
   197:20230220:145520.230 query [txnlev:1] [select item_parameterid,itemid,name,value from item_parameter]
   197:20230220:145520.230 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.230 In process_proxyconfig_table() table:'drules'
   197:20230220:145520.230 query [txnlev:1] [select druleid,name,iprange,delay from drules]
   197:20230220:145520.231 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.231 In process_proxyconfig_table() table:'dchecks'
   197:20230220:145520.231 query [txnlev:1] [select dcheckid,druleid,type,key_,snmp_community,ports,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,uniq,snmpv3_authprotocol,snmpv3_privprotocol,snmpv3_contextname,host_source,name_source from dchecks]
   197:20230220:145520.231 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.231 In process_proxyconfig_table() table:'regexps'
   197:20230220:145520.231 query [txnlev:1] [select regexpid,name from regexps]
   197:20230220:145520.232 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.232 In process_proxyconfig_table() table:'expressions'
   197:20230220:145520.232 query [txnlev:1] [select expressionid,regexpid,expression,expression_type,exp_delimiter,case_sensitive from expressions]
   197:20230220:145520.232 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.232 In process_proxyconfig_table() table:'hstgrp'
   197:20230220:145520.233 query [txnlev:1] [select groupid from hstgrp]
   197:20230220:145520.233 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.233 In process_proxyconfig_table() table:'config'
   197:20230220:145520.233 query [txnlev:1] [select configid,discovery_groupid,snmptrap_logging,hk_history_global,hk_history,autoreg_tls_accept from config]
   197:20230220:145520.234 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.234 In process_proxyconfig_table() table:'httptest'
   197:20230220:145520.234 query [txnlev:1] [select httptestid,name,delay,agent,authentication,http_user,http_password,hostid,http_proxy,retries,ssl_cert_file,ssl_key_file,ssl_key_password,verify_peer,verify_host from httptest]
   197:20230220:145520.234 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.234 In process_proxyconfig_table() table:'httptestitem'
   197:20230220:145520.234 query [txnlev:1] [select httptestitemid,httptestid,itemid,type from httptestitem]
   197:20230220:145520.235 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.235 In process_proxyconfig_table() table:'httptest_field'
   197:20230220:145520.235 query [txnlev:1] [select httptest_fieldid,httptestid,type,name,value from httptest_field]
   197:20230220:145520.235 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.235 In process_proxyconfig_table() table:'httpstep'
   197:20230220:145520.235 query [txnlev:1] [select httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes,follow_redirects,retrieve_mode,post_type from httpstep]
   197:20230220:145520.236 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.236 In process_proxyconfig_table() table:'httpstepitem'
   197:20230220:145520.236 query [txnlev:1] [select httpstepitemid,httpstepid,itemid,type from httpstepitem]
   197:20230220:145520.236 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.236 In process_proxyconfig_table() table:'httpstep_field'
   197:20230220:145520.236 query [txnlev:1] [select httpstep_fieldid,httpstepid,type,name,value from httpstep_field]
   197:20230220:145520.237 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.237 In process_proxyconfig_table() table:'config_autoreg_tls'
   197:20230220:145520.237 query [txnlev:1] [select autoreg_tlsid,tls_psk_identity,tls_psk from config_autoreg_tls]
   197:20230220:145520.237 End of process_proxyconfig_table():SUCCEED
   197:20230220:145520.237 query [txnlev:1] [commit;]
   197:20230220:145520.237 End of process_proxyconfig()
   197:20230220:145520.237 In DCsync_configuration()
   197:20230220:145520.238 query [txnlev:0] [select changelogid,object,objectid,operation,clock from changelog]
   197:20230220:145520.238 query [txnlev:0] [select discovery_groupid,snmptrap_logging,severity_name_0,severity_name_1,severity_name_2,severity_name_3,severity_name_4,severity_name_5,hk_events_mode,hk_events_trigger,hk_events_internal,hk_events_discovery,hk_events_autoreg,hk_services_mode,hk_services,hk_audit_mode,hk_audit,hk_sessions_mode,hk_sessions,hk_history_mode,hk_history_global,hk_history,hk_trends_mode,hk_trends_global,hk_trends,default_inventory_mode,db_extension,autoreg_tls_accept,compression_status,compress_older,instanceid,default_timezone,hk_events_service,auditlog_enabled from config order by configid]
   197:20230220:145520.238 query [txnlev:0] [select tls_psk_identity,tls_psk from config_autoreg_tls order by autoreg_tlsid]
   197:20230220:145520.239 In DCsync_config()
   197:20230220:145520.239 End of DCsync_config()
   197:20230220:145520.239 In DCsync_autoreg_config()
   197:20230220:145520.239 End of DCsync_autoreg_config()
   197:20230220:145520.239 query [txnlev:0] [select hostid,templateid from hosts_templates order by hostid]
   197:20230220:145520.239 query [txnlev:0] [select globalmacroid,macro,value,type from globalmacro]
   197:20230220:145520.239 query [txnlev:0] [select m.hostmacroid,m.hostid,m.macro,m.value,m.type from hostmacro m inner join hosts h on m.hostid=h.hostid where h.flags<>2]
   197:20230220:145520.240 In DCsync_host_tags()
   197:20230220:145520.240 End of DCsync_host_tags()
   197:20230220:145520.240 query [txnlev:0] [select hostid,inventory_mode,type,type_full,name,alias,os,os_full,os_short,serialno_a,serialno_b,tag,asset_tag,macaddress_a,macaddress_b,hardware,hardware_full,software,software_full,software_app_a,software_app_b,software_app_c,software_app_d,software_app_e,contact,location,location_lat,location_lon,notes,chassis,model,hw_arch,vendor,contract_number,installer_name,deployment_status,url_a,url_b,url_c,host_networks,host_netmask,host_router,oob_ip,oob_netmask,oob_router,date_hw_purchase,date_hw_install,date_hw_expiry,date_hw_decomm,site_address_a,site_address_b,site_address_c,site_city,site_state,site_country,site_zip,site_rack,site_notes,poc_1_name,poc_1_email,poc_1_phone_a,poc_1_phone_b,poc_1_cell,poc_1_screen,poc_1_notes,poc_2_name,poc_2_email,poc_2_phone_a,poc_2_phone_b,poc_2_cell,poc_2_screen,poc_2_notes from host_inventory]
   197:20230220:145520.240 query [txnlev:0] [select groupid,name from hstgrp]
   197:20230220:145520.241 query [txnlev:0] [select hg.groupid,hg.hostid from hosts_groups hg,hosts h where hg.hostid=h.hostid and h.status in (0,1) and h.flags<>2 order by hg.groupid]
   197:20230220:145520.241 query [txnlev:0] [select maintenanceid,maintenance_type,active_since,active_till,tags_evaltype from maintenances]
   197:20230220:145520.241 query [txnlev:0] [select maintenancetagid,maintenanceid,operator,tag,value from maintenance_tag]
   197:20230220:145520.242 query [txnlev:0] [select t.timeperiodid,t.timeperiod_type,t.every,t.month,t.dayofweek,t.day,t.start_time,t.period,t.start_date,m.maintenanceid from maintenances_windows m,timeperiods t where t.timeperiodid=m.timeperiodid]
   197:20230220:145520.242 query [txnlev:0] [select maintenanceid,groupid from maintenances_groups order by maintenanceid]
   197:20230220:145520.242 query [txnlev:0] [select maintenanceid,hostid from maintenances_hosts order by maintenanceid]
   197:20230220:145520.242 In DCsync_hosts()
   197:20230220:145520.242 End of DCsync_hosts()
   197:20230220:145520.242 In DCsync_host_inventory()
   197:20230220:145520.242 End of DCsync_host_inventory()
   197:20230220:145520.242 In DCsync_hostgroups()
   197:20230220:145520.242 End of DCsync_hostgroups()
   197:20230220:145520.242 In DCsync_hostgroup_hosts()
   197:20230220:145520.242 End of DCsync_hostgroup_hosts()
   197:20230220:145520.242 In DCsync_maintenances()
   197:20230220:145520.242 End of DCsync_maintenances()
   197:20230220:145520.242 In DCsync_maintenance_tags()
   197:20230220:145520.242 End of DCsync_maintenance_tags()
   197:20230220:145520.242 In DCsync_maintenance_groups()
   197:20230220:145520.242 End of DCsync_maintenance_groups()
   197:20230220:145520.242 In DCsync_maintenance_hosts()
   197:20230220:145520.242 End of DCsync_maintenance_hosts()
   197:20230220:145520.242 In DCsync_maintenance_periods()
   197:20230220:145520.242 End of DCsync_maintenance_periods()
   197:20230220:145520.242 query [txnlev:0] [select i.interfaceid,i.hostid,i.type,i.main,i.useip,i.ip,i.dns,i.port,i.available,i.disable_until,i.error,i.errors_from,s.version,s.bulk,s.community,s.securityname,s.securitylevel,s.authpassphrase,s.privpassphrase,s.authprotocol,s.privprotocol,s.contextname from interface i left join interface_snmp s on i.interfaceid=s.interfaceid]
   197:20230220:145520.243 query [txnlev:0] [select i.itemid,i.hostid,i.templateid from items i inner join hosts h on i.hostid=h.hostid where h.status=3]
   197:20230220:145520.243 query [txnlev:0] [select itemid,parent_itemid from item_discovery]
   197:20230220:145520.244 query [txnlev:0] [select p.item_parameterid,p.itemid,p.name,p.value,i.hostid from item_parameter p,items i,hosts h where p.itemid=i.itemid and i.hostid=h.hostid and h.status in (0,1) and i.flags<>2 order by p.itemid]
   197:20230220:145520.244 In DCsync_interfaces()
   197:20230220:145520.244 End of DCsync_interfaces()
   197:20230220:145520.244 In DCsync_items()
   197:20230220:145520.244 End of DCsync_items()
   197:20230220:145520.244 In DCsync_template_items()
   197:20230220:145520.244 End of DCsync_template_items()
   197:20230220:145520.244 In DCsync_prototype_items()
   197:20230220:145520.244 End of DCsync_prototype_items()
   197:20230220:145520.244 In DCsync_item_discovery()
   197:20230220:145520.244 End of DCsync_item_discovery()
   197:20230220:145520.244 In DCsync_item_preproc()
   197:20230220:145520.244 End of DCsync_item_preproc()
   197:20230220:145520.244 In DCsync_itemscript_param()
   197:20230220:145520.244 End of DCsync_itemscript_param()
   197:20230220:145520.244 In DCsync_functions()
   197:20230220:145520.244 End of DCsync_functions()
   197:20230220:145520.244 query [txnlev:0] [select triggerid_down,triggerid_up from trigger_depends]
   197:20230220:145520.244 query [txnlev:0] [select r.name,e.expressionid,e.expression,e.expression_type,e.exp_delimiter,e.case_sensitive from regexps r,expressions e where r.regexpid=e.regexpid]
   197:20230220:145520.245 query [txnlev:0] [select actionid,eventsource,evaltype,formula from actions where eventsource<>4 and status=0]
   197:20230220:145520.245 query [txnlev:0] [select a.actionid,o.recovery from actions a left join operations o on a.actionid=o.actionid where a.status=0 group by a.actionid,o.recovery order by a.actionid]
   197:20230220:145520.246 query [txnlev:0] [select c.conditionid,c.actionid,c.conditiontype,c.operator,c.value,c.value2 from conditions c,actions a where c.actionid=a.actionid and a.status=0]
   197:20230220:145520.246 query [txnlev:0] [select correlationid,name,evaltype,formula from correlation where status=0]
   197:20230220:145520.246 query [txnlev:0] [select cc.corr_conditionid,cc.correlationid,cc.type,cct.tag,cctv.tag,cctv.value,cctv.operator, ccg.groupid,ccg.operator,cctp.oldtag,cctp.newtag from correlation c,corr_condition cc left join corr_condition_tag cct on cct.corr_conditionid=cc.corr_conditionid left join corr_condition_tagvalue cctv on cctv.corr_conditionid=cc.corr_conditionid left join corr_condition_group ccg on ccg.corr_conditionid=cc.corr_conditionid left join corr_condition_tagpair cctp on cctp.corr_conditionid=cc.corr_conditionid where c.correlationid=cc.correlationid and c.status=0]
   197:20230220:145520.247 query [txnlev:0] [select co.corr_operationid,co.correlationid,co.type from correlation c,corr_operation co where c.correlationid=co.correlationid and c.status=0]
   197:20230220:145520.247 In DCsync_triggers()
   197:20230220:145520.247 End of DCsync_triggers()
   197:20230220:145520.247 In DCsync_trigdeps()
   197:20230220:145520.247 End of DCsync_trigdeps()
   197:20230220:145520.247 In DCsync_expressions()
   197:20230220:145520.247 End of DCsync_expressions()
   197:20230220:145520.247 In DCsync_actions()
   197:20230220:145520.247 End of DCsync_actions()
   197:20230220:145520.247 In DCsync_action_ops()
   197:20230220:145520.247 End of DCsync_action_ops()
   197:20230220:145520.247 In DCsync_action_conditions()
   197:20230220:145520.247 End of DCsync_action_conditions()
   197:20230220:145520.247 In DCsync_trigger_tags()
   197:20230220:145520.247 End of DCsync_trigger_tags()
   197:20230220:145520.247 In DCsync_item_tags()
   197:20230220:145520.247 End of DCsync_item_tags()
   197:20230220:145520.247 In DCsync_correlations()
   197:20230220:145520.247 End of DCsync_correlations()
   197:20230220:145520.247 In DCsync_corr_conditions()
   197:20230220:145520.247 End of DCsync_corr_conditions()
   197:20230220:145520.247 In DCsync_corr_operations()
   197:20230220:145520.247 End of DCsync_corr_operations()
   197:20230220:145520.247 DCsync_configuration() changelog  : sql:0.000291 sec (0 records)
   197:20230220:145520.247 DCsync_configuration() config     : sql:0.000543 sync:0.000021 sec (1/0/0).
   197:20230220:145520.247 DCsync_configuration() autoreg    : sql:0.000256 sync:0.000010 sec (1/0/0).
   197:20230220:145520.247 DCsync_configuration() hosts      : sql:0.000006 sync:0.000018 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() host_invent: sql:0.000625 sync:0.000008 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() templates  : sql:0.000260 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() globmacros : sql:0.000232 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() hostmacros : sql:0.000621 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() interfaces : sql:0.000422 sync:0.000016 sec (1/0/0).
   197:20230220:145520.247 DCsync_configuration() items      : sql:0.000019 sync:0.000015 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() template_items      : sql:0.000580 sync:0.000009 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() prototype_items      : sql:0.000002 sync:0.000009 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() item_discovery      : sql:0.000252 sync:0.000009 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() triggers   : sql:0.000003 sync:0.000018 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() trigdeps   : sql:0.000244 sync:0.000010 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() trig. tags : sql:0.000002 sync:0.000011 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() host tags : sql:0.000003 sync:0.000021 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() item tags : sql:0.000002 sync:0.000009 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() functions  : sql:0.000002 sync:0.000009 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() expressions: sql:0.000501 sync:0.000012 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() actions    : sql:0.000336 sync:0.000011 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() operations : sql:0.000355 sync:0.000009 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() conditions : sql:0.000272 sync:0.000011 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() corr       : sql:0.000301 sync:0.000011 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() corr_cond  : sql:0.000378 sync:0.000009 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() corr_op    : sql:0.000261 sync:0.000009 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() hgroups    : sql:0.000733 sync:0.000016 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() item pproc : sql:0.000003 sync:0.000009 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() item script param: sql:0.000408 sync:0.000009 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() maintenance: sql:0.001256 sync:0.000047 sec (0/0/0).
   197:20230220:145520.247 DCsync_configuration() macro cache: 0.000000 sec.
   197:20230220:145520.247 DCsync_configuration() reindex    : 0.000000 sec.
   197:20230220:145520.247 DCsync_configuration() total sql  : 0.008466 sec.
   197:20230220:145520.247 DCsync_configuration() total sync : 0.000316 sec.
   197:20230220:145520.247 DCsync_configuration() proxies    : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() hosts      : 2 (11 slots)
   197:20230220:145520.247 DCsync_configuration() hosts_h    : 2 (11 slots)
   197:20230220:145520.247 DCsync_configuration() hosts_p    : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() psks       : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() ipmihosts  : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() host_invent: 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() glob macros: 1 (11 slots)
   197:20230220:145520.247 DCsync_configuration() host macros: 2 (11 slots)
   197:20230220:145520.247 DCsync_configuration() kvs_paths : 0
   197:20230220:145520.247 DCsync_configuration() interfaces : 0 (11 slots)
   197:20230220:145520.247 DCsync_configuration() interfaces_snmp : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() interfac_ht: 0 (11 slots)
   197:20230220:145520.247 DCsync_configuration() if_snmpitms: 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() if_snmpaddr: 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() item_discovery : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() items      : 6 (101 slots)
   197:20230220:145520.247 DCsync_configuration() items_hk   : 6 (101 slots)
   197:20230220:145520.247 DCsync_configuration() numitems   : 6 (11 slots)
   197:20230220:145520.247 DCsync_configuration() preprocitems: 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() preprocops : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() snmpitems  : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() ipmiitems  : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() trapitems  : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() dependentitems  : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() logitems   : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() dbitems    : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() sshitems   : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() telnetitems: 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() simpleitems: 6 (11 slots)
   197:20230220:145520.247 DCsync_configuration() jmxitems   : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() calcitems  : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() httpitems  : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() scriptitems  : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() functions  : 0 (101 slots)
   197:20230220:145520.247 DCsync_configuration() triggers   : 0 (101 slots)
   197:20230220:145520.247 DCsync_configuration() trigdeps   : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() trig. tags : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() expressions: 10 (17 slots)
   197:20230220:145520.247 DCsync_configuration() actions    : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() conditions : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() corr.      : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() corr. conds: 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() corr. ops  : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() hgroups    : 1 (11 slots)
   197:20230220:145520.247 DCsync_configuration() item procs : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() maintenance: 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() maint tags : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() maint time : 0 (0 slots)
   197:20230220:145520.247 DCsync_configuration() queue[0]   : 0 (0 allocated)
   197:20230220:145520.247 DCsync_configuration() queue[1]   : 0 (0 allocated)
   197:20230220:145520.247 DCsync_configuration() queue[2]   : 0 (0 allocated)
   197:20230220:145520.247 DCsync_configuration() queue[3]   : 6 (32 allocated)
   197:20230220:145520.247 DCsync_configuration() queue[4]   : 0 (0 allocated)
   197:20230220:145520.247 DCsync_configuration() queue[5]   : 0 (0 allocated)
   197:20230220:145520.247 DCsync_configuration() queue[6]   : 0 (0 allocated)
   197:20230220:145520.247 DCsync_configuration() pqueue     : 0 (0 allocated)
   197:20230220:145520.247 DCsync_configuration() timer queue: 0 (0 allocated)
   197:20230220:145520.247 DCsync_configuration() changelog  : 0
   197:20230220:145520.247 DCsync_configuration() configfree : 98.922729%
   197:20230220:145520.247 DCsync_configuration() strings    : 38 (101 slots)
   197:20230220:145520.247 === memory statistics for configuration cache ===
   197:20230220:145520.248 free chunks of size >= 256 bytes:        2
   197:20230220:145520.248 min chunk size:        776 bytes
   197:20230220:145520.248 max chunk size:    8297464 bytes
   197:20230220:145520.248 memory of total size 8385808 bytes fragmented into 152 chunks
   197:20230220:145520.248 of those,    8298240 bytes are in        2 free chunks
   197:20230220:145520.248 of those,      87568 bytes are in      150 used chunks
   197:20230220:145520.248 of those,       2416 bytes are used by allocation overhead
   197:20230220:145520.248 ================================
   197:20230220:145520.248 zbx_dbsync_env_flush_changelog() changelog  : 0 (101 slots)
   197:20230220:145520.248 End of DCsync_configuration()
   197:20230220:145520.248 In DCsync_kvs_paths()
   197:20230220:145520.248 End of DCsync_kvs_paths()
   197:20230220:145520.248 In DCupdate_interfaces_availability()
   197:20230220:145520.248 In DCreset_interfaces_availability()
   197:20230220:145520.248 End of DCreset_interfaces_availability() interfaces:0
   197:20230220:145520.248 End of DCupdate_interfaces_availability()
   197:20230220:145520.248 End of process_configuration_sync()
   197:20230220:145520.248 zbx_setproctitle() title:'configuration syncer [synced config 5712 bytes in 0.035012 sec, idle 60 sec]'
   197:20230220:145520.248 In zbx_ipc_async_socket_recv() timeout:60
   305:20230220:145520.315 zbx_setproctitle() title:'history syncer #3 [processed 0 values in 0.000038 sec, syncing history]'
   305:20230220:145520.315 In zbx_sync_history_cache() history_num:0
   305:20230220:145520.315 zbx_setproctitle() title:'history syncer #3 [processed 0 values in 0.000063 sec, idle 1 sec]'
   306:20230220:145520.316 zbx_setproctitle() title:'history syncer #4 [processed 0 values in 0.000038 sec, syncing history]'
   306:20230220:145520.316 In zbx_sync_history_cache() history_num:0
   306:20230220:145520.316 zbx_setproctitle() title:'history syncer #4 [processed 0 values in 0.000038 sec, idle 1 sec]'
   304:20230220:145520.317 zbx_setproctitle() title:'history syncer #2 [processed 3 values in 0.002687 sec, syncing history]'
   304:20230220:145520.317 In zbx_sync_history_cache() history_num:0
   304:20230220:145520.317 zbx_setproctitle() title:'history syncer #2 [processed 0 values in 0.000039 sec, idle 1 sec]'
   303:20230220:145520.317 zbx_setproctitle() title:'history syncer #1 [processed 0 values in 0.000035 sec, syncing history]'
   303:20230220:145520.317 In zbx_sync_history_cache() history_num:0
   303:20230220:145520.317 zbx_setproctitle() title:'history syncer #1 [processed 0 values in 0.000039 sec, idle 1 sec]'
   228:20230220:145520.321 End of zbx_ipc_service_recv():2
   228:20230220:145520.321 In zbx_ipc_service_recv() timeout:1.000
   261:20230220:145520.436 End of zbx_ipc_service_recv():2
   261:20230220:145520.436 zbx_setproctitle() title:'ipmi manager #1 [scheduled 0, polled 0 values, idle 5.013691 sec during 5.013696 sec]'
   261:20230220:145520.436 In DCconfig_get_ipmi_poller_items()
   261:20230220:145520.436 End of DCconfig_get_ipmi_poller_items():0
   261:20230220:145520.436 In zbx_ipc_service_recv() timeout:1.000
     7:20230220:145520.617 End of zbx_ipc_service_recv():2
     7:20230220:145520.617 In zbx_ipc_service_recv() timeout:1.000
   312:20230220:145521.183 zbx_setproctitle() title:'self-monitoring [processing data]'
   312:20230220:145521.183 In collect_selfmon_stats()
   312:20230220:145521.183 End of collect_selfmon_stats()
   312:20230220:145521.183 zbx_setproctitle() title:'self-monitoring [processed data in 0.000077 sec, idle 1 sec]'
   474:20230220:145521.221 End of zbx_ipc_service_recv():2
   474:20230220:145521.221 In zbx_ipc_service_recv() timeout:1.000
   260:20230220:145521.225 zbx_setproctitle() title:'data sender [sent 3 values in 0.008421 sec, sending data]'
   260:20230220:145521.225 In proxy_data_sender()
   260:20230220:145521.225 In get_interface_availability_data()
   260:20230220:145521.225 In DCget_interfaces_availability()
   260:20230220:145521.225 End of DCget_interfaces_availability() interfaces:0
   260:20230220:145521.225 End of get_interface_availability_data():FAIL
   260:20230220:145521.225 In proxy_get_hist_data()
   260:20230220:145521.225 In proxy_get_lastid() field:'proxy_history.history_lastid'
   260:20230220:145521.225 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
   260:20230220:145521.226 End of proxy_get_lastid():1296
   260:20230220:145521.226 In proxy_get_history_data() lastid:1296
   260:20230220:145521.226 query [txnlev:0] [select id,itemid,clock,ns,timestamp,source,severity,value,logeventid,state,lastlogsize,mtime,flags from proxy_history where id>1296 order by id limit 1000]
   260:20230220:145521.226 End of proxy_get_history_data() data_num:0
   260:20230220:145521.226 End of proxy_get_hist_data() lastid:0 records_num:0 size:~91 more:0
   260:20230220:145521.226 In proxy_get_lastid() field:'proxy_dhistory.dhistory_lastid'
   260:20230220:145521.226 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
   260:20230220:145521.227 End of proxy_get_lastid():0
   260:20230220:145521.227 In proxy_get_history_data_simple() table:'proxy_dhistory'
   260:20230220:145521.227 query [txnlev:0] [select id,clock,druleid,dcheckid,ip,dns,port,value,status from proxy_dhistory where id>0 order by id limit 1000]
   260:20230220:145521.227 End of proxy_get_history_data_simple():0 lastid:0 more:0 size:91
   260:20230220:145521.227 In proxy_get_lastid() field:'proxy_autoreg_host.autoreg_host_lastid'
   260:20230220:145521.227 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
   260:20230220:145521.227 End of proxy_get_lastid():0
   260:20230220:145521.227 In proxy_get_history_data_simple() table:'proxy_autoreg_host'
   260:20230220:145521.227 query [txnlev:0] [select id,clock,host,listen_ip,listen_dns,listen_port,host_metadata,flags,tls_accepted from proxy_autoreg_host where id>0 order by id limit 1000]
   260:20230220:145521.228 End of proxy_get_history_data_simple():0 lastid:0 more:0 size:91
   260:20230220:145521.228 In zbx_ipc_socket_write()
   260:20230220:145521.228 End of zbx_ipc_socket_write():SUCCEED
   260:20230220:145521.228 In zbx_ipc_socket_read()
   474:20230220:145521.228 End of zbx_ipc_service_recv():1
   474:20230220:145521.228 In zbx_ipc_client_send() clientid:2
   474:20230220:145521.228 End of zbx_ipc_client_send():SUCCEED
   260:20230220:145521.228 End of zbx_ipc_socket_read():SUCCEED
   474:20230220:145521.228 In zbx_ipc_service_recv() timeout:1.000
   260:20230220:145521.228 query [txnlev:0] [select t.taskid,t.type,t.clock,t.ttl,r.status,r.parent_taskid,r.info,tr.status,tr.parent_taskid,tr.info,d.data,d.parent_taskid,d.type from task t left join task_remote_command_result r on t.taskid=r.taskid left join task_result tr on t.taskid=tr.taskid left join task_data d on t.taskid=d.taskid where t.status=1 and t.type in (3,8,9) order by t.taskid]
   260:20230220:145521.228 In zbx_connect_to_server() [10.72.254.40]:10051 [timeout:600, connection timeout:3]
   260:20230220:145521.229 In is_ip4() ip:'10.72.254.40'
   260:20230220:145521.229 End of is_ip4():SUCCEED
   260:20230220:145521.229 In zbx_put_data_to_server() datalen:120
   260:20230220:145521.229 In zbx_recv_response()
   260:20230220:145521.230 zbx_recv_response() '{"upload":"enabled","response":"success"}'
   260:20230220:145521.230 End of zbx_recv_response():SUCCEED
   260:20230220:145521.230 End of zbx_put_data_to_server():SUCCEED
   260:20230220:145521.230 End of proxy_data_sender():SUCCEED more:0 flags:0x8000
   260:20230220:145521.230 zbx_setproctitle() title:'data sender [sent 0 values in 0.004639 sec, idle 1 sec]'
   305:20230220:145521.315 zbx_setproctitle() title:'history syncer #3 [processed 0 values in 0.000063 sec, syncing history]'
   305:20230220:145521.315 In zbx_sync_history_cache() history_num:0
   305:20230220:145521.315 zbx_setproctitle() title:'history syncer #3 [processed 0 values in 0.000062 sec, idle 1 sec]'
   306:20230220:145521.316 zbx_setproctitle() title:'history syncer #4 [processed 0 values in 0.000038 sec, syncing history]'
   306:20230220:145521.316 In zbx_sync_history_cache() history_num:0
   306:20230220:145521.316 zbx_setproctitle() title:'history syncer #4 [processed 0 values in 0.000038 sec, idle 1 sec]'
   304:20230220:145521.317 zbx_setproctitle() title:'history syncer #2 [processed 0 values in 0.000039 sec, syncing history]'
   304:20230220:145521.317 In zbx_sync_history_cache() history_num:0
   304:20230220:145521.317 zbx_setproctitle() title:'history syncer #2 [processed 0 values in 0.000037 sec, idle 1 sec]'
   303:20230220:145521.317 zbx_setproctitle() title:'history syncer #1 [processed 0 values in 0.000039 sec, syncing history]'
   303:20230220:145521.317 In zbx_sync_history_cache() history_num:0
   303:20230220:145521.317 zbx_setproctitle() title:'history syncer #1 [processed 0 values in 0.000038 sec, idle 1 sec]'
   228:20230220:145521.322 End of zbx_ipc_service_recv():2
   228:20230220:145521.322 In zbx_ipc_service_recv() timeout:1.000
   261:20230220:145521.437 End of zbx_ipc_service_recv():2
   261:20230220:145521.437 In DCconfig_get_ipmi_poller_items()
   261:20230220:145521.437 End of DCconfig_get_ipmi_poller_items():0
   261:20230220:145521.437 In zbx_ipc_service_recv() timeout:1.000
     7:20230220:145521.619 End of zbx_ipc_service_recv():2
     7:20230220:145521.619 In zbx_ipc_service_recv() timeout:1.000
   307:20230220:145522.025 End of zbx_ipc_async_socket_recv():0
   309:20230220:145522.025 End of zbx_ipc_async_socket_recv():0
   308:20230220:145522.046 End of zbx_ipc_async_socket_recv():0
   310:20230220:145522.067 End of zbx_ipc_async_socket_recv():0
   311:20230220:145522.181 End of zbx_ipc_async_socket_recv():0
   312:20230220:145522.183 zbx_setproctitle() title:'self-monitoring [processing data]'
   312:20230220:145522.183 In collect_selfmon_stats()
   312:20230220:145522.183 End of collect_selfmon_stats()
   312:20230220:145522.183 zbx_setproctitle() title:'self-monitoring [processed data in 0.000054 sec, idle 1 sec]'
   474:20230220:145522.228 End of zbx_ipc_service_recv():2
   474:20230220:145522.228 In zbx_ipc_service_recv() timeout:1.000
   260:20230220:145522.230 zbx_setproctitle() title:'data sender [sent 0 values in 0.004639 sec, sending data]'
   260:20230220:145522.230 In proxy_data_sender()
   260:20230220:145522.230 In get_interface_availability_data()
   260:20230220:145522.230 In DCget_interfaces_availability()
   260:20230220:145522.230 End of DCget_interfaces_availability() interfaces:0
   260:20230220:145522.230 End of get_interface_availability_data():FAIL
   260:20230220:145522.230 In proxy_get_hist_data()
   260:20230220:145522.230 In proxy_get_lastid() field:'proxy_history.history_lastid'
   260:20230220:145522.230 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
   260:20230220:145522.231 End of proxy_get_lastid():1296
   260:20230220:145522.231 In proxy_get_history_data() lastid:1296
   260:20230220:145522.231 query [txnlev:0] [select id,itemid,clock,ns,timestamp,source,severity,value,logeventid,state,lastlogsize,mtime,flags from proxy_history where id>1296 order by id limit 1000]
   260:20230220:145522.231 End of proxy_get_history_data() data_num:0
   260:20230220:145522.231 End of proxy_get_hist_data() lastid:0 records_num:0 size:~91 more:0
   260:20230220:145522.231 In proxy_get_lastid() field:'proxy_dhistory.dhistory_lastid'
   260:20230220:145522.231 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
   260:20230220:145522.231 End of proxy_get_lastid():0
   260:20230220:145522.231 In proxy_get_history_data_simple() table:'proxy_dhistory'
   260:20230220:145522.231 query [txnlev:0] [select id,clock,druleid,dcheckid,ip,dns,port,value,status from proxy_dhistory where id>0 order by id limit 1000]
   260:20230220:145522.232 End of proxy_get_history_data_simple():0 lastid:0 more:0 size:91
   260:20230220:145522.232 In proxy_get_lastid() field:'proxy_autoreg_host.autoreg_host_lastid'
   260:20230220:145522.232 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
   260:20230220:145522.232 End of proxy_get_lastid():0
   260:20230220:145522.232 In proxy_get_history_data_simple() table:'proxy_autoreg_host'
   260:20230220:145522.232 query [txnlev:0] [select id,clock,host,listen_ip,listen_dns,listen_port,host_metadata,flags,tls_accepted from proxy_autoreg_host where id>0 order by id limit 1000]
   260:20230220:145522.232 End of proxy_get_history_data_simple():0 lastid:0 more:0 size:91
   260:20230220:145522.232 In zbx_ipc_socket_write()
   260:20230220:145522.232 End of zbx_ipc_socket_write():SUCCEED
   260:20230220:145522.232 In zbx_ipc_socket_read()
   474:20230220:145522.232 End of zbx_ipc_service_recv():1
   474:20230220:145522.232 In zbx_ipc_client_send() clientid:2
   474:20230220:145522.232 End of zbx_ipc_client_send():SUCCEED
   474:20230220:145522.232 In zbx_ipc_service_recv() timeout:1.000
   260:20230220:145522.232 End of zbx_ipc_socket_read():SUCCEED
   260:20230220:145522.233 query [txnlev:0] [select t.taskid,t.type,t.clock,t.ttl,r.status,r.parent_taskid,r.info,tr.status,tr.parent_taskid,tr.info,d.data,d.parent_taskid,d.type from task t left join task_remote_command_result r on t.taskid=r.taskid left join task_result tr on t.taskid=tr.taskid left join task_data d on t.taskid=d.taskid where t.status=1 and t.type in (3,8,9) order by t.taskid]
   260:20230220:145522.233 In zbx_connect_to_server() [10.72.254.40]:10051 [timeout:600, connection timeout:3]
   260:20230220:145522.234 In is_ip4() ip:'10.72.254.40'
   260:20230220:145522.234 End of is_ip4():SUCCEED
   260:20230220:145522.234 In zbx_put_data_to_server() datalen:122
   260:20230220:145522.234 In zbx_recv_response()
   260:20230220:145522.235 zbx_recv_response() '{"upload":"enabled","response":"success"}'
   260:20230220:145522.235 End of zbx_recv_response():SUCCEED
   260:20230220:145522.235 End of zbx_put_data_to_server():SUCCEED
   260:20230220:145522.235 End of proxy_data_sender():SUCCEED more:0 flags:0x8000
   260:20230220:145522.235 zbx_setproctitle() title:'data sender [sent 0 values in 0.004796 sec, idle 1 sec]'
   305:20230220:145522.315 zbx_setproctitle() title:'history syncer #3 [processed 0 values in 0.000062 sec, syncing history]'
   305:20230220:145522.315 In zbx_sync_history_cache() history_num:0
   305:20230220:145522.315 zbx_setproctitle() title:'history syncer #3 [processed 0 values in 0.000062 sec, idle 1 sec]'
   306:20230220:145522.316 zbx_setproctitle() title:'history syncer #4 [processed 0 values in 0.000038 sec, syncing history]'
   306:20230220:145522.316 In zbx_sync_history_cache() history_num:0
   306:20230220:145522.316 zbx_setproctitle() title:'history syncer #4 [processed 0 values in 0.000037 sec, idle 1 sec]'
   382:20230220:145522.317 zbx_setproctitle() title:'icmp pinger #9 [getting values]'
   382:20230220:145522.317 In get_pinger_hosts()
   382:20230220:145522.317 In DCconfig_get_poller_items() poller_type:3
   443:20230220:145522.317 zbx_setproctitle() title:'icmp pinger #70 [getting values]'
   443:20230220:145522.317 In get_pinger_hosts()
   443:20230220:145522.317 In DCconfig_get_poller_items() poller_type:3
   382:20230220:145522.317 End of DCconfig_get_poller_items():3
   382:20230220:145522.317 In substitute_key_macros_impl() data:'icmpping'
   443:20230220:145522.317 End of DCconfig_get_poller_items():0
   443:20230220:145522.317 End of get_pinger_hosts():0
   443:20230220:145522.317 In process_pinger_hosts()
   443:20230220:145522.317 End of process_pinger_hosts()
   382:20230220:145522.317 End of substitute_key_macros_impl():SUCCEED data:'icmpping'
   382:20230220:145522.317 In add_icmpping_item() addr:'' count:3 interval:0 size:0 timeout:0
   382:20230220:145522.317 End of add_icmpping_item()
   382:20230220:145522.317 In substitute_key_macros_impl() data:'icmppingloss'
   382:20230220:145522.317 End of substitute_key_macros_impl():SUCCEED data:'icmppingloss'
   382:20230220:145522.317 In add_icmpping_item() addr:'' count:3 interval:0 size:0 timeout:0
   382:20230220:145522.317 End of add_icmpping_item()
   382:20230220:145522.317 In substitute_key_macros_impl() data:'icmppingsec'
   382:20230220:145522.317 End of substitute_key_macros_impl():SUCCEED data:'icmppingsec'
   382:20230220:145522.317 In add_icmpping_item() addr:'' count:3 interval:0 size:0 timeout:0
   382:20230220:145522.317 End of add_icmpping_item()
   443:20230220:145522.317 In DCconfig_get_poller_nextcheck() poller_type:3
   443:20230220:145522.317 End of DCconfig_get_poller_nextcheck():1676876123
   443:20230220:145522.317 zbx_setproctitle() title:'icmp pinger #70 [got 0 values in 0.000153 sec, idle 1 sec]'
   382:20230220:145522.317 End of get_pinger_hosts():3
   382:20230220:145522.317 In process_pinger_hosts()
   382:20230220:145522.317 In add_pinger_host() addr:''
   382:20230220:145522.317 End of add_pinger_host()
   382:20230220:145522.317 In add_pinger_host() addr:''
   382:20230220:145522.317 In add_pinger_host() addr:''
   382:20230220:145522.317 zbx_setproctitle() title:'icmp pinger #9 [pinging hosts]'
   382:20230220:145522.317 In zbx_ping() hosts_count:1

The proxy receives the data of 10.76.232.62 from the server, but the data is not loaded to the ping thread.

dotneft commented 1 year ago

the output does not contain any ping related data. Please check my comment again and provide ONLY required information.

startips commented 1 year ago

382:20230220:145522.317 In add_pinger_host() addr:'' The log is obvious. The IP address read here is a null value.If I restart the container, there will be an IP address here.

dotneft commented 1 year ago

it is not full log of 382 PID.

startips commented 1 year ago

sorry my fault. Maybe this is the correct PID log:

   197:20230220:143718.847 In zbx_tls_init_child()
   197:20230220:143718.847 OpenSSL library (version OpenSSL 3.0.7 1 Nov 2022) initialized
   197:20230220:143718.851 zbx_tls_init_child() PSK ciphersuites: TLS_CHACHA20_POLY1305_SHA256 TLS_AES_128_GCM_SHA256 ECDHE-PSK-AES128-CBC-SHA256 ECDHE-PSK-AES128-CBC-SHA PSK-AES128-GCM-SHA256 PSK-AES128-CCM8 PSK-AES128-CCM PSK-AES128-CBC-SHA256 PSK-AES128-CBC-SHA
   197:20230220:143718.851 End of zbx_tls_init_child()
   197:20230220:143718.851 In zbx_ipc_async_socket_open()
   197:20230220:143718.851 In zbx_ipc_socket_open()
   197:20230220:143718.851 End of zbx_ipc_socket_open():SUCCEED
   197:20230220:143718.851 End of zbx_ipc_async_socket_open():SUCCEED
   197:20230220:143718.851 In zbx_ipc_async_socket_send()
   197:20230220:143718.851 In zbx_ipc_client_send() clientid:0
   197:20230220:143718.851 End of zbx_ipc_client_send():SUCCEED
   197:20230220:143718.851 End of zbx_ipc_async_socket_send():SUCCEED
   197:20230220:143718.851 In zbx_ipc_async_socket_flush() timeout:3
   197:20230220:143718.851 End of zbx_ipc_async_socket_flush():0
   197:20230220:143718.851 zbx_setproctitle() title:'configuration syncer [connecting to the database]'
   197:20230220:143718.851 In DBconnect() flag:0
   197:20230220:143718.852 End of DBconnect():0
   197:20230220:143718.852 zbx_setproctitle() title:'configuration syncer [syncing configuration]'
   197:20230220:143718.852 In DCsync_configuration()
   197:20230220:143718.852 query [txnlev:0] [select changelogid,clock from changelog]
   197:20230220:143718.853 query [txnlev:0] [select objectid,type,clock,ns from trigger_queue]
   197:20230220:143718.853 query [txnlev:0] [select discovery_groupid,snmptrap_logging,severity_name_0,severity_name_1,severity_name_2,severity_name_3,severity_name_4,severity_name_5,hk_events_mode,hk_events_trigger,hk_events_internal,hk_events_discovery,hk_events_autoreg,hk_services_mode,hk_services,hk_audit_mode,hk_audit,hk_sessions_mode,hk_sessions,hk_history_mode,hk_history_global,hk_history,hk_trends_mode,hk_trends_global,hk_trends,default_inventory_mode,db_extension,autoreg_tls_accept,compression_status,compress_older,instanceid,default_timezone,hk_events_service,auditlog_enabled from config order by configid]
   197:20230220:143718.854 query [txnlev:0] [select tls_psk_identity,tls_psk from config_autoreg_tls order by autoreg_tlsid]
   197:20230220:143718.854 In DCsync_config()
   197:20230220:143718.854 End of DCsync_config()
   197:20230220:143718.854 In DCsync_autoreg_config()
   197:20230220:143718.854 End of DCsync_autoreg_config()
   197:20230220:143718.854 query [txnlev:0] [select hostid,templateid from hosts_templates order by hostid]
   197:20230220:143718.854 query [txnlev:0] [select globalmacroid,macro,value,type from globalmacro]
   197:20230220:143718.855 query [txnlev:0] [select m.hostmacroid,m.hostid,m.macro,m.value,m.type from hostmacro m inner join hosts h on m.hostid=h.hostid where h.flags<>2]
   197:20230220:143718.855 query [txnlev:0] [select hosttagid,hostid,tag,value from host_tag]
   197:20230220:143718.855 In DCsync_host_tags()
   197:20230220:143718.855 End of DCsync_host_tags()
   197:20230220:143718.855 query [txnlev:0] [select h.hostid,h.proxy_hostid,h.host,h.ipmi_authtype,h.ipmi_privilege,h.ipmi_username,h.ipmi_password,h.maintenance_status,h.maintenance_type,h.maintenance_from,h.status,h.name,hr.lastaccess,h.tls_connect,h.tls_accept,h.tls_issuer,h.tls_subject,h.tls_psk_identity,h.tls_psk,h.proxy_address,h.auto_compress,h.maintenanceid from hosts h left join host_rtdata hr on h.hostid=hr.hostid where status in (0,1,5,6) and flags<>2]
   197:20230220:143718.856 query [txnlev:0] [select hostid,inventory_mode,type,type_full,name,alias,os,os_full,os_short,serialno_a,serialno_b,tag,asset_tag,macaddress_a,macaddress_b,hardware,hardware_full,software,software_full,software_app_a,software_app_b,software_app_c,software_app_d,software_app_e,contact,location,location_lat,location_lon,notes,chassis,model,hw_arch,vendor,contract_number,installer_name,deployment_status,url_a,url_b,url_c,host_networks,host_netmask,host_router,oob_ip,oob_netmask,oob_router,date_hw_purchase,date_hw_install,date_hw_expiry,date_hw_decomm,site_address_a,site_address_b,site_address_c,site_city,site_state,site_country,site_zip,site_rack,site_notes,poc_1_name,poc_1_email,poc_1_phone_a,poc_1_phone_b,poc_1_cell,poc_1_screen,poc_1_notes,poc_2_name,poc_2_email,poc_2_phone_a,poc_2_phone_b,poc_2_cell,poc_2_screen,poc_2_notes from host_inventory]
   197:20230220:143718.857 query [txnlev:0] [select groupid,name from hstgrp]
   197:20230220:143718.857 query [txnlev:0] [select hg.groupid,hg.hostid from hosts_groups hg,hosts h where hg.hostid=h.hostid and h.status in (0,1) and h.flags<>2 order by hg.groupid]
   197:20230220:143718.858 query [txnlev:0] [select maintenanceid,maintenance_type,active_since,active_till,tags_evaltype from maintenances]
   197:20230220:143718.858 query [txnlev:0] [select maintenancetagid,maintenanceid,operator,tag,value from maintenance_tag]
   197:20230220:143718.858 query [txnlev:0] [select t.timeperiodid,t.timeperiod_type,t.every,t.month,t.dayofweek,t.day,t.start_time,t.period,t.start_date,m.maintenanceid from maintenances_windows m,timeperiods t where t.timeperiodid=m.timeperiodid]
   197:20230220:143718.858 query [txnlev:0] [select maintenanceid,groupid from maintenances_groups order by maintenanceid]
   197:20230220:143718.859 query [txnlev:0] [select maintenanceid,hostid from maintenances_hosts order by maintenanceid]
   197:20230220:143718.859 In DCsync_hosts()
   197:20230220:143718.859 End of DCsync_hosts()
   197:20230220:143718.859 In DCsync_host_inventory()
   197:20230220:143718.859 End of DCsync_host_inventory()
   197:20230220:143718.859 In DCsync_hostgroups()
   197:20230220:143718.859 End of DCsync_hostgroups()
   197:20230220:143718.859 In DCsync_hostgroup_hosts()
   197:20230220:143718.859 End of DCsync_hostgroup_hosts()
   197:20230220:143718.859 In DCsync_maintenances()
   197:20230220:143718.859 End of DCsync_maintenances()
   197:20230220:143718.859 In DCsync_maintenance_tags()
   197:20230220:143718.859 End of DCsync_maintenance_tags()
   197:20230220:143718.859 In DCsync_maintenance_groups()
   197:20230220:143718.859 End of DCsync_maintenance_groups()
   197:20230220:143718.859 In DCsync_maintenance_hosts()
   197:20230220:143718.859 End of DCsync_maintenance_hosts()
   197:20230220:143718.859 In DCsync_maintenance_periods()
   197:20230220:143718.859 End of DCsync_maintenance_periods()
   197:20230220:143718.859 query [txnlev:0] [select i.interfaceid,i.hostid,i.type,i.main,i.useip,i.ip,i.dns,i.port,i.available,i.disable_until,i.error,i.errors_from,s.version,s.bulk,s.community,s.securityname,s.securitylevel,s.authpassphrase,s.privpassphrase,s.authprotocol,s.privprotocol,s.contextname from interface i left join interface_snmp s on i.interfaceid=s.interfaceid]
   197:20230220:143718.860 query [txnlev:0] [select i.itemid,i.hostid,i.status,i.type,i.value_type,i.key_,i.snmp_oid,i.ipmi_sensor,i.delay,i.trapper_hosts,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.timeout,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_cert_file,i.ssl_key_file,i.ssl_key_password,i.verify_peer,i.verify_host,i.allow_traps,i.templateid,null from items i inner join hosts h on i.hostid=h.hostid join item_rtdata ir on i.itemid=ir.itemid where h.status in (0,1) and i.flags<>2]
   197:20230220:143718.861 query [txnlev:0] [select i.itemid,i.hostid,i.templateid from items i inner join hosts h on i.hostid=h.hostid where h.status=3]
   197:20230220:143718.861 query [txnlev:0] [select i.itemid,i.hostid,i.templateid from items i where i.flags=2]
   197:20230220:143718.861 query [txnlev:0] [select itemid,parent_itemid from item_discovery]
   197:20230220:143718.861 query [txnlev:0] [select item_preprocid,itemid,type,params,step,error_handler,error_handler_params from item_preproc]
   197:20230220:143718.862 query [txnlev:0] [select p.item_parameterid,p.itemid,p.name,p.value,i.hostid from item_parameter p,items i,hosts h where p.itemid=i.itemid and i.hostid=h.hostid and h.status in (0,1) and i.flags<>2 order by p.itemid]
   197:20230220:143718.862 In DCsync_interfaces()
   197:20230220:143718.862 End of DCsync_interfaces()
   197:20230220:143718.862 In DCsync_items()
   197:20230220:143718.862 End of DCsync_items()
   197:20230220:143718.862 In DCsync_template_items()
   197:20230220:143718.862 End of DCsync_template_items()
   197:20230220:143718.862 In DCsync_prototype_items()
   197:20230220:143718.862 End of DCsync_prototype_items()
   197:20230220:143718.862 In DCsync_item_discovery()
   197:20230220:143718.862 End of DCsync_item_discovery()
   197:20230220:143718.862 In DCsync_item_preproc()
   197:20230220:143718.862 End of DCsync_item_preproc()
   197:20230220:143718.862 In DCsync_itemscript_param()
   197:20230220:143718.862 End of DCsync_itemscript_param()
   197:20230220:143718.862 query [txnlev:0] [select itemtagid,itemid,tag,value from item_tag]
   197:20230220:143718.863 query [txnlev:0] [select functionid,itemid,name,parameter,triggerid from functions]
   197:20230220:143718.863 In DCsync_functions()
   197:20230220:143718.863 End of DCsync_functions()
   197:20230220:143718.863 query [txnlev:0] [select triggerid,description,expression,error,priority,type,value,state,lastchange,status,recovery_mode,recovery_expression,correlation_mode,correlation_tag,opdata,event_name,null,null,null,flags from triggers]
   197:20230220:143718.863 query [txnlev:0] [select triggerid_down,triggerid_up from trigger_depends]
   197:20230220:143718.864 query [txnlev:0] [select r.name,e.expressionid,e.expression,e.expression_type,e.exp_delimiter,e.case_sensitive from regexps r,expressions e where r.regexpid=e.regexpid]
   197:20230220:143718.864 query [txnlev:0] [select actionid,eventsource,evaltype,formula from actions where eventsource<>4 and status=0]
   197:20230220:143718.864 query [txnlev:0] [select a.actionid,o.recovery from actions a left join operations o on a.actionid=o.actionid where a.status=0 group by a.actionid,o.recovery order by a.actionid]
   197:20230220:143718.865 query [txnlev:0] [select c.conditionid,c.actionid,c.conditiontype,c.operator,c.value,c.value2 from conditions c,actions a where c.actionid=a.actionid and a.status=0]
   197:20230220:143718.865 query [txnlev:0] [select triggertagid,triggerid,tag,value from trigger_tag]
   197:20230220:143718.866 query [txnlev:0] [select correlationid,name,evaltype,formula from correlation where status=0]
   197:20230220:143718.866 query [txnlev:0] [select cc.corr_conditionid,cc.correlationid,cc.type,cct.tag,cctv.tag,cctv.value,cctv.operator, ccg.groupid,ccg.operator,cctp.oldtag,cctp.newtag from correlation c,corr_condition cc left join corr_condition_tag cct on cct.corr_conditionid=cc.corr_conditionid left join corr_condition_tagvalue cctv on cctv.corr_conditionid=cc.corr_conditionid left join corr_condition_group ccg on ccg.corr_conditionid=cc.corr_conditionid left join corr_condition_tagpair cctp on cctp.corr_conditionid=cc.corr_conditionid where c.correlationid=cc.correlationid and c.status=0]
   197:20230220:143718.867 query [txnlev:0] [select co.corr_operationid,co.correlationid,co.type from correlation c,corr_operation co where c.correlationid=co.correlationid and c.status=0]
   197:20230220:143718.867 In DCsync_triggers()
   197:20230220:143718.867 End of DCsync_triggers()
   197:20230220:143718.867 In DCsync_trigdeps()
   197:20230220:143718.867 End of DCsync_trigdeps()
   197:20230220:143718.867 In DCsync_expressions()
   197:20230220:143718.867 End of DCsync_expressions()
   197:20230220:143718.867 In DCsync_actions()
   197:20230220:143718.867 End of DCsync_actions()
   197:20230220:143718.867 In DCsync_action_ops()
   197:20230220:143718.867 End of DCsync_action_ops()
   197:20230220:143718.867 In DCsync_action_conditions()
   197:20230220:143718.867 End of DCsync_action_conditions()
   197:20230220:143718.867 In DCsync_trigger_tags()
   197:20230220:143718.867 End of DCsync_trigger_tags()
   197:20230220:143718.867 In DCsync_item_tags()
   197:20230220:143718.867 End of DCsync_item_tags()
   197:20230220:143718.867 In DCsync_correlations()
   197:20230220:143718.867 End of DCsync_correlations()
   197:20230220:143718.867 In DCsync_corr_conditions()
   197:20230220:143718.867 End of DCsync_corr_conditions()
   197:20230220:143718.867 In DCsync_corr_operations()
   197:20230220:143718.867 End of DCsync_corr_operations()
   197:20230220:143718.867 DCsync_configuration() changelog  : sql:0.000405 sec (0 records)
   197:20230220:143718.867 DCsync_configuration() config     : sql:0.000537 sync:0.000046 sec (1/0/0).
   197:20230220:143718.867 DCsync_configuration() autoreg    : sql:0.000329 sync:0.000009 sec (1/0/0).
   197:20230220:143718.867 DCsync_configuration() hosts      : sql:0.000747 sync:0.000030 sec (2/0/0).
   197:20230220:143718.867 DCsync_configuration() host_invent: sql:0.000679 sync:0.000009 sec (0/0/0).
   197:20230220:143718.867 DCsync_configuration() templates  : sql:0.000287 sec (2/0/0).
   197:20230220:143718.867 DCsync_configuration() globmacros : sql:0.000299 sec (1/0/0).
   197:20230220:143718.868 DCsync_configuration() hostmacros : sql:0.000520 sec (2/0/0).
   197:20230220:143718.868 DCsync_configuration() interfaces : sql:0.000631 sync:0.000032 sec (2/0/0).
   197:20230220:143718.868 DCsync_configuration() items      : sql:0.000962 sync:0.000091 sec (6/0/0).
   197:20230220:143718.868 DCsync_configuration() template_items      : sql:0.000329 sync:0.000049 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() prototype_items      : sql:0.000234 sync:0.000009 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() item_discovery      : sql:0.000275 sync:0.000009 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() triggers   : sql:0.000361 sync:0.000026 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() trigdeps   : sql:0.000268 sync:0.000009 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() trig. tags : sql:0.000287 sync:0.000009 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() host tags : sql:0.000307 sync:0.000019 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() item tags : sql:0.000323 sync:0.000009 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() functions  : sql:0.000279 sync:0.000022 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() expressions: sql:0.000439 sync:0.000078 sec (10/0/0).
   197:20230220:143718.868 DCsync_configuration() actions    : sql:0.000350 sync:0.000009 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() operations : sql:0.000510 sync:0.000010 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() conditions : sql:0.000339 sync:0.000048 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() corr       : sql:0.000358 sync:0.000009 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() corr_cond  : sql:0.000777 sync:0.000009 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() corr_op    : sql:0.000510 sync:0.000039 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() hgroups    : sql:0.000699 sync:0.000026 sec (1/0/0).
   197:20230220:143718.868 DCsync_configuration() item pproc : sql:0.000295 sync:0.000010 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() item script param: sql:0.000421 sync:0.000009 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() maintenance: sql:0.001380 sync:0.000045 sec (0/0/0).
   197:20230220:143718.868 DCsync_configuration() macro cache: 0.000012 sec.
   197:20230220:143718.868 DCsync_configuration() reindex    : 0.000002 sec.
   197:20230220:143718.868 DCsync_configuration() total sql  : 0.013001 sec.
   197:20230220:143718.868 DCsync_configuration() total sync : 0.000654 sec.
   197:20230220:143718.868 DCsync_configuration() proxies    : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() hosts      : 2 (11 slots)
   197:20230220:143718.868 DCsync_configuration() hosts_h    : 2 (11 slots)
   197:20230220:143718.868 DCsync_configuration() hosts_p    : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() psks       : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() ipmihosts  : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() host_invent: 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() glob macros: 1 (11 slots)
   197:20230220:143718.868 DCsync_configuration() host macros: 2 (11 slots)
   197:20230220:143718.868 DCsync_configuration() kvs_paths : 0
   197:20230220:143718.868 DCsync_configuration() interfaces : 2 (11 slots)
   197:20230220:143718.868 DCsync_configuration() interfaces_snmp : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() interfac_ht: 2 (11 slots)
   197:20230220:143718.868 DCsync_configuration() if_snmpitms: 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() if_snmpaddr: 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() item_discovery : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() items      : 6 (101 slots)
   197:20230220:143718.868 DCsync_configuration() items_hk   : 6 (101 slots)
   197:20230220:143718.868 DCsync_configuration() numitems   : 6 (11 slots)
   197:20230220:143718.868 DCsync_configuration() preprocitems: 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() preprocops : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() snmpitems  : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() ipmiitems  : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() trapitems  : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() dependentitems  : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() logitems   : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() dbitems    : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() sshitems   : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() telnetitems: 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() simpleitems: 6 (11 slots)
   197:20230220:143718.868 DCsync_configuration() jmxitems   : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() calcitems  : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() httpitems  : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() scriptitems  : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() functions  : 0 (101 slots)
   197:20230220:143718.868 DCsync_configuration() triggers   : 0 (101 slots)
   197:20230220:143718.868 DCsync_configuration() trigdeps   : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() trig. tags : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() expressions: 10 (17 slots)
   197:20230220:143718.868 DCsync_configuration() actions    : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() conditions : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() corr.      : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() corr. conds: 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() corr. ops  : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() hgroups    : 1 (11 slots)
   197:20230220:143718.868 DCsync_configuration() item procs : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() maintenance: 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() maint tags : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() maint time : 0 (0 slots)
   197:20230220:143718.868 DCsync_configuration() queue[0]   : 0 (0 allocated)
   197:20230220:143718.868 DCsync_configuration() queue[1]   : 0 (0 allocated)
   197:20230220:143718.868 DCsync_configuration() queue[2]   : 0 (0 allocated)
   197:20230220:143718.868 DCsync_configuration() queue[3]   : 6 (32 allocated)
   197:20230220:143718.868 DCsync_configuration() queue[4]   : 0 (0 allocated)
   197:20230220:143718.868 DCsync_configuration() queue[5]   : 0 (0 allocated)
   197:20230220:143718.868 DCsync_configuration() queue[6]   : 0 (0 allocated)
   197:20230220:143718.868 DCsync_configuration() pqueue     : 0 (0 allocated)
   197:20230220:143718.868 DCsync_configuration() timer queue: 0 (0 allocated)
   197:20230220:143718.868 DCsync_configuration() changelog  : 0
   197:20230220:143718.868 DCsync_configuration() configfree : 98.913765%
   197:20230220:143718.868 DCsync_configuration() strings    : 39 (101 slots)
   197:20230220:143718.868 === memory statistics for configuration cache ===
   197:20230220:143718.868 free chunks of size     24 bytes:        1
   197:20230220:143718.868 free chunks of size >= 256 bytes:        1
   197:20230220:143718.868 min chunk size:         24 bytes
   197:20230220:143718.868 max chunk size:    8297464 bytes
   197:20230220:143718.868 memory of total size 8385680 bytes fragmented into 160 chunks
   197:20230220:143718.868 of those,    8297488 bytes are in        2 free chunks
   197:20230220:143718.868 of those,      88192 bytes are in      158 used chunks
   197:20230220:143718.868 of those,       2544 bytes are used by allocation overhead
   197:20230220:143718.868 ================================
   197:20230220:143718.868 In dc_get_items_to_reschedule()
   197:20230220:143718.868 End of dc_get_items_to_reschedule() items:0
   197:20230220:143718.868 DCsync_configuration() reschedule : 0.000012 sec.
   197:20230220:143718.869 End of DCsync_configuration()
   197:20230220:143718.869 In zbx_ipc_async_socket_send()
   197:20230220:143718.869 In zbx_ipc_client_send() clientid:0
   197:20230220:143718.869 End of zbx_ipc_client_send():SUCCEED
   197:20230220:143718.869 End of zbx_ipc_async_socket_send():SUCCEED
   197:20230220:143718.869 In zbx_ipc_async_socket_flush() timeout:3
   197:20230220:143718.869 End of zbx_ipc_async_socket_flush():0
   197:20230220:143718.869 In zbx_ipc_async_socket_recv() timeout:0
   197:20230220:143718.869 End of zbx_ipc_async_socket_recv():0
   197:20230220:143718.869 zbx_setproctitle() title:'configuration syncer [loading configuration]'
   197:20230220:143718.869 In process_configuration_sync()
   197:20230220:143718.869 In zbx_connect_to_server() [10.72.254.40]:10051 [timeout:600, connection timeout:3]
   197:20230220:143718.869 In is_ip4() ip:'10.72.254.40'
   197:20230220:143718.870 End of is_ip4():SUCCEED
   197:20230220:143718.870 In zbx_get_data_from_server()
   197:20230220:143718.881 Received [{"globalmacro":{"fields":["globalmacroid","macro","value","type"],"data":[[2,"{$SNMP_COMMUNITY}","public",0]]},"hosts":{"fields":["hostid","host","status","ipmi_authtype","ipmi_privilege","ipmi_username","ipmi_password","name","tls_connect","tls_accept","tls_issuer","tls_subject","tls_psk_identity","tls_psk"],"data":[[10542,"icmp_monitor",3,-1,2,"","","icmp_monitor",1,1,"","","",""],[10715,"10.76.243.2",0,-1,2,"","","10.76.243.2",1,1,"","","",""],[10716,"10.76.243.1",0,-1,2,"","","10.76.243.1",1,1,"","","",""]]},"interface":{"fields":["interfaceid","hostid","main","type","useip","ip","dns","port","available"],"data":[[187,10715,1,1,1,"10.76.243.2","","10050",0],[188,10716,1,1,1,"10.76.243.1","","10050",0]]},"interface_snmp":{"fields":["interfaceid","version","bulk","community","securityname","securitylevel","authpassphrase","privpassphrase","authprotocol","privprotocol","contextname"],"data":[]},"host_inventory":{"fields":["hostid","type","type_full","name","alias","os","os_full","os_short","serialno_a","serialno_b","tag","asset_tag","macaddress_a","macaddress_b","hardware","hardware_full","software","software_full","software_app_a","software_app_b","software_app_c","software_app_d","software_app_e","contact","location","location_lat","location_lon","notes","chassis","model","hw_arch","vendor","contract_number","installer_name","deployment_status","url_a","url_b","url_c","host_networks","host_netmask","host_router","oob_ip","oob_netmask","oob_router","date_hw_purchase","date_hw_install","date_hw_expiry","date_hw_decomm","site_address_a","site_address_b","site_address_c","site_city","site_state","site_country","site_zip","site_rack","site_notes","poc_1_name","poc_1_email","poc_1_phone_a","poc_1_phone_b","poc_1_cell","poc_1_screen","poc_1_notes","poc_2_name","poc_2_email","poc_2_phone_a","poc_2_phone_b","poc_2_cell","poc_2_screen","poc_2_notes"],"data":[]},"hosts_templates":{"fields":["hosttemplateid","hostid","templateid","link_type"],"data":[[607,10715,10542,0],[608,10716,10542,0]]},"hostmacro":{"fields":["hostmacroid","hostid","macro","value","type","automatic"],"data":[[5704,10542,"{$ICMP_LOSS_WARN}","20",0,0],[5705,10542,"{$ICMP_RESPONSE_TIME_WARN}","0.15",0,0]]},"items":{"fields":["itemid","type","snmp_oid","hostid","key_","delay","history","status","value_type","trapper_hosts","logtimefmt","params","ipmi_sensor","authtype","username","password","publickey","privatekey","flags","interfaceid","inventory_link","jmx_endpoint","master_itemid","timeout","url","query_fields","posts","status_codes","follow_redirects","post_type","http_proxy","headers","retrieve_mode","request_method","output_format","ssl_cert_file","ssl_key_file","ssl_key_password","verify_peer","verify_host","allow_traps"],"data":[[45725,3,"",10715,"icmpping","5s","60d",0,3,"","","","",0,"","","","",0,187,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0],[45726,3,"",10715,"icmppingloss","5s","60d",0,0,"","","","",0,"","","","",0,187,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0],[45727,3,"",10715,"icmppingsec","5s","60d",0,0,"","","","",0,"","","","",0,187,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0],[45728,3,"",10716,"icmpping","5s","60d",0,3,"","","","",0,"","","","",0,188,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0],[45729,3,"",10716,"icmppingloss","5s","60d",0,0,"","","","",0,"","","","",0,188,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0],[45730,3,"",10716,"icmppingsec","5s","60d",0,0,"","","","",0,"","","","",0,188,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0]]},"item_rtdata":{"fields":["itemid","lastlogsize","mtime"],"data":[[45725,0,0],[45726,0,0],[45727,0,0],[45728,0,0],[45729,0,0],[45730,0,0]]},"item_preproc":{"fields":["item_preprocid","itemid","step","type","params","error_handler","error_handler_params"],"data":[]},"item_parameter":{"fields":["item_parameterid","itemid","name","value"],"data":[]},"drules":{"fields":["druleid","name","iprange","delay"],"data":[]},"dchecks":{"fields":["dcheckid","druleid","type","key_","snmp_community","ports","snmpv3_securityname","snmpv3_securitylevel","snmpv3_authpassphrase","snmpv3_privpassphrase","uniq","snmpv3_authprotocol","snmpv3_privprotocol","snmpv3_contextname","host_source","name_source"],"data":[]},"regexps":{"fields":["regexpid","name"],"data":[[1,"File systems for discovery"],[2,"Network interfaces for discovery"],[3,"Storage devices for SNMP discovery"],[4,"Windows service names for discovery"],[5,"Windows service startup states for discovery"]]},"expressions":{"fields":["expressionid","regexpid","expression","expression_type","exp_delimiter","case_sensitive"],"data":[[1,1,"^(btrfs|ext2|ext3|ext4|reiser|xfs|ffs|ufs|jfs|jfs2|vxfs|hfs|apfs|refs|ntfs|fat32|zfs)$",3,",",0],[3,3,"^(Physical memory|Virtual memory|Memory buffers|Cached memory|Swap space)$",4,",",1],[5,4,"^(MMCSS|gupdate|SysmonLog|clr_optimization_v2.0.50727_32|clr_optimization_v4.0.30319_32)$",4,",",1],[6,5,"^(automatic|automatic delayed)$",3,",",1],[7,2,"^Software Loopback Interface",4,",",1],[8,2,"^(In)?[Ll]oop[Bb]ack[0-9._]*$",4,",",1],[9,2,"^NULL[0-9.]*$",4,",",1],[10,2,"^[Ll]o[0-9.]*$",4,",",1],[11,2,"^[Ss]ystem$",4,",",1],[12,2,"^Nu[0-9.]*$",4,",",1]]},"hstgrp":{"fields":["groupid"],"data":[[5]]},"config":{"fields":["configid","discovery_groupid","snmptrap_logging","hk_history_global","hk_history","autoreg_tls_accept"],"data":[[1,5,1,0,"90d",1]]},"httptest":{"fields":["httptestid","name","delay","agent","authentication","http_user","http_password","hostid","http_proxy","retries","ssl_cert_file","ssl_key_file","ssl_key_password","verify_peer","verify_host"],"data":[]},"httptestitem":{"fields":["httptestitemid","httptestid","itemid","type"],"data":[]},"httptest_field":{"fields":["httptest_fieldid","httptestid","type","name","value"],"data":[]},"httpstep":{"fields":["httpstepid","httptestid","name","no","url","timeout","posts","required","status_codes","follow_redirects","retrieve_mode","post_type"],"data":[]},"httpstepitem":{"fields":["httpstepitemid","httpstepid","itemid","type"],"data":[]},"httpstep_field":{"fields":["httpstep_fieldid","httpstepid","type","name","value"],"data":[]},"config_autoreg_tls":{"fields":["autoreg_tlsid","tls_psk_identity","tls_psk"],"data":[[1,"",""]]},"macro.secrets":{}}] from server
   197:20230220:143718.881 End of zbx_get_data_from_server():SUCCEED
   197:20230220:143718.882 received configuration data from server at "10.72.254.40", datalen 6296
   197:20230220:143718.882 In process_proxyconfig()
   197:20230220:143718.882 query [txnlev:1] [begin;]
   197:20230220:143718.882 In process_proxyconfig_table() table:'globalmacro'
   197:20230220:143718.883 query [txnlev:1] [select globalmacroid,macro,value,type from globalmacro]
   197:20230220:143718.884 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.884 In process_proxyconfig_table() table:'hosts'
   197:20230220:143718.884 query [txnlev:1] [select hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name,tls_connect,tls_accept,tls_issuer,tls_subject,tls_psk_identity,tls_psk from hosts]
   197:20230220:143718.885 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.885 In process_proxyconfig_table() table:'interface'
   197:20230220:143718.885 query [txnlev:1] [select interfaceid,hostid,main,type,useip,ip,dns,port,available from interface]
   197:20230220:143718.886 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.886 In process_proxyconfig_table() table:'interface_snmp'
   197:20230220:143718.886 query [txnlev:1] [select interfaceid,version,bulk,community,securityname,securitylevel,authpassphrase,privpassphrase,authprotocol,privprotocol,contextname from interface_snmp]
   197:20230220:143718.889 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.889 In process_proxyconfig_table() table:'host_inventory'
   197:20230220:143718.889 query [txnlev:1] [select hostid,type,type_full,name,alias,os,os_full,os_short,serialno_a,serialno_b,tag,asset_tag,macaddress_a,macaddress_b,hardware,hardware_full,software,software_full,software_app_a,software_app_b,software_app_c,software_app_d,software_app_e,contact,location,location_lat,location_lon,notes,chassis,model,hw_arch,vendor,contract_number,installer_name,deployment_status,url_a,url_b,url_c,host_networks,host_netmask,host_router,oob_ip,oob_netmask,oob_router,date_hw_purchase,date_hw_install,date_hw_expiry,date_hw_decomm,site_address_a,site_address_b,site_address_c,site_city,site_state,site_country,site_zip,site_rack,site_notes,poc_1_name,poc_1_email,poc_1_phone_a,poc_1_phone_b,poc_1_cell,poc_1_screen,poc_1_notes,poc_2_name,poc_2_email,poc_2_phone_a,poc_2_phone_b,poc_2_cell,poc_2_screen,poc_2_notes from host_inventory]
   197:20230220:143718.891 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.891 In process_proxyconfig_table() table:'hosts_templates'
   197:20230220:143718.892 query [txnlev:1] [select hosttemplateid,hostid,templateid,link_type from hosts_templates]
   197:20230220:143718.893 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.893 In process_proxyconfig_table() table:'hostmacro'
   197:20230220:143718.894 query [txnlev:1] [select hostmacroid,hostid,macro,value,type,automatic from hostmacro]
   197:20230220:143718.896 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.896 In process_proxyconfig_table() table:'items'
   197:20230220:143718.896 query [txnlev:1] [select itemid,type,snmp_oid,hostid,key_,delay,history,status,value_type,trapper_hosts,logtimefmt,params,ipmi_sensor,authtype,username,password,publickey,privatekey,flags,interfaceid,inventory_link,jmx_endpoint,master_itemid,timeout,url,query_fields,posts,status_codes,follow_redirects,post_type,http_proxy,headers,retrieve_mode,request_method,output_format,ssl_cert_file,ssl_key_file,ssl_key_password,verify_peer,verify_host,allow_traps from items]
   197:20230220:143718.899 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.899 In process_proxyconfig_table() table:'item_rtdata'
   197:20230220:143718.900 query [txnlev:1] [select itemid,lastlogsize,mtime from item_rtdata]
   197:20230220:143718.901 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.901 In process_proxyconfig_table() table:'item_preproc'
   197:20230220:143718.902 query [txnlev:1] [select item_preprocid,itemid,step,type,params,error_handler,error_handler_params from item_preproc]
   197:20230220:143718.903 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.903 In process_proxyconfig_table() table:'item_parameter'
   197:20230220:143718.904 query [txnlev:1] [select item_parameterid,itemid,name,value from item_parameter]
   197:20230220:143718.904 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.904 In process_proxyconfig_table() table:'drules'
   197:20230220:143718.905 query [txnlev:1] [select druleid,name,iprange,delay from drules]
   197:20230220:143718.905 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.905 In process_proxyconfig_table() table:'dchecks'
   197:20230220:143718.906 query [txnlev:1] [select dcheckid,druleid,type,key_,snmp_community,ports,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,uniq,snmpv3_authprotocol,snmpv3_privprotocol,snmpv3_contextname,host_source,name_source from dchecks]
   197:20230220:143718.907 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.907 In process_proxyconfig_table() table:'regexps'
   197:20230220:143718.907 query [txnlev:1] [select regexpid,name from regexps]
   197:20230220:143718.909 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.909 In process_proxyconfig_table() table:'expressions'
   197:20230220:143718.909 query [txnlev:1] [select expressionid,regexpid,expression,expression_type,exp_delimiter,case_sensitive from expressions]
   197:20230220:143718.910 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.910 In process_proxyconfig_table() table:'hstgrp'
   197:20230220:143718.911 query [txnlev:1] [select groupid from hstgrp]
   197:20230220:143718.911 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.911 In process_proxyconfig_table() table:'config'
   197:20230220:143718.912 query [txnlev:1] [select configid,discovery_groupid,snmptrap_logging,hk_history_global,hk_history,autoreg_tls_accept from config]
   197:20230220:143718.912 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.913 In process_proxyconfig_table() table:'httptest'
   197:20230220:143718.913 query [txnlev:1] [select httptestid,name,delay,agent,authentication,http_user,http_password,hostid,http_proxy,retries,ssl_cert_file,ssl_key_file,ssl_key_password,verify_peer,verify_host from httptest]
   197:20230220:143718.914 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.914 In process_proxyconfig_table() table:'httptestitem'
   197:20230220:143718.914 query [txnlev:1] [select httptestitemid,httptestid,itemid,type from httptestitem]
   197:20230220:143718.915 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.915 In process_proxyconfig_table() table:'httptest_field'
   197:20230220:143718.915 query [txnlev:1] [select httptest_fieldid,httptestid,type,name,value from httptest_field]
   197:20230220:143718.916 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.916 In process_proxyconfig_table() table:'httpstep'
   197:20230220:143718.916 query [txnlev:1] [select httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes,follow_redirects,retrieve_mode,post_type from httpstep]
   197:20230220:143718.917 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.917 In process_proxyconfig_table() table:'httpstepitem'
   197:20230220:143718.917 query [txnlev:1] [select httpstepitemid,httpstepid,itemid,type from httpstepitem]
   197:20230220:143718.918 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.918 In process_proxyconfig_table() table:'httpstep_field'
   197:20230220:143718.918 query [txnlev:1] [select httpstep_fieldid,httpstepid,type,name,value from httpstep_field]
   197:20230220:143718.919 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.919 In process_proxyconfig_table() table:'config_autoreg_tls'
   197:20230220:143718.919 query [txnlev:1] [select autoreg_tlsid,tls_psk_identity,tls_psk from config_autoreg_tls]
   197:20230220:143718.920 End of process_proxyconfig_table():SUCCEED
   197:20230220:143718.920 query [txnlev:1] [commit;]
   197:20230220:143718.921 End of process_proxyconfig()
   197:20230220:143718.921 In DCsync_configuration()
   197:20230220:143718.921 query [txnlev:0] [select changelogid,object,objectid,operation,clock from changelog]
   197:20230220:143718.925 query [txnlev:0] [select discovery_groupid,snmptrap_logging,severity_name_0,severity_name_1,severity_name_2,severity_name_3,severity_name_4,severity_name_5,hk_events_mode,hk_events_trigger,hk_events_internal,hk_events_discovery,hk_events_autoreg,hk_services_mode,hk_services,hk_audit_mode,hk_audit,hk_sessions_mode,hk_sessions,hk_history_mode,hk_history_global,hk_history,hk_trends_mode,hk_trends_global,hk_trends,default_inventory_mode,db_extension,autoreg_tls_accept,compression_status,compress_older,instanceid,default_timezone,hk_events_service,auditlog_enabled from config order by configid]
   197:20230220:143718.926 query [txnlev:0] [select tls_psk_identity,tls_psk from config_autoreg_tls order by autoreg_tlsid]
   197:20230220:143718.927 In DCsync_config()
   197:20230220:143718.927 End of DCsync_config()
   197:20230220:143718.927 In DCsync_autoreg_config()
   197:20230220:143718.927 End of DCsync_autoreg_config()
   197:20230220:143718.927 query [txnlev:0] [select hostid,templateid from hosts_templates order by hostid]
   197:20230220:143718.927 query [txnlev:0] [select globalmacroid,macro,value,type from globalmacro]
   197:20230220:143718.928 query [txnlev:0] [select m.hostmacroid,m.hostid,m.macro,m.value,m.type from hostmacro m inner join hosts h on m.hostid=h.hostid where h.flags<>2]
   197:20230220:143718.929 In DCsync_host_tags()
   197:20230220:143718.929 End of DCsync_host_tags()
   197:20230220:143718.929 query [txnlev:0] [select hostid,inventory_mode,type,type_full,name,alias,os,os_full,os_short,serialno_a,serialno_b,tag,asset_tag,macaddress_a,macaddress_b,hardware,hardware_full,software,software_full,software_app_a,software_app_b,software_app_c,software_app_d,software_app_e,contact,location,location_lat,location_lon,notes,chassis,model,hw_arch,vendor,contract_number,installer_name,deployment_status,url_a,url_b,url_c,host_networks,host_netmask,host_router,oob_ip,oob_netmask,oob_router,date_hw_purchase,date_hw_install,date_hw_expiry,date_hw_decomm,site_address_a,site_address_b,site_address_c,site_city,site_state,site_country,site_zip,site_rack,site_notes,poc_1_name,poc_1_email,poc_1_phone_a,poc_1_phone_b,poc_1_cell,poc_1_screen,poc_1_notes,poc_2_name,poc_2_email,poc_2_phone_a,poc_2_phone_b,poc_2_cell,poc_2_screen,poc_2_notes from host_inventory]
   197:20230220:143718.930 query [txnlev:0] [select groupid,name from hstgrp]
   197:20230220:143718.931 query [txnlev:0] [select hg.groupid,hg.hostid from hosts_groups hg,hosts h where hg.hostid=h.hostid and h.status in (0,1) and h.flags<>2 order by hg.groupid]
   197:20230220:143718.932 query [txnlev:0] [select maintenanceid,maintenance_type,active_since,active_till,tags_evaltype from maintenances]
   197:20230220:143718.933 query [txnlev:0] [select maintenancetagid,maintenanceid,operator,tag,value from maintenance_tag]
   197:20230220:143718.933 query [txnlev:0] [select t.timeperiodid,t.timeperiod_type,t.every,t.month,t.dayofweek,t.day,t.start_time,t.period,t.start_date,m.maintenanceid from maintenances_windows m,timeperiods t where t.timeperiodid=m.timeperiodid]
   197:20230220:143718.935 query [txnlev:0] [select maintenanceid,groupid from maintenances_groups order by maintenanceid]
   197:20230220:143718.936 query [txnlev:0] [select maintenanceid,hostid from maintenances_hosts order by maintenanceid]
   197:20230220:143718.940 In DCsync_hosts()
   197:20230220:143718.940 End of DCsync_hosts()
   197:20230220:143718.941 In DCsync_host_inventory()
   197:20230220:143718.941 End of DCsync_host_inventory()
   197:20230220:143718.941 In DCsync_hostgroups()
   197:20230220:143718.941 End of DCsync_hostgroups()
   197:20230220:143718.941 In DCsync_hostgroup_hosts()
   197:20230220:143718.941 End of DCsync_hostgroup_hosts()
   197:20230220:143718.942 In DCsync_maintenances()
   197:20230220:143718.942 End of DCsync_maintenances()
   197:20230220:143718.942 In DCsync_maintenance_tags()
   197:20230220:143718.944 End of DCsync_maintenance_tags()
   197:20230220:143718.945 In DCsync_maintenance_groups()
   197:20230220:143718.945 End of DCsync_maintenance_groups()
   197:20230220:143718.945 In DCsync_maintenance_hosts()
   197:20230220:143718.945 End of DCsync_maintenance_hosts()
   197:20230220:143718.945 In DCsync_maintenance_periods()
   197:20230220:143718.946 End of DCsync_maintenance_periods()
   197:20230220:143718.946 query [txnlev:0] [select i.interfaceid,i.hostid,i.type,i.main,i.useip,i.ip,i.dns,i.port,i.available,i.disable_until,i.error,i.errors_from,s.version,s.bulk,s.community,s.securityname,s.securitylevel,s.authpassphrase,s.privpassphrase,s.authprotocol,s.privprotocol,s.contextname from interface i left join interface_snmp s on i.interfaceid=s.interfaceid]
   197:20230220:143718.948 query [txnlev:0] [select i.itemid,i.hostid,i.templateid from items i inner join hosts h on i.hostid=h.hostid where h.status=3]
   197:20230220:143718.949 query [txnlev:0] [select itemid,parent_itemid from item_discovery]
   197:20230220:143718.949 query [txnlev:0] [select p.item_parameterid,p.itemid,p.name,p.value,i.hostid from item_parameter p,items i,hosts h where p.itemid=i.itemid and i.hostid=h.hostid and h.status in (0,1) and i.flags<>2 order by p.itemid]
   197:20230220:143718.950 In DCsync_interfaces()
   197:20230220:143718.950 End of DCsync_interfaces()
   197:20230220:143718.950 In DCsync_items()
   197:20230220:143718.950 End of DCsync_items()
   197:20230220:143718.950 In DCsync_template_items()
   197:20230220:143718.950 End of DCsync_template_items()
   197:20230220:143718.950 In DCsync_prototype_items()
   197:20230220:143718.950 End of DCsync_prototype_items()
   197:20230220:143718.950 In DCsync_item_discovery()
   197:20230220:143718.950 End of DCsync_item_discovery()
   197:20230220:143718.950 In DCsync_item_preproc()
   197:20230220:143718.950 End of DCsync_item_preproc()
   197:20230220:143718.950 In DCsync_itemscript_param()
   197:20230220:143718.950 End of DCsync_itemscript_param()
   197:20230220:143718.950 In DCsync_functions()
   197:20230220:143718.950 End of DCsync_functions()
   197:20230220:143718.950 query [txnlev:0] [select triggerid_down,triggerid_up from trigger_depends]
   197:20230220:143718.951 query [txnlev:0] [select r.name,e.expressionid,e.expression,e.expression_type,e.exp_delimiter,e.case_sensitive from regexps r,expressions e where r.regexpid=e.regexpid]
   197:20230220:143718.952 query [txnlev:0] [select actionid,eventsource,evaltype,formula from actions where eventsource<>4 and status=0]
   197:20230220:143718.952 query [txnlev:0] [select a.actionid,o.recovery from actions a left join operations o on a.actionid=o.actionid where a.status=0 group by a.actionid,o.recovery order by a.actionid]
   197:20230220:143718.953 query [txnlev:0] [select c.conditionid,c.actionid,c.conditiontype,c.operator,c.value,c.value2 from conditions c,actions a where c.actionid=a.actionid and a.status=0]
   197:20230220:143718.953 query [txnlev:0] [select correlationid,name,evaltype,formula from correlation where status=0]
   197:20230220:143718.954 query [txnlev:0] [select cc.corr_conditionid,cc.correlationid,cc.type,cct.tag,cctv.tag,cctv.value,cctv.operator, ccg.groupid,ccg.operator,cctp.oldtag,cctp.newtag from correlation c,corr_condition cc left join corr_condition_tag cct on cct.corr_conditionid=cc.corr_conditionid left join corr_condition_tagvalue cctv on cctv.corr_conditionid=cc.corr_conditionid left join corr_condition_group ccg on ccg.corr_conditionid=cc.corr_conditionid left join corr_condition_tagpair cctp on cctp.corr_conditionid=cc.corr_conditionid where c.correlationid=cc.correlationid and c.status=0]
   197:20230220:143718.954 query [txnlev:0] [select co.corr_operationid,co.correlationid,co.type from correlation c,corr_operation co where c.correlationid=co.correlationid and c.status=0]
   197:20230220:143718.955 In DCsync_triggers()
   197:20230220:143718.955 End of DCsync_triggers()
   197:20230220:143718.955 In DCsync_trigdeps()
   197:20230220:143718.955 End of DCsync_trigdeps()
   197:20230220:143718.955 In DCsync_expressions()
   197:20230220:143718.955 End of DCsync_expressions()
   197:20230220:143718.955 In DCsync_actions()
   197:20230220:143718.956 End of DCsync_actions()
   197:20230220:143718.956 In DCsync_action_ops()
   197:20230220:143718.956 End of DCsync_action_ops()
   197:20230220:143718.956 In DCsync_action_conditions()
   197:20230220:143718.956 End of DCsync_action_conditions()
   197:20230220:143718.956 In DCsync_trigger_tags()
   197:20230220:143718.956 End of DCsync_trigger_tags()
   197:20230220:143718.957 In DCsync_item_tags()
   197:20230220:143718.957 End of DCsync_item_tags()
   197:20230220:143718.957 In DCsync_correlations()
   197:20230220:143718.957 End of DCsync_correlations()
   197:20230220:143718.957 In DCsync_corr_conditions()
   197:20230220:143718.957 End of DCsync_corr_conditions()
   197:20230220:143718.958 In DCsync_corr_operations()
   197:20230220:143718.958 End of DCsync_corr_operations()
   197:20230220:143718.958 DCsync_configuration() changelog  : sql:0.004287 sec (0 records)
   197:20230220:143718.958 DCsync_configuration() config     : sql:0.000714 sync:0.000037 sec (1/0/0).
   197:20230220:143718.958 DCsync_configuration() autoreg    : sql:0.000822 sync:0.000070 sec (1/0/0).
   197:20230220:143718.958 DCsync_configuration() hosts      : sql:0.000009 sync:0.003488 sec (0/0/0).
   197:20230220:143718.958 DCsync_configuration() host_invent: sql:0.001225 sync:0.000983 sec (0/0/0).
   197:20230220:143718.958 DCsync_configuration() templates  : sql:0.000594 sec (0/0/0).
   197:20230220:143718.958 DCsync_configuration() globmacros : sql:0.000682 sec (0/0/0).
   197:20230220:143718.958 DCsync_configuration() hostmacros : sql:0.000805 sec (0/0/0).
   197:20230220:143718.958 DCsync_configuration() interfaces : sql:0.001700 sync:0.000095 sec (0/0/0).
   197:20230220:143718.958 DCsync_configuration() items      : sql:0.000030 sync:0.000016 sec (0/0/0).
   197:20230220:143718.958 DCsync_configuration() template_items      : sql:0.001597 sync:0.000015 sec (0/0/0).
   197:20230220:143718.958 DCsync_configuration() prototype_items      : sql:0.000009 sync:0.000015 sec (0/0/0).
   197:20230220:143718.958 DCsync_configuration() item_discovery      : sql:0.000497 sync:0.000020 sec (0/0/0).
   197:20230220:143718.958 DCsync_configuration() triggers   : sql:0.000005 sync:0.000542 sec (0/0/0).
   197:20230220:143718.958 DCsync_configuration() trigdeps   : sql:0.000395 sync:0.000031 sec (0/0/0).
   197:20230220:143718.958 DCsync_configuration() trig. tags : sql:0.000007 sync:0.000540 sec (0/0/0).
   197:20230220:143718.958 DCsync_configuration() host tags : sql:0.000004 sync:0.000095 sec (0/0/0).
   197:20230220:143718.958 DCsync_configuration() item tags : sql:0.000004 sync:0.000032 sec (0/0/0).
   197:20230220:143718.958 DCsync_configuration() functions  : sql:0.000003 sync:0.000015 sec (0/0/0).
   197:20230220:143718.958 DCsync_configuration() expressions: sql:0.001027 sync:0.000128 sec (0/0/0).
   197:20230220:143718.959 DCsync_configuration() actions    : sql:0.000417 sync:0.000463 sec (0/0/0).
   197:20230220:143718.959 DCsync_configuration() operations : sql:0.000913 sync:0.000025 sec (0/0/0).
   197:20230220:143718.959 DCsync_configuration() conditions : sql:0.000386 sync:0.000089 sec (0/0/0).
   197:20230220:143718.959 DCsync_configuration() corr       : sql:0.000373 sync:0.000056 sec (0/0/0).
   197:20230220:143718.959 DCsync_configuration() corr_cond  : sql:0.000586 sync:0.000418 sec (0/0/0).
   197:20230220:143718.959 DCsync_configuration() corr_op    : sql:0.000447 sync:0.000700 sec (0/0/0).
   197:20230220:143718.959 DCsync_configuration() hgroups    : sql:0.001530 sync:0.000308 sec (0/0/0).
   197:20230220:143718.959 DCsync_configuration() item pproc : sql:0.000004 sync:0.000015 sec (0/0/0).
   197:20230220:143718.959 DCsync_configuration() item script param: sql:0.000533 sync:0.000015 sec (0/0/0).
   197:20230220:143718.959 DCsync_configuration() maintenance: sql:0.005013 sync:0.004000 sec (0/0/0).
   197:20230220:143718.959 DCsync_configuration() macro cache: 0.000000 sec.
   197:20230220:143718.959 DCsync_configuration() reindex    : 0.000000 sec.
   197:20230220:143718.959 DCsync_configuration() total sql  : 0.019795 sec.
   197:20230220:143718.959 DCsync_configuration() total sync : 0.012105 sec.
   197:20230220:143718.959 DCsync_configuration() proxies    : 0 (0 slots)
   197:20230220:143718.959 DCsync_configuration() hosts      : 2 (11 slots)
   197:20230220:143718.959 DCsync_configuration() hosts_h    : 2 (11 slots)
   197:20230220:143718.959 DCsync_configuration() hosts_p    : 0 (0 slots)
   197:20230220:143718.960 DCsync_configuration() psks       : 0 (0 slots)
   197:20230220:143718.960 DCsync_configuration() ipmihosts  : 0 (0 slots)
   197:20230220:143718.960 DCsync_configuration() host_invent: 0 (0 slots)
   197:20230220:143718.960 DCsync_configuration() glob macros: 1 (11 slots)
   197:20230220:143718.960 DCsync_configuration() host macros: 2 (11 slots)
   197:20230220:143718.960 DCsync_configuration() kvs_paths : 0
   197:20230220:143718.960 DCsync_configuration() interfaces : 2 (11 slots)
   197:20230220:143718.960 DCsync_configuration() interfaces_snmp : 0 (0 slots)
   197:20230220:143718.960 DCsync_configuration() interfac_ht: 2 (11 slots)
   197:20230220:143718.960 DCsync_configuration() if_snmpitms: 0 (0 slots)
   197:20230220:143718.960 DCsync_configuration() if_snmpaddr: 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() item_discovery : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() items      : 6 (101 slots)
   197:20230220:143718.961 DCsync_configuration() items_hk   : 6 (101 slots)
   197:20230220:143718.961 DCsync_configuration() numitems   : 6 (11 slots)
   197:20230220:143718.961 DCsync_configuration() preprocitems: 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() preprocops : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() snmpitems  : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() ipmiitems  : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() trapitems  : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() dependentitems  : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() logitems   : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() dbitems    : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() sshitems   : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() telnetitems: 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() simpleitems: 6 (11 slots)
   197:20230220:143718.961 DCsync_configuration() jmxitems   : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() calcitems  : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() httpitems  : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() scriptitems  : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() functions  : 0 (101 slots)
   197:20230220:143718.961 DCsync_configuration() triggers   : 0 (101 slots)
   197:20230220:143718.961 DCsync_configuration() trigdeps   : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() trig. tags : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() expressions: 10 (17 slots)
   197:20230220:143718.961 DCsync_configuration() actions    : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() conditions : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() corr.      : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() corr. conds: 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() corr. ops  : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() hgroups    : 1 (11 slots)
   197:20230220:143718.961 DCsync_configuration() item procs : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() maintenance: 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() maint tags : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() maint time : 0 (0 slots)
   197:20230220:143718.961 DCsync_configuration() queue[0]   : 0 (0 allocated)
   197:20230220:143718.961 DCsync_configuration() queue[1]   : 0 (0 allocated)
   197:20230220:143718.961 DCsync_configuration() queue[2]   : 0 (0 allocated)
   197:20230220:143718.961 DCsync_configuration() queue[3]   : 6 (32 allocated)
   197:20230220:143718.961 DCsync_configuration() queue[4]   : 0 (0 allocated)
   197:20230220:143718.961 DCsync_configuration() queue[5]   : 0 (0 allocated)
   197:20230220:143718.961 DCsync_configuration() queue[6]   : 0 (0 allocated)
   197:20230220:143718.961 DCsync_configuration() pqueue     : 0 (0 allocated)
   197:20230220:143718.961 DCsync_configuration() timer queue: 0 (0 allocated)
   197:20230220:143718.961 DCsync_configuration() changelog  : 0
   197:20230220:143718.961 DCsync_configuration() configfree : 98.913765%
   197:20230220:143718.961 DCsync_configuration() strings    : 39 (101 slots)
   197:20230220:143718.961 === memory statistics for configuration cache ===
   197:20230220:143718.961 free chunks of size     24 bytes:        1
   197:20230220:143718.961 free chunks of size >= 256 bytes:        1
   197:20230220:143718.961 min chunk size:         24 bytes
   197:20230220:143718.961 max chunk size:    8297464 bytes
   197:20230220:143718.961 memory of total size 8385680 bytes fragmented into 160 chunks
   197:20230220:143718.962 of those,    8297488 bytes are in        2 free chunks
   197:20230220:143718.962 of those,      88192 bytes are in      158 used chunks
   197:20230220:143718.962 of those,       2544 bytes are used by allocation overhead
   197:20230220:143718.962 ================================
   197:20230220:143718.962 zbx_dbsync_env_flush_changelog() changelog  : 0 (101 slots)
   197:20230220:143718.962 End of DCsync_configuration()
   197:20230220:143718.962 In DCsync_kvs_paths()
   197:20230220:143718.962 End of DCsync_kvs_paths()
   197:20230220:143718.962 In DCupdate_interfaces_availability()
   197:20230220:143718.962 In DCreset_interfaces_availability()
   197:20230220:143718.962 End of DCreset_interfaces_availability() interfaces:0
   197:20230220:143718.976 End of DCupdate_interfaces_availability()
   197:20230220:143718.976 End of process_configuration_sync()
   197:20230220:143718.976 zbx_setproctitle() title:'configuration syncer [synced config 6296 bytes in 0.106924 sec, idle 60 sec]'
   197:20230220:143718.978 In zbx_ipc_async_socket_recv() timeout:60
   197:20230220:143819.006 End of zbx_ipc_async_socket_recv():0
   197:20230220:143819.006 zbx_setproctitle() title:'configuration syncer [loading configuration]'
   197:20230220:143819.006 In process_configuration_sync()
   197:20230220:143819.006 In zbx_connect_to_server() [10.72.254.40]:10051 [timeout:600, connection timeout:3]
   197:20230220:143819.006 In is_ip4() ip:'10.72.254.40'
   197:20230220:143819.006 End of is_ip4():SUCCEED
   197:20230220:143819.006 In zbx_get_data_from_server()
   197:20230220:143819.018 Received [{"globalmacro":{"fields":["globalmacroid","macro","value","type"],"data":[[2,"{$SNMP_COMMUNITY}","public",0]]},"hosts":{"fields":["hostid","host","status","ipmi_authtype","ipmi_privilege","ipmi_username","ipmi_password","name","tls_connect","tls_accept","tls_issuer","tls_subject","tls_psk_identity","tls_psk"],"data":[[10542,"icmp_monitor",3,-1,2,"","","icmp_monitor",1,1,"","","",""],[10715,"10.76.243.2",0,-1,2,"","","10.76.243.2",1,1,"","","",""],[10716,"10.76.243.1",0,-1,2,"","","10.76.243.1",1,1,"","","",""]]},"interface":{"fields":["interfaceid","hostid","main","type","useip","ip","dns","port","available"],"data":[[187,10715,1,1,1,"10.76.243.2","","10050",0],[188,10716,1,1,1,"10.76.243.1","","10050",0]]},"interface_snmp":{"fields":["interfaceid","version","bulk","community","securityname","securitylevel","authpassphrase","privpassphrase","authprotocol","privprotocol","contextname"],"data":[]},"host_inventory":{"fields":["hostid","type","type_full","name","alias","os","os_full","os_short","serialno_a","serialno_b","tag","asset_tag","macaddress_a","macaddress_b","hardware","hardware_full","software","software_full","software_app_a","software_app_b","software_app_c","software_app_d","software_app_e","contact","location","location_lat","location_lon","notes","chassis","model","hw_arch","vendor","contract_number","installer_name","deployment_status","url_a","url_b","url_c","host_networks","host_netmask","host_router","oob_ip","oob_netmask","oob_router","date_hw_purchase","date_hw_install","date_hw_expiry","date_hw_decomm","site_address_a","site_address_b","site_address_c","site_city","site_state","site_country","site_zip","site_rack","site_notes","poc_1_name","poc_1_email","poc_1_phone_a","poc_1_phone_b","poc_1_cell","poc_1_screen","poc_1_notes","poc_2_name","poc_2_email","poc_2_phone_a","poc_2_phone_b","poc_2_cell","poc_2_screen","poc_2_notes"],"data":[]},"hosts_templates":{"fields":["hosttemplateid","hostid","templateid","link_type"],"data":[[607,10715,10542,0],[608,10716,10542,0]]},"hostmacro":{"fields":["hostmacroid","hostid","macro","value","type","automatic"],"data":[[5704,10542,"{$ICMP_LOSS_WARN}","20",0,0],[5705,10542,"{$ICMP_RESPONSE_TIME_WARN}","0.15",0,0]]},"items":{"fields":["itemid","type","snmp_oid","hostid","key_","delay","history","status","value_type","trapper_hosts","logtimefmt","params","ipmi_sensor","authtype","username","password","publickey","privatekey","flags","interfaceid","inventory_link","jmx_endpoint","master_itemid","timeout","url","query_fields","posts","status_codes","follow_redirects","post_type","http_proxy","headers","retrieve_mode","request_method","output_format","ssl_cert_file","ssl_key_file","ssl_key_password","verify_peer","verify_host","allow_traps"],"data":[[45725,3,"",10715,"icmpping","5s","60d",0,3,"","","","",0,"","","","",0,187,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0],[45726,3,"",10715,"icmppingloss","5s","60d",0,0,"","","","",0,"","","","",0,187,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0],[45727,3,"",10715,"icmppingsec","5s","60d",0,0,"","","","",0,"","","","",0,187,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0],[45728,3,"",10716,"icmpping","5s","60d",0,3,"","","","",0,"","","","",0,188,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0],[45729,3,"",10716,"icmppingloss","5s","60d",0,0,"","","","",0,"","","","",0,188,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0],[45730,3,"",10716,"icmppingsec","5s","60d",0,0,"","","","",0,"","","","",0,188,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0]]},"item_rtdata":{"fields":["itemid","lastlogsize","mtime"],"data":[[45725,0,0],[45726,0,0],[45727,0,0],[45728,0,0],[45729,0,0],[45730,0,0]]},"item_preproc":{"fields":["item_preprocid","itemid","step","type","params","error_handler","error_handler_params"],"data":[]},"item_parameter":{"fields":["item_parameterid","itemid","name","value"],"data":[]},"drules":{"fields":["druleid","name","iprange","delay"],"data":[]},"dchecks":{"fields":["dcheckid","druleid","type","key_","snmp_community","ports","snmpv3_securityname","snmpv3_securitylevel","snmpv3_authpassphrase","snmpv3_privpassphrase","uniq","snmpv3_authprotocol","snmpv3_privprotocol","snmpv3_contextname","host_source","name_source"],"data":[]},"regexps":{"fields":["regexpid","name"],"data":[[1,"File systems for discovery"],[2,"Network interfaces for discovery"],[3,"Storage devices for SNMP discovery"],[4,"Windows service names for discovery"],[5,"Windows service startup states for discovery"]]},"expressions":{"fields":["expressionid","regexpid","expression","expression_type","exp_delimiter","case_sensitive"],"data":[[1,1,"^(btrfs|ext2|ext3|ext4|reiser|xfs|ffs|ufs|jfs|jfs2|vxfs|hfs|apfs|refs|ntfs|fat32|zfs)$",3,",",0],[3,3,"^(Physical memory|Virtual memory|Memory buffers|Cached memory|Swap space)$",4,",",1],[5,4,"^(MMCSS|gupdate|SysmonLog|clr_optimization_v2.0.50727_32|clr_optimization_v4.0.30319_32)$",4,",",1],[6,5,"^(automatic|automatic delayed)$",3,",",1],[7,2,"^Software Loopback Interface",4,",",1],[8,2,"^(In)?[Ll]oop[Bb]ack[0-9._]*$",4,",",1],[9,2,"^NULL[0-9.]*$",4,",",1],[10,2,"^[Ll]o[0-9.]*$",4,",",1],[11,2,"^[Ss]ystem$",4,",",1],[12,2,"^Nu[0-9.]*$",4,",",1]]},"hstgrp":{"fields":["groupid"],"data":[[5]]},"config":{"fields":["configid","discovery_groupid","snmptrap_logging","hk_history_global","hk_history","autoreg_tls_accept"],"data":[[1,5,1,0,"90d",1]]},"httptest":{"fields":["httptestid","name","delay","agent","authentication","http_user","http_password","hostid","http_proxy","retries","ssl_cert_file","ssl_key_file","ssl_key_password","verify_peer","verify_host"],"data":[]},"httptestitem":{"fields":["httptestitemid","httptestid","itemid","type"],"data":[]},"httptest_field":{"fields":["httptest_fieldid","httptestid","type","name","value"],"data":[]},"httpstep":{"fields":["httpstepid","httptestid","name","no","url","timeout","posts","required","status_codes","follow_redirects","retrieve_mode","post_type"],"data":[]},"httpstepitem":{"fields":["httpstepitemid","httpstepid","itemid","type"],"data":[]},"httpstep_field":{"fields":["httpstep_fieldid","httpstepid","type","name","value"],"data":[]},"config_autoreg_tls":{"fields":["autoreg_tlsid","tls_psk_identity","tls_psk"],"data":[[1,"",""]]},"macro.secrets":{}}] from server
   197:20230220:143819.018 End of zbx_get_data_from_server():SUCCEED
   197:20230220:143819.018 received configuration data from server at "10.72.254.40", datalen 6296
   197:20230220:143819.018 In process_proxyconfig()
   197:20230220:143819.018 query [txnlev:1] [begin;]
   197:20230220:143819.018 In process_proxyconfig_table() table:'globalmacro'
   197:20230220:143819.018 query [txnlev:1] [select globalmacroid,macro,value,type from globalmacro]
   197:20230220:143819.019 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.019 In process_proxyconfig_table() table:'hosts'
   197:20230220:143819.019 query [txnlev:1] [select hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name,tls_connect,tls_accept,tls_issuer,tls_subject,tls_psk_identity,tls_psk from hosts]
   197:20230220:143819.019 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.019 In process_proxyconfig_table() table:'interface'
   197:20230220:143819.019 query [txnlev:1] [select interfaceid,hostid,main,type,useip,ip,dns,port,available from interface]
   197:20230220:143819.020 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.020 In process_proxyconfig_table() table:'interface_snmp'
   197:20230220:143819.020 query [txnlev:1] [select interfaceid,version,bulk,community,securityname,securitylevel,authpassphrase,privpassphrase,authprotocol,privprotocol,contextname from interface_snmp]
   197:20230220:143819.020 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.020 In process_proxyconfig_table() table:'host_inventory'
   197:20230220:143819.020 query [txnlev:1] [select hostid,type,type_full,name,alias,os,os_full,os_short,serialno_a,serialno_b,tag,asset_tag,macaddress_a,macaddress_b,hardware,hardware_full,software,software_full,software_app_a,software_app_b,software_app_c,software_app_d,software_app_e,contact,location,location_lat,location_lon,notes,chassis,model,hw_arch,vendor,contract_number,installer_name,deployment_status,url_a,url_b,url_c,host_networks,host_netmask,host_router,oob_ip,oob_netmask,oob_router,date_hw_purchase,date_hw_install,date_hw_expiry,date_hw_decomm,site_address_a,site_address_b,site_address_c,site_city,site_state,site_country,site_zip,site_rack,site_notes,poc_1_name,poc_1_email,poc_1_phone_a,poc_1_phone_b,poc_1_cell,poc_1_screen,poc_1_notes,poc_2_name,poc_2_email,poc_2_phone_a,poc_2_phone_b,poc_2_cell,poc_2_screen,poc_2_notes from host_inventory]
   197:20230220:143819.021 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.021 In process_proxyconfig_table() table:'hosts_templates'
   197:20230220:143819.021 query [txnlev:1] [select hosttemplateid,hostid,templateid,link_type from hosts_templates]
   197:20230220:143819.021 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.021 In process_proxyconfig_table() table:'hostmacro'
   197:20230220:143819.021 query [txnlev:1] [select hostmacroid,hostid,macro,value,type,automatic from hostmacro]
   197:20230220:143819.022 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.022 In process_proxyconfig_table() table:'items'
   197:20230220:143819.022 query [txnlev:1] [select itemid,type,snmp_oid,hostid,key_,delay,history,status,value_type,trapper_hosts,logtimefmt,params,ipmi_sensor,authtype,username,password,publickey,privatekey,flags,interfaceid,inventory_link,jmx_endpoint,master_itemid,timeout,url,query_fields,posts,status_codes,follow_redirects,post_type,http_proxy,headers,retrieve_mode,request_method,output_format,ssl_cert_file,ssl_key_file,ssl_key_password,verify_peer,verify_host,allow_traps from items]
   197:20230220:143819.022 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.022 In process_proxyconfig_table() table:'item_rtdata'
   197:20230220:143819.023 query [txnlev:1] [select itemid,lastlogsize,mtime from item_rtdata]
   197:20230220:143819.023 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.023 In process_proxyconfig_table() table:'item_preproc'
   197:20230220:143819.023 query [txnlev:1] [select item_preprocid,itemid,step,type,params,error_handler,error_handler_params from item_preproc]
   197:20230220:143819.023 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.023 In process_proxyconfig_table() table:'item_parameter'
   197:20230220:143819.023 query [txnlev:1] [select item_parameterid,itemid,name,value from item_parameter]
   197:20230220:143819.024 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.024 In process_proxyconfig_table() table:'drules'
   197:20230220:143819.024 query [txnlev:1] [select druleid,name,iprange,delay from drules]
   197:20230220:143819.024 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.024 In process_proxyconfig_table() table:'dchecks'
   197:20230220:143819.024 query [txnlev:1] [select dcheckid,druleid,type,key_,snmp_community,ports,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,uniq,snmpv3_authprotocol,snmpv3_privprotocol,snmpv3_contextname,host_source,name_source from dchecks]
   197:20230220:143819.024 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.025 In process_proxyconfig_table() table:'regexps'
   197:20230220:143819.025 query [txnlev:1] [select regexpid,name from regexps]
   197:20230220:143819.025 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.025 In process_proxyconfig_table() table:'expressions'
   197:20230220:143819.025 query [txnlev:1] [select expressionid,regexpid,expression,expression_type,exp_delimiter,case_sensitive from expressions]
   197:20230220:143819.025 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.025 In process_proxyconfig_table() table:'hstgrp'
   197:20230220:143819.026 query [txnlev:1] [select groupid from hstgrp]
   197:20230220:143819.026 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.026 In process_proxyconfig_table() table:'config'
   197:20230220:143819.026 query [txnlev:1] [select configid,discovery_groupid,snmptrap_logging,hk_history_global,hk_history,autoreg_tls_accept from config]
   197:20230220:143819.026 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.026 In process_proxyconfig_table() table:'httptest'
   197:20230220:143819.026 query [txnlev:1] [select httptestid,name,delay,agent,authentication,http_user,http_password,hostid,http_proxy,retries,ssl_cert_file,ssl_key_file,ssl_key_password,verify_peer,verify_host from httptest]
   197:20230220:143819.027 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.027 In process_proxyconfig_table() table:'httptestitem'
   197:20230220:143819.027 query [txnlev:1] [select httptestitemid,httptestid,itemid,type from httptestitem]
   197:20230220:143819.027 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.027 In process_proxyconfig_table() table:'httptest_field'
   197:20230220:143819.027 query [txnlev:1] [select httptest_fieldid,httptestid,type,name,value from httptest_field]
   197:20230220:143819.027 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.027 In process_proxyconfig_table() table:'httpstep'
   197:20230220:143819.028 query [txnlev:1] [select httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes,follow_redirects,retrieve_mode,post_type from httpstep]
   197:20230220:143819.028 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.028 In process_proxyconfig_table() table:'httpstepitem'
   197:20230220:143819.028 query [txnlev:1] [select httpstepitemid,httpstepid,itemid,type from httpstepitem]
   197:20230220:143819.028 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.028 In process_proxyconfig_table() table:'httpstep_field'
   197:20230220:143819.028 query [txnlev:1] [select httpstep_fieldid,httpstepid,type,name,value from httpstep_field]
   197:20230220:143819.029 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.029 In process_proxyconfig_table() table:'config_autoreg_tls'
   197:20230220:143819.029 query [txnlev:1] [select autoreg_tlsid,tls_psk_identity,tls_psk from config_autoreg_tls]
   197:20230220:143819.029 End of process_proxyconfig_table():SUCCEED
   197:20230220:143819.029 query [txnlev:1] [commit;]
   197:20230220:143819.029 End of process_proxyconfig()
   197:20230220:143819.029 In DCsync_configuration()
   197:20230220:143819.029 query [txnlev:0] [select changelogid,object,objectid,operation,clock from changelog]
   197:20230220:143819.029 query [txnlev:0] [select discovery_groupid,snmptrap_logging,severity_name_0,severity_name_1,severity_name_2,severity_name_3,severity_name_4,severity_name_5,hk_events_mode,hk_events_trigger,hk_events_internal,hk_events_discovery,hk_events_autoreg,hk_services_mode,hk_services,hk_audit_mode,hk_audit,hk_sessions_mode,hk_sessions,hk_history_mode,hk_history_global,hk_history,hk_trends_mode,hk_trends_global,hk_trends,default_inventory_mode,db_extension,autoreg_tls_accept,compression_status,compress_older,instanceid,default_timezone,hk_events_service,auditlog_enabled from config order by configid]
   197:20230220:143819.030 query [txnlev:0] [select tls_psk_identity,tls_psk from config_autoreg_tls order by autoreg_tlsid]
   197:20230220:143819.030 In DCsync_config()
   197:20230220:143819.030 End of DCsync_config()
   197:20230220:143819.030 In DCsync_autoreg_config()
   197:20230220:143819.030 End of DCsync_autoreg_config()
   197:20230220:143819.030 query [txnlev:0] [select hostid,templateid from hosts_templates order by hostid]
   197:20230220:143819.030 query [txnlev:0] [select globalmacroid,macro,value,type from globalmacro]
   197:20230220:143819.030 query [txnlev:0] [select m.hostmacroid,m.hostid,m.macro,m.value,m.type from hostmacro m inner join hosts h on m.hostid=h.hostid where h.flags<>2]
   197:20230220:143819.031 In DCsync_host_tags()
   197:20230220:143819.031 End of DCsync_host_tags()
   197:20230220:143819.031 query [txnlev:0] [select hostid,inventory_mode,type,type_full,name,alias,os,os_full,os_short,serialno_a,serialno_b,tag,asset_tag,macaddress_a,macaddress_b,hardware,hardware_full,software,software_full,software_app_a,software_app_b,software_app_c,software_app_d,software_app_e,contact,location,location_lat,location_lon,notes,chassis,model,hw_arch,vendor,contract_number,installer_name,deployment_status,url_a,url_b,url_c,host_networks,host_netmask,host_router,oob_ip,oob_netmask,oob_router,date_hw_purchase,date_hw_install,date_hw_expiry,date_hw_decomm,site_address_a,site_address_b,site_address_c,site_city,site_state,site_country,site_zip,site_rack,site_notes,poc_1_name,poc_1_email,poc_1_phone_a,poc_1_phone_b,poc_1_cell,poc_1_screen,poc_1_notes,poc_2_name,poc_2_email,poc_2_phone_a,poc_2_phone_b,poc_2_cell,poc_2_screen,poc_2_notes from host_inventory]
   197:20230220:143819.031 query [txnlev:0] [select groupid,name from hstgrp]
   197:20230220:143819.031 query [txnlev:0] [select hg.groupid,hg.hostid from hosts_groups hg,hosts h where hg.hostid=h.hostid and h.status in (0,1) and h.flags<>2 order by hg.groupid]
   197:20230220:143819.032 query [txnlev:0] [select maintenanceid,maintenance_type,active_since,active_till,tags_evaltype from maintenances]
   197:20230220:143819.032 query [txnlev:0] [select maintenancetagid,maintenanceid,operator,tag,value from maintenance_tag]
   197:20230220:143819.032 query [txnlev:0] [select t.timeperiodid,t.timeperiod_type,t.every,t.month,t.dayofweek,t.day,t.start_time,t.period,t.start_date,m.maintenanceid from maintenances_windows m,timeperiods t where t.timeperiodid=m.timeperiodid]
   197:20230220:143819.032 query [txnlev:0] [select maintenanceid,groupid from maintenances_groups order by maintenanceid]
   197:20230220:143819.033 query [txnlev:0] [select maintenanceid,hostid from maintenances_hosts order by maintenanceid]
   197:20230220:143819.033 In DCsync_hosts()
   197:20230220:143819.033 End of DCsync_hosts()
   197:20230220:143819.033 In DCsync_host_inventory()
   197:20230220:143819.033 End of DCsync_host_inventory()
   197:20230220:143819.033 In DCsync_hostgroups()
   197:20230220:143819.033 End of DCsync_hostgroups()
   197:20230220:143819.033 In DCsync_hostgroup_hosts()
   197:20230220:143819.033 End of DCsync_hostgroup_hosts()
   197:20230220:143819.033 In DCsync_maintenances()
   197:20230220:143819.033 End of DCsync_maintenances()
   197:20230220:143819.033 In DCsync_maintenance_tags()
   197:20230220:143819.033 End of DCsync_maintenance_tags()
   197:20230220:143819.033 In DCsync_maintenance_groups()
   197:20230220:143819.033 End of DCsync_maintenance_groups()
   197:20230220:143819.033 In DCsync_maintenance_hosts()
   197:20230220:143819.033 End of DCsync_maintenance_hosts()
   197:20230220:143819.033 In DCsync_maintenance_periods()
   197:20230220:143819.033 End of DCsync_maintenance_periods()
   197:20230220:143819.033 query [txnlev:0] [select i.interfaceid,i.hostid,i.type,i.main,i.useip,i.ip,i.dns,i.port,i.available,i.disable_until,i.error,i.errors_from,s.version,s.bulk,s.community,s.securityname,s.securitylevel,s.authpassphrase,s.privpassphrase,s.authprotocol,s.privprotocol,s.contextname from interface i left join interface_snmp s on i.interfaceid=s.interfaceid]
   197:20230220:143819.033 query [txnlev:0] [select i.itemid,i.hostid,i.templateid from items i inner join hosts h on i.hostid=h.hostid where h.status=3]
   197:20230220:143819.034 query [txnlev:0] [select itemid,parent_itemid from item_discovery]
   197:20230220:143819.034 query [txnlev:0] [select p.item_parameterid,p.itemid,p.name,p.value,i.hostid from item_parameter p,items i,hosts h where p.itemid=i.itemid and i.hostid=h.hostid and h.status in (0,1) and i.flags<>2 order by p.itemid]
   197:20230220:143819.034 In DCsync_interfaces()
   197:20230220:143819.034 End of DCsync_interfaces()
   197:20230220:143819.034 In DCsync_items()
   197:20230220:143819.034 End of DCsync_items()
   197:20230220:143819.034 In DCsync_template_items()
   197:20230220:143819.034 End of DCsync_template_items()
   197:20230220:143819.034 In DCsync_prototype_items()
   197:20230220:143819.034 End of DCsync_prototype_items()
   197:20230220:143819.034 In DCsync_item_discovery()
   197:20230220:143819.034 End of DCsync_item_discovery()
   197:20230220:143819.034 In DCsync_item_preproc()
   197:20230220:143819.034 End of DCsync_item_preproc()
   197:20230220:143819.034 In DCsync_itemscript_param()
   197:20230220:143819.034 End of DCsync_itemscript_param()
   197:20230220:143819.034 In DCsync_functions()
   197:20230220:143819.034 End of DCsync_functions()
   197:20230220:143819.034 query [txnlev:0] [select triggerid_down,triggerid_up from trigger_depends]
   197:20230220:143819.034 query [txnlev:0] [select r.name,e.expressionid,e.expression,e.expression_type,e.exp_delimiter,e.case_sensitive from regexps r,expressions e where r.regexpid=e.regexpid]
   197:20230220:143819.035 query [txnlev:0] [select actionid,eventsource,evaltype,formula from actions where eventsource<>4 and status=0]
   197:20230220:143819.035 query [txnlev:0] [select a.actionid,o.recovery from actions a left join operations o on a.actionid=o.actionid where a.status=0 group by a.actionid,o.recovery order by a.actionid]
   197:20230220:143819.035 query [txnlev:0] [select c.conditionid,c.actionid,c.conditiontype,c.operator,c.value,c.value2 from conditions c,actions a where c.actionid=a.actionid and a.status=0]
   197:20230220:143819.036 query [txnlev:0] [select correlationid,name,evaltype,formula from correlation where status=0]
   197:20230220:143819.036 query [txnlev:0] [select cc.corr_conditionid,cc.correlationid,cc.type,cct.tag,cctv.tag,cctv.value,cctv.operator, ccg.groupid,ccg.operator,cctp.oldtag,cctp.newtag from correlation c,corr_condition cc left join corr_condition_tag cct on cct.corr_conditionid=cc.corr_conditionid left join corr_condition_tagvalue cctv on cctv.corr_conditionid=cc.corr_conditionid left join corr_condition_group ccg on ccg.corr_conditionid=cc.corr_conditionid left join corr_condition_tagpair cctp on cctp.corr_conditionid=cc.corr_conditionid where c.correlationid=cc.correlationid and c.status=0]
   197:20230220:143819.036 query [txnlev:0] [select co.corr_operationid,co.correlationid,co.type from correlation c,corr_operation co where c.correlationid=co.correlationid and c.status=0]
   197:20230220:143819.036 In DCsync_triggers()
   197:20230220:143819.037 End of DCsync_triggers()
   197:20230220:143819.037 In DCsync_trigdeps()
   197:20230220:143819.037 End of DCsync_trigdeps()
   197:20230220:143819.037 In DCsync_expressions()
   197:20230220:143819.037 End of DCsync_expressions()
   197:20230220:143819.037 In DCsync_actions()
   197:20230220:143819.037 End of DCsync_actions()
   197:20230220:143819.037 In DCsync_action_ops()
   197:20230220:143819.037 End of DCsync_action_ops()
   197:20230220:143819.037 In DCsync_action_conditions()
   197:20230220:143819.037 End of DCsync_action_conditions()
   197:20230220:143819.037 In DCsync_trigger_tags()
   197:20230220:143819.037 End of DCsync_trigger_tags()
   197:20230220:143819.037 In DCsync_item_tags()
   197:20230220:143819.037 End of DCsync_item_tags()
   197:20230220:143819.037 In DCsync_correlations()
   197:20230220:143819.037 End of DCsync_correlations()
   197:20230220:143819.037 In DCsync_corr_conditions()
   197:20230220:143819.037 End of DCsync_corr_conditions()
   197:20230220:143819.037 In DCsync_corr_operations()
   197:20230220:143819.037 End of DCsync_corr_operations()
   197:20230220:143819.037 DCsync_configuration() changelog  : sql:0.000181 sec (0 records)
   197:20230220:143819.037 DCsync_configuration() config     : sql:0.000363 sync:0.000024 sec (1/0/0).
   197:20230220:143819.037 DCsync_configuration() autoreg    : sql:0.000215 sync:0.000009 sec (1/0/0).
   197:20230220:143819.037 DCsync_configuration() hosts      : sql:0.000006 sync:0.000048 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() host_invent: sql:0.000415 sync:0.000009 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() templates  : sql:0.000208 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() globmacros : sql:0.000211 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() hostmacros : sql:0.000320 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() interfaces : sql:0.000400 sync:0.000022 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() items      : sql:0.000019 sync:0.000015 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() template_items      : sql:0.000297 sync:0.000010 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() prototype_items      : sql:0.000003 sync:0.000011 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() item_discovery      : sql:0.000208 sync:0.000009 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() triggers   : sql:0.000003 sync:0.000021 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() trigdeps   : sql:0.000188 sync:0.000015 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() trig. tags : sql:0.000002 sync:0.000021 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() host tags : sql:0.000003 sync:0.000021 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() item tags : sql:0.000002 sync:0.000009 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() functions  : sql:0.000002 sync:0.000010 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() expressions: sql:0.000323 sync:0.000012 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() actions    : sql:0.000263 sync:0.000009 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() operations : sql:0.000297 sync:0.000009 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() conditions : sql:0.000262 sync:0.000009 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() corr       : sql:0.000276 sync:0.000009 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() corr_cond  : sql:0.000359 sync:0.000009 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() corr_op    : sql:0.000253 sync:0.000009 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() hgroups    : sql:0.000537 sync:0.000017 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() item pproc : sql:0.000002 sync:0.000009 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() item script param: sql:0.000317 sync:0.000009 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() maintenance: sql:0.001073 sync:0.000046 sec (0/0/0).
   197:20230220:143819.037 DCsync_configuration() macro cache: 0.000000 sec.
   197:20230220:143819.037 DCsync_configuration() reindex    : 0.000000 sec.
   197:20230220:143819.037 DCsync_configuration() total sql  : 0.006507 sec.
   197:20230220:143819.037 DCsync_configuration() total sync : 0.000370 sec.
   197:20230220:143819.037 DCsync_configuration() proxies    : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() hosts      : 2 (11 slots)
   197:20230220:143819.037 DCsync_configuration() hosts_h    : 2 (11 slots)
   197:20230220:143819.037 DCsync_configuration() hosts_p    : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() psks       : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() ipmihosts  : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() host_invent: 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() glob macros: 1 (11 slots)
   197:20230220:143819.037 DCsync_configuration() host macros: 2 (11 slots)
   197:20230220:143819.037 DCsync_configuration() kvs_paths : 0
   197:20230220:143819.037 DCsync_configuration() interfaces : 2 (11 slots)
   197:20230220:143819.037 DCsync_configuration() interfaces_snmp : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() interfac_ht: 2 (11 slots)
   197:20230220:143819.037 DCsync_configuration() if_snmpitms: 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() if_snmpaddr: 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() item_discovery : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() items      : 6 (101 slots)
   197:20230220:143819.037 DCsync_configuration() items_hk   : 6 (101 slots)
   197:20230220:143819.037 DCsync_configuration() numitems   : 6 (11 slots)
   197:20230220:143819.037 DCsync_configuration() preprocitems: 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() preprocops : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() snmpitems  : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() ipmiitems  : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() trapitems  : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() dependentitems  : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() logitems   : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() dbitems    : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() sshitems   : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() telnetitems: 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() simpleitems: 6 (11 slots)
   197:20230220:143819.037 DCsync_configuration() jmxitems   : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() calcitems  : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() httpitems  : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() scriptitems  : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() functions  : 0 (101 slots)
   197:20230220:143819.037 DCsync_configuration() triggers   : 0 (101 slots)
   197:20230220:143819.037 DCsync_configuration() trigdeps   : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() trig. tags : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() expressions: 10 (17 slots)
   197:20230220:143819.037 DCsync_configuration() actions    : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() conditions : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() corr.      : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() corr. conds: 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() corr. ops  : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() hgroups    : 1 (11 slots)
   197:20230220:143819.037 DCsync_configuration() item procs : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() maintenance: 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() maint tags : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() maint time : 0 (0 slots)
   197:20230220:143819.037 DCsync_configuration() queue[0]   : 0 (0 allocated)
   197:20230220:143819.037 DCsync_configuration() queue[1]   : 0 (0 allocated)
   197:20230220:143819.037 DCsync_configuration() queue[2]   : 0 (0 allocated)
   197:20230220:143819.037 DCsync_configuration() queue[3]   : 0 (32 allocated)
   197:20230220:143819.037 DCsync_configuration() queue[4]   : 0 (0 allocated)
   197:20230220:143819.037 DCsync_configuration() queue[5]   : 0 (0 allocated)
   197:20230220:143819.037 DCsync_configuration() queue[6]   : 0 (0 allocated)
   197:20230220:143819.037 DCsync_configuration() pqueue     : 0 (0 allocated)
   197:20230220:143819.037 DCsync_configuration() timer queue: 0 (0 allocated)
   197:20230220:143819.037 DCsync_configuration() changelog  : 0
   197:20230220:143819.037 DCsync_configuration() configfree : 98.913765%
   197:20230220:143819.037 DCsync_configuration() strings    : 39 (101 slots)
   197:20230220:143819.037 === memory statistics for configuration cache ===
   197:20230220:143819.037 free chunks of size     24 bytes:        1
   197:20230220:143819.037 free chunks of size >= 256 bytes:        1
   197:20230220:143819.037 min chunk size:         24 bytes
   197:20230220:143819.037 max chunk size:    8297464 bytes
   197:20230220:143819.037 memory of total size 8385680 bytes fragmented into 160 chunks
   197:20230220:143819.037 of those,    8297488 bytes are in        2 free chunks
   197:20230220:143819.037 of those,      88192 bytes are in      158 used chunks
   197:20230220:143819.037 of those,       2544 bytes are used by allocation overhead
   197:20230220:143819.037 ================================
   197:20230220:143819.037 zbx_dbsync_env_flush_changelog() changelog  : 0 (101 slots)
   197:20230220:143819.037 End of DCsync_configuration()
   197:20230220:143819.037 In DCsync_kvs_paths()
   197:20230220:143819.037 End of DCsync_kvs_paths()
   197:20230220:143819.037 In DCupdate_interfaces_availability()
   197:20230220:143819.037 In DCreset_interfaces_availability()
   197:20230220:143819.037 End of DCreset_interfaces_availability() interfaces:0
   197:20230220:143819.037 End of DCupdate_interfaces_availability()
   197:20230220:143819.037 End of process_configuration_sync()
   197:20230220:143819.037 zbx_setproctitle() title:'configuration syncer [synced config 6296 bytes in 0.031673 sec, idle 60 sec]'
   197:20230220:143819.037 In zbx_ipc_async_socket_recv() timeout:60
   197:20230220:163126.833 End of zbx_ipc_async_socket_recv():0
   197:20230220:163126.833 zbx_setproctitle() title:'configuration syncer [loading configuration]'
   197:20230220:163126.833 In process_configuration_sync()
   197:20230220:163126.833 In zbx_connect_to_server() [10.72.254.40]:10051 [timeout:600, connection timeout:3]
   197:20230220:163126.833 In is_ip4() ip:'10.72.254.40'
   197:20230220:163126.833 End of is_ip4():SUCCEED
   197:20230220:163126.833 In zbx_get_data_from_server()
   197:20230220:163126.843 Received [{"globalmacro":{"fields":["globalmacroid","macro","value","type"],"data":[[2,"{$SNMP_COMMUNITY}","public",0]]},"hosts":{"fields":["hostid","host","status","ipmi_authtype","ipmi_privilege","ipmi_username","ipmi_password","name","tls_connect","tls_accept","tls_issuer","tls_subject","tls_psk_identity","tls_psk"],"data":[[10542,"icmp_monitor",3,-1,2,"","","icmp_monitor",1,1,"","","",""],[10717,"10.76.232.62",0,-1,2,"","","10.76.232.62",1,1,"","","",""]]},"interface":{"fields":["interfaceid","hostid","main","type","useip","ip","dns","port","available"],"data":[[189,10717,1,1,1,"10.76.232.62","","10050",0]]},"interface_snmp":{"fields":["interfaceid","version","bulk","community","securityname","securitylevel","authpassphrase","privpassphrase","authprotocol","privprotocol","contextname"],"data":[]},"host_inventory":{"fields":["hostid","type","type_full","name","alias","os","os_full","os_short","serialno_a","serialno_b","tag","asset_tag","macaddress_a","macaddress_b","hardware","hardware_full","software","software_full","software_app_a","software_app_b","software_app_c","software_app_d","software_app_e","contact","location","location_lat","location_lon","notes","chassis","model","hw_arch","vendor","contract_number","installer_name","deployment_status","url_a","url_b","url_c","host_networks","host_netmask","host_router","oob_ip","oob_netmask","oob_router","date_hw_purchase","date_hw_install","date_hw_expiry","date_hw_decomm","site_address_a","site_address_b","site_address_c","site_city","site_state","site_country","site_zip","site_rack","site_notes","poc_1_name","poc_1_email","poc_1_phone_a","poc_1_phone_b","poc_1_cell","poc_1_screen","poc_1_notes","poc_2_name","poc_2_email","poc_2_phone_a","poc_2_phone_b","poc_2_cell","poc_2_screen","poc_2_notes"],"data":[]},"hosts_templates":{"fields":["hosttemplateid","hostid","templateid","link_type"],"data":[[609,10717,10542,0]]},"hostmacro":{"fields":["hostmacroid","hostid","macro","value","type","automatic"],"data":[[5704,10542,"{$ICMP_LOSS_WARN}","20",0,0],[5705,10542,"{$ICMP_RESPONSE_TIME_WARN}","0.15",0,0]]},"items":{"fields":["itemid","type","snmp_oid","hostid","key_","delay","history","status","value_type","trapper_hosts","logtimefmt","params","ipmi_sensor","authtype","username","password","publickey","privatekey","flags","interfaceid","inventory_link","jmx_endpoint","master_itemid","timeout","url","query_fields","posts","status_codes","follow_redirects","post_type","http_proxy","headers","retrieve_mode","request_method","output_format","ssl_cert_file","ssl_key_file","ssl_key_password","verify_peer","verify_host","allow_traps"],"data":[[45731,3,"",10717,"icmpping","5s","60d",0,3,"","","","",0,"","","","",0,189,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0],[45732,3,"",10717,"icmppingloss","5s","60d",0,0,"","","","",0,"","","","",0,189,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0],[45733,3,"",10717,"icmppingsec","5s","60d",0,0,"","","","",0,"","","","",0,189,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0]]},"item_rtdata":{"fields":["itemid","lastlogsize","mtime"],"data":[[45731,0,0],[45732,0,0],[45733,0,0]]},"item_preproc":{"fields":["item_preprocid","itemid","step","type","params","error_handler","error_handler_params"],"data":[]},"item_parameter":{"fields":["item_parameterid","itemid","name","value"],"data":[]},"drules":{"fields":["druleid","name","iprange","delay"],"data":[]},"dchecks":{"fields":["dcheckid","druleid","type","key_","snmp_community","ports","snmpv3_securityname","snmpv3_securitylevel","snmpv3_authpassphrase","snmpv3_privpassphrase","uniq","snmpv3_authprotocol","snmpv3_privprotocol","snmpv3_contextname","host_source","name_source"],"data":[]},"regexps":{"fields":["regexpid","name"],"data":[[1,"File systems for discovery"],[2,"Network interfaces for discovery"],[3,"Storage devices for SNMP discovery"],[4,"Windows service names for discovery"],[5,"Windows service startup states for discovery"]]},"expressions":{"fields":["expressionid","regexpid","expression","expression_type","exp_delimiter","case_sensitive"],"data":[[1,1,"^(btrfs|ext2|ext3|ext4|reiser|xfs|ffs|ufs|jfs|jfs2|vxfs|hfs|apfs|refs|ntfs|fat32|zfs)$",3,",",0],[3,3,"^(Physical memory|Virtual memory|Memory buffers|Cached memory|Swap space)$",4,",",1],[5,4,"^(MMCSS|gupdate|SysmonLog|clr_optimization_v2.0.50727_32|clr_optimization_v4.0.30319_32)$",4,",",1],[6,5,"^(automatic|automatic delayed)$",3,",",1],[7,2,"^Software Loopback Interface",4,",",1],[8,2,"^(In)?[Ll]oop[Bb]ack[0-9._]*$",4,",",1],[9,2,"^NULL[0-9.]*$",4,",",1],[10,2,"^[Ll]o[0-9.]*$",4,",",1],[11,2,"^[Ss]ystem$",4,",",1],[12,2,"^Nu[0-9.]*$",4,",",1]]},"hstgrp":{"fields":["groupid"],"data":[[5]]},"config":{"fields":["configid","discovery_groupid","snmptrap_logging","hk_history_global","hk_history","autoreg_tls_accept"],"data":[[1,5,1,0,"90d",1]]},"httptest":{"fields":["httptestid","name","delay","agent","authentication","http_user","http_password","hostid","http_proxy","retries","ssl_cert_file","ssl_key_file","ssl_key_password","verify_peer","verify_host"],"data":[]},"httptestitem":{"fields":["httptestitemid","httptestid","itemid","type"],"data":[]},"httptest_field":{"fields":["httptest_fieldid","httptestid","type","name","value"],"data":[]},"httpstep":{"fields":["httpstepid","httptestid","name","no","url","timeout","posts","required","status_codes","follow_redirects","retrieve_mode","post_type"],"data":[]},"httpstepitem":{"fields":["httpstepitemid","httpstepid","itemid","type"],"data":[]},"httpstep_field":{"fields":["httpstep_fieldid","httpstepid","type","name","value"],"data":[]},"config_autoreg_tls":{"fields":["autoreg_tlsid","tls_psk_identity","tls_psk"],"data":[[1,"",""]]},"macro.secrets":{}}] from server
   197:20230220:163126.843 End of zbx_get_data_from_server():SUCCEED
   197:20230220:163126.843 received configuration data from server at "10.72.254.40", datalen 5712
   197:20230220:163126.843 In process_proxyconfig()
   197:20230220:163126.843 query [txnlev:1] [begin;]
   197:20230220:163126.843 In process_proxyconfig_table() table:'globalmacro'
   197:20230220:163126.843 query [txnlev:1] [select globalmacroid,macro,value,type from globalmacro]
   197:20230220:163126.844 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.844 In process_proxyconfig_table() table:'hosts'
   197:20230220:163126.844 query [txnlev:1] [select hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name,tls_connect,tls_accept,tls_issuer,tls_subject,tls_psk_identity,tls_psk from hosts]
   197:20230220:163126.844 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.844 In process_proxyconfig_table() table:'interface'
   197:20230220:163126.845 query [txnlev:1] [select interfaceid,hostid,main,type,useip,ip,dns,port,available from interface]
   197:20230220:163126.845 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.845 In process_proxyconfig_table() table:'interface_snmp'
   197:20230220:163126.845 query [txnlev:1] [select interfaceid,version,bulk,community,securityname,securitylevel,authpassphrase,privpassphrase,authprotocol,privprotocol,contextname from interface_snmp]
   197:20230220:163126.846 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.846 In process_proxyconfig_table() table:'host_inventory'
   197:20230220:163126.846 query [txnlev:1] [select hostid,type,type_full,name,alias,os,os_full,os_short,serialno_a,serialno_b,tag,asset_tag,macaddress_a,macaddress_b,hardware,hardware_full,software,software_full,software_app_a,software_app_b,software_app_c,software_app_d,software_app_e,contact,location,location_lat,location_lon,notes,chassis,model,hw_arch,vendor,contract_number,installer_name,deployment_status,url_a,url_b,url_c,host_networks,host_netmask,host_router,oob_ip,oob_netmask,oob_router,date_hw_purchase,date_hw_install,date_hw_expiry,date_hw_decomm,site_address_a,site_address_b,site_address_c,site_city,site_state,site_country,site_zip,site_rack,site_notes,poc_1_name,poc_1_email,poc_1_phone_a,poc_1_phone_b,poc_1_cell,poc_1_screen,poc_1_notes,poc_2_name,poc_2_email,poc_2_phone_a,poc_2_phone_b,poc_2_cell,poc_2_screen,poc_2_notes from host_inventory]
   197:20230220:163126.847 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.847 In process_proxyconfig_table() table:'hosts_templates'
   197:20230220:163126.847 query [txnlev:1] [select hosttemplateid,hostid,templateid,link_type from hosts_templates]
   197:20230220:163126.847 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.847 In process_proxyconfig_table() table:'hostmacro'
   197:20230220:163126.847 query [txnlev:1] [select hostmacroid,hostid,macro,value,type,automatic from hostmacro]
   197:20230220:163126.848 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.848 In process_proxyconfig_table() table:'items'
   197:20230220:163126.848 query [txnlev:1] [select itemid,type,snmp_oid,hostid,key_,delay,history,status,value_type,trapper_hosts,logtimefmt,params,ipmi_sensor,authtype,username,password,publickey,privatekey,flags,interfaceid,inventory_link,jmx_endpoint,master_itemid,timeout,url,query_fields,posts,status_codes,follow_redirects,post_type,http_proxy,headers,retrieve_mode,request_method,output_format,ssl_cert_file,ssl_key_file,ssl_key_password,verify_peer,verify_host,allow_traps from items]
   197:20230220:163126.849 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.849 In process_proxyconfig_table() table:'item_rtdata'
   197:20230220:163126.849 query [txnlev:1] [select itemid,lastlogsize,mtime from item_rtdata]
   197:20230220:163126.849 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.849 In process_proxyconfig_table() table:'item_preproc'
   197:20230220:163126.849 query [txnlev:1] [select item_preprocid,itemid,step,type,params,error_handler,error_handler_params from item_preproc]
   197:20230220:163126.850 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.850 In process_proxyconfig_table() table:'item_parameter'
   197:20230220:163126.850 query [txnlev:1] [select item_parameterid,itemid,name,value from item_parameter]
   197:20230220:163126.851 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.851 In process_proxyconfig_table() table:'drules'
   197:20230220:163126.851 query [txnlev:1] [select druleid,name,iprange,delay from drules]
   197:20230220:163126.851 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.851 In process_proxyconfig_table() table:'dchecks'
   197:20230220:163126.851 query [txnlev:1] [select dcheckid,druleid,type,key_,snmp_community,ports,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,uniq,snmpv3_authprotocol,snmpv3_privprotocol,snmpv3_contextname,host_source,name_source from dchecks]
   197:20230220:163126.852 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.852 In process_proxyconfig_table() table:'regexps'
   197:20230220:163126.852 query [txnlev:1] [select regexpid,name from regexps]
   197:20230220:163126.852 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.852 In process_proxyconfig_table() table:'expressions'
   197:20230220:163126.852 query [txnlev:1] [select expressionid,regexpid,expression,expression_type,exp_delimiter,case_sensitive from expressions]
   197:20230220:163126.853 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.853 In process_proxyconfig_table() table:'hstgrp'
   197:20230220:163126.853 query [txnlev:1] [select groupid from hstgrp]
   197:20230220:163126.854 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.854 In process_proxyconfig_table() table:'config'
   197:20230220:163126.854 query [txnlev:1] [select configid,discovery_groupid,snmptrap_logging,hk_history_global,hk_history,autoreg_tls_accept from config]
   197:20230220:163126.854 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.854 In process_proxyconfig_table() table:'httptest'
   197:20230220:163126.854 query [txnlev:1] [select httptestid,name,delay,agent,authentication,http_user,http_password,hostid,http_proxy,retries,ssl_cert_file,ssl_key_file,ssl_key_password,verify_peer,verify_host from httptest]
   197:20230220:163126.855 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.855 In process_proxyconfig_table() table:'httptestitem'
   197:20230220:163126.855 query [txnlev:1] [select httptestitemid,httptestid,itemid,type from httptestitem]
   197:20230220:163126.855 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.855 In process_proxyconfig_table() table:'httptest_field'
   197:20230220:163126.855 query [txnlev:1] [select httptest_fieldid,httptestid,type,name,value from httptest_field]
   197:20230220:163126.856 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.856 In process_proxyconfig_table() table:'httpstep'
   197:20230220:163126.856 query [txnlev:1] [select httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes,follow_redirects,retrieve_mode,post_type from httpstep]
   197:20230220:163126.856 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.856 In process_proxyconfig_table() table:'httpstepitem'
   197:20230220:163126.857 query [txnlev:1] [select httpstepitemid,httpstepid,itemid,type from httpstepitem]
   197:20230220:163126.857 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.857 In process_proxyconfig_table() table:'httpstep_field'
   197:20230220:163126.857 query [txnlev:1] [select httpstep_fieldid,httpstepid,type,name,value from httpstep_field]
   197:20230220:163126.858 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.858 In process_proxyconfig_table() table:'config_autoreg_tls'
   197:20230220:163126.858 query [txnlev:1] [select autoreg_tlsid,tls_psk_identity,tls_psk from config_autoreg_tls]
   197:20230220:163126.858 End of process_proxyconfig_table():SUCCEED
   197:20230220:163126.858 query [txnlev:1] [commit;]
   197:20230220:163126.858 End of process_proxyconfig()
   197:20230220:163126.858 In DCsync_configuration()
   197:20230220:163126.858 query [txnlev:0] [select changelogid,object,objectid,operation,clock from changelog]
   197:20230220:163126.859 query [txnlev:0] [select discovery_groupid,snmptrap_logging,severity_name_0,severity_name_1,severity_name_2,severity_name_3,severity_name_4,severity_name_5,hk_events_mode,hk_events_trigger,hk_events_internal,hk_events_discovery,hk_events_autoreg,hk_services_mode,hk_services,hk_audit_mode,hk_audit,hk_sessions_mode,hk_sessions,hk_history_mode,hk_history_global,hk_history,hk_trends_mode,hk_trends_global,hk_trends,default_inventory_mode,db_extension,autoreg_tls_accept,compression_status,compress_older,instanceid,default_timezone,hk_events_service,auditlog_enabled from config order by configid]
   197:20230220:163126.859 query [txnlev:0] [select tls_psk_identity,tls_psk from config_autoreg_tls order by autoreg_tlsid]
   197:20230220:163126.860 In DCsync_config()
   197:20230220:163126.860 End of DCsync_config()
   197:20230220:163126.860 In DCsync_autoreg_config()
   197:20230220:163126.860 End of DCsync_autoreg_config()
   197:20230220:163126.860 query [txnlev:0] [select hostid,templateid from hosts_templates order by hostid]
   197:20230220:163126.860 query [txnlev:0] [select globalmacroid,macro,value,type from globalmacro]
   197:20230220:163126.860 query [txnlev:0] [select m.hostmacroid,m.hostid,m.macro,m.value,m.type from hostmacro m inner join hosts h on m.hostid=h.hostid where h.flags<>2]
   197:20230220:163126.861 In DCsync_host_tags()
   197:20230220:163126.861 End of DCsync_host_tags()
   197:20230220:163126.861 query [txnlev:0] [select hostid,inventory_mode,type,type_full,name,alias,os,os_full,os_short,serialno_a,serialno_b,tag,asset_tag,macaddress_a,macaddress_b,hardware,hardware_full,software,software_full,software_app_a,software_app_b,software_app_c,software_app_d,software_app_e,contact,location,location_lat,location_lon,notes,chassis,model,hw_arch,vendor,contract_number,installer_name,deployment_status,url_a,url_b,url_c,host_networks,host_netmask,host_router,oob_ip,oob_netmask,oob_router,date_hw_purchase,date_hw_install,date_hw_expiry,date_hw_decomm,site_address_a,site_address_b,site_address_c,site_city,site_state,site_country,site_zip,site_rack,site_notes,poc_1_name,poc_1_email,poc_1_phone_a,poc_1_phone_b,poc_1_cell,poc_1_screen,poc_1_notes,poc_2_name,poc_2_email,poc_2_phone_a,poc_2_phone_b,poc_2_cell,poc_2_screen,poc_2_notes from host_inventory]
   197:20230220:163126.862 query [txnlev:0] [select groupid,name from hstgrp]
   197:20230220:163126.862 query [txnlev:0] [select hg.groupid,hg.hostid from hosts_groups hg,hosts h where hg.hostid=h.hostid and h.status in (0,1) and h.flags<>2 order by hg.groupid]
   197:20230220:163126.862 query [txnlev:0] [select maintenanceid,maintenance_type,active_since,active_till,tags_evaltype from maintenances]
   197:20230220:163126.863 query [txnlev:0] [select maintenancetagid,maintenanceid,operator,tag,value from maintenance_tag]
   197:20230220:163126.863 query [txnlev:0] [select t.timeperiodid,t.timeperiod_type,t.every,t.month,t.dayofweek,t.day,t.start_time,t.period,t.start_date,m.maintenanceid from maintenances_windows m,timeperiods t where t.timeperiodid=m.timeperiodid]
   197:20230220:163126.863 query [txnlev:0] [select maintenanceid,groupid from maintenances_groups order by maintenanceid]
   197:20230220:163126.864 query [txnlev:0] [select maintenanceid,hostid from maintenances_hosts order by maintenanceid]
   197:20230220:163126.864 In DCsync_hosts()
   197:20230220:163126.864 End of DCsync_hosts()
   197:20230220:163126.864 In DCsync_host_inventory()
   197:20230220:163126.864 End of DCsync_host_inventory()
   197:20230220:163126.864 In DCsync_hostgroups()
   197:20230220:163126.864 End of DCsync_hostgroups()
   197:20230220:163126.864 In DCsync_hostgroup_hosts()
   197:20230220:163126.864 End of DCsync_hostgroup_hosts()
   197:20230220:163126.864 In DCsync_maintenances()
   197:20230220:163126.864 End of DCsync_maintenances()
   197:20230220:163126.864 In DCsync_maintenance_tags()
   197:20230220:163126.864 End of DCsync_maintenance_tags()
   197:20230220:163126.864 In DCsync_maintenance_groups()
   197:20230220:163126.864 End of DCsync_maintenance_groups()
   197:20230220:163126.864 In DCsync_maintenance_hosts()
   197:20230220:163126.864 End of DCsync_maintenance_hosts()
   197:20230220:163126.864 In DCsync_maintenance_periods()
   197:20230220:163126.864 End of DCsync_maintenance_periods()
   197:20230220:163126.864 query [txnlev:0] [select i.interfaceid,i.hostid,i.type,i.main,i.useip,i.ip,i.dns,i.port,i.available,i.disable_until,i.error,i.errors_from,s.version,s.bulk,s.community,s.securityname,s.securitylevel,s.authpassphrase,s.privpassphrase,s.authprotocol,s.privprotocol,s.contextname from interface i left join interface_snmp s on i.interfaceid=s.interfaceid]
   197:20230220:163126.865 query [txnlev:0] [select i.itemid,i.hostid,i.templateid from items i inner join hosts h on i.hostid=h.hostid where h.status=3]
   197:20230220:163126.866 query [txnlev:0] [select itemid,parent_itemid from item_discovery]
   197:20230220:163126.866 query [txnlev:0] [select p.item_parameterid,p.itemid,p.name,p.value,i.hostid from item_parameter p,items i,hosts h where p.itemid=i.itemid and i.hostid=h.hostid and h.status in (0,1) and i.flags<>2 order by p.itemid]
   197:20230220:163126.866 In DCsync_interfaces()
   197:20230220:163126.866 End of DCsync_interfaces()
   197:20230220:163126.866 In DCsync_items()
   197:20230220:163126.866 End of DCsync_items()
   197:20230220:163126.866 In DCsync_template_items()
   197:20230220:163126.866 End of DCsync_template_items()
   197:20230220:163126.866 In DCsync_prototype_items()
   197:20230220:163126.866 End of DCsync_prototype_items()
   197:20230220:163126.866 In DCsync_item_discovery()
   197:20230220:163126.866 End of DCsync_item_discovery()
   197:20230220:163126.866 In DCsync_item_preproc()
   197:20230220:163126.866 End of DCsync_item_preproc()
   197:20230220:163126.866 In DCsync_itemscript_param()
   197:20230220:163126.866 End of DCsync_itemscript_param()
   197:20230220:163126.866 In DCsync_functions()
   197:20230220:163126.866 End of DCsync_functions()
   197:20230220:163126.866 query [txnlev:0] [select triggerid_down,triggerid_up from trigger_depends]
   197:20230220:163126.867 query [txnlev:0] [select r.name,e.expressionid,e.expression,e.expression_type,e.exp_delimiter,e.case_sensitive from regexps r,expressions e where r.regexpid=e.regexpid]
   197:20230220:163126.867 query [txnlev:0] [select actionid,eventsource,evaltype,formula from actions where eventsource<>4 and status=0]
   197:20230220:163126.867 query [txnlev:0] [select a.actionid,o.recovery from actions a left join operations o on a.actionid=o.actionid where a.status=0 group by a.actionid,o.recovery order by a.actionid]
   197:20230220:163126.868 query [txnlev:0] [select c.conditionid,c.actionid,c.conditiontype,c.operator,c.value,c.value2 from conditions c,actions a where c.actionid=a.actionid and a.status=0]
   197:20230220:163126.868 query [txnlev:0] [select correlationid,name,evaltype,formula from correlation where status=0]
   197:20230220:163126.869 query [txnlev:0] [select cc.corr_conditionid,cc.correlationid,cc.type,cct.tag,cctv.tag,cctv.value,cctv.operator, ccg.groupid,ccg.operator,cctp.oldtag,cctp.newtag from correlation c,corr_condition cc left join corr_condition_tag cct on cct.corr_conditionid=cc.corr_conditionid left join corr_condition_tagvalue cctv on cctv.corr_conditionid=cc.corr_conditionid left join corr_condition_group ccg on ccg.corr_conditionid=cc.corr_conditionid left join corr_condition_tagpair cctp on cctp.corr_conditionid=cc.corr_conditionid where c.correlationid=cc.correlationid and c.status=0]
   197:20230220:163126.869 query [txnlev:0] [select co.corr_operationid,co.correlationid,co.type from correlation c,corr_operation co where c.correlationid=co.correlationid and c.status=0]
   197:20230220:163126.869 In DCsync_triggers()
   197:20230220:163126.869 End of DCsync_triggers()
   197:20230220:163126.869 In DCsync_trigdeps()
   197:20230220:163126.869 End of DCsync_trigdeps()
   197:20230220:163126.869 In DCsync_expressions()
   197:20230220:163126.869 End of DCsync_expressions()
   197:20230220:163126.869 In DCsync_actions()
   197:20230220:163126.869 End of DCsync_actions()
   197:20230220:163126.869 In DCsync_action_ops()
   197:20230220:163126.869 End of DCsync_action_ops()
   197:20230220:163126.869 In DCsync_action_conditions()
   197:20230220:163126.869 End of DCsync_action_conditions()
   197:20230220:163126.869 In DCsync_trigger_tags()
   197:20230220:163126.869 End of DCsync_trigger_tags()
   197:20230220:163126.869 In DCsync_item_tags()
   197:20230220:163126.869 End of DCsync_item_tags()
   197:20230220:163126.869 In DCsync_correlations()
   197:20230220:163126.869 End of DCsync_correlations()
   197:20230220:163126.869 In DCsync_corr_conditions()
   197:20230220:163126.869 End of DCsync_corr_conditions()
   197:20230220:163126.870 In DCsync_corr_operations()
   197:20230220:163126.870 End of DCsync_corr_operations()
   197:20230220:163126.870 DCsync_configuration() changelog  : sql:0.000313 sec (0 records)
   197:20230220:163126.870 DCsync_configuration() config     : sql:0.000467 sync:0.000026 sec (1/0/0).
   197:20230220:163126.870 DCsync_configuration() autoreg    : sql:0.000343 sync:0.000009 sec (1/0/0).
   197:20230220:163126.870 DCsync_configuration() hosts      : sql:0.000006 sync:0.000023 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() host_invent: sql:0.000606 sync:0.000009 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() templates  : sql:0.000358 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() globmacros : sql:0.000354 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() hostmacros : sql:0.000598 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() interfaces : sql:0.000954 sync:0.000024 sec (1/0/0).
   197:20230220:163126.870 DCsync_configuration() items      : sql:0.000037 sync:0.000010 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() template_items      : sql:0.000526 sync:0.000010 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() prototype_items      : sql:0.000003 sync:0.000009 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() item_discovery      : sql:0.000294 sync:0.000009 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() triggers   : sql:0.000003 sync:0.000021 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() trigdeps   : sql:0.000209 sync:0.000009 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() trig. tags : sql:0.000002 sync:0.000009 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() host tags : sql:0.000003 sync:0.000026 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() item tags : sql:0.000002 sync:0.000011 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() functions  : sql:0.000002 sync:0.000012 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() expressions: sql:0.000458 sync:0.000009 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() actions    : sql:0.000337 sync:0.000009 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() operations : sql:0.000410 sync:0.000011 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() conditions : sql:0.000277 sync:0.000011 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() corr       : sql:0.000331 sync:0.000009 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() corr_cond  : sql:0.000450 sync:0.000009 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() corr_op    : sql:0.000416 sync:0.000008 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() hgroups    : sql:0.000830 sync:0.000017 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() item pproc : sql:0.000003 sync:0.000009 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() item script param: sql:0.000422 sync:0.000009 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() maintenance: sql:0.001639 sync:0.000054 sec (0/0/0).
   197:20230220:163126.870 DCsync_configuration() macro cache: 0.000000 sec.
   197:20230220:163126.870 DCsync_configuration() reindex    : 0.000000 sec.
   197:20230220:163126.870 DCsync_configuration() total sql  : 0.009913 sec.
   197:20230220:163126.870 DCsync_configuration() total sync : 0.000336 sec.
   197:20230220:163126.870 DCsync_configuration() proxies    : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() hosts      : 2 (11 slots)
   197:20230220:163126.870 DCsync_configuration() hosts_h    : 2 (11 slots)
   197:20230220:163126.870 DCsync_configuration() hosts_p    : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() psks       : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() ipmihosts  : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() host_invent: 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() glob macros: 1 (11 slots)
   197:20230220:163126.870 DCsync_configuration() host macros: 2 (11 slots)
   197:20230220:163126.870 DCsync_configuration() kvs_paths : 0
   197:20230220:163126.870 DCsync_configuration() interfaces : 0 (11 slots)
   197:20230220:163126.870 DCsync_configuration() interfaces_snmp : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() interfac_ht: 0 (11 slots)
   197:20230220:163126.870 DCsync_configuration() if_snmpitms: 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() if_snmpaddr: 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() item_discovery : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() items      : 6 (101 slots)
   197:20230220:163126.870 DCsync_configuration() items_hk   : 6 (101 slots)
   197:20230220:163126.870 DCsync_configuration() numitems   : 6 (11 slots)
   197:20230220:163126.870 DCsync_configuration() preprocitems: 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() preprocops : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() snmpitems  : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() ipmiitems  : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() trapitems  : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() dependentitems  : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() logitems   : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() dbitems    : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() sshitems   : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() telnetitems: 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() simpleitems: 6 (11 slots)
   197:20230220:163126.870 DCsync_configuration() jmxitems   : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() calcitems  : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() httpitems  : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() scriptitems  : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() functions  : 0 (101 slots)
   197:20230220:163126.870 DCsync_configuration() triggers   : 0 (101 slots)
   197:20230220:163126.870 DCsync_configuration() trigdeps   : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() trig. tags : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() expressions: 10 (17 slots)
   197:20230220:163126.870 DCsync_configuration() actions    : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() conditions : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() corr.      : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() corr. conds: 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() corr. ops  : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() hgroups    : 1 (11 slots)
   197:20230220:163126.870 DCsync_configuration() item procs : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() maintenance: 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() maint tags : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() maint time : 0 (0 slots)
   197:20230220:163126.870 DCsync_configuration() queue[0]   : 0 (0 allocated)
   197:20230220:163126.870 DCsync_configuration() queue[1]   : 0 (0 allocated)
   197:20230220:163126.870 DCsync_configuration() queue[2]   : 0 (0 allocated)
   197:20230220:163126.870 DCsync_configuration() queue[3]   : 6 (32 allocated)
   197:20230220:163126.870 DCsync_configuration() queue[4]   : 0 (0 allocated)
   197:20230220:163126.870 DCsync_configuration() queue[5]   : 0 (0 allocated)
   197:20230220:163126.870 DCsync_configuration() queue[6]   : 0 (0 allocated)
   197:20230220:163126.870 DCsync_configuration() pqueue     : 0 (0 allocated)
   197:20230220:163126.870 DCsync_configuration() timer queue: 0 (0 allocated)
   197:20230220:163126.870 DCsync_configuration() changelog  : 0
   197:20230220:163126.870 DCsync_configuration() configfree : 98.922729%
   197:20230220:163126.870 DCsync_configuration() strings    : 38 (101 slots)
   197:20230220:163126.870 === memory statistics for configuration cache ===
   197:20230220:163126.870 free chunks of size >= 256 bytes:        2
   197:20230220:163126.870 min chunk size:        776 bytes
   197:20230220:163126.870 max chunk size:    8297464 bytes
   197:20230220:163126.870 memory of total size 8385808 bytes fragmented into 152 chunks
   197:20230220:163126.870 of those,    8298240 bytes are in        2 free chunks
   197:20230220:163126.870 of those,      87568 bytes are in      150 used chunks
   197:20230220:163126.870 of those,       2416 bytes are used by allocation overhead
   197:20230220:163126.870 ================================
   197:20230220:163126.870 zbx_dbsync_env_flush_changelog() changelog  : 0 (101 slots)
   197:20230220:163126.870 End of DCsync_configuration()
   197:20230220:163126.871 In DCsync_kvs_paths()
   197:20230220:163126.871 End of DCsync_kvs_paths()
   197:20230220:163126.873 In DCupdate_interfaces_availability()
   197:20230220:163126.873 In DCreset_interfaces_availability()
   197:20230220:163126.874 End of DCreset_interfaces_availability() interfaces:0
   197:20230220:163126.874 End of DCupdate_interfaces_availability()
   197:20230220:163126.874 End of process_configuration_sync()
   197:20230220:163126.874 zbx_setproctitle() title:'configuration syncer [synced config 5712 bytes in 0.041272 sec, idle 60 sec]'
   197:20230220:163126.874 In zbx_ipc_async_socket_recv() timeout:60
dotneft commented 1 year ago

incorrect again. no pinger processes at all. I asked you increase debug ONLY for pinger processes:

zabbix_proxy -R log_level_increase="icmp pinger"
startips commented 1 year ago

Sir, the problem is that there is no pinger process.

dotneft commented 1 year ago

what is that:

 382:20230220:145522.317 zbx_setproctitle() title:'icmp pinger #9 [getting values]'
startips commented 1 year ago

You can see from the above log that the IP(10.76.232.62) was received on proxy,

 197:20230220:163126.843 Received [{"globalmacro":{"fields":["globalmacroid","macro","value","type"],"data":[[2,"{$SNMP_COMMUNITY}","public",0]]},"hosts":{"fields":["hostid","host","status","ipmi_authtype","ipmi_privilege","ipmi_username","ipmi_password","name","tls_connect","tls_accept","tls_issuer","tls_subject","tls_psk_identity","tls_psk"],"data":[[10542,"icmp_monitor",3,-1,2,"","","icmp_monitor",1,1,"","","",""],[10717,"10.76.232.62",0,-1,2,"","","10.76.232.62",1,1,"","","",""]]},"interface":{"fields":["interfaceid","hostid","main","type","useip","ip","dns","port","available"],"data":[[189,10717,1,1,1,"10.76.232.62","","10050",0]]},"interface_snmp":{"fields":["interfaceid","version","bulk","community","securityname","securitylevel","authpassphrase","privpassphrase","authprotocol","privprotocol","contextname"],"data":[]},"host_inventory":{"fields":["hostid","type","type_full","name","alias","os","os_full","os_short","serialno_a","serialno_b","tag","asset_tag","macaddress_a","macaddress_b","hardware","hardware_full","software","software_full","software_app_a","software_app_b","software_app_c","software_app_d","software_app_e","contact","location","location_lat","location_lon","notes","chassis","model","hw_arch","vendor","contract_number","installer_name","deployment_status","url_a","url_b","url_c","host_networks","host_netmask","host_router","oob_ip","oob_netmask","oob_router","date_hw_purchase","date_hw_install","date_hw_expiry","date_hw_decomm","site_address_a","site_address_b","site_address_c","site_city","site_state","site_country","site_zip","site_rack","site_notes","poc_1_name","poc_1_email","poc_1_phone_a","poc_1_phone_b","poc_1_cell","poc_1_screen","poc_1_notes","poc_2_name","poc_2_email","poc_2_phone_a","poc_2_phone_b","poc_2_cell","poc_2_screen","poc_2_notes"],"data":[]},"hosts_templates":{"fields":["hosttemplateid","hostid","templateid","link_type"],"data":[[609,10717,10542,0]]},"hostmacro":{"fields":["hostmacroid","hostid","macro","value","type","automatic"],"data":[[5704,10542,"{$ICMP_LOSS_WARN}","20",0,0],[5705,10542,"{$ICMP_RESPONSE_TIME_WARN}","0.15",0,0]]},"items":{"fields":["itemid","type","snmp_oid","hostid","key_","delay","history","status","value_type","trapper_hosts","logtimefmt","params","ipmi_sensor","authtype","username","password","publickey","privatekey","flags","interfaceid","inventory_link","jmx_endpoint","master_itemid","timeout","url","query_fields","posts","status_codes","follow_redirects","post_type","http_proxy","headers","retrieve_mode","request_method","output_format","ssl_cert_file","ssl_key_file","ssl_key_password","verify_peer","verify_host","allow_traps"],"data":[[45731,3,"",10717,"icmpping","5s","60d",0,3,"","","","",0,"","","","",0,189,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0],[45732,3,"",10717,"icmppingloss","5s","60d",0,0,"","","","",0,"","","","",0,189,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0],[45733,3,"",10717,"icmppingsec","5s","60d",0,0,"","","","",0,"","","","",0,189,0,"",null,"3s","","","","200",1,0,"","",0,0,0,"","","",0,0,0]]},"item_rtdata":{"fields":["itemid","lastlogsize","mtime"],"data":[[45731,0,0],[45732,0,0],[45733,0,0]]},"item_preproc":{"fields":["item_preprocid","itemid","step","type","params","error_handler","error_handler_params"],"data":[]},"item_parameter":{"fields":["item_parameterid","itemid","name","value"],"data":[]},"drules":{"fields":["druleid","name","iprange","delay"],"data":[]},"dchecks":{"fields":["dcheckid","druleid","type","key_","snmp_community","ports","snmpv3_securityname","snmpv3_securitylevel","snmpv3_authpassphrase","snmpv3_privpassphrase","uniq","snmpv3_authprotocol","snmpv3_privprotocol","snmpv3_contextname","host_source","name_source"],"data":[]},"regexps":{"fields":["regexpid","name"],"data":[[1,"File systems for discovery"],[2,"Network interfaces for discovery"],[3,"Storage devices for SNMP discovery"],[4,"Windows service names for discovery"],[5,"Windows service startup states for discovery"]]},"expressions":{"fields":["expressionid","regexpid","expression","expression_type","exp_delimiter","case_sensitive"],"data":[[1,1,"^(btrfs|ext2|ext3|ext4|reiser|xfs|ffs|ufs|jfs|jfs2|vxfs|hfs|apfs|refs|ntfs|fat32|zfs)$",3,",",0],[3,3,"^(Physical memory|Virtual memory|Memory buffers|Cached memory|Swap space)$",4,",",1],[5,4,"^(MMCSS|gupdate|SysmonLog|clr_optimization_v2.0.50727_32|clr_optimization_v4.0.30319_32)$",4,",",1],[6,5,"^(automatic|automatic delayed)$",3,",",1],[7,2,"^Software Loopback Interface",4,",",1],[8,2,"^(In)?[Ll]oop[Bb]ack[0-9._]*$",4,",",1],[9,2,"^NULL[0-9.]*$",4,",",1],[10,2,"^[Ll]o[0-9.]*$",4,",",1],[11,2,"^[Ss]ystem$",4,",",1],[12,2,"^Nu[0-9.]*$",4,",",1]]},"hstgrp":{"fields":["groupid"],"data":[[5]]},"config":{"fields":["configid","discovery_groupid","snmptrap_logging","hk_history_global","hk_history","autoreg_tls_accept"],"data":[[1,5,1,0,"90d",1]]},"httptest":{"fields":["httptestid","name","delay","agent","authentication","http_user","http_password","hostid","http_proxy","retries","ssl_cert_file","ssl_key_file","ssl_key_password","verify_peer","verify_host"],"data":[]},"httptestitem":{"fields":["httptestitemid","httptestid","itemid","type"],"data":[]},"httptest_field":{"fields":["httptest_fieldid","httptestid","type","name","value"],"data":[]},"httpstep":{"fields":["httpstepid","httptestid","name","no","url","timeout","posts","required","status_codes","follow_redirects","retrieve_mode","post_type"],"data":[]},"httpstepitem":{"fields":["httpstepitemid","httpstepid","itemid","type"],"data":[]},"httpstep_field":{"fields":["httpstep_fieldid","httpstepid","type","name","value"],"data":[]},"config_autoreg_tls":{"fields":["autoreg_tlsid","tls_psk_identity","tls_psk"],"data":[[1,"",""]]},"macro.secrets":{}}] from server

but not called to the process，I have try many times ，just only reboot container，then proxy have process and server can receive data. Yes you will think it is strange, but it is the truth, I have tried many times, not just reload, create a new environment. It's not that I don't want to debug ping, it's just that there's no ping debug log for this IP. I don't know if I've explained this problem clearly.Thank you very much for your answer.You can also use my above YML file to build, 100% can reproduce the problem, the system is Ubuntu 22.04, Docker version is 20.10.9.

dotneft commented 1 year ago

we already spent 3 days for such kind of troubleshooting, and I still do not see pinger process debug. The problem is explained, but to understand the reason I need pinger debug with at least one attempt of ping.

startips commented 1 year ago

only pinger process debug logs ,There's too many duplicate logs, just cut a little bit. I stayed for about 5 minutes and didn't see this IP loaded.


   490:20230221:150330.752 End of DCconfig_get_poller_nextcheck():-1
   490:20230221:150330.752 zbx_setproctitle() title:'icmp pinger #92 [got 0 values in 0.000124 sec, idle 5 sec]'
   463:20230221:150330.752 In DCconfig_get_poller_items() poller_type:3
   463:20230221:150330.752 End of DCconfig_get_poller_items():0
   463:20230221:150330.752 End of get_pinger_hosts():0
   463:20230221:150330.752 In process_pinger_hosts()
   463:20230221:150330.752 End of process_pinger_hosts()
   463:20230221:150330.752 In DCconfig_get_poller_nextcheck() poller_type:3
   463:20230221:150330.752 End of DCconfig_get_poller_nextcheck():-1
   463:20230221:150330.752 zbx_setproctitle() title:'icmp pinger #65 [got 0 values in 0.000201 sec, idle 5 sec]'
   400:20230221:150335.714 zbx_setproctitle() title:'icmp pinger #2 [getting values]'
   400:20230221:150335.714 In get_pinger_hosts()
   400:20230221:150335.714 In DCconfig_get_poller_items() poller_type:3
   400:20230221:150335.714 End of DCconfig_get_poller_items():0
   400:20230221:150335.714 End of get_pinger_hosts():0
   400:20230221:150335.714 In process_pinger_hosts()
   400:20230221:150335.714 End of process_pinger_hosts()
   400:20230221:150335.714 In DCconfig_get_poller_nextcheck() poller_type:3
   400:20230221:150335.714 End of DCconfig_get_poller_nextcheck():-1
   400:20230221:150335.714 zbx_setproctitle() title:'icmp pinger #2 [got 0 values in 0.000083 sec, idle 5 sec]'
   406:20230221:150335.714 zbx_setproctitle() title:'icmp pinger #8 [getting values]'
   406:20230221:150335.714 In get_pinger_hosts()
   407:20230221:150335.717 In DCconfig_get_poller_items() poller_type:3
   407:20230221:150335.717 End of process_pinger_hosts()
   406:20230221:150335.714 In DCconfig_get_poller_items() poller_type:3
   406:20230221:150335.714 End of DCconfig_get_poller_items():0
   406:20230221:150335.714 End of get_pinger_hosts():0
   406:20230221:150335.714 In process_pinger_hosts()
   406:20230221:150335.714 End of process_pinger_hosts()
   406:20230221:150335.714 In DCconfig_get_poller_nextcheck() poller_type:3
   406:20230221:150335.714 End of DCconfig_get_poller_nextcheck():-1
   406:20230221:150335.714 zbx_setproctitle() title:'icmp pinger #8 [got 0 values in 0.000091 sec, idle 5 sec]'
   404:20230221:150335.717 zbx_setproctitle() title:'icmp pinger #6 [getting values]'
   404:20230221:150335.717 In get_pinger_hosts()
   404:20230221:150335.717 In DCconfig_get_poller_items() poller_type:3
   404:20230221:150335.717 End of DCconfig_get_poller_items():0
   404:20230221:150335.717 End of get_pinger_hosts():0
   404:20230221:150335.717 In process_pinger_hosts()
   404:20230221:150335.717 End of process_pinger_hosts()
   404:20230221:150335.717 In DCconfig_get_poller_nextcheck() poller_type:3
   404:20230221:150335.717 End of DCconfig_get_poller_nextcheck():-1
   404:20230221:150335.717 zbx_setproctitle() title:'icmp pinger #6 [got 0 values in 0.000078 sec, idle 5 sec]'
   407:20230221:150335.717 zbx_setproctitle() title:'icmp pinger #9 [getting values]'
   407:20230221:150335.717 In get_pinger_hosts()
   407:20230221:150335.717 End of DCconfig_get_poller_items():0
   407:20230221:150335.717 End of get_pinger_hosts():0
   407:20230221:150335.717 In process_pinger_hosts()
   407:20230221:150335.717 In DCconfig_get_poller_nextcheck() poller_type:3
   407:20230221:150335.717 End of DCconfig_get_poller_nextcheck():-1
   407:20230221:150335.717 zbx_setproctitle() title:'icmp pinger #9 [got 0 values in 0.000072 sec, idle 5 sec]'
   402:20230221:150335.717 zbx_setproctitle() title:'icmp pinger #4 [getting values]'
   402:20230221:150335.717 In get_pinger_hosts()
   402:20230221:150335.717 In DCconfig_get_poller_items() poller_type:3
   402:20230221:150335.717 End of DCconfig_get_poller_items():0
   402:20230221:150335.717 End of get_pinger_hosts():0
   402:20230221:150335.717 In process_pinger_hosts()
   402:20230221:150335.717 End of process_pinger_hosts()
   402:20230221:150335.717 In DCconfig_get_poller_nextcheck() poller_type:3
   402:20230221:150335.717 End of DCconfig_get_poller_nextcheck():-1
   402:20230221:150335.717 zbx_setproctitle() title:'icmp pinger #4 [got 0 values in 0.000076 sec, idle 5 sec]'```
dotneft commented 1 year ago

You have too much icmp pinger processes. How many NVPS do you have on the proxy? Only one icmp pinger can process up to 1000 items at the same time (in case of identical ping params)...

startips commented 1 year ago

You have too much icmp pinger processes. How many NVPS do you have on the proxy? Only one icmp pinger can process up to 1000 items at the same time (in case of identical ping params)...

ZBX_STARTPINGERS=100 Opened 100, my server performance is ok

dotneft commented 1 year ago

I asked different question, how many nvps do you have on the proxy? I do not speak about performance at all.

startips commented 1 year ago

just add one ip :

Name Mode Encryption Compression Last seen (age) Host count Item count Required performance (vps) Hosts zbx-proxy-001 Active None On 5s 1 3 0.6 10.76.232.62

This is a new environment,In the testing phase, I didn't have this problem when I used zabbix version 5.

dotneft commented 1 year ago

Ok. So, specify please ZBX_STARTPINGERS=1, then restart proxy. Increase debug for pinger and wait 5-10 minutes. Then attach debug log.

startips commented 1 year ago

As you said, just start one PINGER , check the log that keeps repeating:


   215:20230221:173540.265 zbx_setproctitle() title:'icmp pinger #1 [getting values]'
   215:20230221:173540.265 In get_pinger_hosts()
   215:20230221:173540.265 In DCconfig_get_poller_items() poller_type:3
   215:20230221:173540.265 End of DCconfig_get_poller_items():3
   215:20230221:173540.265 In substitute_key_macros_impl() data:'icmppingloss'
   215:20230221:173540.265 End of substitute_key_macros_impl():SUCCEED data:'icmppingloss'
   215:20230221:173540.265 In add_icmpping_item() addr:'' count:3 interval:0 size:0 timeout:0
   215:20230221:173540.265 End of add_icmpping_item()
   215:20230221:173540.265 In substitute_key_macros_impl() data:'icmpping'
   215:20230221:173540.265 End of substitute_key_macros_impl():SUCCEED data:'icmpping'
   215:20230221:173540.265 In add_icmpping_item() addr:'' count:3 interval:0 size:0 timeout:0
   215:20230221:173540.265 End of add_icmpping_item()
   215:20230221:173540.265 In substitute_key_macros_impl() data:'icmppingsec'
   215:20230221:173540.265 End of substitute_key_macros_impl():SUCCEED data:'icmppingsec'
   215:20230221:173540.265 In add_icmpping_item() addr:'' count:3 interval:0 size:0 timeout:0
   215:20230221:173540.265 End of add_icmpping_item()
   215:20230221:173540.265 End of get_pinger_hosts():3
   215:20230221:173540.265 In process_pinger_hosts()
   215:20230221:173540.265 In add_pinger_host() addr:''
   215:20230221:173540.265 End of add_pinger_host()
   215:20230221:173540.265 In add_pinger_host() addr:''
   215:20230221:173540.265 In add_pinger_host() addr:''
   215:20230221:173540.265 zbx_setproctitle() title:'icmp pinger #1 [pinging hosts]'
   215:20230221:173540.265 In zbx_ping() hosts_count:1
   215:20230221:173540.265 /tmp/zabbix_proxy_215.pinger
   215:20230221:173540.265     
   215:20230221:173540.265 /usr/sbin/fping -C3 -i0 2>&1 </tmp/zabbix_proxy_215.pinger;
   215:20230221:173540.267 fping failed: no output
   215:20230221:173540.267 End of zbx_ping():NOTSUPPORTED
   215:20230221:173540.267 In process_values()
   215:20230221:173540.267 host [] fping failed: no output
   215:20230221:173540.267 In process_value()
   215:20230221:173540.267 In zbx_preprocess_item_value()
   215:20230221:173540.267 End of zbx_preprocess_item_value()
   215:20230221:173540.267 End of process_value()
   215:20230221:173540.267 In process_value()
   215:20230221:173540.267 In zbx_preprocess_item_value()
   215:20230221:173540.267 End of zbx_preprocess_item_value()
   215:20230221:173540.267 End of process_value()
   215:20230221:173540.267 In process_value()
   215:20230221:173540.267 In zbx_preprocess_item_value()
   215:20230221:173540.267 End of zbx_preprocess_item_value()
   215:20230221:173540.267 End of process_value()
   215:20230221:173540.267 In zbx_ipc_socket_write()
   215:20230221:173540.267 End of zbx_ipc_socket_write():SUCCEED
   215:20230221:173540.267 End of process_values()
   215:20230221:173540.267 End of process_pinger_hosts()
   215:20230221:173540.267 In DCconfig_get_poller_nextcheck() poller_type:3
   215:20230221:173540.267 End of DCconfig_get_poller_nextcheck():1676972145
   215:20230221:173540.267 zbx_setproctitle() title:'icmp pinger #1 [got 3 values in 0.002157 sec, idle 5 sec]'```
dotneft commented 1 year ago

Thank you! Please execute the following SQL query on proxy side:

select h.host, i.key_, n.* from items i JOIN hosts h on h.hostid = i.hostid join interface n on n.interfaceid = i.interfaceid where i.key_ in ('icmppingloss', 'icmpping', 'icmppingsec');
dotneft commented 1 year ago

the host you added regular one or SNMP device?

startips commented 1 year ago

Thank you! Please execute the following SQL query on proxy side:

select h.host, i.key_, n.* from items i JOIN hosts h on h.hostid = i.hostid join interface n on n.interfaceid = i.interfaceid where i.key_ in ('icmppingloss', 'icmpping', 'icmppingsec');

MySQL [(none)]> select h.host, i.key, n.* from items i JOIN hosts h on h.hostid = i.hostid join interface n on n.interfaceid = i.interfaceid where i.key in ('icmppingloss', 'icmpping', 'icmppingsec'); ERROR 1046 (3D000): No database selected MySQL [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | performance_schema | | zabbix_proxy | +--------------------+ 3 rows in set (0.002 sec)

startips commented 1 year ago

the host you added regular one or SNMP device?

regular one and just link a ICMP Ping template

dotneft commented 1 year ago

Of course execute the query in "zabbix_proxy" database.

startips commented 1 year ago

Of course execute the query in "zabbix_proxy" database.

+--------------+--------------+-------------+--------+------+------+-------+--------------+-----+-------+-----------+-------+-------------+---------------+ | host | key_ | interfaceid | hostid | main | type | useip | ip | dns | port | available | error | errors_from | disable_until | +--------------+--------------+-------------+--------+------+------+-------+--------------+-----+-------+-----------+-------+-------------+---------------+ | 10.76.232.62 | icmpping | 235 | 10763 | 1 | 1 | 1 | 10.76.232.62 | | 10050 | 0 | | 0 | 0 | | 10.76.232.62 | icmppingloss | 235 | 10763 | 1 | 1 | 1 | 10.76.232.62 | | 10050 | 0 | | 0 | 0 | | 10.76.232.62 | icmppingsec | 235 | 10763 | 1 | 1 | 1 | 10.76.232.62 | | 10050 | 0 | | 0 | 0 | +--------------+--------------+-------------+--------+------+------+-------+--------------+-----+-------+-----------+-------+-------------+---------------+ 3 rows in set (0.001 sec)

dotneft commented 1 year ago

everything looks like some bug in Zabbix. May I ask you to check previous version of image? For example, 6.2.2 or 6.2.3. Also different OS base (ubuntu, centos...)?

Also you said after restart everything works fine, right?

startips commented 1 year ago

everything looks like some bug in Zabbix. May I ask you to check previous version of image? For example, 6.2.2 or 6.2.3. Also different OS base (ubuntu, centos...)? ----- it take a lot time to do this work..Why don't you use my YML to start reproducing this problem? Is it hard? If you don't care, I'll close the issue, thank you for your answer.

Also you said after restart everything works fine, right?------yes!

dotneft commented 1 year ago

The problem is not related to your YML at all. You should have the same problem with vanilla compose files.

startips commented 1 year ago

I'm not saying there's a problem with my YML file, I mean, you can use my file to reproduce the problem and then you can do any debugging on it so we don't have to communicate back and forth like this, which is very inefficient.

dotneft commented 1 year ago

your compose files work fine:

 223:20230223:214710.065 zbx_setproctitle() title:'icmp pinger #1 [got 0 values in 0.000107 sec, idle 5 sec]'
   223:20230223:214715.068 zbx_setproctitle() title:'icmp pinger #1 [getting values]'
   223:20230223:214715.068 In get_pinger_hosts()
   223:20230223:214715.068 In DCconfig_get_poller_items() poller_type:3
   223:20230223:214715.069 End of DCconfig_get_poller_items():3
   223:20230223:214715.069 In substitute_key_macros_impl() data:'icmpping'
   223:20230223:214715.069 End of substitute_key_macros_impl():SUCCEED data:'icmpping'
   223:20230223:214715.069 In add_icmpping_item() addr:'8.8.8.8' count:3 interval:0 size:0 timeout:0
   223:20230223:214715.069 End of add_icmpping_item()
   223:20230223:214715.069 In substitute_key_macros_impl() data:'icmppingsec'
   223:20230223:214715.069 End of substitute_key_macros_impl():SUCCEED data:'icmppingsec'
   223:20230223:214715.069 In add_icmpping_item() addr:'8.8.8.8' count:3 interval:0 size:0 timeout:0
   223:20230223:214715.069 End of add_icmpping_item()
   223:20230223:214715.069 In substitute_key_macros_impl() data:'icmppingloss'
   223:20230223:214715.069 End of substitute_key_macros_impl():SUCCEED data:'icmppingloss'
   223:20230223:214715.069 In add_icmpping_item() addr:'8.8.8.8' count:3 interval:0 size:0 timeout:0
   223:20230223:214715.069 End of add_icmpping_item()
   223:20230223:214715.069 End of get_pinger_hosts():3
   223:20230223:214715.069 In process_pinger_hosts()
   223:20230223:214715.069 In add_pinger_host() addr:'8.8.8.8'
   223:20230223:214715.069 End of add_pinger_host()
   223:20230223:214715.069 In add_pinger_host() addr:'8.8.8.8'
   223:20230223:214715.069 In add_pinger_host() addr:'8.8.8.8'
   223:20230223:214715.069 zbx_setproctitle() title:'icmp pinger #1 [pinging hosts]'
   223:20230223:214715.069 In zbx_ping() hosts_count:1
   223:20230223:214715.069 testing fping interval 0 ms
   223:20230223:214715.069 In zbx_popen() command:'/usr/sbin/fping -c1 -t50 -i0 8.8.8.8'
   223:20230223:214715.069 End of zbx_popen():11
   232:20230223:214715.070 zbx_popen(): executing script
   223:20230223:214715.122 In zbx_waitpid()
   223:20230223:214715.122 zbx_waitpid() exited, status:1
   223:20230223:214715.122 End of zbx_waitpid():232
   223:20230223:214715.122 detected minimum supported fping interval (-i): 0
   223:20230223:214715.122 In zbx_popen() command:'/usr/sbin/fping -6 -c1 -t50 8.8.8.8'
   223:20230223:214715.123 End of zbx_popen():11
   233:20230223:214715.123 zbx_popen(): executing script
   223:20230223:214715.124 In zbx_waitpid()
   223:20230223:214715.125 zbx_waitpid() exited, status:2
   223:20230223:214715.125 End of zbx_waitpid():233
   223:20230223:214715.125 detected fping IPv6 support: "yes"
   223:20230223:214715.125 /tmp/zabbix_proxy_223.pinger
   223:20230223:214715.125     8.8.8.8
   223:20230223:214715.125 /usr/sbin/fping -C3 -i0 2>&1 </tmp/zabbix_proxy_223.pinger;
   223:20230223:214715.213 read line [8.8.8.8 : [0], 64 bytes, 87.3 ms (87.3 avg, 0% loss)]
   223:20230223:214716.255 read line [8.8.8.8 : [1], 64 bytes, 125 ms (106 avg, 0% loss)]
   223:20230223:214717.141 read line [8.8.8.8 : [2], 64 bytes, 13.1 ms (75.0 avg, 0% loss)]
   223:20230223:214717.141 read line []
   223:20230223:214717.141 read line [8.8.8.8 : 87.3 125 13.1]
   223:20230223:214717.141 End of zbx_ping():SUCCEED
   223:20230223:214717.141 In process_values()
   223:20230223:214717.141 host [8.8.8.8] cnt=3 rcv=3 min=0.013100 max=0.125000 sum=0.225400

I wait a few minutes after added the host, always good:

223:20230223:215115.496 In get_pinger_hosts()
   223:20230223:215115.496 In DCconfig_get_poller_items() poller_type:3
   223:20230223:215115.496 End of DCconfig_get_poller_items():3
   223:20230223:215115.496 In substitute_key_macros_impl() data:'icmppingloss'
   223:20230223:215115.496 End of substitute_key_macros_impl():SUCCEED data:'icmppingloss'
   223:20230223:215115.496 In add_icmpping_item() addr:'8.8.8.8' count:3 interval:0 size:0 timeout:0
   223:20230223:215115.496 End of add_icmpping_item()
   223:20230223:215115.496 In substitute_key_macros_impl() data:'icmpping'
   223:20230223:215115.496 End of substitute_key_macros_impl():SUCCEED data:'icmpping'
   223:20230223:215115.496 In add_icmpping_item() addr:'8.8.8.8' count:3 interval:0 size:0 timeout:0
   223:20230223:215115.496 End of add_icmpping_item()
   223:20230223:215115.496 In substitute_key_macros_impl() data:'icmppingsec'
   223:20230223:215115.496 End of substitute_key_macros_impl():SUCCEED data:'icmppingsec'
   223:20230223:215115.496 In add_icmpping_item() addr:'8.8.8.8' count:3 interval:0 size:0 timeout:0
   223:20230223:215115.496 End of add_icmpping_item()
   223:20230223:215115.496 End of get_pinger_hosts():3
   223:20230223:215115.496 In process_pinger_hosts()
   223:20230223:215115.496 In add_pinger_host() addr:'8.8.8.8'
   223:20230223:215115.496 End of add_pinger_host()
   223:20230223:215115.496 In add_pinger_host() addr:'8.8.8.8'
   223:20230223:215115.496 In add_pinger_host() addr:'8.8.8.8'
# docker exec -ti mysql-server2 mysql -pzbxpasswd -e "select * from interface" zabbix_proxy
mysql: [Warning] Using a password on the command line interface can be insecure.
+-------------+--------+------+------+-------+---------+-----+-------+-----------+-------+-------------+---------------+
| interfaceid | hostid | main | type | useip | ip      | dns | port  | available | error | errors_from | disable_until |
+-------------+--------+------+------+-------+---------+-----+-------+-----------+-------+-------------+---------------+
|          15 |  10560 |    1 |    1 |     1 | 8.8.8.8 |     | 10050 |         0 |       |           0 |             0 |
+-------------+--------+------+------+-------+---------+-----+-------+-----------+-------+-------------+---------------+

in your case interfaces looks empty:

   197:20230220:145520.247 DCsync_configuration() interfaces : 0 (11 slots)

but in my case everything is fine:

   196:20230223:215403.860 DCsync_configuration() interfaces : 1 (11 slots)
startips commented 1 year ago 
197:20230220:145520.247 DCsync_configuration() interfaces : 0 (11 slots)

What does that logs mean? Does the proxy fail to read the database data? Why?

dotneft commented 1 year ago

It is necessary to perform debug which is not related to docker images. I recommend you check our forum for help. It is necessary to check configuration syncer process debug now.