Cleaning all history

[jsomoza]

Hi everybody,

A week ago, almost all of my zabbix items stopped getting data. I figured out that by selecting and item and using the Clean history selected items option, it starts working again.

The problem is that doing it this way, I'll probably last a month to clean history of all items, so, is there any way to do it manually? Any command to do it faster? Which could be the reason of that failure?

Thanks beforehand.

[nelsonab]

You can do a bulk cleanup from the items configuration screen. Select all the items you want to clean up then scroll to the bottom and select "Clean history selected items".

However have you tried to disable/enable the item in question? Have you also tried to stop/restart the zabbix server? I have found in the rare cases where an item get's stuck disable/enable will likely fix it, and if that does not work a stop/restart will usually fix the problem.

[jsomoza]

First of all, thanks for replying nelsonab.

By selecting all items and then "Clean history selected items", the problem remains the same. It lasts too much.

I've also tried to disable/enable the item and also to restart zabbix, which has worked to me a lot of times, but nothing really happens.

Any other suggestion?

Thanks.

[nelsonab]

How comfortable are you with some MySQL queries?

If you feel comfortable enough try the following query:

select type, description, key_, delay, from_unixtime(nextcheck),lastvalue, from_unixtime(lastclock),prevvalue, status, delta, now() as cur_time from items where itemid=<Item ID Here>;

You will need to know one itemid in question. If you want to check for a list of item id's replace the where clause with:

where itemid in (id1,id2,id3,id4)

This will show you when the item was last checked and when it's due to be checked again, along with the current time according to MySQL.

[jsomoza]

Hi,

We fixed it up. It was a parameter in zabbix server which tells zabbix when next update has to be. It was set to 12 and it has to be zero.

Thanks!