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

Mysql Slave replication Issues - Zabbix 5.0

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Trivial
    • Resolution: Commercial support required
    • None
    • None
    • None
    • None

    Description

      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
      
      

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: