MySQL patches by Codership

wsrep aborter thread does not show in processlist

Reported by Seppo Jaakola on 2009-12-20
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
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
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
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  Edit
Everyone can see this information.

Other bug subscribers