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

Zabbix discovery prototype items sql statement errors

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Cannot Reproduce
    • Icon: Critical Critical
    • 2.0.9
    • 2.0.9
    • Server (S)

      When I remove item prototypes in a discovery template the discovered items on the hosts get deleted but in the server log I get the following sql statement errors:

      1447:20131024:090856.726 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`item_discovery`, CONSTRAINT `c_item_discovery_2` FOREIGN KEY (`parent_itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE) [insert into item_discovery (itemdiscoveryid,itemid,parent_itemid,key_) values (22073,50131,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22074,50132,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22075,50133,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22076,50134,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22077,50135,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22078,50136,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22079,50137,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22080,50138,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22081,50139,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22082,50140,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22083,50141,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22084,50142,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22085,50143,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22086,50144,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22087,50145,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22088,50146,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22089,50147,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22090,50148,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22091,50149,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22092,50150,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22093,50151,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22094,50152,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22095,50153,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22096,50154,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22097,50155,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22098,50156,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22099,50157,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22100,50158,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22101,50159,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22102,50160,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22103,50161,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22104,50162,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22105,50163,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22106,50164,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22107,50165,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22108,50166,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22109,50167,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22110,50168,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22111,50169,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22112,50170,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22113,50171,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22114,50172,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22115,50173,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22116,50174,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22117,50175,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22118,50176,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22119,50177,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22120,50178,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22121,50179,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22122,50180,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22123,50181,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22124,50182,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22125,50183,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22126,50184,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22127,50185,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22128,50186,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22129,50187,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22130,50188,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22131,50189,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22132,50190,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22133,50191,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22134,50192,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22135,50193,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22136,50194,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22137,50195,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22138,50196,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22139,50197,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22140,50198,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22141,50199,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22142,50200,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22143,50201,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22144,50202,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22145,50203,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22146,50204,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22147,50205,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22148,50206,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22149,50207,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22150,50208,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22151,50209,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22152,50210,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22153,50211,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22154,50212,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22155,50213,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22156,50214,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22157,50215,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22158,50216,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22159,50217,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22160,50218,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22161,50219,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22162,50220,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22163,50221,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22164,50222,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22165,50223,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22166,50224,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22167,50225,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22168,50226,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22169,50227,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22170,50228,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22171,50229,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22172,50230,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22173,50231,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22174,50232,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22175,50233,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22176,50234,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22177,50235,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22178,50236,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22179,50237,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22180,50238,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22181,50239,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22182,50240,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22183,50241,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22184,50242,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22185,50243,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22186,50244,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22187,50245,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22188,50246,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22189,50247,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22190,50248,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22191,50249,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22192,50250,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22193,50251,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22194,50252,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22195,50253,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22196,50254,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22197,50255,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22198,50256,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22199,50257,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22200,50258,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22201,50259,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22202,50260,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22203,50261,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22204,50262,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22205,50263,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22206,50264,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22207,50265,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22208,50266,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22209,50267,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22210,50268,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22211,50269,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22212,50270,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22213,50271,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22214,50272,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22215,50273,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22216,50274,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22217,50275,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22218,50276,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22219,50277,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22220,50278,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22221,50279,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22222,50280,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22223,50281,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22224,50282,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22225,50283,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22226,50284,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22227,50285,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22228,50286,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22229,50287,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22230,50288,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22231,50289,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22232,50290,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22233,50291,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22234,50292,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22235,50293,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22236,50294,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22237,50295,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22238,50296,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22239,50297,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22240,50298,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22241,50299,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22242,50300,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22243,50301,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22244,50302,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22245,50303,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22246,50304,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22247,50305,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22248,50306,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]'),(22249,50307,39277,'IF-MIB.ifOutNUcastPkts.["

      {#SNMPVALUE}"]'),(22250,50308,39277,'IF-MIB.ifOutNUcastPkts.["{#SNMPVALUE}

      "]');

            Unassigned Unassigned
            remo Remo Stäuble
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: