graph loss after an upgrade & relinking

[richlv]

after an upgrade (1.1.7->1.4.1), hosts are not linked to according templates.
they can be relinked manually, but this happens by removing of existing items and creating them from the template.
unfortunately, it seems that also graphs created separately that include items from that host are deleted (that is, graphs are not linked to the template).

so, if we have a bunch of routers and a separate graph that includes items from them, and then relink any of the hosts, the graph gets deleted permanently.

an example (slightly modified):

Trigger 'Jau 3 min. {HOSTNAME} nav pieejams' deleted from host
'1'
Item '1:icmpping' deleted
Graph 'routers' deleted
Item '1:icmppingsec' deleted
Added new item 1:icmpping
Added new item 1:icmppingsec
Added trigger 'Jau 3 min. {HOSTNAME} nav pieejams' to host '1'

so, items and triggers are recreated, but graphs are not (though i'd say that graph should not have been deleted in the first place).

1.4.2 changelog lists "improved inheritance of template graphs", but that probably is not connected.

[Alexei]

Did you press "Unlink and clear" button and then linked the host to a template, right?

You should have pressed "Unlink" which does not delete information from a host, it just unlinks host elements from a template.

[richlv]

actually, no.
after an upgrade, there is no 'unlink' button. host has no templates linked at all (though all the items shown come from a template in 1.1). this was noticed some time before (http://www.zabbix.com/forum/showthread.php?t=6818), but only now some ugly consequences are showing up.

so simply pressing 'add' and choosing a template nukes all graphs.

and it is even slightly worse than that... as linking deletes items, it also completely wipes out all logged data.
only by coincidence we have a backup before the upgrade - i'll try to see whether data can be safely restored.

edit : haven't yet looked into details, but i guess item and trigger ids have changed, so this could be pretty damn HARD to do...

[alj]

actually, no.
after an upgrade, there is no 'unlink' button. host has no templates linked at all (though all the items shown come from a template in 1.1). this was noticed some time before (http://www.zabbix.com/forum/showthread.php?t=6818), but only now some ugly consequences are showing up.

so simply pressing 'add' and choosing a template nukes all graphs.

and it is even slightly worse than that... as linking deletes items, it also completely wipes out all logged data.
only by coincidence we have a backup before the upgrade - i'll try to see whether data can be safely restored.

edit : haven't yet looked into details, but i guess item and trigger ids have changed, so this could be pretty damn HARD to do...

Sounds like the same problem i had

http://www.zabbix.com/forum/showthread.php?t=7039

If it was fixed where can i get updated database migration sql script?