Database entrys with future timestamps: Zabbix stops monitoring

[Norlo]

Yesterday morning the system time of our zabbix server was changed to some date in 2014. It collected data for more than 1 Hour with future timestamps.

After changeing system time to correct value zabbix stopped monitoring.

We tried to fix the problem by deleting future items in tables history, history_str, history_log, history_uint and trends.

In table items we set nextcheck to a value that is a few minutes in the past. Lastclock was set to a few more minutes in the past.

These changes were only made for items with nextcheck in the future. Zabbix Server was stopped while changes were applied.

After starting zabbix server it was starting monitoring. Unfortunatly I recognized this morning, that still some items are not monitored.

Nextcheck and Lastclock of these items are both in the past.

How can we reactivate these items (aprox. 2200 of 18000 items in total).

We are running Zabbix 1.6.5 with mysql.

Regards
Niko

[simonc]

I think if you put 0 to the nextcheck value, zabbix will try to collect data immediatly.
I'm not really sure, so try that to 1 or 2 items before.

[fjrial]

hi:

the same happen to me today.. but can't find nextcheck field in items table.. zabbix_server 1.8.2

any help please?

[fjrial]

sorry.. just figured out right now.. a restart on zabbix_server did the trick for all items, even those with future timestamps.