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

Mike Bayer mbayer at redhat.com
Mon Sep 29 16:37:39 UTC 2014





On Sep 29, 2014, at 12:31 PM, Nader Lahouti <nader.lahouti at 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 everything, getting on the command line *first* and leaving it open, then rerunning your whole environment, so that you’ve reserved that spot at least to do testing queries.




> 
> 
> Thanks,
> Nader.
> 
> 
> On Mon, Sep 29, 2014 at 8:42 AM, Jay Pipes <jaypipes at gmail.com> wrote:
> On Sun, Sep 28, 2014 at 5:56 PM, Nader Lahouti <nader.lahouti at 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 logs when error happens:
> 
> (1) nova-api logs/traceback:
> http://paste.openstack.org/show/116414/
> 
> (2) cinder api logs/traceback:
> http://paste.openstack.org/show/hbaomc5IVS3mig8z2BWq/
> 
> (3) Stats of some connections:
> http://paste.openstack.org/show/116425/
> 
> As it shown in (3) the issue is not seen with icehouse release.
> 
> Can somebody please let me know if it is a known issue?
> 
> Hi Nader,
> 
> Would you mind pastebin'ing the contents of:
> 
>  SHOW FULL PROCESSLIST\G
> 
> when executed from the mysql command line client? 
> 
> That will help to show us which threads are stuck executing what in MySQL.
> 
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20140929/735a2c2d/attachment.html>


More information about the OpenStack-dev mailing list