slave doesn't report Seconds_Behind_Master when running slave_parallel_workers > 0
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Robert Golebiowski | |||
5.6 |
Fix Released
|
Medium
|
Robert Golebiowski | |||
5.7 |
Fix Released
|
Medium
|
Robert Golebiowski |
Bug Description
Reported here too http://
When running mysql with slave_parallel_
From SHOW PROCESSLIST, Id 3 is executing an event from 76 seconds ago
slave1 [localhost] {msandbox} ((none)) > SHOW PROCESSLIST;
+----+-
| Id | User | Host | db | Command | Time | State | Info |
+----+-
| 1 | system user | | NULL | Connect | 274 | Waiting for master to send event | NULL |
| 2 | system user | | NULL | Connect | 11 | Waiting for dependent transaction to commit | NULL |
| 4 | system user | | NULL | Connect | 76 | Executing event | NULL |
| 5 | system user | | NULL | Connect | 274 | Waiting for an event from Coordinator | NULL |
| 6 | system user | | NULL | Connect | 274 | Waiting for an event from Coordinator | NULL |
| 7 | system user | | NULL | Connect | 274 | Waiting for an event from Coordinator | NULL |
| 8 | system user | | NULL | Connect | 274 | Waiting for an event from Coordinator | NULL |
| 9 | system user | | NULL | Connect | 274 | Waiting for an event from Coordinator | NULL |
| 10 | system user | | NULL | Connect | 274 | Waiting for an event from Coordinator | NULL |
| 11 | system user | | NULL | Connect | 274 | Waiting for an event from Coordinator | NULL |
| 12 | system user | | NULL | Connect | 274 | Waiting for an event from Coordinator | NULL |
| 13 | system user | | NULL | Connect | 274 | Waiting for an event from Coordinator | NULL |
| 14 | system user | | NULL | Connect | 274 | Waiting for an event from Coordinator | NULL |
| 15 | system user | | NULL | Connect | 274 | Waiting for an event from Coordinator | NULL |
| 16 | system user | | NULL | Connect | 274 | Waiting for an event from Coordinator | NULL |
| 17 | system user | | NULL | Connect | 274 | Waiting for an event from Coordinator | NULL |
| 18 | system user | | NULL | Connect | 274 | Waiting for an event from Coordinator | NULL |
| 19 | system user | | NULL | Connect | 274 | Waiting for an event from Coordinator | NULL |
| 20 | msandbox | localhost | NULL | Query | 0 | starting | SHOW PROCESSLIST |
+----+-
19 rows in set (0.00 sec)
But SHOW SLAVE STATUS doesn't report any lag:
slave1 [localhost] {msandbox} ((none)) > SHOW SLAVE STATUS\G
*******
Replicate
Replicate_
Master_
Replicate_
Slave_
Last_
Last_
1 row in set (0.00 sec)
Same happens with slave_parallel_
How to repeat:
1) Start slave with slave_parallel_
2) Create a table with some rows on master:
sysbench --test=
3) Delete a big amount of rows in your master:
DELETE FROM sbtest1 WHERE id > 100;
4) Compare output of SHOW PROCESSLIST and SHOW SLAVE STATUS\G
Changed in percona-server: | |
status: | New → Confirmed |
tags: | added: i162291 |
tags: | added: upstream |
5.6 PR => https:/ /github. com/percona/ percona- server/ pull/1439 /github. com/percona/ percona- server/ pull/1440
5.7 PR => https:/