[ZBX-21808] Slow configuration sync after upgrade from 5 to 6 Created: 2022 Oct 25 Updated: 2024 Apr 10 Resolved: 2022 Nov 10 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Proxy (P), Server (S) |
Affects Version/s: | 6.0.9 |
Fix Version/s: | None |
Type: | Problem report | Priority: | Blocker |
Reporter: | Aleksey Volodin | Assignee: | Vladislavs Sokurenko |
Resolution: | Cannot Reproduce | Votes: | 1 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Attachments: |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
||||||||||||
Issue Links: |
|
||||||||||||
Team: | |||||||||||||
Sprint: | Support backlog |
Description |
After upgrade from 5 to 6 configuration sync time for Server and proxy jump from 2-5 minutes up to 50. ENV: around 200 hosts with 20 000 + items. Affected SQL: 1421192:20221021:124632.333 DCsync_configuration() items : sql:1262.652292 sync:0.043896 sec (9/17570/246). 1421192:20221021:124632.333 DCsync_configuration() item pproc : sql:1313.027720 sync:0.013206 sec (0/0/14512). 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;
select pp.item_preprocid,pp.itemid,pp.type,pp.params,pp.step,h.hostid,pp.error_handler,pp.error_handler_params from item_preproc pp,items i,hosts h where pp.itemid=i.itemid and i.hostid=h.hostid and (h.proxy_hostid is null or i.type in (5,15,18)) and h.status in (0,1) and i.flags<>2;
|
Comments |
Comment by Zaur Azimov [ 2024 Feb 13 ] |
Hi! Shortened Zabbix_Proxy start log: ZBX_PROXY_DEBUG.txt create new task https://support.zabbix.com/browse/ZBX-24089 |