在部署配置完openstack基础服务以及dashboard后。登录页面发现很多功能都不正常,无法获取实例,也无法获取镜像。
查看日志:
grep ‘ERROR’ /var/log/nova/*
/var/log/nova/nova-api.log:2019-07-30 17:28:54.468 3043 ERROR nova.api.openstack.wsgi [req-658adbbb-614e-49fe-a4cd-1c3e0a1eee13 4a01afbb5b3c45feb53fbbf186a615a3 71daca9bc26f44f2b1da8a490cde9348 - default default] Unexpected exception in API method: OperationalError: (pymysql.err.OperationalError) (1040, u’Too many connections’) (Background on this error at: http://sqlalche.me/e/e3q8)
/var/log/nova/nova-api.log:2019-07-30 17:28:54.468 3043 ERROR nova.api.openstack.wsgi Traceback (most recent call last):
/var/log/nova/nova-api.log:2019-07-30 17:28:54.468 3043 ERROR nova.api.openstack.wsgi File “/usr/lib/python2.7/site-packages/nova/api/openstack/wsgi.py”, line 801, in wrapped
/var/log/nova/nova-api.log:2019-07-30 17:28:54.468 3043 ERROR nova.api.openstack.wsgi return f(*args, **kwargs)
grep ‘ERROR’ /var/log/glance/*
/var/log/glance/api.log:2019-07-30 17:25:19.316 28323 ERROR glance.common.wsgi [req-4718dde2-d477-4341-bff9-1845a4c4e271 4a01afbb5b3c45feb53fbbf186a615a3 71daca9bc26f44f2b1da8a490cde9348 - default default] Caught error: (pymysql.err.OperationalError) (1040, u’Too many connections’) (Background on this error at: http://sqlalche.me/e/e3q8): OperationalError: (pymysql.err.OperationalError) (1040, u’Too many connections’) (Background on this error at: http://sqlalche.me/e/e3q8)
/var/log/glance/api.log:2019-07-30 17:25:19.316 28323 ERROR glance.common.wsgi Traceback (most recent call last):
/var/log/glance/api.log:2019-07-30 17:25:19.316 28323 ERROR glance.common.wsgi File “/usr/lib/python2.7/site-packages/glance/common/wsgi.py”, line 1274, in call
/var/log/glance/api.log:2019-07-30 17:25:19.316 28323 ERROR glance.common.wsgi request, **action_args)
可以看到这些错误其实都是一样的错误,是数据库的最大连接数有问题。
进入数据库中查看该设置
mysql -u root -p
MariaDB [(none)]> show global variables like ‘%max_conn%’;
±----------------------±------+
| Variable_name | Value |
±----------------------±------+
| extra_max_connections | 1 |
| max_connect_errors | 100 |
| max_connections | 214 |
±----------------------±------+
3 rows in set (0.00 sec)
在openstack.cnf中虽然设置了最大连接数为4096,但是这里显示仍然是214。
修改mariadb.service文件
vi /usr/lib/systemd/system/mariadb.service
在[Service]新添加两行参数:
LimitNOFILE=10000
LimitNPROC=10000
重新加载系统服务,并重启mariadb
systemctl --system daemon-reload
systemctl restart mariadb.service
进入数据库查看最大连接数:
MariaDB [(none)]> show global variables like ‘%max_conn%’;
±----------------------±------+
| Variable_name | Value |
±----------------------±------+
| extra_max_connections | 1 |
| max_connect_errors | 100 |
| max_connections | 4096 |
±----------------------±------+
3 rows in set (0.01 sec)
此时再登录dashboard页面,发现各项服务恢复正常
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)