MariaDB seconds behind issue fixed
We (my friend Vishnu and I) had reported a bug with MariaDB 10.0.4. Just got an update that the issue is fixed now! Here are the details about the bug:
We had setup maria 10.0.4 for multi-source replication. It was replicating from a Percona 5.5 master. When we started replication, Maria was a day behind its master. It was 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.
Note: XXX is some positive number.
Reference: https://mariadb.atlassian.net/browse/MDEV-5114
The fix is deployed in MariaDB 10.0.10.