[MDEV-9630] Seconds_Behind_Master is always 0 Created: 2016-02-25 Updated: 2016-07-28 Resolved: 2016-03-25 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Replication |
| Affects Version/s: | 10.1.11 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Igor Pashev | Assignee: | Unassigned |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | need_feedback | ||
| Environment: |
Linux. Replicating many RDS instances. |
||
| Description |
|
Configuration is the same as in SHOW SLAVE '<any channel>' STATUS\G always shows Seconds_Behind_Master: 0, while SQL and IO thread are running, and Exec_Master_Log_Pos and Relay_Log_Space are changing. I tried stopping SQL thread for a day |
| Comments |
| Comment by Elena Stepanova [ 2016-02-25 ] |
|
Please read the mail thread here: https://lists.launchpad.net/maria-developers/msg08958.html (especially the first message) to make sure you understand the current semantics of Seconds_Behind_Master. If that's what you observe, then the corresponding JIRA issue is MDEV-7837, it's still open. If what you observe is different from the described behavior, please specify how and provide examples. Thanks. |
| Comment by Elena Stepanova [ 2016-03-25 ] |
|
Please comment to re-open if you have further information on the issue. |
| Comment by Ivan Chuang [ 2016-07-28 ] |
|
at different db version, must to set slave_parallel_mode = none my environment |
and stopping both IO and SQL threads for a hour, but when I start the threads again, Seconds_Behind_Master is still 0 all the time. Masters are quite busy servers, and we can observe lags in other slaves running MariaDB 10.0.17.