Ad Widget

Collapse

Template with graphs

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • uweiss
    Junior Member
    • Jun 2006
    • 27

    #1

    Template with graphs

    I updated my zabbix 1.0 installation to final 1.1 this week and played around with linked templates. But one thing which not works are graphs defined in a template. I always get an SQL error.

    What i did:
    1. Configuration => Hosts
    2. clicked "Graphs" of my template
    3. "Create graph"
    4. adden graph name "CPU load"
    5. saved graph
    6. choosed Group: all / Host: all to see all graphs (The newly created graph has no "Hosts")
    7. clicked "Edit" of the created graph
    8. "Add item" => selected a "parameter" of the template => "save"
    9. Now i get this messages/errors:

    Graph 'CPU load' added
    Added Item 'Processor load (1min)' for graph ''
    Added Item 'Processor load (1min)' for graph 'CPU load'

    SQL error: Duplicate entry 'CPU load' for key 2
    Query: insert into graphs (name,width,height,yaxistype,yaxismin,yaxismax,tem plateid,show_work_period,show_triggers) values ('CPU load',900,200,0,0.0000, 100.0000,118,1,1)
    No graph with graphid=[316]

    "118" in the query is the graph itself

    But the item was created and adding a additional item don't gives an new error. Anyway, the graph don't works correctly. Maybe someone can reproduce this or has a fix for it?

    Thank you
    Urs
  • uweiss
    Junior Member
    • Jun 2006
    • 27

    #2
    Don't know why this thread was saved on the false place. Should be on "ZABBIX Troubleshooting and Problems" of course.

    Comment

    • raminix
      Member
      • Jun 2006
      • 37

      #3
      Try deleting the unique key on name and add a regular index on name. This worked for me.

      Comment

      • uweiss
        Junior Member
        • Jun 2006
        • 27

        #4
        Hi raminix,
        Yes, works for me too. Great, thank you.

        Comment

        Working...