ldd /usr/sbin/zabbix_server

mariadb -V
mariadb  Ver 15.1 Distrib 10.6.9-MariaDB, for Linux (x86_64) using readline 

ldd /usr/sbin/zabbix_server
    linux-vdso.so.1 (0x00007fff38d63000)
    libmariadb.so.3 => /lib64/libmariadb.so.3 (0x00007fd6805de000)
    libxml2.so.2 => /lib64/libxml2.so.2 (0x00007fd680276000)
    libodbc.so.2 => /lib64/libodbc.so.2 (0x00007fd680005000)
    libnetsnmp.so.35 => /lib64/libnetsnmp.so.35 (0x00007fd67fc59000)
    libssh.so.4 => /lib64/libssh.so.4 (0x00007fd67f9ea000)
    libOpenIPMI.so.0 => /lib64/libOpenIPMI.so.0 (0x00007fd67f6d6000)
    libOpenIPMIposix.so.0 => /lib64/libOpenIPMIposix.so.0 (0x00007fd67f4ce000)
    libz.so.1 => /lib64/libz.so.1 (0x00007fd67f2b6000)
    libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fd67f096000)
    libevent-2.1.so.6 => /lib64/libevent-2.1.so.6 (0x00007fd67ee3d000)
    libssl.so.1.1 => /lib64/libssl.so.1.1 (0x00007fd67eba9000)
    libcrypto.so.1.1 => /lib64/libcrypto.so.1.1 (0x00007fd67e6c0000)
    libldap-2.4.so.2 => /lib64/libldap-2.4.so.2 (0x00007fd67e471000)
    liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00007fd67e261000)
    libcurl.so.4 => /lib64/libcurl.so.4 (0x00007fd67dfd3000)
    libm.so.6 => /lib64/libm.so.6 (0x00007fd67dc51000)
    libdl.so.2 => /lib64/libdl.so.2 (0x00007fd67da4d000)
    libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fd67d835000)
    libpcre2-8.so.0 => /lib64/libpcre2-8.so.0 (0x00007fd67d5b1000)
    libc.so.6 => /lib64/libc.so.6 (0x00007fd67d1eb000)
    liblzma.so.5 => /lib64/liblzma.so.5 (0x00007fd67cfc4000)
    libltdl.so.7 => /lib64/libltdl.so.7 (0x00007fd67cdba000)
    librt.so.1 => /lib64/librt.so.1 (0x00007fd67cbb2000)
    libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007fd67c95d000)
    libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007fd67c673000)
    libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007fd67c45c000)
    libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007fd67c258000)
    /lib64/ld-linux-x86-64.so.2 (0x00007fd680fc5000)
    libOpenIPMIutils.so.0 => /lib64/libOpenIPMIutils.so.0 (0x00007fd67c04e000)
    libgdbm.so.6 => /lib64/libgdbm.so.6 (0x00007fd67be3e000)
    libsasl2.so.3 => /lib64/libsasl2.so.3 (0x00007fd67bc20000)
    libnghttp2.so.14 => /lib64/libnghttp2.so.14 (0x00007fd67b9f9000)
    libidn2.so.0 => /lib64/libidn2.so.0 (0x00007fd67b7db000)
    libpsl.so.5 => /lib64/libpsl.so.5 (0x00007fd67b5ca000)
    libbrotlidec.so.1 => /lib64/libbrotlidec.so.1 (0x00007fd67b3bd000)
    libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007fd67b1ac000)
    libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007fd67afa8000)
    libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007fd67ad7f000)
    libunistring.so.2 => /lib64/libunistring.so.2 (0x00007fd67a9fe000)
    libbrotlicommon.so.1 => /lib64/libbrotlicommon.so.1 (0x00007fd67a7dd000)
    libselinux.so.1 => /lib64/libselinux.so.1 (0x00007fd67a5b2000)

the issue is still present in 6.2.2, zabbix won't start

 5550:20221108:022806.581 slow query: 3.722514 sec, "commit;"
  5550:20221108:023311.838 slow query: 3.806548 sec, "commit;"
  5550:20221108:023328.493 slow query: 3.983467 sec, "commit;"
  5550:20221108:023541.655 slow query: 4.185292 sec, "commit;"
  5550:20221108:023600.699 slow query: 3.179674 sec, "commit;"
  5550:20221108:023656.695 slow query: 3.015633 sec, "commit;"
  5550:20221108:023715.710 slow query: 8.284148 sec, "commit;"
  5550:20221108:023814.171 slow query: 3.746391 sec, "commit;"
  5550:20221108:023851.724 slow query: 3.995127 sec, "commit;"
  5550:20221108:023913.405 slow query: 4.040817 sec, "commit;"
  5550:20221108:024945.722 slow query: 4.941224 sec, "commit;"
  5550:20221108:025924.966 slow query: 3.489818 sec, "commit;"
  5550:20221108:030010.286 slow query: 3.766765 sec, "commit;"
  5550:20221108:030018.529 slow query: 3.236922 sec, "commit;"
  5550:20221108:030035.101 slow query: 5.300070 sec, "commit;"
  5550:20221108:030100.935 slow query: 3.374528 sec, "commit;"
  5550:20221108:030124.975 slow query: 4.000803 sec, "commit;"
  5550:20221108:030252.376 slow query: 4.521605 sec, "commit;"
  5550:20221108:030319.271 slow query: 3.518697 sec, "commit;"
  5550:20221108:051159.128 slow query: 3.324534 sec, "commit;"
  5550:20221108:055525.910 slow query: 3.468364 sec, "commit;"
  5550:20221109:025858.471 slow query: 3.974728 sec, "commit;"
  5550:20221109:061128.410 slow query: 6.306368 sec, "commit;"

611:20221109:162137.058 Starting Zabbix Server. Zabbix 6.2.4 (revision 885eaefa6f7).
  1611:20221109:162137.076 ****** Enabled features ******
  1611:20221109:162137.076 SNMP monitoring:           YES
  1611:20221109:162137.076 IPMI monitoring:           YES
  1611:20221109:162137.076 Web monitoring:            YES
  1611:20221109:162137.076 VMware monitoring:         YES
  1611:20221109:162137.076 SMTP authentication:       YES
  1611:20221109:162137.076 ODBC:                      YES
  1611:20221109:162137.076 SSH support:               YES
  1611:20221109:162137.076 IPv6 support:              YES
  1611:20221109:162137.076 TLS support:               YES
  1611:20221109:162137.076 ******************************
  1611:20221109:162137.076 using configuration file: /etc/zabbix/zabbix_server.conf
  1611:20221109:162137.094 In zbx_load_modules()
  1611:20221109:162137.094 End of zbx_load_modules():SUCCEED
  1611:20221109:162137.095 In zbx_ipc_service_start() service:rtc
  1611:20221109:162137.097 End of zbx_ipc_service_start():SUCCEED
  1611:20221109:162137.097 In zbx_db_get_database_type()
  1611:20221109:162137.097 In DBconnect() flag:0
  1611:20221109:162137.217 End of DBconnect():0
  1611:20221109:162137.240 query [txnlev:0] [select userid from users limit 1]
  1611:20221109:162138.684 there is at least 1 record in "users" table
  1611:20221109:162138.684 End of zbx_db_get_database_type():ZBX_DB_SERVER
  1611:20221109:162138.684 In init_database_cache()
  1611:20221109:162138.684 In zbx_shmem_create() param:'HistoryCacheSize' size:134217728
  1611:20221109:162138.685 valid user addresses: [0x7f673210a170, 0x7f673a109ff0] total size: 134217344
  1611:20221109:162138.685 End of zbx_shmem_create()
  1611:20221109:162138.685 In zbx_shmem_create() param:'HistoryIndexCacheSize' size:8388608
  1611:20221109:162138.685 valid user addresses: [0x7f673190a180, 0x7f6732109ff0] total size: 8388208
  1611:20221109:162138.685 End of zbx_shmem_create()
  1611:20221109:162138.685 In init_trend_cache()
  1611:20221109:162138.685 In zbx_shmem_required_size() size:0 chunks_num:1 descr:'trend cache' param:'TrendCacheSize'
  1611:20221109:162138.685 End of zbx_shmem_required_size() size:422
  1611:20221109:162138.685 In zbx_shmem_create() param:'TrendCacheSize' size:8388608
  1611:20221109:162138.685 valid user addresses: [0x7f673110a170, 0x7f6731909ff0] total size: 8388224
  1611:20221109:162138.685 End of zbx_shmem_create()
  1611:20221109:162138.685 End of init_trend_cache()
  1611:20221109:162138.685 End of init_database_cache()
  1611:20221109:162138.685 In DBconnect() flag:0
  1611:20221109:162138.686 End of DBconnect():0
  1611:20221109:162138.686 query [txnlev:0] [select default_character_set_name,default_collation_name from information_schema.SCHEMATA where schema_name='zabbix']
  1611:20221109:162138.709 query [txnlev:0] [select count(*) from information_schema.`COLUMNS` where table_schema='zabbix' and data_type in ('text','varchar','longtext') and (character_set_name not in ('utf8','utf8mb3','utf8mb4') or collation_name not in ('utf8_bin','utf8mb3_bin','utf8mb4_bin'))]
  1611:20221109:162141.759 slow query: 3.050052 sec, "select count(*) from information_schema.`COLUMNS` where table_schema='zabbix' and data_type in ('text','varchar','longtext') and (character_set_name not in ('utf8','utf8mb3','utf8mb4') or collation_name not in ('utf8_bin','utf8mb3_bin','utf8mb4_bin'))"
  1611:20221109:162141.759 In DBconnect() flag:0
  1611:20221109:162141.760 End of DBconnect():0
  1611:20221109:162141.760 In zbx_dbms_version_info_extract()
  1611:20221109:162141.760 MariaDB fork detected
  1611:20221109:162141.760 End of zbx_dbms_version_info_extract() version:100611
  1611:20221109:162141.760 In DBcheck_version()
  1611:20221109:162141.760 In DBconnect() flag:0
  1611:20221109:162141.761 End of DBconnect():0
  1611:20221109:162141.761 query [txnlev:0] [show tables like 'dbversion']
  1611:20221109:162141.762 query [txnlev:0] [select mandatory,optional from dbversion]
  1611:20221109:162141.800 current database version (mandatory/optional): 06020000/06020000
  1611:20221109:162141.800 required mandatory version: 06020000
  1611:20221109:162141.800 optional patches were found
  1611:20221109:162141.800 starting automatic database upgrade
  1611:20221109:162141.800 query [txnlev:1] [begin;]
  1611:20221109:162141.800 query [txnlev:1] [alter table `group_discovery` modify `name` varchar(255) default '' not null]
  1611:20221109:162142.193 query [txnlev:1] [update dbversion set optional=6020001]
  1611:20221109:162142.352 query [txnlev:1] [commit;]
  1611:20221109:162142.352 completed 33% of database upgrade
  1611:20221109:162142.352 query [txnlev:1] [begin;]
  1611:20221109:162142.352 query [txnlev:1] [update group_discovery gd set name=(select gp.name from group_prototype gp where gd.parent_group_prototypeid=gp.group_prototypeid) where char_length(gd.name)=64]
  1611:20221109:162144.605 query [txnlev:1] [update dbversion set optional=6020002]
  1611:20221109:162144.605 query [txnlev:1] [commit;]
  1611:20221109:162144.616 completed 66% of database upgrade
  1611:20221109:162144.616 query [txnlev:1] [begin;]
  1611:20221109:162144.617 query [txnlev:1] [alter table `users` modify `url` varchar(2048) default '' not null]
  1611:20221109:162146.665 query [txnlev:1] [update dbversion set optional=6020003]
  1611:20221109:162146.698 query [txnlev:1] [commit;]
  1611:20221109:162146.698 completed 100% of database upgrade
  1611:20221109:162146.698 query without transaction detected
  1611:20221109:162146.698 query [txnlev:0] [delete from changelog]
  1611:20221109:162147.422 database upgrade fully completed
  1611:20221109:162147.422 End of DBcheck_version():SUCCEED
  1611:20221109:162147.422 In DBconnect() flag:0
  1611:20221109:162147.423 End of DBconnect():0
  1611:20221109:162147.423 query [txnlev:0] [show columns from config like 'dbversion_status']
  1611:20221109:162147.535 query [txnlev:0] [show index from history where key_name='PRIMARY']
  1611:20221109:162147.728 In zbx_db_flush_version_requirements()
  1611:20221109:162147.728 query without transaction detected
  1611:20221109:162147.728 query [txnlev:0] [update config set dbversion_status='[{"database":"MariaDB","current_version":"10.06.11","min_version":"10.02.00","max_version":"10.08.xx","history_pk":1,"min_supported_version":"10.05.00","flag":0}]']
  1611:20221109:162147.944 End of zbx_db_flush_version_requirements()
  1611:20221109:162147.945 In DBcheck_double_type()
  1611:20221109:162147.945 In DBconnect() flag:0
  1611:20221109:162147.945 End of DBconnect():0
  1611:20221109:162147.945 query [txnlev:0] [select count(*) from information_schema.columns where table_schema='zabbix' and column_type='double' and ((lower(table_name)='trends' and (lower(column_name) in ('value_min', 'value_avg', 'value_max'))) or (lower(table_name)='history' and lower(column_name)='value'))]
  1611:20221109:162147.960 End of DBcheck_double_type()
  1611:20221109:162147.960 In DBconnect() flag:0
  1611:20221109:162147.960 End of DBconnect():0
  1611:20221109:162147.960 query [txnlev:0] [select configid,instanceid from config order by configid]
  1611:20221109:162147.960 In zbx_ha_start()
  1611:20221109:162147.961 In zbx_ipc_service_recv() timeout:1.000
  1639:20221109:162147.961 zbx_setproctitle() title:'ha manager'
  1639:20221109:162147.961 starting HA manager
  1639:20221109:162147.961 In zbx_ipc_service_start() service:haservice
  1639:20221109:162147.962 End of zbx_ipc_service_start():SUCCEED
  1639:20221109:162147.962 In zbx_ipc_async_socket_open()
  1639:20221109:162147.962 In zbx_ipc_socket_open()
  1611:20221109:162147.962 In ipc_service_accept()
  1611:20221109:162147.962 In ipc_service_add_client()
  1611:20221109:162147.962 End of ipc_service_add_client() clientid:1
  1611:20221109:162147.962 End of ipc_service_accept()
  1611:20221109:162147.962 End of zbx_ipc_service_recv():2
  1611:20221109:162147.962 In zbx_ipc_service_recv() timeout:1.000
  1639:20221109:162147.962 End of zbx_ipc_socket_open():SUCCEED
  1639:20221109:162147.962 End of zbx_ipc_async_socket_open():SUCCEED
  1639:20221109:162147.962 In zbx_ipc_async_socket_send()
  1639:20221109:162147.962 In zbx_ipc_client_send() clientid:0
  1639:20221109:162147.962 End of zbx_ipc_client_send():SUCCEED
  1639:20221109:162147.962 End of zbx_ipc_async_socket_send():SUCCEED
  1639:20221109:162147.962 In zbx_ipc_async_socket_flush() timeout:10
  1639:20221109:162147.962 End of zbx_ipc_async_socket_flush():0
  1611:20221109:162147.962 zbx_ipc_service_recv() code:10000 size:0 data:
  1611:20221109:162147.962 End of zbx_ipc_service_recv():1
  1611:20221109:162147.962 End of zbx_ha_start():SUCCEED
  1611:20221109:162147.963 In zbx_ha_get_status()
  1611:20221109:162147.963 In zbx_ipc_async_socket_open()
  1611:20221109:162147.963 In zbx_ipc_socket_open()
  1639:20221109:162147.963 In ha_db_register_node()
  1639:20221109:162147.963 In ha_db_create_node()
  1611:20221109:162147.963 End of zbx_ipc_socket_open():SUCCEED
  1639:20221109:162147.963 In DBconnect() flag:2
  1611:20221109:162147.963 End of zbx_ipc_async_socket_open():SUCCEED
  1611:20221109:162147.963 In zbx_ipc_async_socket_send()
  1611:20221109:162147.963 In zbx_ipc_client_send() clientid:0
  1611:20221109:162147.963 End of zbx_ipc_client_send():SUCCEED
  1611:20221109:162147.963 End of zbx_ipc_async_socket_send():SUCCEED
  1611:20221109:162147.963 In zbx_ipc_async_socket_flush() timeout:10
  1611:20221109:162147.963 End of zbx_ipc_async_socket_flush():0
  1611:20221109:162147.963 In zbx_ipc_async_socket_recv() timeout:10
  1639:20221109:162147.963 End of DBconnect():0
  1639:20221109:162147.963 query [txnlev:1] [begin;]
  1639:20221109:162147.963 query [txnlev:1] [select ha_nodeid,name,status,lastaccess,address,port,ha_sessionid from ha_node order by ha_nodeid]
  1639:20221109:162147.986 query [txnlev:1] [select ha_failover_delay,auditlog_enabled from config]
  1639:20221109:162147.986 query [txnlev:1] [commit;]
  1639:20221109:162147.986 End of ha_db_create_node()
  1639:20221109:162147.986 query [txnlev:1] [begin;]
  1639:20221109:162147.986 query [txnlev:1] [select ha_nodeid,name,status,lastaccess,address,port,ha_sessionid from ha_node order by ha_nodeid for update]
  1639:20221109:162147.986 In ha_db_get_time()
  1639:20221109:162147.986 query [txnlev:1] [select unix_timestamp() from config]
  1639:20221109:162147.986 End of ha_db_get_time():SUCCEED db_time:1668000107
  1639:20221109:162147.987 query [txnlev:1] [update ha_node set lastaccess=unix_timestamp(),ha_sessionid='cla9o6vxe00008r86y6esb4pu' where ha_nodeid='cl5s5on970001vc86e9psiztc']
  1639:20221109:162147.987 query [txnlev:1] [delete from ha_node where name<>'']
  1639:20221109:162147.987 query [txnlev:1] [commit;]
  1639:20221109:162148.142 End of ha_db_register_node() nodeid:cl5s5on970001vc86e9psiztc ha_status:active db_status:0
  1639:20221109:162148.142 HA manager started in active mode
  1639:20221109:162148.142 In zbx_ipc_async_socket_send()
  1639:20221109:162148.142 In zbx_ipc_client_send() clientid:0
  1639:20221109:162148.142 End of zbx_ipc_client_send():SUCCEED
  1639:20221109:162148.143 End of zbx_ipc_async_socket_send():SUCCEED
  1639:20221109:162148.143 In zbx_ipc_async_socket_flush() timeout:10
  1639:20221109:162148.143 End of zbx_ipc_async_socket_flush():0
  1639:20221109:162148.143 In zbx_ipc_service_recv() timeout:0.819
  1639:20221109:162148.143 In ipc_service_accept()
  1639:20221109:162148.143 In ipc_service_add_client()
  1639:20221109:162148.143 End of ipc_service_add_client() clientid:1
  1639:20221109:162148.143 End of ipc_service_accept()
  1639:20221109:162148.143 End of zbx_ipc_service_recv():2
  1639:20221109:162148.143 In zbx_ipc_service_recv() timeout:0.819
  1639:20221109:162148.143 zbx_ipc_service_recv() code:3 size:0 data:
  1639:20221109:162148.143 End of zbx_ipc_service_recv():1
  1639:20221109:162148.143 In ha_send_status() ha_status:active info:
  1639:20221109:162148.143 In zbx_ipc_client_send() clientid:1
  1639:20221109:162148.143 End of zbx_ipc_client_send():SUCCEED
  1639:20221109:162148.143 End of ha_send_status():SYSINFO_SUCCEED
  1639:20221109:162148.143 In zbx_ipc_service_recv() timeout:0.819
  1611:20221109:162148.143 zbx_ipc_async_socket_recv() code:3 size:12 data:03 00 00 00 3c 00 00 00 | 00 00 00 00
  1611:20221109:162148.143 End of zbx_ipc_async_socket_recv():0
  1611:20221109:162148.143 In zbx_ipc_async_socket_close()
  1611:20221109:162148.143 In zbx_ipc_socket_close()
  1611:20221109:162148.143 End of zbx_ipc_socket_close()
  1639:20221109:162148.143 End of zbx_ipc_service_recv():1
  1639:20221109:162148.143 In zbx_ipc_socket_close()
  1611:20221109:162148.143 End of zbx_ipc_async_socket_close()
  1611:20221109:162148.143 End of zbx_ha_get_status():SUCCEED
  1639:20221109:162148.143 End of zbx_ipc_socket_close()
  1639:20221109:162148.143 In zbx_ipc_service_recv() timeout:0.819
  1611:20221109:162148.294 In init_database_cache()
  1611:20221109:162148.294 End of init_database_cache()
  1611:20221109:162148.294 In init_configuration_cache() size:234881024
  1611:20221109:162148.294 In zbx_shmem_create() param:'CacheSize' size:234881024
  1611:20221109:162148.294 valid user addresses: [0x7f672310a170, 0x7f6731109ff0] total size: 234880640
  1611:20221109:162148.294 End of zbx_shmem_create()
  1611:20221109:162148.302 End of init_configuration_cache()
  1611:20221109:162148.302 In init_selfmon_collector()
  1611:20221109:162148.302 init_selfmon_collector() size:14320
  1611:20221109:162148.302 End of init_selfmon_collector() collector:0x7f6742b61000
  1611:20221109:162148.302 In zbx_vc_init()
  1611:20221109:162148.302 In zbx_shmem_required_size() size:0 chunks_num:1 descr:'value cache size' param:'ValueCacheSize'
  1611:20221109:162148.303 End of zbx_shmem_required_size() size:427
  1611:20221109:162148.303 In zbx_shmem_create() param:'ValueCacheSize' size:100663296
  1611:20221109:162148.303 valid user addresses: [0x7f671d10a170, 0x7f6723109ff0] total size: 100662912
  1611:20221109:162148.303 End of zbx_shmem_create()
  1611:20221109:162148.303 End of zbx_vc_init()
  1611:20221109:162148.303 In zbx_tfc_init()
  1611:20221109:162148.303 In zbx_shmem_required_size() size:0 chunks_num:1 descr:'trend function cache size' param:'TrendFunctionCacheSize'
  1611:20221109:162148.303 End of zbx_shmem_required_size() size:444
  1611:20221109:162148.303 In zbx_shmem_create() param:'TrendFunctionCacheSize' size:8388608
  1611:20221109:162148.303 valid user addresses: [0x7f671c90a188, 0x7f671d109ff0] total size: 8388200
  1611:20221109:162148.303 End of zbx_shmem_create()
  1611:20221109:162148.303 zbx_tfc_init(): slots:99857
  1611:20221109:162148.305 End of zbx_tfc_init(): 
  1611:20221109:162148.306 server #0 started [main process]
  1611:20221109:162148.307 In zbx_ipc_service_recv() timeout:1.000
  1611:20221109:162148.307 zbx_ipc_service_recv() code:10001 size:0 data:
  1641:20221109:162148.307 server #2 started [configuration syncer #1]
  1611:20221109:162148.307 End of zbx_ipc_service_recv():1
  1611:20221109:162148.307 In zbx_ipc_service_recv() timeout:1.000
  1641:20221109:162148.307 In zbx_ipc_async_socket_open()
  1641:20221109:162148.307 In zbx_ipc_socket_open()
  1641:20221109:162148.307 End of zbx_ipc_socket_open():SUCCEED
  1611:20221109:162148.307 In ipc_service_accept()
  1611:20221109:162148.307 In ipc_service_add_client()
  1611:20221109:162148.307 End of ipc_service_add_client() clientid:2
  1611:20221109:162148.307 End of ipc_service_accept()
  1641:20221109:162148.307 End of zbx_ipc_async_socket_open():SUCCEED
  1641:20221109:162148.307 In zbx_ipc_async_socket_send()
  1641:20221109:162148.307 In zbx_ipc_client_send() clientid:0
  1611:20221109:162148.307 End of zbx_ipc_service_recv():2
  1611:20221109:162148.307 In zbx_ipc_service_recv() timeout:1.000
  1641:20221109:162148.307 End of zbx_ipc_client_send():SUCCEED
  1641:20221109:162148.307 End of zbx_ipc_async_socket_send():SUCCEED
  1641:20221109:162148.307 In zbx_ipc_async_socket_flush() timeout:4
  1641:20221109:162148.307 End of zbx_ipc_async_socket_flush():0
  1641:20221109:162148.307 zbx_setproctitle() title:'configuration syncer [connecting to the database]'
  1611:20221109:162148.307 zbx_ipc_service_recv() code:100 size:5 data:10 01 00 00 00
  1611:20221109:162148.307 End of zbx_ipc_service_recv():1
  1611:20221109:162148.307 In zbx_rtc_dispatch() code:100 size:5
  1641:20221109:162148.307 In DBconnect() flag:0
  1611:20221109:162148.307 End of zbx_rtc_dispatch()
  1611:20221109:162148.308 In zbx_ipc_service_recv() timeout:1.000
  1641:20221109:162148.308 End of DBconnect():0
  1641:20221109:162148.308 zbx_setproctitle() title:'configuration syncer [syncing configuration]'
  1640:20221109:162148.347 server #1 started [service manager #1]
  1640:20221109:162148.347 zbx_setproctitle() title:'service manager #1 [connecting to the database]'
  1640:20221109:162148.347 In DBconnect() flag:0
  1640:20221109:162148.348 End of DBconnect():0
  1640:20221109:162148.348 In zbx_ipc_service_start() service:service
  1640:20221109:162148.349 End of zbx_ipc_service_start():SUCCEED
  1640:20221109:162148.349 In db_get_events()
  1640:20221109:162148.349 query [txnlev:0] [select p.eventid,p.clock,p.severity,t.tag,t.value,p.ns from problem p left join problem_tag t on p.eventid=t.eventid where p.source=0 and p.object=0 and r_eventid is null order by p.eventid]
  1641:20221109:162148.434 In DCsync_configuration()
  1641:20221109:162148.434 query [txnlev:0] [select changelogid,clock from changelog]
  1641:20221109:162148.435 query [txnlev:0] [select objectid,type,clock,ns from trigger_queue]
  1641:20221109:162148.934 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]
  1641:20221109:162148.934 query [txnlev:0] [select tls_psk_identity,tls_psk from config_autoreg_tls order by autoreg_tlsid]
  1639:20221109:162148.964 End of zbx_ipc_service_recv():2
  1639:20221109:162148.964 In zbx_ipc_async_socket_send()
  1639:20221109:162148.965 In zbx_ipc_client_send() clientid:0
  1639:20221109:162148.965 End of zbx_ipc_client_send():SUCCEED
  1639:20221109:162148.965 End of zbx_ipc_async_socket_send():SUCCEED
  1639:20221109:162148.965 In zbx_ipc_async_socket_flush() timeout:10
  1639:20221109:162148.965 End of zbx_ipc_async_socket_flush():0
  1639:20221109:162148.965 In zbx_ipc_service_recv() timeout:0.997
  1611:20221109:162148.965 zbx_ipc_service_recv() code:10001 size:0 data:
  1611:20221109:162148.965 End of zbx_ipc_service_recv():1
  1611:20221109:162148.965 In zbx_ipc_service_recv() timeout:1.000
  1641:20221109:162148.966 In DCsync_config()
  1641:20221109:162148.966 End of DCsync_config()
  1641:20221109:162148.966 In DCsync_autoreg_config()
  1641:20221109:162148.966 End of DCsync_autoreg_config()
  1641:20221109:162148.966 query [txnlev:0] [select hostid,templateid from hosts_templates order by hostid]
  1640:20221109:162148.973 End of db_get_events()
  1640:20221109:162148.974 zbx_setproctitle() title:'service manager #1 started'
  1640:20221109:162148.974 query [txnlev:1] [begin;]
  1640:20221109:162148.974 In sync_services()
  1640:20221109:162148.974 query [txnlev:1] [select serviceid,status,algorithm,name,weight,propagation_rule,propagation_value from services]
  1641:20221109:162149.042 query [txnlev:0] [select globalmacroid,macro,value,type from globalmacro]
  1641:20221109:162149.318 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]
  1640:20221109:162149.572 End of sync_services()
  1640:20221109:162149.572 In sync_service_rules()
  1640:20221109:162149.573 query [txnlev:1] [select service_status_ruleid,serviceid,type,limit_value,limit_status,new_status from service_status_rule order by serviceid]
  1640:20221109:162149.856 End of sync_service_rules()
  1640:20221109:162149.856 In sync_service_tags()
  1640:20221109:162149.856 query [txnlev:1] [select servicetagid,serviceid,tag,value from service_tag]
  1639:20221109:162149.964 End of zbx_ipc_service_recv():2
  1639:20221109:162149.964 In zbx_ipc_async_socket_send()
  1639:20221109:162149.964 In zbx_ipc_client_send() clientid:0
  1639:20221109:162149.964 End of zbx_ipc_client_send():SUCCEED
  1639:20221109:162149.964 End of zbx_ipc_async_socket_send():SUCCEED
  1639:20221109:162149.964 In zbx_ipc_async_socket_flush() timeout:10
  1639:20221109:162149.964 End of zbx_ipc_async_socket_flush():0
  1639:20221109:162149.964 In zbx_ipc_service_recv() timeout:0.998
  1611:20221109:162149.964 zbx_ipc_service_recv() code:10001 size:0 data:
  1611:20221109:162149.964 End of zbx_ipc_service_recv():1
  1611:20221109:162149.964 In zbx_ipc_service_recv() timeout:1.000
  1639:20221109:162150.964 End of zbx_ipc_service_recv():2
  1639:20221109:162150.964 In zbx_ipc_async_socket_send()
  1639:20221109:162150.964 In zbx_ipc_client_send() clientid:0
  1639:20221109:162150.964 End of zbx_ipc_client_send():SUCCEED
  1639:20221109:162150.964 End of zbx_ipc_async_socket_send():SUCCEED
  1639:20221109:162150.964 In zbx_ipc_async_socket_flush() timeout:10
  1639:20221109:162150.964 End of zbx_ipc_async_socket_flush():0
  1639:20221109:162150.964 In zbx_ipc_service_recv() timeout:0.998
  1611:20221109:162150.964 zbx_ipc_service_recv() code:10001 size:0 data:
  1611:20221109:162150.964 End of zbx_ipc_service_recv():1
  1611:20221109:162150.964 In zbx_ipc_service_recv() timeout:1.000
  1639:20221109:162151.964 End of zbx_ipc_service_recv():2
  1639:20221109:162151.965 In ha_check_nodes() ha_status:active db_status:0
  1639:20221109:162151.965 query [txnlev:1] [begin;]
  1639:20221109:162151.965 query [txnlev:1] [select ha_nodeid,name,status,lastaccess,address,port,ha_sessionid from ha_node order by ha_nodeid for update]
  1639:20221109:162151.965 query [txnlev:1] [select ha_failover_delay,auditlog_enabled from config]
  1611:20221109:162151.965 End of zbx_ipc_service_recv():2
  1611:20221109:162151.965 In zbx_ipc_service_recv() timeout:1.000
  1639:20221109:162151.965 In ha_db_get_time()
  1639:20221109:162151.965 query [txnlev:1] [select unix_timestamp() from config]
  1639:20221109:162151.965 End of ha_db_get_time():SUCCEED db_time:1668000111
  1639:20221109:162151.965 query [txnlev:1] [update ha_node set lastaccess=unix_timestamp() where ha_nodeid='cl5s5on970001vc86e9psiztc']
  1639:20221109:162151.966 query [txnlev:1] [commit;]
  1639:20221109:162152.096 End of ha_check_nodes() nodeid:cl5s5on970001vc86e9psiztc ha_status:active db_status:0
  1639:20221109:162152.097 In zbx_ipc_async_socket_send()
  1639:20221109:162152.097 In zbx_ipc_client_send() clientid:0
  1639:20221109:162152.097 End of zbx_ipc_client_send():SUCCEED
  1639:20221109:162152.097 End of zbx_ipc_async_socket_send():SUCCEED
  1639:20221109:162152.097 In zbx_ipc_async_socket_flush() timeout:10
  1639:20221109:162152.097 End of zbx_ipc_async_socket_flush():0
  1639:20221109:162152.097 In zbx_ipc_service_recv() timeout:0.997
  1611:20221109:162152.097 zbx_ipc_service_recv() code:10001 size:0 data:
  1611:20221109:162152.097 End of zbx_ipc_service_recv():1
  1611:20221109:162152.097 In zbx_ipc_service_recv() timeout:1.000
  1640:20221109:162152.261 End of sync_service_tags()
  1640:20221109:162152.261 In sync_service_problem_tags()
  1640:20221109:162152.261 query [txnlev:1] [select service_problem_tagid,serviceid,tag,operator,value from service_problem_tag order by serviceid]
  1640:20221109:162152.306 End of sync_service_problem_tags()
  1640:20221109:162152.306 In sync_services_links()
  1640:20221109:162152.306 query [txnlev:1] [select linkid,serviceupid,servicedownid from services_links]
  1640:20221109:162152.333 End of sync_services_links()
  1640:20221109:162152.333 In sync_actions()
  1640:20221109:162152.333 query [txnlev:1] [select actionid,evaltype,formula from actions where eventsource=4 and status=0]
  1641:20221109:162152.752 slow query: 3.433752 sec, "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"
  1641:20221109:162152.752 query [txnlev:0] [select hosttagid,hostid,tag,value from host_tag]
  1640:20221109:162153.045 End of sync_actions()
  1640:20221109:162153.045 In sync_action_conditions()
  1640:20221109:162153.045 query [txnlev:1] [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.eventsource=4 and a.status=0]
  1640:20221109:162153.057 End of sync_action_conditions()
  1640:20221109:162153.057 query [txnlev:1] [select severity_name_0,severity_name_1,severity_name_2,severity_name_3,severity_name_4,severity_name_5 from config]
  1640:20221109:162153.058 In sync_service_problems()
  1640:20221109:162153.058 query [txnlev:1] [select service_problemid,eventid,serviceid,severity from service_problem]
  1641:20221109:162153.067 In DCsync_host_tags()
  1641:20221109:162153.067 End of DCsync_host_tags()
  1641:20221109:162153.067 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]
  1641:20221109:162153.080 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]