[MDEV-6206] wsrep_slave_threads subtracts from max_connections Created: 2014-05-03  Updated: 2014-05-10  Resolved: 2014-05-10

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.37-galera
Fix Version/s: 5.5.38-galera, 10.0.11-galera

Type: Bug Priority: Major
Reporter: Daniel Black Assignee: Nirbhay Choubey (Inactive)
Resolution: Fixed Votes: 0
Labels: galera


 Description   

my.cnf:

max_connections=200
wsrep_slave_threads=400

# /etc/init.d/mysql restart ;  mysql -u openquery 
 * Stopping MariaDB database server mysqld                                                                                          [ OK ] 
 * Starting MariaDB database server mysqld                                                                                          [ OK ] 
 * Checking for corrupt, not cleanly closed and upgrade needing tables.
ERROR 1040 (HY000): Too many connections
# ERROR 1040 (HY000): Too many connections



 Comments   
Comment by Elena Stepanova [ 2014-05-03 ]

I'm not sure it's actually wrong, assigning to nirbhay_c to decide.

Comment by Daniel Black [ 2014-05-05 ]

My basis for the bug report is the max_connections definition:

https://mariadb.com/kb/en/server-system-variables/#max_connections
max_connections Description: The maximum number of simultaneous client connections

Though a wsrep_slave_threads shows up in the process list its not actually a client connection.

I see the wsrep_slave_threads also affects the status threads_connected.

Variable_name Value
Threads_connected 66

I appreciate that even async replication took two "connections" as a slave and 1 per slave as a master however it seems wsrep_slave_threads can make much more of an impact into the max_connections.

I'm in favour of preserving the definition of max_connections as client connections but alter the statusThreads_connected definition to include systems threads.

Comment by Nirbhay Choubey (Inactive) [ 2014-05-08 ]

Hi Daniel,
I too think "system" threads should not be included under "connection" threads. However,
I do not feel like changing the definition of Threads_connected, would rather introduce a
new status variable representing wsrep thread count. Thanks!

Comment by Daniel Black [ 2014-05-08 ]

> I too think "system" threads should not be included under "connection" threads.

Thank you. I hoped you see it that way too.

> However,I do not feel like changing the definition of Threads_connected, would rather introduce a
new status variable representing wsrep thread count.

works for me.

Comment by Nirbhay Choubey (Inactive) [ 2014-05-10 ]

Fix pushed to maria-5.5-galera.

Comment by Daniel Black [ 2014-05-10 ]

thank you.

http://bazaar.launchpad.net/~maria-captains/maria/maria-5.5-galera/revision/3492

Generated at Thu Feb 08 07:10:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.