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 B
    • Sprint 80 (Sep 2021), Sprint 81 (Oct 2021), Sprint 82 (Nov 2021), Sprint 83 (Dec 2021), Sprint 84 (Jan 2022), Sprint 85 (Feb 2022), Sprint 86 (Mar 2022), Sprint 87 (Apr 2022), Sprint 88 (May 2022), Sprint 89 (Jun 2022), Support backlog

    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

        Activity

          People

            Miks.Kronkalns Miks Kronkalns
            zalex_ua Oleksii Zagorskyi
            Votes:
            3 Vote for this issue
            Watchers:
            13 Start watching this issue

            Dates

              Created:
              Updated: