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

Partial GTID Replication Restoration

    XMLWordPrintable

Details

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

    Description

      Hi Team,
      We have setup the GTID based Replication between 4 DB Servers and then after some time we observed that my replication breaked connections breaked are as follow:

      1. DB 1 --> DB 3
      2. DB 2 --> DB 3
      3. DB 1 --> DB 4
      4. DB 2 --> DB 4
        and vice versa.

      We can see the SQL error as mentioned below:

      1. Last_SQL_Errno: 1032
        Last_SQL_Error: Could not execute Update_rows_v1 event on table aaadb.activesessions; Can't find record in 'activesessions', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log db2-binary.005151, end_log_pos 4978
      1. Last_SQL_Errno: 1032
        Last_SQL_Error: Could not execute Update_rows_v1 event on table aaadb.activesessions; Can't find record in 'activesessions', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log db1-binary.004968, end_log_pos 141985000

      Please provide the resolution or steps to restore these nodes only instead of setting up GTID Replication from scratch.

      Attachments

        Activity

          People

            Unassigned Unassigned
            ashwani.singh ASHWANI SINGH
            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.