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

Trunk not working with Oracle DB

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.9.7 (beta)
    • Fix Version/s: 2.0.0
    • Component/s: Server (S)
    • Labels:
    • Environment:
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
      RedHat EL 5.3 x64

      Description

      After an upgrade to 2.0 go to "Configuration" -> "Hosts" -> "Items" (of any host) and look down for the error:

      ociexecute(): ORA-00932: inconsistent datatypes: expected - got NCLOB [include/db.inc.php:458]
      SQL error [ORA-00932: inconsistent datatypes: expected - got NCLOB] in [SELECT DISTINCT i.*,f.triggerid FROM items i,functions f WHERE i.itemid BETWEEN 000000000000000 AND 099999999999999 AND 1=0 AND i.itemid=f.itemid]
      ocifetchinto(): ORA-24374: define not done before fetch or execute and fetch [include/db.inc.php:606]

      You can got to Oracle command-line (e. g. sqlplus) and execute next query in order to reproduce the error:

      SELECT DISTINCT i.*,f.triggerid FROM items i,functions f WHERE i.itemid BETWEEN 000000000000000 AND 099999999999999 AND 1=0 AND i.itemid=f.itemid;

      An error points to "i.*", selecting all the fields of an item. This is caused by the change of the "description" field in the "items" table from "nvarchar2(255)" to "NCLOB".

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              dimir dimir
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: