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

Replication Slave + SQL_Delay

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.3.9
    • 10.2.24
    • Replication
    • None
    • debian 9

    Description

      Hello, I have some trouble when I set up SQL_Delay, if you set it from 0 no problem, until you change DELAY, and / or you change stop / start replication.

      In some time it's look like the slave ask again the binlog to the master !

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13895 GTID and Master_Delay causes excessive initial delay

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            Aurelien_LEQUOY Aurélien LEQUOY added a comment -

            and without reason he decide to recover delta around 21h45, (between 9h00 and 21h45 the replication don't moved), maybe server reask binlog again from master?

            Aurelien_LEQUOY Aurélien LEQUOY added a comment - and without reason he decide to recover delta around 21h45, (between 9h00 and 21h45 the replication don't moved), maybe server reask binlog again from master?
            Elkin Andrei Elkin added a comment -

            Thank you for the report Aurelien. I think this is a highly probable duplicate of MDEV-13895 which we take on first. If you could help a bit its fixing trying out a how-to-repeat test on that page.

            Elkin Andrei Elkin added a comment - Thank you for the report Aurelien. I think this is a highly probable duplicate of MDEV-13895 which we take on first. If you could help a bit its fixing trying out a how-to-repeat test on that page.
            bnestere Brandon Nesterenko added a comment -

            Closing as duplicate of MDEV-13895, which is fixed starting in 10.4.4. This is evident based on the value of Seconds_Behind_Master growing to 2*SQL_Delay, which is a symptom of MDEV-13895.

            bnestere Brandon Nesterenko added a comment - Closing as duplicate of MDEV-13895 , which is fixed starting in 10.4.4. This is evident based on the value of Seconds_Behind_Master growing to 2*SQL_Delay, which is a symptom of MDEV-13895 .

            People

              Elkin Andrei Elkin
              Aurelien_LEQUOY Aurélien LEQUOY
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.