Fixing a corrupt discovered item Interval.
There's some discovered items with a wrong delay value in my zabbix, somehow, different from the template's delay.
I've got one host that's causing a huge amount of data inflow because many of its discovered items (there's a lot which are supposed to run at high intervals) are stuck at a very low interval of '2'. Not '2s', the value in the database is literally the number '2' only. Even though the discovery is a much higher value. It's not similar either, I have no idea where the magic two came from.
Is it possible to fix that with this kind of query:
Or will this break things and is it better to remove and re-apply the template, at the cost of removing all the history?
I've got one host that's causing a huge amount of data inflow because many of its discovered items (there's a lot which are supposed to run at high intervals) are stuck at a very low interval of '2'. Not '2s', the value in the database is literally the number '2' only. Even though the discovery is a much higher value. It's not similar either, I have no idea where the magic two came from.
Is it possible to fix that with this kind of query:
Code:
UPDATE `items` SET `delay` = '10m' WHERE `hostid` = '10329' AND `delay` = '2'