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

First Event After Starting a Delayed Parallel Replica Shows 0 Seconds_Behind_Master

Details

    Description

      A parallel replica delays all events that the SQL Thread reads in. With the changes from MDEV-29639, a replica will update Seconds_Behind_Master on the first user-generated event after idling. This mismatch leads to a parallel replica displaying 0 for Seconds_Behind_Master for the entire duration of a configured MASTER_DELAY if it is delaying an internal event, even if there are user-generated events that the IO thread has seen and written to the relay log. One example would be when delaying the first event after issuing START SLAVE.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29639 Seconds_Behind_Master is incorrect for Delayed, Parallel Replicas

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17516 Replication lag issue using parallel replication

          • Major - Major loss of function.
          • Stalled

          Activity

            Ascending order - Click to sort in descending order
            bnestere Brandon Nesterenko created issue -
            bnestere Brandon Nesterenko made changes -
            Field Original Value New Value
            bnestere Brandon Nesterenko made changes -
            Elkin Andrei Elkin made changes -
            Labels Seconds_Behind_Master
            elenst Elena Stepanova made changes -
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.10 [ 27530 ]
            Fix Version/s 10.11 [ 27614 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.10 [ 27530 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.4 [ 22408 ]

            People

              bnestere Brandon Nesterenko
              bnestere Brandon Nesterenko
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.