SHOW SLAVE STATUS hangs
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
|||
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Unassigned | ||
5.1 |
Won't Fix
|
Undecided
|
Unassigned | ||
5.5 |
Invalid
|
Undecided
|
Unassigned | ||
5.6 |
Fix Released
|
High
|
Unassigned |
Bug Description
mysql> show processlist;
+------
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |
+------
| 42 | SUSR_Heartbeat | 127.0.0.1:45020 | NULL | Query | 123719 | init | show slave status | 0 | 0 |
| 46 | system user | | NULL | Connect | 131101 | Queueing master event to the relay log | NULL | 0 | 0 |
| 47 | system user | | NULL | Connect | 131675 | Waiting for commit lock | NULL | 0 | 0 |
| 332 | root | localhost | NULL | Query | 123742 | init | SHOW SLAVE STATUS | 0 | 0 |
| 334 | SUSR_Heartbeat | 127.0.0.1:46323 | NULL | Query | 123539 | init | show slave status | 0 | 0 |
| 335 | SUSR_Heartbeat | 127.0.0.1:46324 | NULL | Query | 123599 | init | show slave status | 0 | 0 |
| 336 | SUSR_Heartbeat | 127.0.0.1:46325 | NULL | Query | 123659 | init | show slave status | 0 | 0 |
| 340 | SUSR_Heartbeat | 127.0.0.1:46335 | NULL | Query | 123359 | init | show slave status | 0 | 0 |
| 341 | SUSR_Heartbeat | 127.0.0.1:46336 | NULL | Query | 123479 | init | show slave status | 0 | 0 |
| 342 | SUSR_Heartbeat | 127.0.0.1:46337 | NULL | Query | 123419 | init | show slave status | 0 | 0 |
| 346 | SUSR_Heartbeat | 127.0.0.1:46348 | NULL | Query | 123299 | init | show slave status | 0 | 0 |
| 347 | SUSR_Heartbeat | 127.0.0.1:46349 | NULL | Query | 123239 | init | show slave status | 0 | 0 |
| 348 | SUSR_Heartbeat | 127.0.0.1:46350 | NULL | Query | 123179 | init | show slave status | 0 | 0 |
| 352 | SUSR_Heartbeat | 127.0.0.1:46362 | NULL | Query | 122999 | init | show slave status | 0 | 0 |
| 353 | SUSR_Heartbeat | 127.0.0.1:46363 | NULL | Query | 123119 | init | show slave status | 0 | 0 |
| 354 | SUSR_Heartbeat | 127.0.0.1:46364 | NULL | Query | 123059 | init | show slave status | 0 | 0 |
| 358 | SUSR_Heartbeat | 127.0.0.1:46374 | NULL | Query | 122938 | init | show slave status | 0 | 0 |
| 359 | SUSR_Heartbeat | 127.0.0.1:46375 | NULL | Query | 122878 | init | show slave status | 0 | 0 |
| 518 | root | localhost | NULL | Query | 116575 | init | SHOW SLAVE STATUS | 0 | 0 |
| 675 | root | localhost | NULL | Query | 108307 | init | SHOW SLAVE STATUS | 0 | 0 |
| 832 | root | localhost | NULL | Query | 101946 | init | SHOW SLAVE STATUS | 0 | 0 |
| 989 | root | localhost | NULL | Query | 93683 | init | SHOW SLAVE STATUS | 0 | 0 |
| 1146 | root | localhost | NULL | Query | 86599 | init | SHOW SLAVE STATUS | 0 | 0 |
| 1303 | root | localhost | NULL | Query | 79176 | init | SHOW SLAVE STATUS | 0 | 0 |
| 1460 | root | localhost | NULL | Query | 72558 | init | SHOW SLAVE STATUS | 0 | 0 |
| 1617 | root | localhost | NULL | Query | 64801 | init | SHOW SLAVE STATUS | 0 | 0 |
| 1774 | root | localhost | NULL | Query | 58595 | init | SHOW SLAVE STATUS | 0 | 0 |
| 1931 | root | localhost | NULL | Query | 50480 | init | SHOW SLAVE STATUS | 0 | 0 |
| 2012 | root | localhost | mysql | Query | 48241 | init | SHOW SLAVE STATUS | 0 | 0 |
| 2091 | root | localhost | NULL | Query | 43341 | init | SHOW SLAVE STATUS | 0 | 0 |
| 2248 | root | localhost | NULL | Query | 37136 | init | SHOW SLAVE STATUS | 0 | 0 |
| 2405 | root | localhost | NULL | Query | 28899 | init | SHOW SLAVE STATUS | 0 | 0 |
| 2562 | root | localhost | NULL | Query | 22128 | init | SHOW SLAVE STATUS | 0 | 0 |
| 2758 | root | localhost | NULL | Query | 14131 | init | SHOW SLAVE STATUS | 0 | 0 |
| 2876 | root | localhost | NULL | Query | 7733 | init | SHOW SLAVE STATUS | 0 | 0 |
| 3033 | root | localhost | NULL | Query | 1139 | init | SHOW SLAVE STATUS | 0 | 0 |
| 3035 | root | localhost | NULL | Query | 0 | init | show processlist | 0 | 0 |
+------
37 rows in set (0.00 sec)
Changed in percona-server: | |
status: | Incomplete → New |
Changed in percona-server: | |
status: | Incomplete → New |
mysql Ver 14.14 Distrib 5.6.21-69.0, for Linux (x86_64) using EditLine wrapper
Server version: 5.6.21-69.0-log Percona Server (GPL), Release 69.0, Revision 675
Linux tonopah 2.6.32- 431.el6. x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
CentOS release 6.5 (Final)