yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1550017] [NEW] keystone eventlet using session is in 'prepared' state

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Brant Knudson <bknudson@xxxxxxxxxx>
Date: Thu, 25 Feb 2016 22:11:34 -0000
Reply-to: Bug 1550017 <1550017@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:


http://logs.openstack.org/58/257458/5/check/gate-tempest-dsvm-keystone-eventlet-full/2441200/logs/screen-key.txt.gz#_2016-02-24_17_26_26_453

Many operations are failing with an exception:

This session is in 'prepared' state; no further SQL can be emitted
within this transaction.

Traceback (most recent call last):
  File "/opt/stack/new/keystone/keystone/common/wsgi.py", line 250, in __call__
    result = method(context, **params)
  File "/usr/local/lib/python2.7/dist-packages/oslo_log/versionutils.py", line 165, in wrapped
    return func_or_cls(*args, **kwargs)
  File "/opt/stack/new/keystone/keystone/token/controllers.py", line 100, in authenticate
    context, auth)
  File "/opt/stack/new/keystone/keystone/token/controllers.py", line 302, in _authenticate_local
    password=password)
  File "/opt/stack/new/keystone/keystone/common/manager.py", line 124, in wrapped
    __ret_val = __f(*args, **kwargs)
  File "/opt/stack/new/keystone/keystone/notifications.py", line 558, in wrapper
    result = f(wrapped_self, context, user_id, *args, **kwargs)
  File "/opt/stack/new/keystone/keystone/identity/core.py", line 425, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/stack/new/keystone/keystone/identity/core.py", line 435, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/stack/new/keystone/keystone/identity/core.py", line 841, in authenticate
    ref = driver.authenticate(entity_id, password)
  File "/opt/stack/new/keystone/keystone/identity/backends/sql.py", line 184, in authenticate
    user_ref = self._get_user(session, user_id)
  File "/opt/stack/new/keystone/keystone/identity/backends/sql.py", line 209, in _get_user
    user_ref = session.query(User).get(user_id)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 831, in get
    return self._get_impl(ident, loading.load_on_ident)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 864, in _get_impl
    return fallback_fn(self, key)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/loading.py", line 219, in load_on_ident
    return q.one()
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2693, in one
    ret = list(self)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2736, in __iter__
    return self._execute_and_instances(context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2749, in _execute_and_instances
    close_with_result=True)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2740, in _connection_from_session
    **kw)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 893, in connection
    execution_options=execution_options)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 898, in _connection_for_bind
    engine, execution_options)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 313, in _connection_for_bind
    self._assert_active()
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 202, in _assert_active
    "This session is in 'prepared' state; no further "
InvalidRequestError: This session is in 'prepared' state; no further SQL can be emitted within this transaction.
2016-02-24 17:26:26.458 14573 ERROR keystone.common.wsgi

Seems like this is related to https://review.openstack.org/#/c/257458/ ,
Use the new enginefacade from oslo.db

** 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/1550017

Title:
  keystone eventlet using session is in 'prepared' state

Status in OpenStack Identity (keystone):
  New

Bug description:
  
  http://logs.openstack.org/58/257458/5/check/gate-tempest-dsvm-keystone-eventlet-full/2441200/logs/screen-key.txt.gz#_2016-02-24_17_26_26_453

  Many operations are failing with an exception:

  This session is in 'prepared' state; no further SQL can be emitted
  within this transaction.

  Traceback (most recent call last):
    File "/opt/stack/new/keystone/keystone/common/wsgi.py", line 250, in __call__
      result = method(context, **params)
    File "/usr/local/lib/python2.7/dist-packages/oslo_log/versionutils.py", line 165, in wrapped
      return func_or_cls(*args, **kwargs)
    File "/opt/stack/new/keystone/keystone/token/controllers.py", line 100, in authenticate
      context, auth)
    File "/opt/stack/new/keystone/keystone/token/controllers.py", line 302, in _authenticate_local
      password=password)
    File "/opt/stack/new/keystone/keystone/common/manager.py", line 124, in wrapped
      __ret_val = __f(*args, **kwargs)
    File "/opt/stack/new/keystone/keystone/notifications.py", line 558, in wrapper
      result = f(wrapped_self, context, user_id, *args, **kwargs)
    File "/opt/stack/new/keystone/keystone/identity/core.py", line 425, in wrapper
      return f(self, *args, **kwargs)
    File "/opt/stack/new/keystone/keystone/identity/core.py", line 435, in wrapper
      return f(self, *args, **kwargs)
    File "/opt/stack/new/keystone/keystone/identity/core.py", line 841, in authenticate
      ref = driver.authenticate(entity_id, password)
    File "/opt/stack/new/keystone/keystone/identity/backends/sql.py", line 184, in authenticate
      user_ref = self._get_user(session, user_id)
    File "/opt/stack/new/keystone/keystone/identity/backends/sql.py", line 209, in _get_user
      user_ref = session.query(User).get(user_id)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 831, in get
      return self._get_impl(ident, loading.load_on_ident)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 864, in _get_impl
      return fallback_fn(self, key)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/loading.py", line 219, in load_on_ident
      return q.one()
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2693, in one
      ret = list(self)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2736, in __iter__
      return self._execute_and_instances(context)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2749, in _execute_and_instances
      close_with_result=True)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2740, in _connection_from_session
      **kw)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 893, in connection
      execution_options=execution_options)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 898, in _connection_for_bind
      engine, execution_options)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 313, in _connection_for_bind
      self._assert_active()
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 202, in _assert_active
      "This session is in 'prepared' state; no further "
  InvalidRequestError: This session is in 'prepared' state; no further SQL can be emitted within this transaction.
  2016-02-24 17:26:26.458 14573 ERROR keystone.common.wsgi

  Seems like this is related to https://review.openstack.org/#/c/257458/
  , Use the new enginefacade from oslo.db

To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1550017/+subscriptions
Follow ups

[Bug 1550017] Re: keystone eventlet using session is in 'prepared' state
From: OpenStack Infra, 2016-02-26