Details

    • Type: Incident report
    • Status: Closed
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 4.0.0rc1
    • Fix Version/s: None
    • Component/s: Frontend (F), Server (S)
    • Labels:
      None
    • Environment:
      Centos 7

      Description

      Steps to reproduce:

      1. Add auto registration rule. 
      2. Configure agent point Active Server to Zabbix IP
      3. Start agent but new hosts is not added to server

      Result:
      See screenshot...

      See log file...

      {code}


      7480:20180924:180651.191 In lld_graphs_save()
      7480:20180924:180651.191 End of lld_graphs_save()
      7480:20180924:180651.191 In lld_graphs_get()
      7480:20180924:180651.191 query [txnlev:0] [select g.graphid,g.name,g.width,g.height,g.yaxismin,g.yaxisma
      x,g.show_work_period,g.show_triggers,g.graphtype,g.show_legend,g.show_3d,g.percent_left,g.percent_right,g.
      ymin_type,g.ymin_itemid,g.ymax_type,g.ymax_itemid from graphs g,graph_discovery gd where g.graphid=gd.grap
      hid and gd.parent_graphid=2153]
      7287:20180924:180651.191 Sending [net.if.out[em3]]
      7663:20180924:180651.191 [Z3005] query failed: [1064] You have an error in your SQL syntax; check the ma
      nual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 [select t
      .triggerid,t.templateid from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.i
      temid and i.hostid=10514 and]
      7480:20180924:180651.191 End of lld_graphs_get()
      7480:20180924:180651.191 In lld_gitems_get()
      7480:20180924:180651.191 query [txnlev:0] [select gitemid,graphid,itemid,drawtype,sortorder,color,yaxiss
      ide,calc_fnc,type from graphs_items where graphid=2153]
      7550:20180924:180651.192 End of evaluate() value:0.007255
      7550:20180924:180651.192 get_value_calculated() value:0.007255

      {code}

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                chuyengiason Minh Son
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: