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

ORA-00918: column ambiguously defined

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.0.0
    • Fix Version/s: 2.0.1rc1, 2.1.0
    • Component/s: Server (S)
    • Labels:
    • Environment:
      Oracle 11gR1

      Description

      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.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: