Hi,
I'm running zabbix 5.0.14 and I monitor about 2800 hosts, probably around 1000+ ILOs and a few more odds and ends. I'm trying to link a new template to a template that about 2500 hosts use but I keep getting a deadlock. The deadlock errors can vary from something like
To something like
I can only guess this is because of the amount of hosts I'm monitoring and using that template on. I'm wondering if anyone has a work around?
I'm running zabbix 5.0.14 and I monitor about 2800 hosts, probably around 1000+ ILOs and a few more odds and ends. I'm trying to link a new template to a template that about 2500 hosts use but I keep getting a deadlock. The deadlock errors can vary from something like
Code:
[LIST][*]Error in query [SELECT hi.interfaceid,hi.main,hi.type,hi.hostid FROM interface hi WHERE (hi.hostid IN (40716,40734,40740,40801,40804,40807, ....... ,80202,80204,80205,80206,80207))] [Deadlock found when trying to get lock; try restarting transaction][/LIST]
Code:
Details Cannot update template[LIST][*]Error in query [INSERT INTO items_applications (applicationid,itemid,itemappid) VALUES ('792317','2875142','2094246'),('792319','2875143' ,'2094247'),('792321','2875144','2094248'),('79232 3','2875145','2094249'),('792325','2875146','20942 50'),('792327','2875147','2094251'),('792329','287 5148','2094252'),('792331','2875149','2094253'),(' 792333','2875150','2094254'),('792335','2875151',' 2094255'),('792337','2875152'..... ,'2097060')] [Deadlock found when trying to get lock; try restarting transaction][/LIST]