Ask Your Question
0

Constantly seeing the "CRITICAL nova [req-b4004c91-3651-4230-9283-7ed9b4998ad1 None] OperationalError: (OperationalError) (1040, 'Too many connections') None None"

asked 2015-01-08 20:56:04 -0500

Vivek gravatar image

updated 2015-01-09 02:52:48 -0500

fifieldt gravatar image

Constantly seeing the below mentioned errors on my openstack JUNO (all in one) system.

When this happens the system stops working and restarting various nova-services rectifies these issues but after some time the system runs into same state again (error + stops working).

Any idea the reason behind this and how to prevent this ?

Command failed, please check log for more info
2015-01-08 18:49:11.056 9097 CRITICAL nova [req-b4004c91-3651-4230-9283-7ed9b4998ad1 None] OperationalError: (OperationalError) (1040, 'Too many connections') None None
2015-01-08 18:49:11.056 9097 TRACE nova Traceback (most recent call last):
2015-01-08 18:49:11.056 9097 TRACE nova   File "/usr/bin/nova-manage", line 10, in <module>
2015-01-08 18:49:11.056 9097 TRACE nova     sys.exit(main())
2015-01-08 18:49:11.056 9097 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 1401, in main
2015-01-08 18:49:11.056 9097 TRACE nova     ret = fn(*fn_args, **fn_kwargs)
2015-01-08 18:49:11.056 9097 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 704, in list
2015-01-08 18:49:11.056 9097 TRACE nova     services = db.service_get_all(ctxt)
2015-01-08 18:49:11.056 9097 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 112, in service_get_all
2015-01-08 18:49:11.056 9097 TRACE nova     return IMPL.service_get_all(context, disabled)
2015-01-08 18:49:11.056 9097 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 125, in wrapper
2015-01-08 18:49:11.056 9097 TRACE nova     return f(*args, **kwargs)
2015-01-08 18:49:11.056 9097 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 441, in service_get_all
2015-01-08 18:49:11.056 9097 TRACE nova     query = model_query(context, models.Service)
2015-01-08 18:49:11.056 9097 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 213, in model_query
2015-01-08 18:49:11.056 9097 TRACE nova     session = kwargs.get('session') or get_session(use_slave=use_slave)
2015-01-08 18:49:11.056 9097 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 101, in get_session
2015-01-08 18:49:11.056 9097 TRACE nova     facade = _create_facade_lazily()
2015-01-08 18:49:11.056 9097 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 91, in _create_facade_lazily
2015-01-08 18:49:11.056 9097 TRACE nova     _ENGINE_FACADE = db_session.EngineFacade.from_config(CONF)
2015-01-08 18:49:11.056 9097 TRACE nova   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line 795, in from_config
2015-01-08 18:49:11.056 9097 TRACE nova     retry_interval=conf.database.retry_interval)
2015-01-08 18:49:11.056 9097 TRACE nova   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line 711, in __init__
2015-01-08 18:49:11.056 9097 TRACE nova     **engine_kwargs)
2015-01-08 18:49:11.056 9097 TRACE nova   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line 386, in create_engine
2015-01-08 18:49:11.056 9097 TRACE nova     connection_trace ...
(more)
edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
1

answered 2015-01-09 02:53:49 -0500

fifieldt gravatar image

updated 2015-01-09 02:54:30 -0500

Hi,

This error is coming from your MySQL Database.

You need to increase the number of connections allowed to your database in your MySQL settings.

(A large OpenStack cloud makes a lot of database connections)

See

http://dev.mysql.com/doc/refman/5.5/e...

http://dev.mysql.com/doc/refman/5.5/e...

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2015-01-08 20:56:04 -0500

Seen: 1,756 times

Last updated: Jan 09 '15