← Back to team overview

maria-developers team mailing list archive

Re: Race Condition in Seconds behind master.

 

Sachin Setiya <sachin.setiya@xxxxxxxxxxx> writes:

> Then I executed Show slave status (couple of times in a second), and
> found Seconds_behind_master is changing arbitrarily

I have always found the semantics of Seconds_behind_master complex to
understand.

I wrote an analysis some time ago:

  https://lists.launchpad.net/maria-developers/msg08958.html
  https://lists.launchpad.net/maria-developers/msg08961.html

Maybe with that background, you can go back to the binlog and compare time
stamps and see if the behaviour you see makes sense.

Maybe there are other places in the code where wrong timestamp is binlogged?

I do not remember if the change discussed in that email thread was ever
implemented (for non-parallel replication).

 - Kristian.


Follow ups

References