Activity log for bug #1862833

Date Who What changed Old value New value Message
2020-02-11 20:08:38 Carlos Eduardo bug added bug
2020-02-11 20:09:40 Goutham Pacha Ravi manila: status New Confirmed
2020-02-11 20:09:43 Goutham Pacha Ravi manila: importance Undecided High
2020-02-11 20:09:49 Goutham Pacha Ravi manila: milestone ussuri-2
2020-02-11 20:10:09 Carlos Eduardo description Some manila/python-manilaclient jobs are broken, since some share network subnet and share group tests are constantly failing. In both cases, the issue seems database related. All the failing tests have something in common in the exception, which is a database lazy loaded entity, as shown in the below example exception. Captured traceback: ~~~~~~~~~~~~~~~~~~~ Traceback (most recent call last): File "/home/zuul/src/opendev.org/openstack/manila/manila/tests/api/v2/test_share_network_subnets.py", line 463, in test_list_subnet result = self.controller.index(req, self.share_network['id']) File "/home/zuul/src/opendev.org/openstack/manila/manila/api/openstack/wsgi.py", line 1068, in version_select return func.func(self, *args, **kwargs) File "/home/zuul/src/opendev.org/openstack/manila/manila/api/openstack/wsgi.py", line 1162, in wrapper return f(self, req, *args, **kwargs) File "/home/zuul/src/opendev.org/openstack/manila/manila/api/v2/share_network_subnets.py", line 56, in index req, share_network.get('share_network_subnets')) File "/home/zuul/src/opendev.org/openstack/manila/manila/api/views/share_network_subnets.py", line 33, in build_share_network_subnets for share_network_subnet in share_network_subnets]} File "/home/zuul/src/opendev.org/openstack/manila/manila/api/views/share_network_subnets.py", line 33, in <listcomp> for share_network_subnet in share_network_subnets]} File "/home/zuul/src/opendev.org/openstack/manila/manila/api/views/share_network_subnets.py", line 40, in _build_share_network_subnet_view 'share_network_name': share_network_subnet.share_network['name'], File "/home/zuul/src/opendev.org/openstack/manila/.tox/py36/lib/python3.6/site-packages/sqlalchemy/orm/attributes.py", line 282, in __get__ return self.impl.get(instance_state(instance), dict_) File "/home/zuul/src/opendev.org/openstack/manila/.tox/py36/lib/python3.6/site-packages/sqlalchemy/orm/attributes.py", line 710, in get value = self.callable_(state, passive) File "/home/zuul/src/opendev.org/openstack/manila/.tox/py36/lib/python3.6/site-packages/sqlalchemy/orm/strategies.py", line 710, in _load_for_state % (orm_util.state_str(state), self.key) sqlalchemy.orm.exc.DetachedInstanceError: Parent instance <ShareNetworkSubnet at 0x7fee3100d2b0> is not bound to a Session; lazy load operation of attribute 'share_network' cannot proceed (Background on this error at: http://sqlalche.me/e/bhk3) Some manila or python-manilaclient jobs are broken, since some share network subnet and share group tests are constantly failing. In both cases, the issue seems database related. All the failing tests have something in common in the exception, which is a database lazy loaded entity, as shown in the below example exception. Captured traceback: ~~~~~~~~~~~~~~~~~~~      Traceback (most recent call last):        File "/home/zuul/src/opendev.org/openstack/manila/manila/tests/api/v2/test_share_network_subnets.py", line 463, in test_list_subnet          result = self.controller.index(req, self.share_network['id'])        File "/home/zuul/src/opendev.org/openstack/manila/manila/api/openstack/wsgi.py", line 1068, in version_select          return func.func(self, *args, **kwargs)        File "/home/zuul/src/opendev.org/openstack/manila/manila/api/openstack/wsgi.py", line 1162, in wrapper          return f(self, req, *args, **kwargs)        File "/home/zuul/src/opendev.org/openstack/manila/manila/api/v2/share_network_subnets.py", line 56, in index          req, share_network.get('share_network_subnets'))        File "/home/zuul/src/opendev.org/openstack/manila/manila/api/views/share_network_subnets.py", line 33, in build_share_network_subnets          for share_network_subnet in share_network_subnets]}        File "/home/zuul/src/opendev.org/openstack/manila/manila/api/views/share_network_subnets.py", line 33, in <listcomp>          for share_network_subnet in share_network_subnets]}        File "/home/zuul/src/opendev.org/openstack/manila/manila/api/views/share_network_subnets.py", line 40, in _build_share_network_subnet_view          'share_network_name': share_network_subnet.share_network['name'],        File "/home/zuul/src/opendev.org/openstack/manila/.tox/py36/lib/python3.6/site-packages/sqlalchemy/orm/attributes.py", line 282, in __get__          return self.impl.get(instance_state(instance), dict_)        File "/home/zuul/src/opendev.org/openstack/manila/.tox/py36/lib/python3.6/site-packages/sqlalchemy/orm/attributes.py", line 710, in get          value = self.callable_(state, passive)        File "/home/zuul/src/opendev.org/openstack/manila/.tox/py36/lib/python3.6/site-packages/sqlalchemy/orm/strategies.py", line 710, in _load_for_state          % (orm_util.state_str(state), self.key)      sqlalchemy.orm.exc.DetachedInstanceError: Parent instance <ShareNetworkSubnet at 0x7fee3100d2b0> is not bound to a Session; lazy load operation of attribute 'share_network' cannot proceed (Background on this error at: http://sqlalche.me/e/bhk3)
2020-02-11 20:17:53 Goutham Pacha Ravi tags db
2020-02-13 03:02:35 Goutham Pacha Ravi summary Some manila jobs are failing due to unit test issues Sqlalchemy errors with subnet and group snapshot models
2020-02-13 03:03:54 OpenStack Infra manila: status Confirmed In Progress
2020-02-13 03:03:54 OpenStack Infra manila: assignee Goutham Pacha Ravi (gouthamr)
2020-02-13 23:28:38 OpenStack Infra manila: status In Progress Fix Released