HA - DCsync_configuration() total sync take long time
Hello
during switching from primary node to second node time needed by zabbix-server to fully proceed take about 15 minutes,
On debug log level I see the entry 'DCsync_configuration() total sync : 902.165286 sec.'
Few minutes later when Im back to primary mode this process take 'DCsync_configuration() total sync : 32.825873 sec.'
why it take so long when im movie to secondary node ?
Im using Oracle DB for zabbix-server
both Zabbix server node are the same (VM RHEL 7.9 with 4xvCPU, 24GB RAM)
part of logs:
DCsync_configuration() changelog : sql:0.006662 sec (199 records)
DCsync_configuration() config : sql:0.005436 sync:0.000231 sec (1/0/0).
DCsync_configuration() autoreg : sql:0.004828 sync:0.000056 sec (1/0/0).
DCsync_configuration() hosts : sql:0.009940 sync:0.011548 sec (337/0/0).
DCsync_configuration() host_invent: sql:0.005925 sync:0.000215 sec (1/0/0).
DCsync_configuration() templates : sql:0.004730 sec (837/0/0).
DCsync_configuration() globmacros : sql:0.004864 sec (16/0/0).
DCsync_configuration() hostmacros : sql:0.005539 sec (2216/0/0).
DCsync_configuration() interfaces : sql:0.005514 sync:0.006990 sec (332/0/0).
DCsync_configuration() items : sql:0.005222 sync:333.049732 sec (72505/0/0).
DCsync_configuration() template_items : sql:0.005954 sync:0.233090 sec (8649/0/0).
DCsync_configuration() prototype_items : sql:0.004963 sync:0.181751 sec (6925/0/0).
DCsync_configuration() item_discovery : sql:0.004806 sync:1.577208 sec (65726/0/0).
DCsync_configuration() triggers : sql:0.013940 sync:1.137879 sec (25947/0/0).
DCsync_configuration() trigdeps : sql:0.005014 sync:0.192838 sec (8029/0/0).
DCsync_configuration() trig. tags : sql:0.004956 sync:0.438783 sec (17779/0/0).
DCsync_configuration() host tags : sql:0.004843 sync:0.020225 sec (813/0/0).
DCsync_configuration() item tags : sql:0.005102 sync:2.338047 sec (93279/0/0).
DCsync_configuration() functions : sql:0.009544 sync:1.488535 sec (56571/0/0).
DCsync_configuration() expressions: sql:0.005025 sync:0.000218 sec (10/0/0).
DCsync_configuration() actions : sql:0.004938 sync:0.000093 sec (6/0/0).
DCsync_configuration() operations : sql:0.006191 sync:0.000064 sec (0/6/0).
DCsync_configuration() conditions : sql:0.005523 sync:0.000135 sec (10/0/0).
DCsync_configuration() corr : sql:0.004912 sync:0.000215 sec (0/0/0).
DCsync_configuration() corr_cond : sql:0.005247 sync:0.000299 sec (0/0/0).
DCsync_configuration() corr_op : sql:0.004891 sync:0.000476 sec (0/0/0).
DCsync_configuration() hgroups : sql:0.010764 sync:0.009777 sec (96/0/0).
DCsync_configuration() item pproc : sql:0.004719 sync:561.380135 sec (54612/0/0).
DCsync_configuration() item script param: sql:0.005809 sync:0.000416 sec (0/0/0).
DCsync_configuration() maintenance: sql:0.024116 sync:0.000545 sec (9/0/0).
DCsync_configuration() macro cache: 0.075863 sec.
DCsync_configuration() reindex : 0.040564 sec.
DCsync_configuration() total sql : 0.182606 sec.
DCsync_configuration() total sync : 902.165286 sec.
DCsync_configuration() proxies : 8 (17 slots)
DCsync_configuration() hosts : 337 (521 slots)
DCsync_configuration() hosts_h : 329 (521 slots)
DCsync_configuration() hosts_p : 8 (17 slots)
DCsync_configuration() psks : 162 (227 slots)
DCsync_configuration() ipmihosts : 0 (0 slots)
DCsync_configuration() host_invent: 1 (11 slots)
DCsync_configuration() glob macros: 16 (29 slots)
DCsync_configuration() host macros: 2216 (4007 slots)
DCsync_configuration() kvs_paths : 0
DCsync_configuration() interfaces : 328 (521 slots)
DCsync_configuration() interfaces_snmp : 152 (227 slots)
DCsync_configuration() interfac_ht: 328 (521 slots)
DCsync_configuration() if_snmpitms: 0 (0 slots)
DCsync_configuration() if_snmpaddr: 150 (227 slots)
DCsync_configuration() item_discovery : 65726 (103001 slots)
DCsync_configuration() items : 72505 (103001 slots)
DCsync_configuration() items_hk : 72505 (103001 slots)
DCsync_configuration() numitems : 59339 (103001 slots)
DCsync_configuration() preprocitems: 43022 (68659 slots)
DCsync_configuration() preprocops : 54612 (68659 slots)
DCsync_configuration() snmpitems : 36793 (68659 slots)
DCsync_configuration() ipmiitems : 0 (0 slots)
DCsync_configuration() trapitems : 6 (11 slots)
DCsync_configuration() dependentitems : 5763 (9029 slots)
DCsync_configuration() logitems : 188 (347 slots)
DCsync_configuration() dbitems : 0 (0 slots)
DCsync_configuration() sshitems : 0 (0 slots)
DCsync_configuration() telnetitems: 0 (0 slots)
DCsync_configuration() simpleitems: 432 (787 slots)
DCsync_configuration() jmxitems : 0 (0 slots)
DCsync_configuration() calcitems : 106 (151 slots)
DCsync_configuration() httpitems : 0 (0 slots)
DCsync_configuration() scriptitems : 0 (0 slots)
DCsync_configuration() functions : 46124 (68659 slots)
DCsync_configuration() triggers : 25947 (45763 slots)
DCsync_configuration() trigdeps : 13055 (20333 slots)
DCsync_configuration() trig. tags : 17779 (30509 slots)
DCsync_configuration() expressions: 10 (17 slots)
DCsync_configuration() actions : 6 (11 slots)
DCsync_configuration() conditions : 10 (17 slots)
DCsync_configuration() corr. : 0 (0 slots)
DCsync_configuration() corr. conds: 0 (0 slots)
DCsync_configuration() corr. ops : 0 (0 slots)
DCsync_configuration() hgroups : 96 (151 slots)
DCsync_configuration() item procs : 54612 (68659 slots)
DCsync_configuration() maintenance: 9 (17 slots)
DCsync_configuration() maint tags : 0 (0 slots)
DCsync_configuration() maint time : 9 (17 slots)
DCsync_configuration() queue[0] : 258 (364 allocated)
DCsync_configuration() queue[1] : 0 (0 allocated)
DCsync_configuration() queue[2] : 0 (0 allocated)
DCsync_configuration() queue[3] : 0 (0 allocated)
DCsync_configuration() queue[4] : 0 (0 allocated)
DCsync_configuration() queue[5] : 104 (108 allocated)
DCsync_configuration() queue[6] : 0 (0 allocated)
DCsync_configuration() pqueue : 0 (0 allocated)
DCsync_configuration() timer queue: 6 (32 allocated)
DCsync_configuration() changelog : 199
DCsync_configuration() configfree : 97.480111%
DCsync_configuration() strings : 70117 (103001 slots)
DCsync_configuration() reschedule : 0.014389 sec.
End of DCsync_configuration()
during switching from primary node to second node time needed by zabbix-server to fully proceed take about 15 minutes,
On debug log level I see the entry 'DCsync_configuration() total sync : 902.165286 sec.'
Few minutes later when Im back to primary mode this process take 'DCsync_configuration() total sync : 32.825873 sec.'
why it take so long when im movie to secondary node ?
Im using Oracle DB for zabbix-server
both Zabbix server node are the same (VM RHEL 7.9 with 4xvCPU, 24GB RAM)
part of logs:
DCsync_configuration() changelog : sql:0.006662 sec (199 records)
DCsync_configuration() config : sql:0.005436 sync:0.000231 sec (1/0/0).
DCsync_configuration() autoreg : sql:0.004828 sync:0.000056 sec (1/0/0).
DCsync_configuration() hosts : sql:0.009940 sync:0.011548 sec (337/0/0).
DCsync_configuration() host_invent: sql:0.005925 sync:0.000215 sec (1/0/0).
DCsync_configuration() templates : sql:0.004730 sec (837/0/0).
DCsync_configuration() globmacros : sql:0.004864 sec (16/0/0).
DCsync_configuration() hostmacros : sql:0.005539 sec (2216/0/0).
DCsync_configuration() interfaces : sql:0.005514 sync:0.006990 sec (332/0/0).
DCsync_configuration() items : sql:0.005222 sync:333.049732 sec (72505/0/0).
DCsync_configuration() template_items : sql:0.005954 sync:0.233090 sec (8649/0/0).
DCsync_configuration() prototype_items : sql:0.004963 sync:0.181751 sec (6925/0/0).
DCsync_configuration() item_discovery : sql:0.004806 sync:1.577208 sec (65726/0/0).
DCsync_configuration() triggers : sql:0.013940 sync:1.137879 sec (25947/0/0).
DCsync_configuration() trigdeps : sql:0.005014 sync:0.192838 sec (8029/0/0).
DCsync_configuration() trig. tags : sql:0.004956 sync:0.438783 sec (17779/0/0).
DCsync_configuration() host tags : sql:0.004843 sync:0.020225 sec (813/0/0).
DCsync_configuration() item tags : sql:0.005102 sync:2.338047 sec (93279/0/0).
DCsync_configuration() functions : sql:0.009544 sync:1.488535 sec (56571/0/0).
DCsync_configuration() expressions: sql:0.005025 sync:0.000218 sec (10/0/0).
DCsync_configuration() actions : sql:0.004938 sync:0.000093 sec (6/0/0).
DCsync_configuration() operations : sql:0.006191 sync:0.000064 sec (0/6/0).
DCsync_configuration() conditions : sql:0.005523 sync:0.000135 sec (10/0/0).
DCsync_configuration() corr : sql:0.004912 sync:0.000215 sec (0/0/0).
DCsync_configuration() corr_cond : sql:0.005247 sync:0.000299 sec (0/0/0).
DCsync_configuration() corr_op : sql:0.004891 sync:0.000476 sec (0/0/0).
DCsync_configuration() hgroups : sql:0.010764 sync:0.009777 sec (96/0/0).
DCsync_configuration() item pproc : sql:0.004719 sync:561.380135 sec (54612/0/0).
DCsync_configuration() item script param: sql:0.005809 sync:0.000416 sec (0/0/0).
DCsync_configuration() maintenance: sql:0.024116 sync:0.000545 sec (9/0/0).
DCsync_configuration() macro cache: 0.075863 sec.
DCsync_configuration() reindex : 0.040564 sec.
DCsync_configuration() total sql : 0.182606 sec.
DCsync_configuration() total sync : 902.165286 sec.
DCsync_configuration() proxies : 8 (17 slots)
DCsync_configuration() hosts : 337 (521 slots)
DCsync_configuration() hosts_h : 329 (521 slots)
DCsync_configuration() hosts_p : 8 (17 slots)
DCsync_configuration() psks : 162 (227 slots)
DCsync_configuration() ipmihosts : 0 (0 slots)
DCsync_configuration() host_invent: 1 (11 slots)
DCsync_configuration() glob macros: 16 (29 slots)
DCsync_configuration() host macros: 2216 (4007 slots)
DCsync_configuration() kvs_paths : 0
DCsync_configuration() interfaces : 328 (521 slots)
DCsync_configuration() interfaces_snmp : 152 (227 slots)
DCsync_configuration() interfac_ht: 328 (521 slots)
DCsync_configuration() if_snmpitms: 0 (0 slots)
DCsync_configuration() if_snmpaddr: 150 (227 slots)
DCsync_configuration() item_discovery : 65726 (103001 slots)
DCsync_configuration() items : 72505 (103001 slots)
DCsync_configuration() items_hk : 72505 (103001 slots)
DCsync_configuration() numitems : 59339 (103001 slots)
DCsync_configuration() preprocitems: 43022 (68659 slots)
DCsync_configuration() preprocops : 54612 (68659 slots)
DCsync_configuration() snmpitems : 36793 (68659 slots)
DCsync_configuration() ipmiitems : 0 (0 slots)
DCsync_configuration() trapitems : 6 (11 slots)
DCsync_configuration() dependentitems : 5763 (9029 slots)
DCsync_configuration() logitems : 188 (347 slots)
DCsync_configuration() dbitems : 0 (0 slots)
DCsync_configuration() sshitems : 0 (0 slots)
DCsync_configuration() telnetitems: 0 (0 slots)
DCsync_configuration() simpleitems: 432 (787 slots)
DCsync_configuration() jmxitems : 0 (0 slots)
DCsync_configuration() calcitems : 106 (151 slots)
DCsync_configuration() httpitems : 0 (0 slots)
DCsync_configuration() scriptitems : 0 (0 slots)
DCsync_configuration() functions : 46124 (68659 slots)
DCsync_configuration() triggers : 25947 (45763 slots)
DCsync_configuration() trigdeps : 13055 (20333 slots)
DCsync_configuration() trig. tags : 17779 (30509 slots)
DCsync_configuration() expressions: 10 (17 slots)
DCsync_configuration() actions : 6 (11 slots)
DCsync_configuration() conditions : 10 (17 slots)
DCsync_configuration() corr. : 0 (0 slots)
DCsync_configuration() corr. conds: 0 (0 slots)
DCsync_configuration() corr. ops : 0 (0 slots)
DCsync_configuration() hgroups : 96 (151 slots)
DCsync_configuration() item procs : 54612 (68659 slots)
DCsync_configuration() maintenance: 9 (17 slots)
DCsync_configuration() maint tags : 0 (0 slots)
DCsync_configuration() maint time : 9 (17 slots)
DCsync_configuration() queue[0] : 258 (364 allocated)
DCsync_configuration() queue[1] : 0 (0 allocated)
DCsync_configuration() queue[2] : 0 (0 allocated)
DCsync_configuration() queue[3] : 0 (0 allocated)
DCsync_configuration() queue[4] : 0 (0 allocated)
DCsync_configuration() queue[5] : 104 (108 allocated)
DCsync_configuration() queue[6] : 0 (0 allocated)
DCsync_configuration() pqueue : 0 (0 allocated)
DCsync_configuration() timer queue: 6 (32 allocated)
DCsync_configuration() changelog : 199
DCsync_configuration() configfree : 97.480111%
DCsync_configuration() strings : 70117 (103001 slots)
DCsync_configuration() reschedule : 0.014389 sec.
End of DCsync_configuration()
Comment