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

Error when deleting trigger from a template

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 2.0.1
    • Frontend (F)
    • None

      When trying to delete a trigger from a template, I get the following error:

      Error in query [DELETE FROM triggers WHERE (triggerid IN ('100100000015805','100100000016916','100100000020835','100100000025345','100100000025544','100100000026062','100100000027118','100100000027705','100100000029572','100100000029647','100100000029698','100100000030801','100100000030802','100100000030803','100100000030804','100100000030805','100100000030806','100100000030807','100100000030808','100100000030809','100100000030810','100100000030811','100100000030812','100100000030813','100100000030814','100100000030815','100100000030816','100100000030817','100100000030818','100100000030819','100100000030820','100100000030821','100100000030822','100100000030823','100100000030824','100100000030825','100100000030826','100100000030827','100100000030828','100100000030829','100100000030830','100100000030831','100100000030832','100100000030833','100100000030834','100100000030835','100100000030836','100100000030837','100100000030838','100100000030839','100100000032528','100100000032529','100100000032530','100100000032531','100100000032532','100100000032533','100100000032534','100100000032535','100100000032536','100100000032537','100100000032538','100100000032539','100100000032540','100100000032541','100100000032542','100100000032543','100100000032544','100100000032545','100100000032546','100100000032547','100100000032548','100100000032549','100100000032550','100100000032551','100100000032552','100100000032553','100100000032554','100100000032555','100100000032556','100100000032557','100100000032558','100100000032559','100100000032560','100100000032561','100100000032562','100100000033873','100100000033981','100100000034032','100100000034114','100100000034699','100100000034742','100100000034858','100100000034957','100100000035010','100100000035064','100100000035151','100100000035258','100100000035618','100100000035712','100100000035794','100100000035842','100100000036527','100100000036601','100100000036695','100100000036766','100100000036804','100100000036974','100100000037005','100100000037117','100100000037147','100100000037333','100100000037409','100100000037476','100100000037513','100100000037548','100100000037619','100100000037695','100100000037738','100100000037781','100100000037824','100100000037865','100100000037900','100100000037972','100100000038007','100100000038035','100100000038114','100100000038155','100100000038213','100100000038256','100100000038294','100100000038332','100100000038408','100100000038484','100100000038560','100100000038598','100100000038636','100100000038674','100100000038745','100100000038784','100100000038823','100100000038862','100100000038901','100100000038940','100100000038979','100100000039018','100100000039075','100100000039136','100100000039220','100100000039270','100100000039308','100100000039448','100100000039486','100100000039516','100100000039555','100100000039592','100100000039630','100100000039668','100100000039743','100100000039869','100100000039906','100100000039970','100100000040013','100100000040114','100100000040202','100100000040965','100100000042094','100100000042398','100100000042457','100100000042499','100100000042536','100100000042590','100100000042621','100100000043545','100100000043649','100100000044108','100100000044230','100100000044281','100100000044322','100100000044364','100100000045765','100100000045898','100100000047701','100100000048177','100100000048219','100100000048272','100100000048321','100100000048371','100100000048421','100100000048462','100100000049857','100100000049902','100100000049947','100100000050195','100100000050321','100100000051620','100100000051667','100100000051714','100100000051815','100100000052055','100100000052129','100100000052203','100100000052267','100100000052331','100100000052389','100100000052817','100100000052881','100100000052986','100100000053044','100100000053137','100100000053209','100100000053288','100100000053343','100100000053398','100100000053462','100100000054013','100100000054399','100100000054548','100100000054595','100100000054658','100100000054838','100100000055668','100100000055737','100100000055806','100100000055875','100100000055944','100100000055995','100100000056060','100100000056250')) ] [Got error -1 from storage engine]
      SQL statement execution has failed "DELETE FROM triggers WHERE (triggerid IN ('100100000015805','100100000016916','100100000020835','100100000025345','100100000025544','100100000026062','100100000027118','100100000027705','100100000029572','100100000029647','100100000029698','100100000030801','100100000030802','100100000030803','100100000030804','100100000030805','100100000030806','100100000030807','100100000030808','100100000030809','100100000030810','100100000030811','100100000030812','100100000030813','100100000030814','100100000030815','100100000030816','100100000030817','100100000030818','100100000030819','100100000030820','100100000030821','100100000030822','100100000030823','100100000030824','100100000030825','100100000030826','100100000030827','100100000030828','100100000030829','100100000030830','100100000030831','100100000030832','100100000030833','100100000030834','100100000030835','100100000030836','100100000030837','100100000030838','100100000030839','100100000032528','100100000032529','100100000032530','100100000032531','100100000032532','100100000032533','100100000032534','100100000032535','100100000032536','100100000032537','100100000032538','100100000032539','100100000032540','100100000032541','100100000032542','100100000032543','100100000032544','100100000032545','100100000032546','100100000032547','100100000032548','100100000032549','100100000032550','100100000032551','100100000032552','100100000032553','100100000032554','100100000032555','100100000032556','100100000032557','100100000032558','100100000032559','100100000032560','100100000032561','100100000032562','100100000033873','100100000033981','100100000034032','100100000034114','100100000034699','100100000034742','100100000034858','100100000034957','100100000035010','100100000035064','100100000035151','100100000035258','100100000035618','100100000035712','100100000035794','100100000035842','100100000036527','100100000036601','100100000036695','100100000036766','100100000036804','100100000036974','100100000037005','100100000037117','100100000037147','100100000037333','100100000037409','100100000037476','100100000037513','100100000037548','100100000037619','100100000037695','100100000037738','100100000037781','100100000037824','100100000037865','100100000037900','100100000037972','100100000038007','100100000038035','100100000038114','100100000038155','100100000038213','100100000038256','100100000038294','100100000038332','100100000038408','100100000038484','100100000038560','100100000038598','100100000038636','100100000038674','100100000038745','100100000038784','100100000038823','100100000038862','100100000038901','100100000038940','100100000038979','100100000039018','100100000039075','100100000039136','100100000039220','100100000039270','100100000039308','100100000039448','100100000039486','100100000039516','100100000039555','100100000039592','100100000039630','100100000039668','100100000039743','100100000039869','100100000039906','100100000039970','100100000040013','100100000040114','100100000040202','100100000040965','100100000042094','100100000042398','100100000042457','100100000042499','100100000042536','100100000042590','100100000042621','100100000043545','100100000043649','100100000044108','100100000044230','100100000044281','100100000044322','100100000044364','100100000045765','100100000045898','100100000047701','100100000048177','100100000048219','100100000048272','100100000048321','100100000048371','100100000048421','100100000048462','100100000049857','100100000049902','100100000049947','100100000050195','100100000050321','100100000051620','100100000051667','100100000051714','100100000051815','100100000052055','100100000052129','100100000052203','100100000052267','100100000052331','100100000052389','100100000052817','100100000052881','100100000052986','100100000053044','100100000053137','100100000053209','100100000053288','100100000053343','100100000053398','100100000053462','100100000054013','100100000054399','100100000054548','100100000054595','100100000054658','100100000054838','100100000055668','100100000055737','100100000055806','100100000055875','100100000055944','100100000055995','100100000056060','100100000056250')) "

      Any idea?

            Unassigned Unassigned
            mcerutti Matteo Cerutti
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: