Openstack 一直在调度中解决Too many connections

admin

查看日志/var/log/nova/nova-scheduler.log,/var/log/nova/nova-compute.log,均无报错
/ L% d) j' l) B3 B* q
查看/var/log/nova/nova-conductor.log报错为

2017-02-06 09:27:04.976 2206 ERROR oslo_messaging.rpc.server OperationalError: (pymysql.err.OperationalError) (1040, u'Too many connections')

2018-10-11 22:59:43.524 13733 ERROR neutron OperationalError: (pymysql.err.OperationalError) (1040, u'Too many connections') (Background on this error at: http://sqlalche.me/e/e3q8)
. \8 P( ^8 ~: W1 B3 L. [2018-10-11 22:59:43.524 13733 ERROR neutron

修改mariadb配置文件

* v7 y* N9 ?# B# j' r2 I2 C]# vim /etc/my.cnf.d/openstack.cnf
2 G; ?: p) x* t; {* l4 x[mysqld]
$ c' R: N  p6 \/ ^* p' _8 U! `max_connections = 4096
修改系统打开数
% ^; W, s  F! z
]# vim /etc/security/limits.conf
*  soft nofile 65536
% M( m. K& O6 R2 H+ g1 O7 E*  hard nofile 65536
]# ulimit -SHn 65536
/ E+ {4 P- Z8 Z+ A# Q
1 s- o  Q+ y) h& h8 Y* @7 O  g
]# vim /etc/sysctl.conf
# max open files
fs.file-max = 65536
]# sysctl -p
4 P  n6 ~& m3 M" s" K重启mariadb
9 D! B% z( p9 T8 o$ O7 U
]# systemctl restart mariadb
0 {8 ~5 f! v! K" r. O! M6 ]7 o