DetachedInstanceError trying to lazy-load VolumeTypes.projects

These are results from a stable/newton change, but it's also showing up in master.

http://logs.openstack.org/89/529389/1/check/legacy-tempest-dsvm-cells/6fa4ca0/logs/screen-c-api.txt.gz?level=TRACE#_2017-12-20_19_15_41_889

2017-12-20 19:15:41.889 ERROR cinder.api.middleware.fault [req-557f09bb-ce35-4d56-98f3-acf0a34be17b tempest-GroupsTest-1489832436] Caught error: <class 'sqlalchemy.orm.exc.DetachedInstanceError'> Parent instance <VolumeTypes at 0x7ff9b7560990> is not bound to a Session; lazy load operation of attribute 'projects' cannot proceed
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault Traceback (most recent call last):
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/opt/stack/new/cinder/cinder/api/middleware/fault.py", line 79, in __call__
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault return req.get_response(self.application)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/webob/request.py", line 1299, in send
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault application, catch_exc_info=False)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/webob/request.py", line 1263, in call_application
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault app_iter = application(self.environ, start_response)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault return resp(environ, start_response)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/webob/dec.py", line 130, in __call__
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault resp = self.call_func(req, *args, **self.kwargs)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/webob/dec.py", line 195, in call_func
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault return self.func(req, *args, **kwargs)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/osprofiler/web.py", line 108, in __call__
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault return request.get_response(self.application)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/webob/request.py", line 1299, in send
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault application, catch_exc_info=False)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/webob/request.py", line 1263, in call_application
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault app_iter = application(self.environ, start_response)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/webob/dec.py", line 130, in __call__
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault resp = self.call_func(req, *args, **self.kwargs)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/webob/dec.py", line 195, in call_func
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault return self.func(req, *args, **kwargs)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/keystonemiddleware/auth_token/__init__.py", line 323, in __call__
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault response = req.get_response(self._app)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/webob/request.py", line 1299, in send
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault application, catch_exc_info=False)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/webob/request.py", line 1263, in call_application
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault app_iter = application(self.environ, start_response)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault return resp(environ, start_response)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault return resp(environ, start_response)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/routes/middleware.py", line 141, in __call__
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault response = self.app(environ, start_response)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault return resp(environ, start_response)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/webob/dec.py", line 130, in __call__
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault resp = self.call_func(req, *args, **self.kwargs)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/webob/dec.py", line 195, in call_func
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault return self.func(req, *args, **kwargs)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/opt/stack/new/cinder/cinder/api/openstack/wsgi.py", line 843, in __call__
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault content_type, body, accept)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/opt/stack/new/cinder/cinder/api/openstack/wsgi.py", line 902, in _process_stack
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault action_result = self.dispatch(meth, request, action_args)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/opt/stack/new/cinder/cinder/api/openstack/wsgi.py", line 997, in dispatch
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault return method(req=request, **action_args)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/opt/stack/new/cinder/cinder/api/openstack/wsgi.py", line 1163, in version_select
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault return func.func(self, *args, **kwargs)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/opt/stack/new/cinder/cinder/api/v3/groups.py", line 55, in show
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault return self._view_builder.detail(req, group)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/opt/stack/new/cinder/cinder/api/v3/views/groups.py", line 56, in detail
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault 'volume_types': [v_type.id for v_type in group.volume_types],
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/oslo_versionedobjects/base.py", line 67, in getter
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault self.obj_load_attr(name)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/opt/stack/new/cinder/cinder/objects/group.py", line 128, in obj_load_attr
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault self._context, self.id)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/opt/stack/new/cinder/cinder/objects/volume_type.py", line 156, in get_all_by_group
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault expected_attrs=expected_attrs)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/oslo_versionedobjects/base.py", line 1125, in obj_make_list
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault **extra_args)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/opt/stack/new/cinder/cinder/objects/volume_type.py", line 87, in _from_db_object
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault type.projects = db_type.get('projects', [])
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/models.py", line 68, in get
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault return getattr(self, key, default)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/attributes.py", line 237, in __get__
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault return self.impl.get(instance_state(instance), dict_)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/attributes.py", line 583, in get
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault value = self.callable_(state, passive)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/strategies.py", line 517, in _load_for_state
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault (orm_util.state_str(state), self.key)
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault DetachedInstanceError: Parent instance <VolumeTypes at 0x7ff9b7560990> is not bound to a Session; lazy load operation of attribute 'projects' cannot proceed
2017-12-20 19:15:41.889 32306 ERROR cinder.api.middleware.fault

http://logstash.openstack.org/#dashboard/file/logstash.json?query=message%3A%5C%22DetachedInstanceError%5C%22%20AND%20message%3A%5C%22in%20get_all_by_group%5C%22%20AND%20tags%3A%5C%22screen-c-api.txt%5C%22&from=7d

7 hits in 7 days, check and gate, all failures.