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

Slave delays when there is "nothing" to replicate

    XMLWordPrintable

Details

    • Not for ES Release Notes
    • Fix Delayed Replication delays on metadata received at start, even if already up-to-date.

    Description

      To Reproduce

      -- Start with the slave synchronized with the master
      STOP SLAVE;
        CHANGE MASTER TO master_delay=60;
      START SLAVE;
      SHOW SLAVE STATUS;
      --> Slave_SQL_Running_State = 'Waiting until MASTER_DELAY seconds after master executed event'
      

      Possible Cause

      Inside sql_delay_event() is a guard that prevents delay for certain event types, but not the GTID List type.
      It should probably include all types listed false in Log_event::is_group_event().

      Attachments

        Issue Links

          Activity

            People

              ParadoxV5 Jimmy Hú
              ParadoxV5 Jimmy Hú
              Jimmy Hú Jimmy Hú
              Andrei Elkin Andrei Elkin
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 1d
                  1d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 1.5h Time Not Required
                  1.5h

                  Git Integration

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