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

Relay Log Sequence Reset on Start Slave during FK fix cause Replication Breakage in MariaDB 10.6.19

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Incomplete
    • 10.6.19
    • N/A
    • Replication
    • Red Hat Enterprise Linux release 8.10 & mariadb Ver 15.1 Distrib 10.6.19-MariaDB, for Linux (x86_64) using readline 5.1

    Description

      While resolving a replication error related to a foreign key constraint, we observed that issuing a START SLAVE after dropping the foreign key unexpectedly reset the relay log sequence from relay-log.00004404 to relay-log.00000001. As a result, some transactions were not applied on the replica, and replication broke again after appearing temporarily healthy.

      This behavior is unexpected because STOP SLAVE; START SLAVE; should not reset the relay log sequence under normal circumstances, unless a RESET SLAVE or CHANGE MASTER was explicitly issued — which we did not execute in this case.

      This appears to be a destructive relay log reset triggered by START SLAVE, which should not occur and may indicate a bug in MariaDB 10.6.19.

      Attachments

        1. Mariadb_Replica_Config.txt
          4 kB
          Premkumar Manoharan
        2. Mariadb_relay_reset_Scenario_1.txt
          18 kB
          Premkumar Manoharan
        3. Mariadb_relay_reset_Scenario_2.txt
          21 kB
          Premkumar Manoharan
        4. Mariadb_relay_reset_Scenario_3.txt
          25 kB
          Premkumar Manoharan
        5. Mariadb_relay_reset_Scenario_4.txt
          18 kB
          Premkumar Manoharan

        Activity

          People

            Unassigned Unassigned
            pkumar98 Premkumar Manoharan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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