Hostsite (hosts.php?form=update) freezes with 4500 Usermacros

XMLWordPrintable

    • Type: Problem report
    • Resolution: Unresolved
    • Priority: Minor
    • None
    • Affects Version/s: 5.0.22, 6.0.3
    • Component/s: None
    • Environment:
      Zabbix v.5.0.12
      virtual zabbixserver
      8Cores, 16GB RAM

      3x virtual proxys
      4Cores, 16GB RAM

      2x hardware db-server
      2x 8Core CPU, 128GB RAM

      Hello,

      we have a problem with loading the MacroTab from the Hostpage. The Browser stalls and is asking to terminate the tab. 
      Also updating the host is impossible in the UI. 

      Steps to reproduce:

      1. fill host with a lot of usermacros with API usermacro.create
      2. Navigate to Host 
      3. Click on screen element Macro
      4. Wait forever...

      Guess:

      The MacroTab tries to load all usermacros within the same page and the database struggels to get the data. To load 5000 items is not a problem for zabbix because only 50 rows are loaded at the same time.

        1. slow.jpg
          slow.jpg
          100 kB
        2. macrotab.jpg
          macrotab.jpg
          154 kB
        3. image-2022-04-14-23-24-06-797.png
          image-2022-04-14-23-24-06-797.png
          73 kB
        4. hosts.jpg
          hosts.jpg
          66 kB

            Assignee:
            Zabbix Development Team
            Reporter:
            Julian Stolp
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: