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

Trunk not working with Oracle DB

    XMLWordPrintable

Details

    • Incident report
    • Resolution: Fixed
    • Blocker
    • 2.0.0
    • 1.9.7 (beta)
    • Server (S)
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: