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

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

      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.

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

              Created:
              Updated:
              Resolved: