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

Incorrect inserts into DB

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Major Major
    • 1.9.0 (alpha)
    • 1.8.4
    • Server (S)
    • None

      6332:20100421:102341.718 [Z3005] Query failed: [-1] ORA-02291: integrity constraint (ZABBIX_TEST.FUNCTIONS_FK2) violated - parent key not found
      ORA-06512: at line 2
      [begin
      insert into functions (functionid,itemid,triggerid,function,parameter) values (346803,601880,225199,'last','0');
      insert into functions (functionid,itemid,triggerid,function,parameter) values (346804,601881,225199,'last','0');
      insert into triggers (triggerid,description,expression,priority,status,comments,url,type,value,templateid) values (225199,'Packet loss >20%','(

      {346804}

      >20)&(

      {346803}

      =1)',2,0,'','',0,2,13511);
      end;
      ]

      I think need first add trigger and them functions

            Unassigned Unassigned
            dotneft Alexey Pustovalov
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: