Bug #74509 MySQL Fabric is accepting just one request per time

• Submitted: 22 Oct 2014 13:54
• Modified: 13 Dec 2014 0:11
• Reporter: Alfranio Tavares Correia Junior
• Status: Closed
• Category: MySQL Fabric
• Severity: S3 (Non-critical)
• Version: 1.5.1
• OS: Any
• CPU Architecture: Any

[22 Oct 2014 13:54] Alfranio Tavares Correia Junior

Description:
The number of session threads is not properly configured thus making MySQL accept one request per time. This is a regression caused by the following
patch:

revno: 270
committer: Geert Vanderkelen <[e-mail]>
branch nick: WL7600
timestamp: Fri 2014-07-18 19:26:24 +0200
message:
  WL#7600: New interface using the MySQL Protocol

Note thought that MySQL Fabric currently serializes write requests but it should accept multiple read requests (i.e. dump requests from connectors) concurrently. We are working on improving how write requests are handled.

How to repeat:
Check the code or run MySQL Fabric and try to execute more than one request concurrently.

Suggested fix:
Either add the following line to the "protocol.mysql" section in the configuration file:

threads = 5

Or apply the following patch:

--- lib/mysql/fabric/services/manage.py	revid:[e-mail]-20141021080749-eph2gc4wq91t4k4e
+++ lib/mysql/fabric/services/manage.py	2014-10-22 08:42:33 +0000
@@ -317,13 +317,6 @@
     # MySQL-RPC service
     try:
         services['protocol.mysql'] = config.get('protocol.mysql', "address")
-
-        try:
-            number_threads = config.get('protocol.mysql', "threads")
-            number_threads = int(number_threads)
-        except (_config.NoOptionError, ValueError):
-            number_threads = DEFAULT_N_THREADS
-
     except _config.NoSectionError:
         # No MySQL-RPC configured
         pass

[13 Dec 2014 0:11] Philip Olson

Posted by developer:
 
Fixed as of the upcoming MySQL Fabric 1.6.1 release, and here's the changelog entry:

The number of session threads was not properly configured, thus making
MySQL only accept one request at a time.

Thank you for the bug report.