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

    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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38826 Parallel slave delays skipped events

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            People

              ParadoxV5 Jimmy Hú
              ParadoxV5 Jimmy Hú
              Jimmy Hú Jimmy Hú
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.