Open Stack

what’s spooking me is the original paste at http://paste.openstack.org/show/116425/ which showed:

icehouse:

Fri Sep 26 17:00:50 PDT 2014
Number of open TCP:3306 - 58
Number of open TCP:3306 nova-api - 5
Number of open TCP:3306 mysqld - 29
Number of open TCP:8774 - 10
Number of nova-api - 14


fresh startup with juno:

Fri Sep 26 09:42:58 PDT 2014
Number of open TCP:3306 - 152
Number of open TCP:3306 nova-api - 7
Number of open TCP:3306 mysqld - 76
Number of open TCP:8774 - 66
Number of nova-api - 99


does that seem right that an upgrade from icehouse would cause there to be 99 nova-api procs at startup where there were only 14 before?




On Sep 29, 2014, at 1:34 PM, Amrith Kumar <amrith at tesora.com> wrote:

> 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
> 
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev