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

Amrith Kumar amrith at tesora.com
Mon Sep 29 16:36:27 UTC 2014


What do you see if you run

mysqladmin processlist

I hope it doesn’t also give the same error (but that may be what you see).

-amrith

From: Nader Lahouti [mailto:nader.lahouti at gmail.com]
Sent: Monday, September 29, 2014 12:31 PM
To: OpenStack Development Mailing List (not for usage questions)
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.


On Mon, Sep 29, 2014 at 8:42 AM, Jay Pipes <jaypipes at gmail.com<mailto:jaypipes at gmail.com>> wrote:
On Sun, Sep 28, 2014 at 5:56 PM, Nader Lahouti <nader.lahouti at gmail.com<mailto: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<mailto: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/a9309065/attachment.html>


More information about the OpenStack-dev mailing list