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

Not optimised SQL queries for Oracle database: timer process

    XMLWordPrintable

Details

    • Team A
    • Sprint 57 (Oct 2019), Sprint 58 (Nov 2019)
    • 1

    Description

      Steps to reproduce:
      Install Zabbix 4.0/4.2/4.4, use maintenance.

      Result:
      timer_log_info.txt

      Expected:
      Usage of the tmp tables or arrays, not in (list) clause.

      Attachments

        Issue Links

          is duplicated by

          Problem report - Problem report ZBX-15272 Zabbix running extremely long queries that time out, causing logs to fill up the disk

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Incident report - Incident report ZBX-16863 Query from timer when using tags in maintenance

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Activity

            People

              vso Vladislavs Sokurenko
              edgar.akhmetshin Edgar Akhmetshin
              Votes:
              0 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: