[openstack-dev] [nova][cinder] (OperationalError) (1040, 'Too many connections') None None

Amrith Kumar amrith at tesora.com
Mon Sep 29 17:34:54 UTC 2014


Yes, looks like MySQL was just configured with too low a max-connections value.

-amrith

| -----Original Message-----
| From: Jay Pipes [mailto:jaypipes at gmail.com]
| Sent: Monday, September 29, 2014 12:58 PM
| To: openstack-dev at lists.openstack.org
| Subject: Re: [openstack-dev] [nova][cinder] (OperationalError) (1040, 'Too
| many connections') None None
| 
| On 09/29/2014 12:48 PM, Nader Lahouti wrote:
| > Hi Jay,
| >
| > I login first and the recreated the problem and here is the log:
| > http://paste.openstack.org/show/116776/
| 
| OK. Looks like there isn't anything wrong with your setup. I'm guessing
| you have set up Keystone to run in Apache with 10 worker processes, and
| you have the workers config option setting in nova.conf, neutron.conf and
| all the other project configuration files set to 0, which will trigger a
| number of worker processes equal to the number of CPU cores on your box,
| which I'm guessing from looking at your SHOW FULL PROCESSLIST is around
| 24-32 cores.
| 
| Solution: either lower the workers configuration option from 0 to
| something like 12, or increase the max_connections setting in your my.cnf
| to something that can handle the worker processes from all the OpenStack
| services (I'd recommend something like 2000).
| 
| Best,
| -jay
| 
| _______________________________________________
| OpenStack-dev mailing list
| OpenStack-dev at lists.openstack.org
| http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev



More information about the OpenStack-dev mailing list