[ZBX-4718] Incorrect cloning graph's items in case of Full host cloning Created: 2012 Mar 01  Updated: 2017 May 30  Resolved: 2012 Apr 04

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: API (A), Frontend (F)
Affects Version/s: 1.8.10
Fix Version/s: 1.8.11, 2.0.0rc2

Type: Incident report Priority: Minor
Reporter: Dmitrij Gavrilenko Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: cloning, graphs
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

FreeBSD 8.2 x64
PHP 5.3.8 (5.3.6)


Attachments: File BUG.Graph.Clone.JPG    
Issue Links:
Duplicate
duplicates ZBX-2999 Y axis MAX value item not changed whi... Closed

 Description   

google translate :
--------------------------------------------------------

Improper cloning of the complete elements of graphs cloning host (Feature: Full clone)

We have a host: **term****. All items / triggers / schedules attached without templates.
We perform a function for this host "Full clone" mode "Configuration > Host". We give a new host name **-ais****.

All the elements, and triggers copied correctly!
Open for editing the schedule, "Memory Allocation, RAM" (see atach: "BUG.Graph.Clone.jpg").
The screenshot shows that the graphic elements of cloned correctly.

An error occurred while copying restrictions on the axis "Y axix MAX value". Host name remains the same "**term****", and the name of the cloned correctly.

I suspect that cloning restrictions on the axis "Y axix MIN value" will also be cloned with an error.

original :
--------------------------------------------------------

???????????? ???????????? ????????? ???????? ??? ?????? ???????????? ????? (???????: Full clone)

????? ??: **term**** . ??? ????????/????/????? ?????????? ??? ????????.
????????? ??? ????? ????? ??????? "Full clone" ? ?????? "Configuration > Host". ???? ?????? ????? ??? **-ais****.

??? ???????? ? ???????? ????????????? ?????????!
????????? ?? ?????????????? ?????? "????????????? ????, RAM" (. ????: "BUG.Graph.Clone.jpg").
?? ????????? ?????, ??? ???????? ??????? ????????????? ?????????.

?????? ????????? ??? ??????????? ??????????? ?? ??? "Y axix MAX value". ??? ????? ???????? ??????? "**term****", ? ??? ???????? ????????????? ?????????.

??????????, ??? ???????????? ??????????? ??? ??? "Y axix MIN value" ????? ????? ????????????? ? ???????.



 Comments   
Comment by Toms (Inactive) [ 2012 Mar 07 ]

Fixed in dev. branch: svn://svn.zabbix.com/branches/dev/ZBX-4718

Comment by Pavels Jelisejevs (Inactive) [ 2012 Mar 08 ]

(1) It would be better to use the get_same_item_for_host() to replace the items.

<Toms> RESOLVED in r.25902

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Mar 12 ]

(2) When I'm trying to clone a host i get an SQL error:

Error in query [INSERT INTO graphs (graphid,name,width,height,ymin_type,ymax_type,yaxismin,yaxismax,ymin_itemid,ymax_itemid,templateid,show_work_period,show_triggers,graphtype,show_legend,show_3d,percent_left,percent_right) VALUES (795,'graph1',900,200,2,1,0.0000,0.0000,26786,, 0,0,0,0,0,0,0.0000,0.0000)] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 0,0,0,0,0,0,0.0000,0.0000)' at line 1]

<Toms> RESOLVED in r.25968

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Mar 12 ]

(3) The min/max items should be replaced only if an item with the same key exists on the host we clone. A graph can reference an item from a different host with a key, that's not used on the cloned host. In that case, the item should not be replaced.

<Toms> RESOLVED in r.25968

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Mar 12 ]

The fix for 1.8 is TESTED.

By the way, the trunk also has this problem.

Comment by Toms (Inactive) [ 2012 Mar 12 ]

Fixed in version pre-1.8.11 r25980

Comment by Toms (Inactive) [ 2012 Mar 15 ]

RESOLVED in trunk - r26101

<richlv> i assume this was resolved in dev branch branches/dev/ZBX-4718 for trunk, right ?

<Toms> You are correct

Comment by richlv [ 2012 Apr 04 ]

(4) changelog entries for 1.8 section in 1.8 & trunk changelogs are different

<Toms> RESOLVED, CLOSED

Generated at Wed Apr 24 03:08:14 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.