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

2014-09-29 Thread Jay Pipes
On Sun, Sep 28, 2014 at 5:56 PM, Nader Lahouti nader.laho...@gmail.com wrote: Hi All, I am seeing 'Too many connections' error in nova api and cinder when when installing openstack using the latest.. The error happens when launching couple of VMs (in this test around 5 VMs). Here are the

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

2014-09-29 Thread Mike Bayer
On Sep 28, 2014, at 5:56 PM, Nader Lahouti nader.laho...@gmail.com wrote: Hi All, I am seeing 'Too many connections' error in nova api and cinder when when installing openstack using the latest.. The error happens when launching couple of VMs (in this test around 5 VMs). Here are the

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

2014-09-29 Thread Nader Lahouti
Hi Jay, Thanks for your reply. I'm not able to use mysql command line. $ mysql ERROR 1040 (HY000): Too many connections $ Is there any other way to collect the information? Thanks, Nader. On Mon, Sep 29, 2014 at 8:42 AM, Jay Pipes jaypi...@gmail.com wrote: On Sun, Sep 28, 2014 at 5:56 PM,

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

2014-09-29 Thread Amrith Kumar
) Subject: Re: [openstack-dev] [nova][cinder] (OperationalError) (1040, 'Too many connections') None None Hi Jay, Thanks for your reply. I'm not able to use mysql command line. $ mysql ERROR 1040 (HY000): Too many connections $ Is there any other way to collect the information? Thanks, Nader

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

2014-09-29 Thread Mike Bayer
On Sep 29, 2014, at 12:31 PM, Nader Lahouti nader.laho...@gmail.com wrote: Hi Jay, Thanks for your reply. I'm not able to use mysql command line. $ mysql ERROR 1040 (HY000): Too many connections $ Is there any other way to collect the information? you can try stopping

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

2014-09-29 Thread Jay Pipes
On 09/29/2014 12:31 PM, Nader Lahouti wrote: Hi Jay, Thanks for your reply. I'm not able to use mysql command line. $ mysql ERROR 1040 (HY000): Too many connections $ Is there any other way to collect the information? This should allow you to change the max connections property without

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

2014-09-29 Thread Nader Lahouti
Hi Jay, I login first and the recreated the problem and here is the log: http://paste.openstack.org/show/116776/ Thanks, Nader. On Mon, Sep 29, 2014 at 8:42 AM, Jay Pipes jaypi...@gmail.com wrote: On Sun, Sep 28, 2014 at 5:56 PM, Nader Lahouti nader.laho...@gmail.com wrote: Hi All, I am

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

2014-09-29 Thread Jay Pipes
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

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

2014-09-29 Thread Nader Lahouti
On Mon, Sep 29, 2014 at 9:58 AM, Jay Pipes jaypi...@gmail.com wrote: 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.

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

2014-09-29 Thread Amrith Kumar
] (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

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

2014-09-29 Thread Mike Bayer
] | 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

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

2014-09-29 Thread Nader Lahouti
more on to previous reply (sorry hit the send button by accident) For nova workers option: osapi_compute_workers=None And what is for keystone what option need to be set? # The number of worker processes to serve the public WSGI # application. Defaults to number of CPUs (minimum of 2). #

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

2014-09-29 Thread Jay Pipes
On 09/29/2014 01:34 PM, Nader Lahouti wrote: On Mon, Sep 29, 2014 at 9:58 AM, Jay Pipes jaypi...@gmail.com mailto:jaypi...@gmail.com wrote: 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:

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

2014-09-29 Thread Dean Troyer
On Mon, Sep 29, 2014 at 12:34 PM, Nader Lahouti nader.laho...@gmail.com wrote: I haven't modified the default values in *.conf files (I'm using devstack for installation) for workers setting. How to check that keystone is using apache with 10 worker process? And the number of CPU cores on my

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

2014-09-29 Thread Nader Lahouti
Jay, I increased the max_connection to 2000 and so far don't see any issue. After launching 20 VMs the number of connections as follows: Mon Sep 29 05:05:29 PDT 2014 Number of open TCP:3306 - 326 Number of open TCP:3306 nova-api - 34 Number of open TCP:3306 mysqld - 163 Number of open TCP:8774 -

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

2014-09-29 Thread Jay Pipes
On 09/29/2014 03:12 PM, Nader Lahouti wrote: Jay, I increased the max_connection to 2000 and so far don't see any issue. After launching 20 VMs the number of connections as follows: Mon Sep 29 05:05:29 PDT 2014 Number of open TCP:3306 - 326 Number of open TCP:3306 nova-api - 34 Number of open