run housekeeper

[sid]

For some reason, the data in my trends table has disappeared. (I checked retention periods) So when I try to look at a graph for a period of more than 24 hours, I cannot look at any data.

However, the data is still in my history table. So I can view the data but in smaller time frames.

Does anyone know if there is a way to update the trends table using data from the history table?

Is this a housekeeper issue?

Thanks for the help.

[aspeer]

same issue

I am experiencing the same sort of issue with my trend data missing but historical data being present. I also need a way to make the housekeeper run and move the historical into the trend table.
Any help would be appreciated,
Thanks.

[Alexei]

I also need a way to make the housekeeper run and move the historical into the trend table.

Both history and trends are updated online as soon as ZABBIX receives a new value! Not need for any batch processing.

[aspeer]

What is the sql that it runs to update this table? We need to manually populate it since we had a data loss in trends but still have the historical. We just need to know how zabbix averages the data in order to maunally recreate it based off the historical data.
Thanks.