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

recent 5.0 on Oracle DB cause "ORA-00913: too many values" SQL error

    XMLWordPrintable

Details

    • Team A
    • Sprint 80 (Sep 2021), Sprint 81 (Oct 2021), Sprint 82 (Nov 2021)
    • 10

    Description

      Zabbix installation was upgraded from 5.0.8 to 5.0.14 and an issue appeared when we try to import a template, linked to many hosts.

      We tried to upgrade/downgrade frontend back and forth and it seems it's reproducible on 5.0.14 only, but it's not guaranteed. Anyway, an issue is there.

      Attached is 2 long SQLs on 5.0.14 5014-sqls-wrapped
      It formatted using sed, to add \n after each OR, for better readability.

      It contains ~30K "OR f.functionid BETWEEN 4286266 AND 4286270..." repeats.
      And also ~50 "OR f.functionid IN(less than 1000)..." repeats, which ONLY were seen in debug in 5.0.8 and they were successful.

      So, looks like new 30K repeats supposedly cause an issue.

      Attaching also similar? import attempt SQLs from debug on 5.0.8 (formatted too) 508-sqls-wrapped

      Note also how these 2 SQLs are  slow on 5.0.14 (270 seconds each) - not acceptable.

       

      Attachments

        1. 5014-sqls-wrapped
          3.30 MB
        2. 508-sqls-wrapped
          316 kB
        3. A1 Zabbix dev_ Configuration import-NEW2.html
          748 kB
        4. after-patch-debug-info.html
          748 kB
        5. before-patch-debug-info.html
          752 kB
        6. debug.txt
          717 kB
        7. Screenshot 2021-10-18 at 01.05.49.png
          Screenshot 2021-10-18 at 01.05.49.png
          9 kB
        8. ZBX-19902-graphs.patch
          7 kB

        Issue Links

          Activity

            People

              jfreibergs Janis Freibergs
              zalex_ua Oleksii Zagorskyi
              Votes:
              2 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated: