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

    • Problem report
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 5.0.3
    • 5.0.5rc1, 5.2.0beta1, 5.2 (plan)
    • Installation (I)
    • None
    • Oracle 19c, CentOS 7
    • Team A
    • Sprint 68 (Sep 2020)
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: