最近又部署了一个osp环境:Pike版本。变化很大。
安装了最小化组件运行(keystone/glance/neutron/nova/horizon)。
运行几分钟还行,建立instance后dashboard频繁发出Error:提示API Error。
后台查看日志:
2018-01-16 14:39:38.274 4873 ERROR nova.servicegroup.drivers.db File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1152, in _request_authentication
2018-01-16 14:39:38.274 4873 ERROR nova.servicegroup.drivers.db auth_packet = self._read_packet()
2018-01-16 14:39:38.274 4873 ERROR nova.servicegroup.drivers.db File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet
2018-01-16 14:39:38.274 4873 ERROR nova.servicegroup.drivers.db packet.check_error()
2018-01-16 14:39:38.274 4873 ERROR nova.servicegroup.drivers.db File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error
2018-01-16 14:39:38.274 4873 ERROR nova.servicegroup.drivers.db err.raise_mysql_exception(self._data)
2018-01-16 14:39:38.274 4873 ERROR nova.servicegroup.drivers.db File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
2018-01-16 14:39:38.274 4873 ERROR nova.servicegroup.drivers.db raise errorclass(errno, errval)
2018-01-16 14:39:38.274 4873 ERROR nova.servicegroup.drivers.db OperationalError: (pymysql.err.OperationalError) (1040, u'Too many connections')
感觉跟数据库有关。
可是已经安装Install Guide修改了mariadb的max_connection参数:
查询数据库内设置,果然发现问题:max-connection并不是我们设置的8192,而是214:
百度解决方案:
http://blog.csdn.net/hnhuangyiyang/article/details/51132141
根据上文修改mariadb的service文件:/usr/lib/systemd/system/mariadb.service
[Service]后添加:
LimitNOFILE=10000
LimitNPROC=10000
systemctl deamon-reload
systemctl restart mariadb
再去查询:已经修改成8192了:
P.S. 我这里已经修改了系统ulimits里面的nofile为88888(默认1024)。