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

Slave delays when there is "nothing" to replicate

    XMLWordPrintable

Details

    • Related to performance
    • 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:

                Git Integration

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