Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
None
-
None
-
MXS-SPRINT-213, MXS-SPRINT-214
Description
Unfortunately we don't have server logs for this event, but the following output should explain pretty much the situation.
This is a master with one replica.
But it has slave threads running with no show slave status output.
MariaDB [(none)]> show processlist;
|
+-----------+----------------------------------+---------------------+------------------+--------------+----------+---------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+-----------+----------------------------------+---------------------+------------------+--------------+----------+---------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| 7 | system user | | NULL | Slave_worker | 13517436 | Waiting for work from SQL thread | NULL | 0.000 |
|
| 8 | system user | | NULL | Slave_worker | 13517436 | Waiting for work from SQL thread | NULL | 0.000 |
|
| 9 | system user | | NULL | Slave_worker | 13517436 | Waiting for work from SQL thread | NULL | 0.000 |
|
| 10 | system user | | NULL | Slave_worker | 13517436 | Waiting for work from SQL thread | NULL | 0.000 |
|
| 11 | system user | | NULL | Slave_worker | 13517436 | Waiting for work from SQL thread | NULL | 0.000 |
|
| 12 | system user | | NULL | Slave_worker | 13517436 | Waiting for work from SQL thread | NULL | 0.000 |
|
| 13 | system user | | NULL | Slave_worker | 13517436 | Waiting for work from SQL thread | NULL | 0.000 |
|
| 14 | system user | | NULL | Slave_worker | 13517436 | Waiting for work from SQL thread | NULL | 0.000 |
|
| 6 | system user | | NULL | Slave_SQL | 13517414 | Slave has read all relay log; waiting for more updates | NULL | 0.000 |
|
| 191408807 | airflow | 45.157.40.55:44117 | airflow2 | Sleep | 49 | | NULL | 0.000 |
|
| 340427695 | vault | 45.157.40.35:40264 | NULL | Sleep | 155 | | NULL | 0.000 |
|
| 424838884 | skysql_maxscale_db00005510 | 10.42.0.99:42982 | NULL | Sleep | 0 | | NULL | 0.000 |
|
| 424841739 | skysql_replication_db00005510 | 10.42.0.74:45162 | NULL | Binlog Dump | 582238 | Master has sent all binlog to slave; waiting for more updates | NULL
|
but
MariaDB [(none)]> show slave status\G
|
Empty set (0.000 sec)
|
 |
MariaDB [(none)]> show all slaves status\G
|
Empty set (0.000 sec)
|