Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-36973

Replication breaks after snapshot/failover/restore cycle

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Replication
    • None

    Description

      The customer takes backups via GCP snapshot while the replica is shutdown.
      The async cluster is then failed over promoting the host where the snapshot was done to master.
      When the snapshot is then restored to the former master host, the replication is breaking after startup.

      Replication error
      Last_SQL_Error: Could not execute Update_rows_v1 event on table ecobee.SecurityTokenNoIntID202012; Can't find record in 'SecurityTokenNoIntID202012', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log binlog.000062, end_log_pos 26775880

      We have done several tests in attempt to fix this issue as seen in the referenced support ticket (#210916) with no luck so far.

      Attachments

        Activity

          People

            susil.behera Susil Behera
            bwillits Bill Willits
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.