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

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.2.5rc1, 2.3.2
    • 2.2.3
    • Server (S)

      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]')

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

              Created:
              Updated:
              Resolved: