Seen with R3.2 SM build 2, and Contrail package R3.2 build 5 as well

nodec28 (cfgm0) in the above mentioned setup becomes, very slow to the execution of commands

contrail-api.log shows same trace as mentioned in the comment #3


Before start of test case

root@nodec28:~# ps -aux | grep mysql
mysql     1363  2.1  0.7 12656876 258324 ?     Sl   Nov30   4:13 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --wsrep_start_position=e133cfb1-b736-11e6-872d-3b4849414c8d:98762
root     26284  0.0  0.0  10464   936 pts/17   S+   02:26   0:00 grep --color=auto mysql
root     31396  0.0  0.0   4440   752 ?        S    Nov30   0:00 /bin/sh /usr/bin/mysqld_safe
root@nodec28:~# 
root@nodec28:~# 
root@nodec28:~# After the Start of the test cases

root@nodec28:~# ps -aux | grep mysql
mysql     1363  2.1  0.7 12656876 258324 ?     Sl   Nov30   4:14 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --wsrep_start_position=e133cfb1-b736-11e6-872d-3b4849414c8d:98762
root     29605  0.0  0.0  99716  2052 ?        S    02:27   0:00 /usr/bin/mysql --connect_timeout 2 -h localhost --port 3306 -u cmon -px xx -e show global status where variable_name='wsrep_local_state'
root     29612  0.0  0.0  99716  2048 ?        S    02:27   0:00 /usr/bin/mysql --connect_timeout 2 -h localhost --port 3306 -u cmon -px xx -e show global status where variable_name='wsrep_local_state'
root     29619  0.0  0.0  99716  2048 ?        S    02:27   0:00 /usr/bin/mysql --connect_timeout 2 -h localhost --port 3306 -u cmon -px xx -e show global status where variable_name='wsrep_local_state'
root     29664  0.0  0.0  99716  2052 ?        S    02:27   0:00 /usr/bin/mysql --connect_timeout 2 -h localhost --port 3306 -u cmon -px xx -e show global status where variable_name='wsrep_local_state'
root     29671  0.0  0.0  99716  2044 ?        S    02:27   0:00 /usr/bin/mysql --connect_timeout 2 -h localhost --port 3306 -u cmon -px xx -e show global status where variable_name='wsrep_local_state'
root     29678  0.0  0.0  99716  2048 ?        S    02:27   0:00 /usr/bin/mysql --connect_timeout 2 -h localhost --port 3306 -u cmon -px xx -e show global status where variable_name='wsrep_local_state'
root     29685  0.0  0.0  99716  2048 ?        S    02:27   0:00 /usr/bin/mysql --connect_timeout 2 -h localhost --port 3306 -u cmon -px xx -e show global status where variable_name='wsrep_local_state'
root     29693  0.0  0.0  99716  2044 ?        S    02:27   0:00 /usr/bin/mysql --connect_timeout 2 -h localhost --port 3306 -u cmon -px xx -e show global status where variable_name='wsrep_local_state'
root     29701  0.0  0.0  99716  2052 ?        S    02:27   0:00 /usr/bin/mysql --connect_timeout 2 -h localhost --port 3306 -u cmon -px xx -e show global status where variable_name='wsrep_local_state'
root     29707  0.0  0.0  99716  2048 ?        S    02:27   0:00 /usr/bin/mysql --connect_timeout 2 -h localhost --port 3306 -u cmon -px xx -e show global status where variable_name='wsrep_local_state'
root     29714  0.0  0.0  99716  2044 ?        S    02:27   0:00 /usr/bin/mysql --connect_timeout 2 -h localhost --port 3306 -u cmon -px xx -e show global status where variable_name='wsrep_local_state'
root     29721  0.0  0.0  99716  2052 ?        S    02:27   0:00 /usr/bin/mysql --connect_timeout 2 -h localhost --port 3306 -u cmon -px xx -e show global status where variable_name='wsrep_local_state'
root     29726  0.0  0.0  10464   940 pts/17   S+   02:27   0:00 grep --color=auto mysql
root     29746  0.0  0.0  99716  2048 ?        S    02:27   0:00 /usr/bin/mysql --connect_timeout 2 -h localhost --port 3306 -u cmon -px xx -e show global status where variable_name='wsrep_local_state'
root     29770  0.0  0.0  99716  2052 ?        S    02:27   0:00 /usr/bin/mysql --connect_timeout 2 -h localhost --port 3306 -u cmon -px xx -e show global status where variable_name='wsrep_local_state'
root     29791  0.0  0.0  99716  2048 ?        S    02:27   0:00 /usr/bin/mysql --connect_timeout 2 -h localhost --port 3306 -u cmon -px xx -e show global status where variable_name='wsrep_local_state'
root     29834  0.0  0.0  99716  2044 ?        S    02:27   0:00 /usr/bin/mysql --connect_timeout 2 -h localhost --port 3306 -u cmon -px xx -e show global status where variable_name='wsrep_local_state'
root     31396  0.0  0.0   4440   752 ?        S    Nov30   0:00 /bin/sh /usr/bin/mysqld_safe
root@nodec28:~# 


And falls back to 

root@nodec28:~# ps -aux | grep mysql
mysql     1363  2.1  0.7 12656876 258952 ?     Sl   Nov30   4:17 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --wsrep_start_position=e133cfb1-b736-11e6-872d-3b4849414c8d:98762
root     22115  0.0  0.0  10464   936 pts/17   S+   02:30   0:00 grep --color=auto mysql
root     31396  0.0  0.0   4440   752 ?        S    Nov30   0:00 /bin/sh /usr/bin/mysqld_safe