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

Nader Lahouti nader.lahouti at gmail.com
Mon Sep 29 16:31:07 UTC 2014


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 <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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20140929/b9e3a7fe/attachment.html>


More information about the OpenStack-dev mailing list