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

seconds_behind_master flips to 0 & spikes back, when running show slaves status

    Details

      Description

      we setup maria 10.0.4 for multisource replication.

      it was replicating from a percona 5.5 master. When we started replication, maria was a day behind its master.

      its working fine but we noticed this phenomenon:

      when we execute 'show all slaves status' consecutively the 'seconds_behind_master' flips from 0 to XXX and XXX to 0. XXX keeps decreasing though, which is good as its getting closer to the state of its master.

      But wanted to know why the 'seconds_behind_master' comes down to 0 then again sets to a positive number.

      Note: XXX is some positive number.

      Elena Stepanova asked to file a bug for the same.

      bugs related to this issue
      --------------------------------
      http://bugs.mysql.com/bug.php?id=52166
      http://bugs.mysql.com/bug.php?id=53167

      these were fixed in 5.6. We need to either merge the bugfixes or fix them on our own

        Attachments

          Activity

            People

            • Assignee:
              serg Sergei Golubchik
              Reporter:
              jaihind213 vishnu rao
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: