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

Not remove linked data with triggers

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Cannot Reproduce
    • Affects Version/s: 1.9.0 (alpha)
    • Fix Version/s: 1.9.7 (beta), 2.0.0
    • Component/s: Frontend (F)
    • Labels:

      Description

      ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-02292: integrity constraint (ZABBIX_TEST.ALERTS_FK3) violated - child record found[/var/www/zabbix/include/db.inc.php:507]
      SQL error [ORA-02292: integrity constraint (ZABBIX_TEST.ALERTS_FK3) violated - child record found] in [DELETE FROM events WHERE (objectid IN (20785)) AND object=0]
      ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-02292: integrity constraint (ZABBIX_TEST.ESCALATIONS_FK2) violated - child record found[/var/www/zabbix/include/db.inc.php:507]
      SQL error [ORA-02292: integrity constraint (ZABBIX_TEST.ESCALATIONS_FK2) violated - child record found] in [DELETE FROM triggers WHERE (triggerid IN (20785)) ]

      where

      CONSTRAINT alerts_fk3 FOREIGN KEY (eventid) REFERENCES zabbix_test.events (eventid);
      CONSTRAINT escalations_fk2 FOREIGN KEY (triggerid) REFERENCES zabbix_test.triggers (triggerid)

      need

      + DELETE FROM alerts WHERE eventid IN (SELECT eventid FROM events WHERE (objectid IN (20785)) AND object=0);
      + DELETE FROM escalations WHERE eventid IN (SELECT eventid FROM events WHERE (objectid IN (20785)) AND object=0);
      DELETE FROM events WHERE (objectid IN (20785)) AND object=0;
      DELETE FROM triggers WHERE (triggerid IN (20785));

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: