← Back to team overview

yahoo-eng-team team mailing list archive

  1. yahoo-eng-team team
  2. Mailing list archive
  3. Message #78606

[Bug 1830307] [NEW] Keystone create nonlocal user failed with sqlalchemy 1.2.X

  Thread Previous • Date Previous • • Thread Next 
Public bug reported:

Keystone report error when executing 'openstack user list' with a ldap user
2019-05-24 02:17:20.717356 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi [req-e8dce895-b647-4699-8c89-b5b128976273 - - - - -] (exceptions.TypeError) Not a boolean value: u'544' [SQL: u'INSERT INTO user (id, domain_id, enabled, extra, default_project_id, created_at, last_active_at) VALUES (%(id)s, %(domain_id)s, %(enabled)s, %(extra)s, %(default_project_id)s, %(created_at)s, %(last_active_at)s)'] [parameters: [{'last_active_at': None, 'extra': {'email': u'tester@xxxxxxxx', 'description': u'tester'}, 'created_at': datetime.datetime(2019, 5, 24, 2, 17, 20, 583026), 'enabled': u'544', 'id': u'tester', 'default_project_id': None, 'domain_id': 'default'}]]: DBError: (exceptions.TypeError) Not a boolean value: u'544' [SQL: u'INSERT INTO user (id, domain_id, enabled, extra, default_project_id, created_at, last_active_at) VALUES (%(id)s, %(domain_id)s, %(enabled)s, %(extra)s, %(default_project_id)s, %(created_at)s, %(last_active_at)s)'] [parameters: [{'last_active_at': None, 'extra': {'email': u'tester@xxxxxxxx', 'description': u'tester'}, 'created_at': datetime.datetime(2019, 5, 24, 2, 17, 20, 583026), 'enabled': u'544', 'id': u'tester', 'default_project_id': None, 'domain_id': 'default'}]]
2019-05-24 02:17:20.717405 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi Traceback (most recent call last):
2019-05-24 02:17:20.717408 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/common/wsgi.py", line 148, in __call__
2019-05-24 02:17:20.717410 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     result = method(req, **params)
2019-05-24 02:17:20.717412 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/auth/controllers.py", line 67, in authenticate_for_token
2019-05-24 02:17:20.717415 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     self.authenticate(request, auth_info, auth_context)
2019-05-24 02:17:20.717417 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/auth/controllers.py", line 236, in authenticate
2019-05-24 02:17:20.717419 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     auth_info.get_method_data(method_name))
2019-05-24 02:17:20.717422 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/auth/plugins/password.py", line 37, in authenticate
2019-05-24 02:17:20.717424 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     password=user_info.password)
2019-05-24 02:17:20.717426 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/common/manager.py", line 116, in wrapped
2019-05-24 02:17:20.717428 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     __ret_val = __f(*args, **kwargs)
2019-05-24 02:17:20.717430 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/notifications.py", line 521, in wrapper
2019-05-24 02:17:20.717433 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     result = f(wrapped_self, request, user_id, *args, **kwargs)
2019-05-24 02:17:20.717435 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/identity/core.py", line 416, in wrapper
2019-05-24 02:17:20.717437 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     return f(self, *args, **kwargs)
2019-05-24 02:17:20.717439 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/identity/core.py", line 426, in wrapper
2019-05-24 02:17:20.717441 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     return f(self, *args, **kwargs)
2019-05-24 02:17:20.717443 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/identity/core.py", line 913, in authenticate
2019-05-24 02:17:20.717445 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     ref = self._shadow_nonlocal_user(ref)
2019-05-24 02:17:20.717447 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 1270, in decorate
2019-05-24 02:17:20.717449 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     should_cache_fn)
2019-05-24 02:17:20.717451 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 864, in get_or_create
2019-05-24 02:17:20.717626 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     async_creator) as value:
2019-05-24 02:17:20.717640 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/dogpile/lock.py", line 186, in __enter__
2019-05-24 02:17:20.717642 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     return self._enter()
2019-05-24 02:17:20.717644 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/dogpile/lock.py", line 93, in _enter
2019-05-24 02:17:20.717646 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     generated = self._enter_create(value, createdtime)
2019-05-24 02:17:20.717648 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/dogpile/lock.py", line 179, in _enter_create
2019-05-24 02:17:20.717650 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     return self.creator()
2019-05-24 02:17:20.717652 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 831, in gen_value
2019-05-24 02:17:20.717764 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     created_value = creator()
2019-05-24 02:17:20.717785 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 1266, in creator
2019-05-24 02:17:20.717787 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     return fn(*arg, **kw)
2019-05-24 02:17:20.717790 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/identity/core.py", line 1409, in _shadow_nonlocal_user
2019-05-24 02:17:20.717792 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     return PROVIDERS.shadow_users_api.create_nonlocal_user(user)
2019-05-24 02:17:20.717794 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/common/sql/core.py", line 516, in wrapper
2019-05-24 02:17:20.717796 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     return method(*args, **kwargs)
2019-05-24 02:17:20.717886 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/identity/shadow_backends/sql.py", line 161, in create_nonlocal_user
2019-05-24 02:17:20.717890 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     return identity_base.filter_user(new_user_ref.to_dict())
2019-05-24 02:17:20.717892 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/contextlib.py", line 24, in __exit__
2019-05-24 02:17:20.717894 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     self.gen.next()
2019-05-24 02:17:20.717896 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 1043, in _transaction_scope
2019-05-24 02:17:20.717898 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     yield resource
2019-05-24 02:17:20.717900 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/contextlib.py", line 24, in __exit__
2019-05-24 02:17:20.717902 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     self.gen.next()
2019-05-24 02:17:20.717904 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 653, in _session
2019-05-24 02:17:20.717906 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     self.session.rollback()
2019-05-24 02:17:20.717908 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__

** Affects: keystone
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Identity (keystone).
https://bugs.launchpad.net/bugs/1830307

Title:
  Keystone create nonlocal user failed with sqlalchemy 1.2.X

Status in OpenStack Identity (keystone):
  New

Bug description:
  Keystone report error when executing 'openstack user list' with a ldap user
  2019-05-24 02:17:20.717356 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi [req-e8dce895-b647-4699-8c89-b5b128976273 - - - - -] (exceptions.TypeError) Not a boolean value: u'544' [SQL: u'INSERT INTO user (id, domain_id, enabled, extra, default_project_id, created_at, last_active_at) VALUES (%(id)s, %(domain_id)s, %(enabled)s, %(extra)s, %(default_project_id)s, %(created_at)s, %(last_active_at)s)'] [parameters: [{'last_active_at': None, 'extra': {'email': u'tester@xxxxxxxx', 'description': u'tester'}, 'created_at': datetime.datetime(2019, 5, 24, 2, 17, 20, 583026), 'enabled': u'544', 'id': u'tester', 'default_project_id': None, 'domain_id': 'default'}]]: DBError: (exceptions.TypeError) Not a boolean value: u'544' [SQL: u'INSERT INTO user (id, domain_id, enabled, extra, default_project_id, created_at, last_active_at) VALUES (%(id)s, %(domain_id)s, %(enabled)s, %(extra)s, %(default_project_id)s, %(created_at)s, %(last_active_at)s)'] [parameters: [{'last_active_at': None, 'extra': {'email': u'tester@xxxxxxxx', 'description': u'tester'}, 'created_at': datetime.datetime(2019, 5, 24, 2, 17, 20, 583026), 'enabled': u'544', 'id': u'tester', 'default_project_id': None, 'domain_id': 'default'}]]
  2019-05-24 02:17:20.717405 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi Traceback (most recent call last):
  2019-05-24 02:17:20.717408 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/common/wsgi.py", line 148, in __call__
  2019-05-24 02:17:20.717410 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     result = method(req, **params)
  2019-05-24 02:17:20.717412 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/auth/controllers.py", line 67, in authenticate_for_token
  2019-05-24 02:17:20.717415 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     self.authenticate(request, auth_info, auth_context)
  2019-05-24 02:17:20.717417 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/auth/controllers.py", line 236, in authenticate
  2019-05-24 02:17:20.717419 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     auth_info.get_method_data(method_name))
  2019-05-24 02:17:20.717422 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/auth/plugins/password.py", line 37, in authenticate
  2019-05-24 02:17:20.717424 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     password=user_info.password)
  2019-05-24 02:17:20.717426 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/common/manager.py", line 116, in wrapped
  2019-05-24 02:17:20.717428 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     __ret_val = __f(*args, **kwargs)
  2019-05-24 02:17:20.717430 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/notifications.py", line 521, in wrapper
  2019-05-24 02:17:20.717433 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     result = f(wrapped_self, request, user_id, *args, **kwargs)
  2019-05-24 02:17:20.717435 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/identity/core.py", line 416, in wrapper
  2019-05-24 02:17:20.717437 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     return f(self, *args, **kwargs)
  2019-05-24 02:17:20.717439 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/identity/core.py", line 426, in wrapper
  2019-05-24 02:17:20.717441 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     return f(self, *args, **kwargs)
  2019-05-24 02:17:20.717443 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/identity/core.py", line 913, in authenticate
  2019-05-24 02:17:20.717445 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     ref = self._shadow_nonlocal_user(ref)
  2019-05-24 02:17:20.717447 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 1270, in decorate
  2019-05-24 02:17:20.717449 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     should_cache_fn)
  2019-05-24 02:17:20.717451 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 864, in get_or_create
  2019-05-24 02:17:20.717626 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     async_creator) as value:
  2019-05-24 02:17:20.717640 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/dogpile/lock.py", line 186, in __enter__
  2019-05-24 02:17:20.717642 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     return self._enter()
  2019-05-24 02:17:20.717644 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/dogpile/lock.py", line 93, in _enter
  2019-05-24 02:17:20.717646 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     generated = self._enter_create(value, createdtime)
  2019-05-24 02:17:20.717648 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/dogpile/lock.py", line 179, in _enter_create
  2019-05-24 02:17:20.717650 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     return self.creator()
  2019-05-24 02:17:20.717652 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 831, in gen_value
  2019-05-24 02:17:20.717764 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     created_value = creator()
  2019-05-24 02:17:20.717785 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 1266, in creator
  2019-05-24 02:17:20.717787 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     return fn(*arg, **kw)
  2019-05-24 02:17:20.717790 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/identity/core.py", line 1409, in _shadow_nonlocal_user
  2019-05-24 02:17:20.717792 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     return PROVIDERS.shadow_users_api.create_nonlocal_user(user)
  2019-05-24 02:17:20.717794 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/common/sql/core.py", line 516, in wrapper
  2019-05-24 02:17:20.717796 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     return method(*args, **kwargs)
  2019-05-24 02:17:20.717886 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/identity/shadow_backends/sql.py", line 161, in create_nonlocal_user
  2019-05-24 02:17:20.717890 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     return identity_base.filter_user(new_user_ref.to_dict())
  2019-05-24 02:17:20.717892 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/contextlib.py", line 24, in __exit__
  2019-05-24 02:17:20.717894 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     self.gen.next()
  2019-05-24 02:17:20.717896 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 1043, in _transaction_scope
  2019-05-24 02:17:20.717898 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     yield resource
  2019-05-24 02:17:20.717900 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/contextlib.py", line 24, in __exit__
  2019-05-24 02:17:20.717902 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     self.gen.next()
  2019-05-24 02:17:20.717904 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 653, in _session
  2019-05-24 02:17:20.717906 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi     self.session.rollback()
  2019-05-24 02:17:20.717908 2019-05-24 02:17:20.710 9992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__

To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1830307/+subscriptions
  Thread Previous • Date Previous • • Thread Next