XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 3.2.5rc1
    • Server (S)
    • CentOS 6.8; MySQL 5.7
    • Sprint 6, Sprint 7

      After upgrade to 3.2.5rc this error appears many times in log

      731:20170418:001726.283 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`functions`, CONSTRAINT `c_functions_1` FOREIGN KEY (`itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE) [insert into functions (functionid,itemid,triggerid,function,parameter) values (48904,127334,42075,'diff','0'),(48905,127335,42076,'diff','0'),(48906,127336,42077,'diff','0'),(48907,127337,42078,'diff','0'),(48908,127338,42079,'diff','0'),(48909,127339,42080,'diff','0'),(48910,127340,42081,'diff','0');
      ]
      731:20170418:001726.300 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`graphs_items`, CONSTRAINT `c_graphs_items_2` FOREIGN KEY (`itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE) [insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (45930,23662,127327,5,0,'00AA00',0,2,0),(45931,23662,127348,5,1,'3333FF',0,2,0),(45932,23663,127328,5,0,'00AA00',0,2,0),(45933,23663,127349,5,1,'3333FF',0,2,0),(45934,23664,127329,5,0,'00AA00',0,2,0),(45935,23664,127350,5,1,'3333FF',0,2,0),(45936,23665,127330,5,0,'00AA00',0,2,0),(45937,23665,127351,5,1,'3333FF',0,2,0),(45938,23666,127331,5,0,'00AA00',0,2,0),(45939,23666,127352,5,1,'3333FF',0,2,0),(45940,23667,127332,5,0,'00AA00',0,2,0),(45941,23667,127353,5,1,'3333FF',0,2,0),(45942,23668,127333,5,0,'00AA00',0,2,0),(45943,23668,127354,5,1,'3333FF',0,2,0);

            Unassigned Unassigned
            hakihdo Anderson Oliveira
            Team B
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: