Threads_running becomes very large

Bug #1040108 reported by johan
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Fix Released
High
Teemu Ollakka

Bug Description

Sometimes, after node recovery is most common the Threads_running becomes set to 2^64-1.

I will try and create a reproducable test case.

-J

Related branches

Revision history for this message
johan (johan-severalnines) wrote :

btw 2^64-1 should be 2^32

I use Haproxy to loadbalance across 4 servers and sysbench to drive load:

sysbench --test=oltp --mysql-table-engine=innodb --oltp-table-size=1000000 --mysql-user=johan --mysql-password=123johan --mysql-host=127.0.0.1 --mysql-port=33306 --num-threads=64 --max-time=36000 --max-requests=0 run

on one node do:
service mysql restart
show global status like 'threads_running';

mysql> show global status like 'threads_running';
+-----------------+------------+
| Variable_name | Value |
+-----------------+------------+
| Threads_running | 4294967260 |
+-----------------+------------+
1 row in set (0.00 sec)

This value is the same across all servers.'

Revision history for this message
brad svee (brad-svee) wrote :

We are seeing this as well with Percona Xtradb-Cluster 5.5.24-23.6.340.rhel6 (2 nodes + 1 galera arbitrator) with an F5 bigIP load balancer. Jay Jansen noticed this was unusually high number and recommended we file a bug. Not sure it affects much but it definitely affects the ability to run pt-online-schema-change without setting absurdly high override values for --critical-load and --max-load. Notably we have not had a "node recovery" on our primary server as mentioned in the description above

mysql> show global status like 'threads_running';
+-----------------+------------+
| Variable_name | Value |
+-----------------+------------+
| Threads_running | 4294958896 |
+-----------------+------------+
1 row in set (0.00 sec)

Revision history for this message
Teemu Ollakka (teemu-ollakka) wrote :
Changed in codership-mysql:
status: New → Fix Committed
milestone: none → 5.5.28-23.7
assignee: nobody → Teemu Ollakka (teemu-ollakka)
importance: Undecided → High
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.