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

Data source ignored in Top hosts widget and too much data gets selected

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Trivial
    • Resolution: Fixed
    • 6.0.0rc1
    • 6.0.0rc2, 6.0 (plan)
    • Frontend (F)
    • None
    • Team A
    • Sprint 85 (Feb 2022)
    • 0.25

    Description

      Steps to reproduce:

      1. Enable debugging for current user group.
      2. Create a widget:
        1. Create an item column.
          1. Select Data = Item value.
          2. Select any item.
          3. Select History data = Trends.
          4. Click Add column.
        2. Click Apply.
      3. Open the debug info of the widget.

      Result:

      SQLs like: SELECT * FROM history ... LIMIT 86401.

      Expected:

      1. SQLs like SELECT ... FROM trends.
      2. LIMIT 1 instead of LIMIT 86401 in case when selecting from history table.

      Attachments

        Issue Links

          Activity

            People

              averza Andrejs Verza
              averza Andrejs Verza
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: