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 <amr...@tesora.com> wrote: > Yes, looks like MySQL was just configured with too low a max-connections > value. > > -amrith > > | -----Original Message----- > | From: Jay Pipes [mailto:jaypi...@gmail.com] > | Sent: Monday, September 29, 2014 12:58 PM > | To: openstack-dev@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@lists.openstack.org > | http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > > _______________________________________________ > OpenStack-dev mailing list > OpenStack-dev@lists.openstack.org > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev _______________________________________________ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
