-
Incident report
-
Resolution: Fixed
-
Critical
-
2.0.0
-
Oracle 11gR1
We got the following error in our Zabbix Server log:
7153:20120604:020121.159 [Z3005] query failed: [-1] ORA-00918: column ambiguously defined [select * from (select t1.description,h1.host,t2.description,h2.host from trigger_depends td,triggers t1,functions f1,items i1,hosts h1,triggers t2,functions f2,items i2,hosts h2 where td.triggerid_down=t1.triggerid and t1.triggerid=f1.triggerid and f1.itemid=i1.itemid and i1.hostid=h1.hostid and td.triggerid_up=t2.triggerid and t2.triggerid=f2.triggerid and f2.itemid=i2.itemid and i2.hostid=h2.hostid and i1.hostid=10052 and not i2.hostid=10052 and h2.status=3) where rownum<=1]
It should come from host.c line 143 to line 177.