yahoo-eng-team team mailing list archive

Thread
Date
[Bug 2065924] Re: [OSP][TaaS][sqlalchemy] sqlalchemy updated to 2.0 breaks TaaS

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Bence Romsics <2065924@xxxxxxxxxxxxxxxxxx>
Date: Fri, 17 May 2024 08:34:52 -0000
Reply-to: Bug 2065924 <2065924@xxxxxxxxxxxxxxxxxx>
Sender: noreply@xxxxxxxxxxxxx
** Changed in: tap-as-a-service
       Status: New => Confirmed

** No longer affects: neutron

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/2065924

Title:
  [OSP][TaaS][sqlalchemy] sqlalchemy updated to 2.0 breaks TaaS

Status in tap-as-a-service:
  Confirmed

Bug description:
  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-plugin-tap-as-a-service/d2c64b6/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

To manage notifications about this bug go to:
https://bugs.launchpad.net/tap-as-a-service/+bug/2065924/+subscriptions
References

[Bug 2065924] [NEW] [OSP][TaaS][sqlalchemy] sqlalchemy updated to 2.0 breaks TaaS
From: Maor Blaustein, 2024-05-16