wsrep aborter thread does not show in processlist

Bug #498798 reported by Seppo Jaakola
6
This bug affects 1 person
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
Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

This seems to happen only when gratstate file is missing

summary: - wsrep aborted thread does not show in processlist
+ wsrep aborter thread does not show in processlist
Changed in codership-mysql:
status: New → In Progress
Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

Reason for this appeared to be a bug in mysqld.cc:wsrep_close_client_connections()
Scanning through 'threads' list also emptied the list, which caused wsrep system threads to
disappear from the threads list.

This caused issues also for shutdown phase, where threads list is used to close all connections gracefully.

Changed in codership-mysql:
status: In Progress → Fix Committed
Changed in codership-mysql:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.