Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Juno Authentication to Horizon error - too many connections

Hi,

I'm using Juno on ubuntu 14.04 and I'm not able to log in anymore via the dashboard. I'm getting errors like "An error occurred authenticating. Please try again later." " not able to authenticate with any project"

keystone-all.log

2014-10-28 15:24:35.833 3358 ERROR keystone.common.wsgi [-] (OperationalError) (1040, 'Too many connections') None None
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi Traceback (most recent call last):
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/keystone/common/wsgi.py", line 223, in __call__
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     result = method(context, **params)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/keystone/token/controllers.py", line 100, in authenticate
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     context, auth)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/keystone/token/controllers.py", line 287, in _authenticate_local
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     username, CONF.identity.default_domain_id)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/keystone/identity/core.py", line 202, in wrapper
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     return f(self, *args, **kwargs)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/keystone/identity/core.py", line 213, in wrapper
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     return f(self, *args, **kwargs)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/keystone/identity/core.py", line 600, in get_user_by_name
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     ref = driver.get_user_by_name(user_name, domain_id)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/keystone/identity/backends/sql.py", line 146, in get_user_by_name
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     session = sql.get_session()
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/keystone/common/sql/core.py", line 192, in get_session
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     return _get_engine_facade().get_session(expire_on_commit=expire_on_commit)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/keystone/common/sql/core.py", line 176, in _get_engine_facade
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     _engine_facade = db_session.EngineFacade.from_config(CONF)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line 795, in from_config
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     retry_interval=conf.database.retry_interval)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line 711, in __init__
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     **engine_kwargs)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line 386, in create_engine
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     connection_trace=connection_trace
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/utils.py", line 890, in __call__
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     self._url_from_target(target), target, arg, kw)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/utils.py", line 927, in _dispatch_on
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     return self._dispatch_on_db_driver(dbname, driver, arg, kw)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/utils.py", line 981, in _dispatch_on_db_driver
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     if self._invoke_fn(fn, arg, kw) is not None:
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/utils.py", line 930, in _invoke_fn
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     return fn(*arg, **kw)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line 456, in _init_events
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     realmode = engine.execute("SHOW VARIABLES LIKE 'sql_mode'").fetchone()
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1751, in execute
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     connection = self.contextual_connect(close_with_result=True)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1799, in contextual_connect
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     self.pool.connect(),
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 338, in connect
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     return _ConnectionFairy._checkout(self)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 641, in _checkout
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     fairy = _ConnectionRecord.checkout(pool)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 440, in checkout
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     rec = pool._do_get()
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 961, in _do_get
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     return self._create_connection()
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 285, in _create_connection
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     return _ConnectionRecord(self)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 411, in __init__
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     self.connection = self.__connect()
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 537, in __connect
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     connection = self.__pool._creator()
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 96, in connect
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     connection_invalidated=invalidated
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     reraise(type(exception), exception, tb=exc_tb)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 90, in connect
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     return dialect.connect(*cargs, **cparams)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 377, in connect
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     return self.dbapi.connect(*cargs, **cparams)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     return Connection(*args, **kwargs)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi     super(Connection, self).__init__(*args, **kwargs2)
2014-10-28 15:24:35.833 3358 TRACE keystone.common.wsgi OperationalError: (OperationalError) (1040, 'Too many connections') None None