Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-5123

ORA-00918: column ambiguously defined

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Critical Critical
    • 2.0.1rc1, 2.1.0
    • 2.0.0
    • Server (S)
    • 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.

            Unassigned Unassigned
            mycigar Guoyu Li
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: