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

SQL error for last rev 1.8

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.8.4rc1
    • Fix Version/s: 1.8.4
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      Gentoo, Oracle 10g2

      Description

      31050:20100910:182033.364 [Z3005] Query failed: [-1] ORA-00933: SQL command not properly ended
      [SELECT s.serviceid FROM services as s, services_links as sl WHERE s.serviceid = sl.serviceupid AND NOT(s.triggerid IS NULL) GROUP BY s.serviceid]
      31050:20100910:182033.364 [Z3005] Query failed: [-1] ORA-00933: SQL command not properly ended
      [SELECT s.serviceid,s.algorithm,s.triggerid FROM services AS s WHERE s.serviceid NOT IN (SELECT DISTINCT sl.serviceupid FROM services_links AS sl)]
      31050:20100910:182033.364 [Z3005] Query failed: [-1] ORA-00933: SQL command not properly ended
      [SELECT MAX(sl.servicedownid) as serviceid, sl.serviceupid FROM services_links AS sl WHERE sl.servicedownid NOT IN (select distinct sl.serviceupid from services_links as sl) GROUP BY sl.serviceupid]

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            dotneft Alexey Pustovalov
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: