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

gen_data.pl generates wrong data.sql for Oracle in Zabbix 5.0

    XMLWordPrintable

    Details

    • Type: Problem report
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.0.3
    • Fix Version/s: 5.0.5rc1, 5.2.0beta1, 5.2 (plan)
    • Component/s: Installation (I)
    • Labels:
      None
    • Environment:
      Oracle 19c, CentOS 7
    • Team:
      Team A
    • Sprint:
      Sprint 68 (Sep 2020)
    • Story Points:
      0.25

      Description

      Steps to reproduce:
      1. Run make dbschema, cd to database/oracle
      2. Load schema.sql and images.sql with sqlplus as described in the manual
      3. Log in with sqlplus, then from sqlplus command prompt:

      set echo on
      whenever sqlerror exit sql.sqlcode;
      @data.sql
      

      Result:

      SP2-0341:
      line overflow during variable substitution (>3000 characters at line 3)
      ...
      ...
      ERROR at line 1:
      ORA-02291: integrity constraint (ALEXK50T.C_ITEMS_5) violated - parent key not found
      

      Find a line which inserts record for item with id 31055 (for Zabbix 5.0.4rc1). It has two problems:
      1. The field param starts with concatenation operator "||".
      2. The line is too long for sqlplus.

      gen_data.pl has a special processing for long fields which is used for media types. This processing generates wrong SQL lines for items.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              viktors.tjarve Viktors Tjarve
              Reporter:
              Kalimulin Alex Kalimulin
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: