<div dir="ltr">Mark,<div><br></div><div style>Which token driver are you using?</div><div class="gmail_extra"><div><div><br></div><div>-Dolph<br></div></div>
<br><br><div class="gmail_quote">On Mon, Apr 1, 2013 at 10:49 AM, Dolph Mathews <span dir="ltr"><<a href="mailto:dolph.mathews@gmail.com" target="_blank">dolph.mathews@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div class="im"><span style="font-family:arial,sans-serif;font-size:13px">I also opened bug 1162857, which produces a slightly different symptom with a different configuration (sqlite), but may share the same underlying cause.</span><br>
</div><div class="gmail_extra"><span class="HOEnZb"><font color="#888888"><br clear="all"><div><div><br></div><div>-Dolph<br></div></div></font></span><div><div class="h5">
<br><br><div class="gmail_quote">On Mon, Apr 1, 2013 at 10:26 AM, Dolph Mathews <span dir="ltr"><<a href="mailto:dolph.mathews@gmail.com" target="_blank">dolph.mathews@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">I'm attempting to reproduce this now (haven't been successful with PKI + sqlite on disk), but in the meantime I opened a bug on this issue for tracking:<div><br></div><div> <a href="https://bugs.launchpad.net/keystone/+bug/1162845" target="_blank">https://bugs.launchpad.net/keystone/+bug/1162845</a></div>
</div><div class="gmail_extra"><br clear="all"><div><div><br></div>-Dolph</div>
<br><br><div class="gmail_quote"><div><div>On Fri, Mar 29, 2013 at 1:35 PM, Miller, Mark M (EB SW Cloud - R&D - Corvallis) <span dir="ltr"><<a href="mailto:mark.m.miller@hp.com" target="_blank">mark.m.miller@hp.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal">Hi,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I have a loop that gets PKI tokens from Keystone (RC2). After about 116 loops I get the following error and have to reset Keystone to continue. Has anyone else run into this?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Mark<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="color:#1f497d">(keystone.auth.controllers): 2013-03-29 11:14:01,274 ERROR (OperationalError) (1040, 'Too many connections') None None<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Traceback (most recent call last):<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.rc2-py2.7.egg/keystone/auth/controllers.py", line 286, in authenticate_for_token<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> self.authenticate(context, auth_info, auth_context)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.rc2-py2.7.egg/keystone/auth/controllers.py", line 352, in authenticate<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> auth_context)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.rc2-py2.7.egg/keystone/auth/plugins/password.py", line 108, in authenticate<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> user_info = UserAuthInfo(context, auth_payload)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.rc2-py2.7.egg/keystone/auth/plugins/password.py", line 36, in __init__<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> self._validate_and_normalize_auth_data(auth_payload)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.rc2-py2.7.egg/keystone/auth/plugins/password.py", line 87, in _validate_and_normalize_auth_data<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> domain_ref = self._lookup_domain(user_info['domain'])<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.rc2-py2.7.egg/keystone/auth/plugins/password.py", line 60, in _lookup_domain<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> context=self.context, domain_name=domain_name)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.rc2-py2.7.egg/keystone/common/manager.py", line 47, in _wrapper<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> return f(*args, **kw)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.rc2-py2.7.egg/keystone/common/sql/core.py", line 272, in wrapper<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> return method(*args, **kwargs)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.rc2-py2.7.egg/keystone/identity/backends/sql.py", line 589, in get_domain_by_name<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> ref = session.query(Domain).filter_by(name=domain_name).one()<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2184, in one<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> ret = list(self)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2227, in __iter__<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> return self._execute_and_instances(context)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2240, in _execute_and_instances<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> close_with_result=True)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2231, in _connection_from_session<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> **kw)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/orm/session.py", line 777, in connection<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> close_with_result=close_with_result)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/orm/session.py", line 783, in _connection_for_bind<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> return engine.contextual_connect(**kwargs)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 2489, in contextual_connect<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> self.pool.connect(),<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/pool.py", line 236, in connect<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> return _ConnectionFairy(self).checkout()<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/pool.py", line 401, in __init__<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> rec = self._connection_record = pool._do_get()<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/pool.py", line 746, in _do_get<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> con = self._create_connection()<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/pool.py", line 189, in _create_connection<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> return _ConnectionRecord(self)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/pool.py", line 282, in __init__<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> self.connection = self.__connect()<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/pool.py", line 344, in __connect<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> connection = self.__pool._creator()<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/strategies.py", line 80, in connect<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> return dialect.connect(*cargs, **cparams)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/default.py", line 281, in connect<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> return self.dbapi.connect(*cargs, **cparams)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> return Connection(*args, **kwargs)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> super(Connection, self).__init__(*args, **kwargs2)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">OperationalError: (OperationalError) (1040, 'Too many connections') None None<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">(access): 2013-03-29 11:14:01,278 INFO 15.253.58.148 - - [29/Mar/2013:18:14:01 +0000] "POST <a href="http://15.253.58.165:35357/v3/auth/tokens" target="_blank">http://15.253.58.165:35357/v3/auth/tokens</a> HTTP/1.0" 401 125<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">(eventlet.wsgi.server): 2013-03-29 11:14:01,279 DEBUG 15.253.58.148 - - [29/Mar/2013 11:14:01] "POST /v3/auth/tokens HTTP/1.1" 401 290 0.017322<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<br></div></div>_______________________________________________<br>
Mailing list: <a href="https://launchpad.net/~openstack" target="_blank">https://launchpad.net/~openstack</a><br>
Post to : <a href="mailto:openstack@lists.launchpad.net" target="_blank">openstack@lists.launchpad.net</a><br>
Unsubscribe : <a href="https://launchpad.net/~openstack" target="_blank">https://launchpad.net/~openstack</a><br>
More help : <a href="https://help.launchpad.net/ListHelp" target="_blank">https://help.launchpad.net/ListHelp</a><br>
<br></blockquote></div><br></div>
</blockquote></div><br></div></div></div></div>
</blockquote></div><br></div></div>