manually sync DM child history data?

[steev]

I recently had an issue with one of my child nodes mysql databases. As a result, the sync from child to parent DM node fell behind and now some of my items refuse to sync.

Is it possible to export the history table on the child and import into the db on the parent node? If not, then is there another way to jump-start the node sync process?

[steev]

remove the history_uint_sync data?

can I drop the history sync tables to force sync to pick up from the present time? At this point, I just need to get the sync working, I'm not concerned about losing the data that hasn't been synced.

[groe0286]

Hi Steev,

The answer is hard to find, but you find it here:
http://www.zabbix.com/wiki/doc/troubleshooting/index

Basically it says:

2. Resend configuration from one child node to MASTER

By now, there is no option in the gui (1.4.2). You can do it manually:
* 1. Stop Master node
* 2. Execute on NODEx (not MASTER):
*delete from node_cksum;
*delete from node_configlog;
* 3. Start Master node


There is no node_configlog table anymore. I just ignored this line, and it worked.