Why Is OpenStack Using All My Connections

asked 2015-06-12 08:44:35 -0600

bradnold gravatar image

I just did a fresh install of OpenStack Kilo and it ended up using all of my connections after the brief use of a single user.

Why are my OpenStack services not freeing up connections when its finished with them?

This is causing my setup to constantly timeout because there are no available connections for me to perform operations via horizon

MariaDB [(none)]> select @@global.max_connections;
+--------------------------+
| @@global.max_connections |
+--------------------------+
|                      151 |
+--------------------------+
1 row in set (0.00 sec)

MariaDB [(none)]> show status like '%onn%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| Aborted_connects         | 429   |
| Connections              | 17459 |
| Max_used_connections     | 152   |
| Ssl_client_connects      | 0     |
| Ssl_connect_renegotiates | 0     |
| Ssl_finished_connects    | 0     |
| Threads_connected        | 151   |
+--------------------------+-------+
7 rows in set (0.00 sec)

I found the issue initially when glance images wouldn't display in horizon and got the following error messages: http://pastebin.com/m0qA4U6T

edit retag flag offensive close merge delete

Comments

We temporarily worked around this problem by changing the default timeout values for connections in mariadb We put these values in /etc/mysql/my.cnf on the controller interactive_timeout=30 wait_timeout=30

It seems to workaround the issue. But is not necessarily the right solution here.

bradnold gravatar imagebradnold ( 2015-06-23 09:19:37 -0600 )edit