Public bug reported:

As seen in https://github.com/gophercloud/gophercloud/pull/3319, trying
to use an old `revision_number` when updating a router causes neutron to
return a 500 error in Bobcat. Later versions seem to not exhibit the
problem.

Here's the stack trace:

Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR root [None 
req-bc13ad66-b8f8-425e-a207-99055c506852 None admin] Original exception being 
dropped: ['Traceback (most recent call last):\n', '  File 
"/opt/stack/neutron/neutron/services/ovn_l3/plugin.py", line 199, in 
update_router\n    self._ovn_client.update_router(context, result,\n', '  File 
"/opt/stack/neutron/neutron/plugins/ml2/drivers/ovn/mech_driver/ovsdb/ovn_client.py",
 line 1509, in update_router\n    with 
excutils.save_and_reraise_exception():\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__\n    self.force_reraise()\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise\n    raise self.value\n', '  File 
"/opt/stack/neutron/neutron/plugins/ml2/drivers/ovn/mech_driver/ovsdb/ovn_client.py",
 line 1497, in update_router\n    db_rev.bump_revision(context, new_router,\n', 
'  File "/opt/stack/data/venv/li
 b/python3.10/site-packages/neutron_lib/db/api.py", line 223, in wrapped\n    
return f_with_retry(*args, **kwargs,\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
137, in wrapped\n    with excutils.save_and_reraise_exception():\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__\n    self.force_reraise()\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise\n    raise self.value\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
135, in wrapped\n    return f(*args, **kwargs)\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 144, 
in wrapper\n    with excutils.save_and_reraise_exception() as ectxt:\n', '  
File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__\n    self.force_reraise()\n', '  File "/opt/s
 tack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", line 200, 
in force_reraise\n    raise self.value\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 142, 
in wrapper\n    return f(*args, **kwargs)\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
183, in wrapped\n    with excutils.save_and_reraise_exception():\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__\n    self.force_reraise()\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise\n    raise self.value\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
181, in wrapped\n    return f(*dup_args, **dup_kwargs)\n', '  File 
"/opt/stack/neutron/neutron/db/ovn_revision_numbers_db.py", line 206, in 
bump_revision\n    context.session.merge(row)\n', '  File 
"/opt/stack/data/venv/lib/p
 ython3.10/site-packages/sqlalchemy/orm/session.py", line 2987, in merge\n    
self._autoflush()\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", 
line 2246, in _autoflush\n    self.flush()\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", 
line 3386, in flush\n    self._flush(objects)\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", 
line 3415, in _flush\n    self.dispatch.before_flush(self, flush_context, 
objects)\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/event/attr.py", 
line 247, in __call__\n    fn(*args, **kw)\n', '  File 
"/opt/stack/neutron/neutron/services/revisions/revision_plugin.py", line 79, in 
bump_revisions\n    self._enforce_if_match_constraints(session)\n', '  File 
"/opt/stack/neutron/neutron/services/revisions/revision_plugin.py", line 322, 
in _enforce_if_match_constraints\n    raise RevisionNumberConstraintFailed(mat
 ch,\n', 
'neutron.services.revisions.revision_plugin.RevisionNumberConstraintFailed: 
Constrained to 1, but current revision is 3\n']: 
sqlalchemy.orm.exc.DetachedInstanceError: Parent instance <Router at 
0x7f61a4742920> is not bound to a Session; lazy load operation of attribute 
'gw_port' cannot proceed (Background on this error at: 
https://sqlalche.me/e/14/bhk3)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource [None req-bc13ad66-b8f8-425e-a207-99055c506852 None 
admin] update failed: No details.: sqlalchemy.orm.exc.DetachedInstanceError: 
Parent instance <Router at 0x7f61a4742920> is not bound to a Session; lazy load 
operation of attribute 'gw_port' cannot proceed (Background on this error at: 
https://sqlalche.me/e/14/bhk3)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource Traceback (most recent call last):
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/services/ovn_l3/plugin.py", line 199, in 
update_router
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self._ovn_client.update_router(context, result,
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/plugins/ml2/drivers/ovn/mech_driver/ovsdb/ovn_client.py",
 line 1509, in update_router
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception():
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/plugins/ml2/drivers/ovn/mech_driver/ovsdb/ovn_client.py",
 line 1497, in update_router
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     db_rev.bump_revision(context, new_router,
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
223, in wrapped
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f_with_retry(*args, **kwargs,
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
137, in wrapped
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception():
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
135, in wrapped
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*args, **kwargs)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 144, 
in wrapper
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception() as ectxt:
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 142, 
in wrapper
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*args, **kwargs)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
183, in wrapped
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception():
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
181, in wrapped
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*dup_args, **dup_kwargs)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/db/ovn_revision_numbers_db.py", line 206, in 
bump_revision
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     context.session.merge(row)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", 
line 2987, in merge
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self._autoflush()
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", 
line 2246, in _autoflush
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.flush()
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", 
line 3386, in flush
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self._flush(objects)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", 
line 3415, in _flush
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.dispatch.before_flush(self, flush_context, 
objects)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/event/attr.py", 
line 247, in __call__
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     fn(*args, **kw)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/services/revisions/revision_plugin.py", line 79, in 
bump_revisions
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self._enforce_if_match_constraints(session)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/services/revisions/revision_plugin.py", line 322, 
in _enforce_if_match_constraints
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise RevisionNumberConstraintFailed(match,
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource 
neutron.services.revisions.revision_plugin.RevisionNumberConstraintFailed: 
Constrained to 1, but current revision is 3
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource 
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource During handling of the above exception, another 
exception occurred:
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource 
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource Traceback (most recent call last):
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/resource.py", 
line 98, in resource
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     result = method(request=request, **args)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/base.py", 
line 623, in update
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return self._update(request, id, body, **kwargs)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
137, in wrapped
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception():
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
135, in wrapped
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*args, **kwargs)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 144, 
in wrapper
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception() as ectxt:
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 142, 
in wrapper
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*args, **kwargs)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
183, in wrapped
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception():
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
181, in wrapped
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*dup_args, **dup_kwargs)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/base.py", 
line 686, in _update
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     obj = obj_updater(request.context, id, **kwargs)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/services/ovn_l3/plugin.py", line 205, in 
update_router
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     super(OVNL3RouterPlugin, 
self).update_router(context, id,
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/db/extraroute_db.py", line 71, in update_router
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return super(ExtraRoute_dbonly_mixin, 
self).update_router(
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File "/opt/stack/neutron/neutron/db/l3_db.py", line 
2236, in update_router
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     router_dict = super(L3_NAT_db_mixin, 
self).update_router(context,
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
223, in wrapped
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f_with_retry(*args, **kwargs,
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
137, in wrapped
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception():
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
135, in wrapped
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*args, **kwargs)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 144, 
in wrapper
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception() as ectxt:
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 142, 
in wrapper
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*args, **kwargs)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
183, in wrapped
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception():
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
181, in wrapped
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*dup_args, **dup_kwargs)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File "/opt/stack/neutron/neutron/db/l3_db.py", line 
352, in update_router
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     updated = self._make_router_dict(router_db)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File "/opt/stack/neutron/neutron/db/l3_db.py", line 
248, in _make_router_dict
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     resource_extend.apply_funcs(l3_apidef.ROUTERS, res, 
router)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/timeutils.py", 
line 331, in wrapper
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     result = func(*args, **kwargs)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/resource_extend.py",
 line 91, in apply_funcs
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     resolved_func(response, db_object)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/db/l3_gateway_ip_qos.py", line 42, in 
_extend_router_dict_gw_qos
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     if router_db.gw_port and (
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py",
 line 482, in __get__
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return self.impl.get(state, dict_)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py",
 line 942, in get
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     value = self._fire_loader_callables(state, key, 
passive)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py",
 line 978, in _fire_loader_callables
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return self.callable_(state, passive)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py",
 line 863, in _load_for_state
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise orm_exc.DetachedInstanceError(
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource sqlalchemy.orm.exc.DetachedInstanceError: Parent 
instance <Router at 0x7f61a4742920> is not bound to a Session; lazy load 
operation of attribute 'gw_port' cannot proceed (Background on this error at: 
https://sqlalche.me/e/14/bhk3)
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource 
Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: INFO neutron.wsgi [None 
req-bc13ad66-b8f8-425e-a207-99055c506852 None admin] 10.1.0.45 "PUT 
/networking/v2.0/routers/6d8b807f-7013-47d6-96a8-3a121e1117b6 HTTP/1.1" status: 
500  len: 344 time: 0.6007731

** Affects: neutron
     Importance: Undecided
         Status: New

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

Title:
  Use of revision_number for router update on 2023.2 Bobcat cause error
  500

Status in neutron:
  New

Bug description:
  As seen in https://github.com/gophercloud/gophercloud/pull/3319,
  trying to use an old `revision_number` when updating a router causes
  neutron to return a 500 error in Bobcat. Later versions seem to not
  exhibit the problem.

  Here's the stack trace:

  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR root [None 
req-bc13ad66-b8f8-425e-a207-99055c506852 None admin] Original exception being 
dropped: ['Traceback (most recent call last):\n', '  File 
"/opt/stack/neutron/neutron/services/ovn_l3/plugin.py", line 199, in 
update_router\n    self._ovn_client.update_router(context, result,\n', '  File 
"/opt/stack/neutron/neutron/plugins/ml2/drivers/ovn/mech_driver/ovsdb/ovn_client.py",
 line 1509, in update_router\n    with 
excutils.save_and_reraise_exception():\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__\n    self.force_reraise()\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise\n    raise self.value\n', '  File 
"/opt/stack/neutron/neutron/plugins/ml2/drivers/ovn/mech_driver/ovsdb/ovn_client.py",
 line 1497, in update_router\n    db_rev.bump_revision(context, new_router,\n', 
'  File "/opt/stack/data/venv/
 lib/python3.10/site-packages/neutron_lib/db/api.py", line 223, in wrapped\n    
return f_with_retry(*args, **kwargs,\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
137, in wrapped\n    with excutils.save_and_reraise_exception():\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__\n    self.force_reraise()\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise\n    raise self.value\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
135, in wrapped\n    return f(*args, **kwargs)\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 144, 
in wrapper\n    with excutils.save_and_reraise_exception() as ectxt:\n', '  
File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__\n    self.force_reraise()\n', '  File "/opt
 /stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", line 
200, in force_reraise\n    raise self.value\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 142, 
in wrapper\n    return f(*args, **kwargs)\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
183, in wrapped\n    with excutils.save_and_reraise_exception():\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__\n    self.force_reraise()\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise\n    raise self.value\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
181, in wrapped\n    return f(*dup_args, **dup_kwargs)\n', '  File 
"/opt/stack/neutron/neutron/db/ovn_revision_numbers_db.py", line 206, in 
bump_revision\n    context.session.merge(row)\n', '  File 
"/opt/stack/data/venv/lib
 /python3.10/site-packages/sqlalchemy/orm/session.py", line 2987, in merge\n    
self._autoflush()\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", 
line 2246, in _autoflush\n    self.flush()\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", 
line 3386, in flush\n    self._flush(objects)\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", 
line 3415, in _flush\n    self.dispatch.before_flush(self, flush_context, 
objects)\n', '  File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/event/attr.py", 
line 247, in __call__\n    fn(*args, **kw)\n', '  File 
"/opt/stack/neutron/neutron/services/revisions/revision_plugin.py", line 79, in 
bump_revisions\n    self._enforce_if_match_constraints(session)\n', '  File 
"/opt/stack/neutron/neutron/services/revisions/revision_plugin.py", line 322, 
in _enforce_if_match_constraints\n    raise RevisionNumberConstraintFailed(m
 atch,\n', 
'neutron.services.revisions.revision_plugin.RevisionNumberConstraintFailed: 
Constrained to 1, but current revision is 3\n']: 
sqlalchemy.orm.exc.DetachedInstanceError: Parent instance <Router at 
0x7f61a4742920> is not bound to a Session; lazy load operation of attribute 
'gw_port' cannot proceed (Background on this error at: 
https://sqlalche.me/e/14/bhk3)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource [None req-bc13ad66-b8f8-425e-a207-99055c506852 None 
admin] update failed: No details.: sqlalchemy.orm.exc.DetachedInstanceError: 
Parent instance <Router at 0x7f61a4742920> is not bound to a Session; lazy load 
operation of attribute 'gw_port' cannot proceed (Background on this error at: 
https://sqlalche.me/e/14/bhk3)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource Traceback (most recent call last):
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/services/ovn_l3/plugin.py", line 199, in 
update_router
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self._ovn_client.update_router(context, result,
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/plugins/ml2/drivers/ovn/mech_driver/ovsdb/ovn_client.py",
 line 1509, in update_router
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception():
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/plugins/ml2/drivers/ovn/mech_driver/ovsdb/ovn_client.py",
 line 1497, in update_router
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     db_rev.bump_revision(context, new_router,
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
223, in wrapped
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f_with_retry(*args, **kwargs,
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
137, in wrapped
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception():
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
135, in wrapped
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*args, **kwargs)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 144, 
in wrapper
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception() as ectxt:
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 142, 
in wrapper
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*args, **kwargs)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
183, in wrapped
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception():
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
181, in wrapped
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*dup_args, **dup_kwargs)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/db/ovn_revision_numbers_db.py", line 206, in 
bump_revision
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     context.session.merge(row)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", 
line 2987, in merge
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self._autoflush()
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", 
line 2246, in _autoflush
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.flush()
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", 
line 3386, in flush
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self._flush(objects)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", 
line 3415, in _flush
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.dispatch.before_flush(self, flush_context, 
objects)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/event/attr.py", 
line 247, in __call__
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     fn(*args, **kw)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/services/revisions/revision_plugin.py", line 79, in 
bump_revisions
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self._enforce_if_match_constraints(session)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/services/revisions/revision_plugin.py", line 322, 
in _enforce_if_match_constraints
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise RevisionNumberConstraintFailed(match,
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource 
neutron.services.revisions.revision_plugin.RevisionNumberConstraintFailed: 
Constrained to 1, but current revision is 3
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource 
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource During handling of the above exception, another 
exception occurred:
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource 
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource Traceback (most recent call last):
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/resource.py", 
line 98, in resource
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     result = method(request=request, **args)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/base.py", 
line 623, in update
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return self._update(request, id, body, **kwargs)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
137, in wrapped
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception():
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
135, in wrapped
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*args, **kwargs)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 144, 
in wrapper
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception() as ectxt:
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 142, 
in wrapper
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*args, **kwargs)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
183, in wrapped
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception():
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
181, in wrapped
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*dup_args, **dup_kwargs)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/base.py", 
line 686, in _update
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     obj = obj_updater(request.context, id, **kwargs)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/services/ovn_l3/plugin.py", line 205, in 
update_router
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     super(OVNL3RouterPlugin, 
self).update_router(context, id,
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/db/extraroute_db.py", line 71, in update_router
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return super(ExtraRoute_dbonly_mixin, 
self).update_router(
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File "/opt/stack/neutron/neutron/db/l3_db.py", line 
2236, in update_router
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     router_dict = super(L3_NAT_db_mixin, 
self).update_router(context,
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
223, in wrapped
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f_with_retry(*args, **kwargs,
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
137, in wrapped
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception():
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
135, in wrapped
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*args, **kwargs)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 144, 
in wrapper
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception() as ectxt:
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/api.py", line 142, 
in wrapper
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*args, **kwargs)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
183, in wrapped
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     with excutils.save_and_reraise_exception():
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 227, in __exit__
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     self.force_reraise()
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/excutils.py", 
line 200, in force_reraise
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise self.value
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/api.py", line 
181, in wrapped
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return f(*dup_args, **dup_kwargs)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File "/opt/stack/neutron/neutron/db/l3_db.py", line 
352, in update_router
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     updated = self._make_router_dict(router_db)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File "/opt/stack/neutron/neutron/db/l3_db.py", line 
248, in _make_router_dict
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     resource_extend.apply_funcs(l3_apidef.ROUTERS, res, 
router)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/oslo_utils/timeutils.py", 
line 331, in wrapper
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     result = func(*args, **kwargs)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/neutron_lib/db/resource_extend.py",
 line 91, in apply_funcs
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     resolved_func(response, db_object)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/neutron/neutron/db/l3_gateway_ip_qos.py", line 42, in 
_extend_router_dict_gw_qos
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     if router_db.gw_port and (
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py",
 line 482, in __get__
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return self.impl.get(state, dict_)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py",
 line 942, in get
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     value = self._fire_loader_callables(state, key, 
passive)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py",
 line 978, in _fire_loader_callables
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     return self.callable_(state, passive)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource   File 
"/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py",
 line 863, in _load_for_state
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource     raise orm_exc.DetachedInstanceError(
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource sqlalchemy.orm.exc.DetachedInstanceError: Parent 
instance <Router at 0x7f61a4742920> is not bound to a Session; lazy load 
operation of attribute 'gw_port' cannot proceed (Background on this error at: 
https://sqlalche.me/e/14/bhk3)
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: ERROR 
neutron.api.v2.resource 
  Mar 06 18:32:36 fv-az568-887 neutron-server[61978]: INFO neutron.wsgi [None 
req-bc13ad66-b8f8-425e-a207-99055c506852 None admin] 10.1.0.45 "PUT 
/networking/v2.0/routers/6d8b807f-7013-47d6-96a8-3a121e1117b6 HTTP/1.1" status: 
500  len: 344 time: 0.6007731

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/2101871/+subscriptions


-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp

Reply via email to