[ZBX-6651] frontend calls lld rule an "item" Created: 2013 May 31  Updated: 2017 May 30  Resolved: 2013 Jun 28

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: API (A)
Affects Version/s: 2.1.0
Fix Version/s: 2.1.0

Type: Incident report Priority: Trivial
Reporter: richlv Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: templatelinking
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

have two lld rules with the same key in two different templates, attempt to link them to the same host - zabbix complains, but it says that

with item key "zzz"

it should not claim that's an item



 Comments   
Comment by Eduards Samersovs (Inactive) [ 2013 Jun 19 ]

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

Comment by Oleg Egorov (Inactive) [ 2013 Jun 21 ]

TESTED

Comment by Eduards Samersovs (Inactive) [ 2013 Jun 21 ]

Fixed in versions pre-2.1.0 (beta) r.36503

Comment by richlv [ 2013 Jun 21 ]

interesting. i don't know what you guys fixed here, but it was not the issue i reported ;D

have two templates with same lld rule. try to link them a host. it errors out :

Template "template" with item key "ddddd" already linked to host.

it should not say "item" here but "low level discovery rule"

(and to clarify, problem is still there in trunk r36505)

Comment by richlv [ 2013 Jun 21 ]

(1) also, please describe what was actually fixed here

Eduards Previously was fixed incorrect template name displaying in validation message for LLD.
But I also want to say that this problem description was written not clear and can be interpreted in different ways.. Shorter doesn't mean more clear.

Comment by Eduards Samersovs (Inactive) [ 2013 Jun 25 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-6651 r.36513

oleg.egorov CLOSED

Comment by Eduards Samersovs (Inactive) [ 2013 Jun 26 ]

Fixed in versions pre-2.1.0 (beta) r.36527

Comment by Eduards Samersovs (Inactive) [ 2013 Jun 28 ]

(4) Sql error in postgresql:

pg_query(): Query failed: ERROR: column "i.flags" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT i.key_,i.flags FROM items i WHERE i.hostid IN ('10047...
^ [hosts.php:473 → CAPIObject->update() → CAPIObject->__call() → czbxrpc::call() → czbxrpc::callAPI() → call_user_func() → CHost->update() → CHost->massUpdate() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → DBselect() → pg_query() in /home/zabbix/www/trunk/frontends/php/include/db.inc.php:441]
Error in query [SELECT i.key_,i.flags FROM items i WHERE i.hostid IN ('10047','10001','10047','10001') GROUP BY i.key_ HAVING COUNT(i.itemid)>1] [ERROR: column "i.flags" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT i.key_,i.flags FROM items i WHERE i.hostid IN ('10047...

Eduards RESOLVED in development branch svn://svn.zabbix.com/branches/dev/ZBX-6651

oleg.egorov CLOSED

Comment by Oleg Egorov (Inactive) [ 2013 Jun 28 ]

TESTED

Comment by Eduards Samersovs (Inactive) [ 2013 Jul 01 ]

Fixed in versions pre-2.1.0 (beta) r.36589

Generated at Wed Apr 24 07:57:16 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.