17428:20240213:153159.266 query [txnlev:1] [insert into item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values (18491018,22525501,2,10,'',0,'');
...
]
17428:20240213:153159.892 query [txnlev:1] [insert into item_parameter (item_parameterid,itemid,name,value) values (11560,18228600,'host','{HOST.HOST}');
...
]
17428:20240213:153159.894 In proxyconfig_sync_templates()
17428:20240213:153159.912 query [txnlev:1] [select hostid from hosts where (hostid in (10186,10474....) or hostid in (...)

17428:20240213:153159.921 query [txnlev:1] [insert into hosts (hostid,status) values (10186,3);
...
]
17428:20240213:153159.947 query [txnlev:1] [insert into hosts_templates (hosttemplateid,hostid,templateid,link_type) values (1079825,307496,209777,0);
...
]
....
....
17428:20240213:153200.163 query [txnlev:1] [insert into hosts_templates (hosttemplateid,hostid,templateid,link_type) values (243192,117411,24507,0);
...
]
17428:20240213:153200.187 query [txnlev:1] [insert into hosts_templates (hosttemplateid,hostid,templateid,link_type) values (503140,203434,32205,0);
...
]

17428:20240213:153200.211 query [txnlev:1] [insert into hosts_templates (hosttemplateid,hostid,templateid,link_type) values (91947,49445,32205,0);
...
]

17428:20240213:153200.229 End of proxyconfig_sync_templates()
17428:20240213:153200.232 query [txnlev:1] [
insert into hostmacro (hostmacroid,hostid,macro,value,type,automatic) values (62033,285405,'{$JMXPORT}','9993',0,0);
...
]

17428:20240213:153200.246 End of proxyconfig_sync_data()
17428:20240213:153200.246 query [txnlev:1] [commit;]

17530:20240213:153200.262 slow query: 124.939502 sec, "select nextid from ids where table_name='proxy_history' and field_name='history_
lastid'"
17649:20240213:153200.262 slow query: 124.806353 sec, "select taskid,type,clock,ttl from task where status=1 and type in (2, 6, 7) orde
r by taskid"

17428:20240213:153200.825 End of zbx_proxyconfig_process()
17428:20240213:153200.825 In DCsync_configuration()
17428:20240213:153200.825 query [txnlev:0] [select changelogid,object,objectid,operation,clock from changelog]

17428:20240213:153203.116 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]
17428:20240213:153203.116 query [txnlev:0] [select tls_psk_identity,tls_psk from config_autoreg_tls order by autoreg_tlsid]
17428:20240213:153203.116 In DCsync_config()
17428:20240213:153203.117 End of DCsync_config()
17428:20240213:153203.117 In DCsync_autoreg_config()
17428:20240213:153203.117 End of DCsync_autoreg_config()
17428:20240213:153203.117 In DCsync_autoreg_host()
17428:20240213:153203.117 End of DCsync_autoreg_host()
17428:20240213:153203.117 query [txnlev:0] [select hostid,templateid from hosts_templates order by hostid]

17428:20240213:153203.137 query [txnlev:0] [select globalmacroid,macro,value,type from globalmacro]
17428:20240213:153203.137 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]
17428:20240213:153203.147 In DCsync_host_tags()
17428:20240213:153203.147 End of DCsync_host_tags()

17428:20240213:153203.148 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.mai
ntenance_from,h.status,h.name,hr.lastaccess,h.tls_connect,h.tls_accept,h.tls_is
suer,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 and (h.hostid in (10186,10474,10480,10658,10670,11177,11187,11253,11254,11418,11450,11451,11461,11717,11733,11827,11828,11833,11834,11840,11841,11849,11852,11875,11881,11908,11926,11934,11941,11946,11953,11954,12047,12081,12089,12099,12105,12153,12167,12191,12207,12223,12231,12301,12302,12317,12393,12412,12413,12414,12415,12429,12497,12589,12657,13241,13356,14832,14833,14834,14957,14959,14968,14969,14970,14971,14972,14973,14974,14976,14978,15070,15072,15073,15208,15209,15210,15211,15212,15213,15214,15433,15440,15498,15584,15589,15599,15600,16018,16292,16297,16298,16446,16447,16448,16449,16450,16451,16453,16454,16455,16456,16537,16569,16570,16572,16573,16574,16575,16576,16577,16696,16697,16698,16699,16700,16701,16702,16703,16704,16705,16706,16707,16708,16709,16710,16711,16716,16744,16746,16775,16923,17024,17039,17040,17041,17042,17043,17044,17045,17063,17064,17065,17066,17067,17068,17069,17070,17071,17072,17073,17074,17075,17076,17077,17293,17316,17320,17366,17382,17393,17394,17396,17402,17409,17470,18072,18262,18296,18297,18354,18475,18823,18858,18965,18971,20516,21576,21594,21596,21598,21603,21604,21605,21606,21610,21614,21619,21620,21621,21629,21631,21651,21655,21657,21658,21662,21679,21940,22003,22032,22033,22034,22035,22036,22037,22041,22062,22063,22072,22656,22803,23216,23403,23684,23704,23718,23719,23720,23722,23757,23758,23759,23762,23764,23884,23975,23979,24249,24336,24363,24364,24365,24398,24507,24864,25044,25107,25208,25209,25210,27126,27127,27128,27156,27157,27158,27219,27742,27743,27744,27745,27746,27747,27748,27749,27750,27751,27752,27753,27754,27755,27756,27757,27758,27759,27760,27761,27989,28184,28351,28352,28353,28354,28355,28356,28722,28801,28808,28832,28833,28881,29050,29072,29415,29416,29417,29418,29419,29420,29421,29593,30295,30402,31082,31087,31123,31124,31505,31507,31575,31576,31860,31861,32115,32202,32205,32221,32225,32499,32513,32547,32553,32582,32710,32841,32950,35210,35567,35986,36414,37593,37611,37612,37631,37632,37633,37634,38214,38233,38236,38237,38238,38314,38357,38358,38359,38360,38361,38362,38363,38364,38365,38366,38367,38368,38369,38370,38371,38372,38373,38374,38375,38376,38526,38528,38529,38809,39908,39909,39910,39911,39912,39913,39914,39915,39916,39917,39954,40213,40298,40299,40348,40949,40950,40951,40955,40956,40957,40964,41075,41640,42031,42651,42652,42659,42801,43412,43584,43607,44474,44656,46086,46139,46140,46141,46142,46143,46146,46158,46216,46864,46966,47853,47900,48574,48672,48673,48674,48699,48729,48816,48827,48828,48889,48890,48896,48897,49445,49526,49647,49852,49862,49867,50462,50463,50511,50512,50809,51067,51078,51079,51080,51081,51789,51790,51791,51792,51811,51818,51858,51887,51945,52027,52028,52248,52249,52258,52260,52261,52264,52265,52276,52277,52347,52443,52446,52447,52448,52449,52485,52570,52575,52581,53348,53490,53740,53780,53790,53823,53923,53924,53925,53926,54244,54245,54436,54517,54757,54795,54797,54798,54812,54816,54817,54819,55303,55304,55305,55306,55307,55393,55471,55476,56226,57422,58137,58868,58869,58870,58871,58956,58957,59018,59019,59020,59052,59090,60512,60513,60660,60665,60841,60842,60843,60890,60891,61312,61313,61314,61315,61316,61317,61318,61319,61320,61321,61322,61324,61325,61326,61327,61328,61329,61330,61331,61332,61333,61334,61335,61336,61337,61338,61339,61340,61341,61342,61343,61344,61345,61346,61347,61348,61349,61350,61351,61352,61353,61354,61355,61356,61357,61358,61359,61360,61361,61362,61363,61364,61365,61366,61367,61368,61369,61370,61371,61372,61373,61374,61375,61376,61377,61378,61379,61381,61382,61383,61384,61385,61386,61387,61388,61389,61390,61391,61392,61393,61394,61395,61396,61397,61398,61399,61400,61401,61402,61403,61404,61405,61406,61407,61408,61409,61410,61411,61413,61414,61415,61416,61417,61418,61419,61420,61421,61422,61423,61424,61425,61426,61427,61428,61429,61430,61431,61432,61433,61434,61435,61436,61437,61438,61439,61440,61442,61444,61445,61446,61447,61448,61449,61450,61451,61452,61453,61454,61455,61456,61457,61458,61459,61461,61462,61463,61464,61465,61466,61467,61468,61469,61470,61471,61472,61473,61474,61475,61476,61477,61478,61479,61480,61481,61482,61483,61484,61485,61486,61487,61488,61489,61490,61491,61492,61493,61494,61495,61496,61497,61498,61499,61501,61502,61503,61504,61505,61506,61507,61508,61509,61510,61511,61512,61513,61514,61515,61516,61517,61518,61519,61520,61521,61522,61523,61524,61525,61527,61529,61530,61531,61532,61533,61534,61535,61536,61537,61538,61539,61540,61541,61542,61543,61544,61545,61546,61547,61548,61549,61550,61551,61552,61553,61554,61555,61557,61558,61559,61560,61561,61562,61563,61564,61565,61566,61567,61568,61569,61570,61571,61572,61573,61574,61575,61576,61577,61578,61579,61580,61581,61582,61583,61584,61586,61587,61588,61589,61590,61591,61592,61593,61594,61595,61596,61796,61814,61815,61816,61818,61819,61820,61823,61832,61839,61848,61849,61850,61851,61865,61869,61871,61872,61873,61876,61901,61902,61904,61905,61906,61907,61932,61933,61934,61935,61936,61937,61958,61959,61960,61961,61963,61978,61985,61988,61989,62010,62013,62014,62015,62016,62018,62027,62030,62039,62040,62041,62042,62043,62059,62063,62066,62067,62070,62071,62173,64385,64583,64643,64677,65049,65091,65409,65410,65411,65412,65414,65418,65419,65420,65421,65428,65430,65440,65441,65443,65444,65445,65446,65465,65502,65978,65979,65980,65983,65984,65985,65987,65988,65992,65993,65994,65995,65996,65997,65998,66023,66024,66025,66048,66050,66099,66100,66370,66371,66375,66402,66416,66436,66437,66452,66472,66473,66474,66475,66476,66477,66478,66488,67007,67008,67009,67019,67020,67335,67517,67526,67884,68012,68019,68313,68320,68321,68322,68323,68324,68325,68326,68644,69346,69377,69378,69380,69386,69553,69555,69556,69610,69612,69613,69657,69691,69697,69698) or h.hostid in (69702,69720,69728,70154,70603,70604,70606,70607,70609,70610,70636,70637,70653,70683,70684,70690,70693,70769,70772,73819,73821,73822,73823,73824,73825,73826,73829,73875,73883,73887,73890,73891,74607,74736,74796,74851,74852,74853,74956,75067,76874,77967,79986,79995,79996,79999,80002,80058,80067,80070))]

17428:20240213:153203.157 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 and (h.hostid in (...


17428:20240213:153203.196 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,ha
rdware_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,contr
act_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_no
tes,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]

17428:20240213:153203.289 query [txnlev:0] [select groupid,name from hstgrp]
17428:20240213:153203.290 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]
17428:20240213:153203.291 query [txnlev:0] [select maintenanceid,maintenance_type,active_since,active_till,tags_evaltype from maintenances]
17428:20240213:153203.292 query [txnlev:0] [select maintenancetagid,maintenanceid,operator,tag,value from maintenance_tag]
17428:20240213:153203.292 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]
17428:20240213:153203.292 query [txnlev:0] [select maintenanceid,groupid from maintenances_groups order by maintenanceid]
17428:20240213:153203.292 query [txnlev:0] [select maintenanceid,hostid from maintenances_hosts order by maintenanceid]
17428:20240213:153203.292 In DCsync_hosts()
17428:20240213:153203.300 End of DCsync_hosts()
17428:20240213:153203.300 In DCsync_host_inventory()
17428:20240213:153203.327 End of DCsync_host_inventory()
17428:20240213:153203.327 In DCsync_hostgroups()
17428:20240213:153203.327 End of DCsync_hostgroups()
17428:20240213:153203.327 In DCsync_hostgroup_hosts()
17428:20240213:153203.327 End of DCsync_hostgroup_hosts()
17428:20240213:153203.327 In DCsync_maintenances()
17428:20240213:153203.328 End of DCsync_maintenances()
17428:20240213:153203.328 In DCsync_maintenance_tags()
17428:20240213:153203.328 End of DCsync_maintenance_tags()
17428:20240213:153203.328 In DCsync_connectors()
17428:20240213:153203.328 End of DCsync_connectors()
17428:20240213:153203.328 In DCsync_connector_tags()
17428:20240213:153203.328 End of DCsync_connector_tags()
17428:20240213:153203.328 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,s.max_repetitions from interface i left join interface_snmp s on i.interfaceid=s.interfaceid]

17428:20240213:153203.359 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 and (i.itemid in (39313,39314,39315,113529,113535,113536,113538,113539,113541,113542,113543,113544,113545,113546,113547,113548,113552,113553,113554,113555,113556,113819,113825,113826,113828,113829,113831,113832,113833,113834,113835,113836,113837,113838,113842,113843,113844,113845,113846,115733,115739,115740,115742,115743,115745,115746,115747,115748,115749,115750,115751,115752,115756,115757,115758,115759,115760,115762,115768,115769,115771,115772,115774,115775,115776,115777,115778,115779,115780,115781,115785,115786,115787,115788,115789,115990,115991,115992,115993,115994,115995,115996,115997,115998,115999,116000,116001,116002,116003,116004,116005,116006,116007,116008,116009,116010,116011,116012,116013,116123,116124,116125,116126,116127,116128,116129,116130,116131,116132,116133,116134,116267,116268,116269,116270,116271,116272,116273,116274,116275,116276,116277,116278,126621,126627,126628,126630,126631,126633,126634,126635,126636,126637,126638,126639,126640,126644,126645,126646,126647,126648,126649,126650,126651,126652,126653,126654,126655,126656,126657,126658,126659,126660,127835,127841,127842,127844,127845,127847,127848,127849,127850,127851,127852,127853,127854,127858,127859,127860,127861,127862,127864,127870,127871,127873,127874,127876,127877,127878,127879,127880,127881,127882,127883,127887,127888,127889,127890,127891,127961,127991,128018,128019,128054,128075,128087,128412,128413,128414,128415,128416,128417,128418,128419,128420,128421,128422,128423,128424,128425,128426,128427,128428,128429,128430,128431,128432,128433,128434,128435,128436,128437,128438,140091,140092,140098,140099,140100,140101,140103,140104,140106,140107,140108,140109,140110,140111,140115,140116,140117,140118,140119,140533,140534,140535,140536,140537,140538,140539,140540,140541,140542,140543,140544,140999,141000,141006,141007,141008,141009,141011,141012,141014,141015,141016,141017,141018,141019,141023,141024,141025,141026,141027,141118,141119,141120,141121,141122,141123,141124,141125,141126,141127,141128,141129,141898,141933,141973,142043,142064,142075,142152,142154,142216,145593,145597,145604,145606,145613,145617,145624,145626,145713,145717,145724,145726,145733,145737,145744,145746,145853,145857,145864,145866,145873,145877,145884,145886,146033,146037,146044,146046,146093,146097,146104,146106,146553,146557,146564,146566,146673,146677,146684,146686,147213,147217,147224,147226,147573,147577,147584,147586,147733,147737,147744,147746,147873,147877,147884,147886,147973,147977,147984,147986,148113,148117,148124,148126,148133,148137,148144,148146,149973,149977,149984,149986,150653,150657,150664,150666,150813,150817,150824,150826,151013,151017,151024,151026,151133,151137,151144,151146,152093,152097,152104,152106,152373,152377,152384,152386,152853,152857,152864,152866,153173,153177,153184,153186,153473,153477,153484,153486,153633,153637,153644,153646,154217,154218,154220,154309,154310,154312,154423,154424,154426,154433,154434,154436,154753,154754,154756,155595,155599,155606,155608,155621,155625,155632,155634,155703,155704,155706,156023,156024,156025,156026,156029,156030,156035,156036,156038,156081,156082,156084,156137,156138,156140,156271,156272,156274,156295,156296,156298,156389,156390,156392,156441,156442,156444,156479,156480,156482,156661,156662,156664,156741,156742,156744,156799,156800,156802,156899,156900,156902,156995,156996,156998,157566,157567,157573,157574,157575,157576,157577,157579,157580,157581,157582,157583,157584,157585,157586,157590,157591,157592,157593,157594,157681,157682,157684,157787,157788,157790,157793,157794,157796,157933,157934,157936,158011,158012,158014,158037,158038,158040,158181,158182,158184,158569,158570,158572,158575,158576,158578,159804,159805,159806,159807,159808,159809,159810,159811,159812,159813,159814,159815,159816,159817,159818,163369,163370,163376,163377,163378,163379,163380,163382,163383,163384,163385,163386,163387,163388,163389,163393,163394,163395,163396,163397,163399,163400,163406,163407,163408,163409,163410,163412,163413,163414,163415,163416,163417,163418,163419,163423,163424,163425,163426,163427,163429,163430,163436,163437,163438,163439,163440,163442,163443,163444,163445,163446,163447,163448,163449,163453,163454,163455,163456,163457,163459,163460,163466,163467,163468,163469,163470,163472,163473,163474,163475,163476,163477,163478,163479,163483,163484,163485,163486,163487,163879,163880,163886,163887,163888,163889,163890,163892,163893,163894,163895,163896,163897,163898,163899,163903,163904,163905,163906,163907,164436,164437,164438,164439,164440,164441,164442,164443,164444,164445,164446,164447,164448,164449,164450,164451,164452,164453,164454,164455,164456,164457,164458,164459,164460,164461,164462,164463,164464,164465,164466,164467,164468,164469,164470,164471,164472,164473,164474,164475,164476,164477,164478,164479,164480,164481,164482,164483,164718,164719,164720,164721,164722,164723,164724,164725,164726,164727,164728,164729,166427,166428,166434,166435,166436,166437,166438,166440,166441,166442,166443,166444,166445,166446,166447,166451,166452,166453,166454,166455,167254,167255,167256,167257,167258,167259,167260,167261,167262,167263,167264,167265,170829,170830,170836,170837,170838,170839,170840,170842,170843,170844,170845,170846,170847,170848,170849,170853,170854,170855,170856,170857,172299,172300,172301,172302,172303,172304,172305,172306,172307,172308,172309,172310,173499,173504,173505,173506,173507,173508,173509,173510,173511,173512,173513,173514,173515,173516,173517,173518,173519,173520,173521,173522,174125,174126,174127,174128,174129,174130,174131,174132,174133,174134,174135,174136,174137,174138,174139,178027,178059,178074,178081,178095,178107,178108,178109,178119,178150,178169,178173,178192,178207,178241,178242,178253,178260,178262,178283,178327,178332,178368,178392,178413,178422,178447,178477,178506,178518,201171,201176,201177,201178,201179,201180,201181,201182,201183,201184,201185,201186,201187,201188,201189,201190,201191,201192,201193,201194,201480,201481,201482,201483,201484,201485,201486,201487,201488,201489,201490,201491,207013,207018,207019,207020,207021,207022,207023,207024,207025,207026,207027,207028,207029,207030,207031,207032,207033,207034,207035,207036,207037,207038,207039,207040,207041,207042,207043,207044,207045,207046,207047,207048,258818,258819,258825,258826,258827,258828,258829,258831,258832,258833,258834,258835,258836,258837,258838,258842,258843,258844,258845,258846,258848,258849,258855,258856,258857,258858,258859,258861,258862,258863,258864,258865,258866,258867,258868,258872,258873,258874,258875,258876,258878,258879,258885,258886,258887,258888,258889,258891,258892,258893,258894,258895,258896,258897,258898,258902,258903,258904) or i.itemid in (258905,258906,259428,259429,259430,259431,259432,259433,259434,259435,259436,259437,259438,259439,259440,259441,259442,259443,259444,259445,259446,259447,259448,259449,259450,259451,259452,259453,259454,259455,259456,259457,259458,259459,259460,259461,259462,259463,265299,265300,265306,265307,265308,265309,265310,265312,265313,265314,265315,265316))]
17428:20240213:153205.057 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 and (i.itemid in (...


Then similar SELECTs are executed and last a long time. If Zabbix_Proxy is stopped at this moment and started, then CONFIGURATION_SYNC will occur in 40 seconds and Zabbix_Proxy will work. If you do not stop Zabbix_Proxy, CONFIG_SYNC will be applied in about 15 minutes. I don't understand why this is happening for so long? Why are these SELECTs not executed when Zabbix_Porxy is rebooted and CONFIG_SYNC is applied immediately.