Mysql Slave replication Issues - Zabbix 5.0

XMLWordPrintable

    • Type: Problem report
    • Resolution: Commercial support required
    • Priority: Trivial
    • None
    • Affects Version/s: None
    • Component/s: None
    • None

      Hi Zabbix Team,

      Good Day!

      We are using MySQL as Zabbix DB server. Unfortunately we are observing some errors as attached in Mysql slave DB server. Please check and update us on how can we resolve the issue.

       Last_SQL_Errno: 1452
       Last_SQL_Error: Could not execute Write_rows event on table sap_new.event_recovery; Cannot add or update a child row: a foreign key constraint fails (`sap_new`.`event_recovery`, CONSTRAINT `c_event_recovery_1` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE), Error_code: 1452; handler error HA_ERR_NO_REFERENCED_ROW; the event's master log binlog.000038, end_log_pos 690214949
      
      

            Assignee:
            Unassigned
            Reporter:
            Deepika YSR
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: