Skip to content

Instantly share code, notes, and snippets.

Created October 27, 2014 21:11
Show Gist options
  • Save anonymous/895feaf05b1844130741 to your computer and use it in GitHub Desktop.
Save anonymous/895feaf05b1844130741 to your computer and use it in GitHub Desktop.
2014-10-27 16:34:02.741 26952 ERROR keystone.common.wsgi [-] (OperationalError) (1054, "Unknown column 'endpoint.region_id' in 'field list'") 'SELECT endpoint.id AS endpoint_id, endpoint.legacy_endpoint_id AS endpoint_legacy_endpoint_id, endpoint.interface AS endpoint_interface, endpoint.region_id AS endpoint_region_id, endpoint.service_id AS endpoint_service_id, endpoint.url AS endpoint_url, endpoint.enabled AS endpoint_enabled, endpoint.extra AS endpoint_extra, service_1.id AS service_1_id, service_1.type AS service_1_type, service_1.enabled AS service_1_enabled, service_1.extra AS service_1_extra \nFROM endpoint LEFT OUTER JOIN service AS service_1 ON service_1.id = endpoint.service_id \nWHERE endpoint.enabled = true' ()
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi Traceback (most recent call last):
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi File "/root/keystone-juno/keystone/common/wsgi.py", line 223, in __call__
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi result = method(context, **params)
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi File "/root/keystone-juno/keystone/token/controllers.py", line 131, in authenticate
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi user_ref['id'], tenant_ref['id'], metadata_ref)
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi File "/root/keystone-juno/keystone/catalog/core.py", line 210, in get_catalog
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi return self.driver.get_catalog(user_id, tenant_id, metadata)
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi File "/root/keystone-juno/keystone/catalog/backends/sql.py", line 280, in get_catalog
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi filter(Endpoint.enabled == t).all())
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2241, in all
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi return list(self)
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2353, in __iter__
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi return self._execute_and_instances(context)
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2368, in _execute_and_instances
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi result = conn.execute(querycontext.statement, self._params)
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 662, in execute
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi params)
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 761, in _execute_clauseelement
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi compiled_sql, distilled_params
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 874, in _execute_context
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi context)
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi File "/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/compat/handle_error.py", line 125, in _handle_dbapi_exception
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi six.reraise(type(newraise), newraise, sys.exc_info()[2])
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi File "/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/compat/handle_error.py", line 102, in _handle_dbapi_exception
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi per_fn = fn(ctx)
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi File "/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/exc_filters.py", line 323, in handler
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi context.is_disconnect)
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi File "/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/exc_filters.py", line 254, in _raise_operational_errors_directly_filter
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi raise operational_error
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi OperationalError: (OperationalError) (1054, "Unknown column 'endpoint.region_id' in 'field list'") 'SELECT endpoint.id AS endpoint_id, endpoint.legacy_endpoint_id AS endpoint_legacy_endpoint_id, endpoint.interface AS endpoint_interface, endpoint.region_id AS endpoint_region_id, endpoint.service_id AS endpoint_service_id, endpoint.url AS endpoint_url, endpoint.enabled AS endpoint_enabled, endpoint.extra AS endpoint_extra, service_1.id AS service_1_id, service_1.type AS service_1_type, service_1.enabled AS service_1_enabled, service_1.extra AS service_1_extra \nFROM endpoint LEFT OUTER JOIN service AS service_1 ON service_1.id = endpoint.service_id \nWHERE endpoint.enabled = true' ()
2014-10-27 16:34:02.741 26952 TRACE keystone.common.wsgi
/usr/lib/python2.7/dist-packages/sqlalchemy/sql/expression.py:1994: SAWarning: The IN-predicate on "assignment.actor_id" was invoked with an empty sequence. This results in a contradiction, which nonetheless can be expensive to evaluate. Consider alternative strategies for improved performance.
return o[0](self, self.expr, op, *(other + o[1:]), **kwargs)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment