In Puppet OpenStack job we observe the following WARNING when neutron-dynamic-routing is enabled
```
2022-08-10 01:35:26.723 102553 WARNING neutron.objects.base [None req-4a9650ba-3041-46db-98c1-af8c625df7c9 85c0a6ad83f24770b3cf565b324d33fd 414c0188246e442c8f0baf6ae86e1d7d - - default default] ORM session: SQL execution without transacti
on in progress, traceback:
File "/usr/lib/python3.9/site-packages/eventlet/greenthread.py", line 221, in main
result = function(*args, **kwargs)
File "/usr/lib/python3.9/site-packages/eventlet/wsgi.py", line 837, in process_request
proto.__init__(conn_state, self)
...
File "/usr/lib/python3.9/site-packages/neutron/db/l3_dvr_db.py", line 1411, in update_floatingip
old_floatingip, floatingip = self._update_floatingip(
File "/usr/lib/python3.9/site-packages/neutron/db/l3_db.py", line 1519, in _update_floatingip
registry.publish(
File "/usr/lib/python3.9/site-packages/neutron_lib/callbacks/registry.py", line 54, in publish
_get_callback_manager().publish(resource, event, trigger, payload=payload)
File "/usr/lib/python3.9/site-packages/neutron_lib/db/utils.py", line 105, in _wrapped
return function(*args, **kwargs)
File "/usr/lib/python3.9/site-packages/neutron_lib/callbacks/manager.py", line 150, in publish
errors = self._notify_loop(resource, event, trigger, payload)
File "/usr/lib/python3.9/site-packages/neutron_lib/callbacks/manager.py", line 181, in _notify_loop
callback(resource, event, trigger, payload=payload)
File "/usr/lib/python3.9/site-packages/neutron_dynamic_routing/services/bgp/bgp_plugin.py", line 257, in floatingip_update_callback
next_hop = self._get_fip_next_hop(
File "/usr/lib/python3.9/site-packages/neutron_dynamic_routing/db/bgp_db.py", line 1090, in _get_fip_next_hop
router = self._get_router(context, router_id)
File "/usr/lib/python3.9/site-packages/neutron_dynamic_routing/db/bgp_db.py", line 1084, in _get_router
router = model_query.get_by_id(context, l3_db.Router, router_id)
File "/usr/lib/python3.9/site-packages/neutron_lib/db/model_query.py", line 169, in get_by_id
return query.filter(model.id == object_id).one()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 2865, in one
return self._iter().one()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter
result = self.session.execute(
File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/session.py", line 1693, in execute
result = fn(orm_exec_state)
```
It seems the fix for https:/ /bugs.launchpad .net/neutron/ +bug/1980671 was incomplete.
In Puppet OpenStack job we observe the following WARNING when neutron- dynamic- routing is enabled
``` objects. base [None req-4a9650ba- 3041-46db- 98c1-af8c625df7 c9 85c0a6ad83f2477 0b3cf565b324d33 fd 414c0188246e442 c8f0baf6ae86e1d 7d - - default default] ORM session: SQL execution without transacti python3. 9/site- packages/ eventlet/ greenthread. py", line 221, in main python3. 9/site- packages/ eventlet/ wsgi.py" , line 837, in process_request __init_ _(conn_ state, self) python3. 9/site- packages/ neutron/ db/l3_dvr_ db.py", line 1411, in update_floatingip floatingip( python3. 9/site- packages/ neutron/ db/l3_db. py", line 1519, in _update_floatingip publish( python3. 9/site- packages/ neutron_ lib/callbacks/ registry. py", line 54, in publish callback_ manager( ).publish( resource, event, trigger, payload=payload) python3. 9/site- packages/ neutron_ lib/db/ utils.py" , line 105, in _wrapped python3. 9/site- packages/ neutron_ lib/callbacks/ manager. py", line 150, in publish loop(resource, event, trigger, payload) python3. 9/site- packages/ neutron_ lib/callbacks/ manager. py", line 181, in _notify_loop resource, event, trigger, payload=payload) python3. 9/site- packages/ neutron_ dynamic_ routing/ services/ bgp/bgp_ plugin. py", line 257, in floatingip_ update_ callback fip_next_ hop( python3. 9/site- packages/ neutron_ dynamic_ routing/ db/bgp_ db.py", line 1090, in _get_fip_next_hop router( context, router_id) python3. 9/site- packages/ neutron_ dynamic_ routing/ db/bgp_ db.py", line 1084, in _get_router get_by_ id(context, l3_db.Router, router_id) python3. 9/site- packages/ neutron_ lib/db/ model_query. py", line 169, in get_by_id model.id == object_id).one() python3. 9/site- packages/ sqlalchemy/ orm/query. py", line 2865, in one python3. 9/site- packages/ sqlalchemy/ orm/query. py", line 2903, in _iter execute( python3. 9/site- packages/ sqlalchemy/ orm/session. py", line 1693, in execute
2022-08-10 01:35:26.723 102553 WARNING neutron.
on in progress, traceback:
File "/usr/lib/
result = function(*args, **kwargs)
File "/usr/lib/
proto.
...
File "/usr/lib/
old_floatingip, floatingip = self._update_
File "/usr/lib/
registry.
File "/usr/lib/
_get_
File "/usr/lib/
return function(*args, **kwargs)
File "/usr/lib/
errors = self._notify_
File "/usr/lib/
callback(
File "/usr/lib/
next_hop = self._get_
File "/usr/lib/
router = self._get_
File "/usr/lib/
router = model_query.
File "/usr/lib/
return query.filter(
File "/usr/lib64/
return self._iter().one()
File "/usr/lib64/
result = self.session.
File "/usr/lib64/
result = fn(orm_exec_state)
```