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

[Z3005] query failed: [-1] ORA-01795: maximum number of expressions in a list is 1000

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.2.3
    • Fix Version/s: 2.2.5rc1, 2.3.2
    • Component/s: Server (S)
    • Labels:

      Description

      If we send in a low-level discovery JSON with 3000 elements, we get this error in the server log:

      [Z3005] query failed: [-1] ORA-01795: maximum number of expressions in a list is 1000 [select key_ from items where hostid=10105 and key_ in ('echo[1]','echo[2]','echo[3]','echo[4]','echo[5]','echo[6]',...,'echo[2998]','echo[2999]','echo[3000]')

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            asaveljevs Aleksandrs Saveljevs
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: