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

    • Team A
    • Sprint 68 (Sep 2020)
    • 0.25

      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.

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

              Created:
              Updated:
              Resolved: