wsrep aborter thread does not show in processlist
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
Fix Released
|
Low
|
Seppo Jaakola |
Bug Description
current 0.7 branch head version gives strange process list:
[galera@haageman ~]$ processlist $cats
Processlist for node: abyssinian
+------
| Id | User | Host | db | Command | Time | State | Info |
+------
| 1 | system user | | NULL | Sleep | | NULL | NULL |
| 2 | system user | | NULL | Sleep | 405 | wsrep aborter idle | NULL |
| 1120 | root | 10.0.0.101:60102 | NULL | Query | 0 | NULL | show processlist |
+------
Processlist for node: bengal
+------
| Id | User | Host | db | Command | Time | State | Info |
+------
| 1 | system user | | test | Sleep | | NULL | NULL |
| 2 | system user | | NULL | Sleep | 401 | wsrep aborter idle | NULL |
| 1186 | root | 10.0.0.101:60304 | NULL | Query | 0 | NULL | show processlist |
+------
Processlist for node: carthusian
+-----+
| Id | User | Host | db | Command | Time | State | Info |
+-----+
| 573 | root | 10.0.0.101:33689 | NULL | Query | 0 | NULL | show processlist |
+-----+
wsrep aborter thread is missing in the process list in node carthusian. Checking by gdb, shows that aborter thread is alive and working well.
Also whole cluster is healthy and works good under sqlgen test load-
This situation is right after starting the cluster
Changed in codership-mysql: | |
importance: | Undecided → Low |
assignee: | nobody → Seppo Jaakola (seppo-jaakola) |
milestone: | none → 0.7.1 |
Changed in codership-mysql: | |
status: | New → In Progress |
Changed in codership-mysql: | |
status: | Fix Committed → Fix Released |
This seems to happen only when gratstate file is missing