← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 2065924] [NEW] [OSP][TaaS][sqlalchemy] sqlalchemy updated to 2.0 breaks TaaS

 

You have been subscribed to a public bug:

I'm getting these constant failures for TaaS latest version job [1] in neutron tempest plugin (regardless of changes made), since May 15th.
Recently sqlalchemy updated to 2.0 and that seems to triggered it.
Please notice traceback [2].

[1] https://zuul.opendev.org/t/openstack/builds?job_name=neutron-tempest-plugin-tap-as-a-service
[2] https://d96da691dc06805eb8a2-f1b4b5a74e40c5266f84a905497b70e3.ssl.cf1.rackcdn.com/919443/7/check/neutron-tempest-[…]controller/logs/screen-q-svc.txt

May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource Traceback (most recent call last):
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/resource.py", line 98, in resource
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     result = method(request=request, **args)
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/base.py", line 440, in create
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     return self._create(request, body, **kwargs)
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 137, in wrapped
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     with excutils.save_and_reraise_exception():
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", line 227, in __exit__
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     self.force_reraise()
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", line 200, in force_reraise
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     raise self.value
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 135, in wrapped
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     return f(*args, **kwargs)
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 144, in wrapper
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     with excutils.save_and_reraise_exception() as ectxt:
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", line 227, in __exit__
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     self.force_reraise()
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", line 200, in force_reraise
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     raise self.value
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 142, in wrapper
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     return f(*args, **kwargs)
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 183, in wrapped
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     with excutils.save_and_reraise_exception():
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", line 227, in __exit__
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     self.force_reraise()
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", line 200, in force_reraise
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     raise self.value
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 181, in wrapped
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     return f(*dup_args, **dup_kwargs)
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/base.py", line 566, in _create
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     obj = do_create(body)
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/base.py", line 544, in do_create
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     with excutils.save_and_reraise_exception():
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", line 227, in __exit__
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     self.force_reraise()
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", line 200, in force_reraise
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     raise self.value
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/base.py", line 540, in do_create
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     return obj_creator(request.context, **kwargs)
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 998, in wrapper
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     return fn(*args, **kwargs)
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/tap-as-a-service/neutron_taas/services/taas/taas_plugin.py", line 165, in create_tap_flow
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     with excutils.save_and_reraise_exception():
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", line 227, in __exit__
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     self.force_reraise()
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", line 200, in force_reraise
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     raise self.value
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/tap-as-a-service/neutron_taas/services/taas/taas_plugin.py", line 163, in create_tap_flow
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     self.driver.create_tap_flow_postcommit(driver_context)
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/tap-as-a-service/neutron_taas/services/taas/service_drivers/taas_rpc.py", line 250, in create_tap_flow_postcommit
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     tf_nw = self.service_plugin.get_port_network_data(
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 221, in wrapped
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     return f(*args, **kwargs)
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 998, in wrapper
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     return fn(*args, **kwargs)
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "/opt/stack/tap-as-a-service/neutron_taas/db/taas_db.py", line 164, in get_port_network_data
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource     'physical_network': ns['physical_network'],
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource   File "lib/sqlalchemy/cyextension/resultproxy.pyx", line 54, in sqlalchemy.cyextension.resultproxy.BaseRow.__getitem__
May 16 14:34:10.245235 np0037530519 neutron-server[61434]: ERROR neutron.api.v2.resource TypeError: tuple indices must be integers or slices, not str

** Affects: neutron
     Importance: Undecided
         Status: New

-- 
[OSP][TaaS][sqlalchemy] sqlalchemy updated to 2.0 breaks TaaS
https://bugs.launchpad.net/bugs/2065924
You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron.


References