no such column tenants.name

Bug #871790 reported by Antony Messerli
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Identity (keystone)
Invalid
Undecided
Unassigned

Bug Description

Running trunk and using the sample data:

Traceback (most recent call last):
  File "/root/keystone/keystone/utils.py", line 60, in check_error
    return func(*args, **kwargs)
  File "/root/keystone/keystone/controllers/auth.py", line 19, in authenticate
    result = config.SERVICE.authenticate(auth_with_credentials)
  File "/root/keystone/keystone/logic/service.py", line 54, in authenticate
    dtenant = self.__validate_tenant_by_name(auth_request.tenant_name)
  File "/root/keystone/keystone/logic/service.py", line 567, in __validate_tenant_by_name
    dtenant = api.TENANT.get_by_name(name=tenant_name)
  File "/root/keystone/keystone/backends/sqlalchemy/api/tenant.py", line 35, in get_by_name
    return session.query(models.Tenant).filter_by(name=name).first()
  File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first
    ret = list(self[0:1])
  File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__
    return list(res)
  File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__
    return self._execute_and_instances(context)
  File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances
    mapper=self._mapper_zero_or_none())
  File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute
    clause, params or {})
  File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute
    params)
  File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement
    return self.__execute_context(context)
  File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context
    context.parameters[0], context=context)
  File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute
    context)
  File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute
    context)
  File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute
    cursor.execute(statement, parameters)
OperationalError: (OperationalError) no such column: tenants.name u'SELECT tenants.id AS tenants_id, tenants.name AS tenants_name, tenants."desc" AS tenants_desc, tenants.enabled AS tenants_enabled \nFROM tenants \nWHERE tenants.name = ? \n LIMIT 1 OFFSET 0' (u'customer-x',)

Revision history for this message
Antony Messerli (antonym) wrote :

Tried again and wasn't able to repro this but found another error, filing that one instead.

Changed in keystone:
status: New → Invalid
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.