After a prolonged period of inactivity, it looks like the MySQL connection times out but Keystone (Redux) does not reconnect
...
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 180, in __call__
result = method(context, **params)
File "/opt/stack/keystone/keystone/service.py", line 231, in authenticate
context=context, user_name=username)
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 188, in get_user_by_name
return _filter_user(self._get_user_by_name(user_name))
File "/opt/stack/keystone/keystone/identity/backends/sql.py", line 179, in _get_user_by_name
user_ref = session.query(User).filter_by(name=user_name).first()
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1652, in first
ret = list(self[0:1])
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1560, in __getitem__
return list(res)
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.id AS user_id, user.name AS user_name, user.extra AS user_extra \nFROM user \nWHERE user.name = %s \n LIMIT 0, 1' ('demo',)
Not sure if this is related to redux... Nati and I have seen it happen quite a bit in TryStack, and that is deployed with Diablo, not Essex... so this might be something vestigial?