“MySQL server has gone away” error.

Bug #953790 reported by shwinpiocess
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Identity (keystone)
New
Undecided
Unassigned

Bug Description

Devstack deployment one node openstack, the 2nd day login error occurs everytime.

Log on the login web GUI:

Error: Unable to communicate with identity service: Traceback (most recent call last): File "/usr/lib/python2.7/dist-packages/eventlet/wsgi.py", line 336, in handle_one_response result = self.application(self.environ, start_response) File "/usr/lib/python2.7/dist-packages/paste/urlmap.py", line 203, in __call__ return app(environ, start_response) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 147, in __call__ resp = self.call_func(req, *args, **self.kwargs) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 208, in call_func return self.func(req, *args, **kwargs) File "/opt/stack/keystone/keystone/common/wsgi.py", line 284, in __call__ response = request.get_response(self.application) File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1053, in get_response application, catch_exc_info=False) File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1022, in call_application app_iter = application(self.environ, start_response) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 147, in __call__ resp = self.call_func(req, *args, **self.kwargs) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 208, in call_func return self.func(req, *args, **kwargs) File "/opt/stack/keystone/keystone/common/wsgi.py", line 284, in __call__ response = request.get_response(self.application) File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1053, in get_response application, catch_exc_info=False) File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1022, in call_application app_iter = application(self.environ, start_response) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 147, in __call__ resp = self.call_func(req, *args, **self.kwargs) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 208, in call_func return self.func(req, *args, **kwargs) File "/opt/stack/keystone/keystone/common/wsgi.py", line 284, in __call__ response = request.get_response(self.application) File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1053, in get_response application, catch_exc_info=False) File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1022, in call_application app_iter = application(self.environ, start_response) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 147, in __call__ resp = self.call_func(req, *args, **self.kwargs) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 208, in call_func return self.func(req, *args, **kwargs) File "/opt/stack/keystone/keystone/common/wsgi.py", line 284, in __call__ response = request.get_response(self.application) File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1053, in get_response application, catch_exc_info=False) File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1022, in call_application app_iter = application(self.environ, start_response) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 147, in __call__ resp = self.call_func(req, *args, **self.kwargs) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 208, in call_func return self.func(req, *args, **kwargs) File "/opt/stack/keystone/keystone/common/wsgi.py", line 307, in __call__ resp = req.get_response(self.application) File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1053, in get_response application, catch_exc_info=False) File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1022, in call_application app_iter = application(self.environ, start_response) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in __call__ return resp(environ, start_response) File "/usr/lib/pymodules/python2.7/routes/middleware.py", line 131, in __call__ response = self.app(environ, start_response) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in __call__ return resp(environ, start_response) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in __call__ return resp(environ, start_response) File "/usr/lib/pymodules/python2.7/routes/middleware.py", line 131, in __call__ response = self.app(environ, start_response) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in __call__ return resp(environ, start_response) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in __call__ return resp(environ, start_response) File "/usr/lib/pymodules/python2.7/routes/middleware.py", line 131, in __call__ response = self.app(environ, start_response) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in __call__ return resp(environ, start_response) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 147, in __call__ resp = self.call_func(req, *args, **self.kwargs) File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 208, in call_func return self.func(req, *args, **kwargs) File "/opt/stack/keystone/keystone/common/wsgi.py", line 181, in __call__ result = method(context, **params) File "/opt/stack/keystone/keystone/identity/core.py", line 273, in get_tenants_for_token context, user_ref['id']) File "/opt/stack/keystone/keystone/common/manager.py", line 34, in _wrapper return f(*args, **kw) File "/opt/stack/keystone/keystone/identity/backends/sql.py", line 244, in get_tenants_for_user .filter_by(user_id=user_id)\ File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1611, in all return list(self) File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1721, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1726, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 724, in execute clause, params or {}) File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1191, in execute params) File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1271, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1302, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1401, in _cursor_execute context) File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1394, in _cursor_execute context) File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 299, in do_execute cursor.execute(statement, parameters) File "/usr/lib/pymodules/python2.7/MySQLdb/cursors.py", line 174, in execute self.errorhandler(self, exc, value) File "/usr/lib/pymodules/python2.7/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue OperationalError: (OperationalError) (2006, 'MySQL server has gone away') 'SELECT user_tenant_membership.user_id AS user_tenant_membership_user_id, user_tenant_membership.tenant_id AS user_tenant_membership_tenant_id \nFROM user_tenant_membership \nWHERE user_tenant_membership.user_id = %s' ('bd6e6216e7984ea8be4fe510b98fa384',) . (HTTP 500)

Error: No tenants present for user: admin

Revision history for this message
Rafael Durán Castañeda (rafadurancastaneda) wrote :

I think fix for this I will land short into trunk, see https://bugs.launchpad.net/keystone/+bug/943031

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.