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

Inserting graphs_items when no graphid or itemid exists

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Major Major
    • None
    • 3.0.8
    • Server (S)
    • None

      My zabbix server keeps throwing insert errors on graphs_items because of foreign key constraints. I finally managed to track down the error to the insert statement below. When I tried to do further diagnosis; I find that the graphid and itemid don't exist at all in my server. How is the server trying to insert data for a graphid that doesn't even exist?

      insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (183241,84078,512467,0,0,'2774A4',0,2,0),(183242,84078,512466,0,1,'A54F10',0,2,0)

      mysql> select * from items where itemid=512467;
      Empty set (0.00 sec)

      mysql> select * from items where itemid=512466;
      Empty set (0.00 sec)

      mysql> select * from graphs where graphid=84078;
      Empty set (0.00 sec)

            Unassigned Unassigned
            kshutt Kelly Shutt
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: