Reviewed: https://review.opendev.org/c/openstack/neutron/+/863780 Committed: https://opendev.org/openstack/neutron/commit/234c5a376bef74bcd1af07d4be8adc69715f1af5 Submitter: "Zuul (22348)" Branch: master
commit 234c5a376bef74bcd1af07d4be8adc69715f1af5 Author: Rodolfo Alonso Hernandez <[email protected]> Date: Fri Dec 2 02:38:36 2022 +0100 [sqlalchemy-20] Add missing DB context decorator This fixes two queries still being executed without the context decorator, which is causing warning messages. Closes-Bug: #1995738 Change-Id: I61692e09119751ac7e19cecf6bf0b4b3a9fb38c7 ** Changed in: neutron Status: In Progress => Fix Released -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1995738 Title: ORM session: SQL execution without transaction in progress Status in Ubuntu Cloud Archive: New Status in Ubuntu Cloud Archive zed series: New Status in neutron: Fix Released Status in neutron package in Ubuntu: New Status in neutron source package in Kinetic: New Bug description: When deploying neutron on Kinetic the stacktrace below Platform: Kinetic on s390x ii python3-sqlalchemy 1.4.31+ds1-1build1 all SQL toolkit and Object Relational Mapper for Python 3 ii python3-sqlalchemy-ext:s390x 1.4.31+ds1-1build1 s390x SQL toolkit and Object Relational Mapper for Python3 - C extension ORM session: SQL execution without transaction in progress, traceback: File "/usr/lib/python3/dist-packages/eventlet/greenthread.py", line 221, in main result = function(*args, **kwargs) File "/usr/lib/python3/dist-packages/eventlet/wsgi.py", line 825, in process_request proto.__init__(conn_state, self) File "/usr/lib/python3/dist-packages/eventlet/wsgi.py", line 357, in __init__ self.handle() File "/usr/lib/python3/dist-packages/eventlet/wsgi.py", line 390, in handle self.handle_one_request() File "/usr/lib/python3/dist-packages/eventlet/wsgi.py", line 466, in handle_one_request self.handle_one_response() File "/usr/lib/python3/dist-packages/eventlet/wsgi.py", line 573, in handle_one_response result = self.application(self.environ, start_response) File "/usr/lib/python3/dist-packages/paste/urlmap.py", line 216, in __call__ return app(environ, start_response) File "/usr/lib/python3/dist-packages/webob/dec.py", line 129, in __call__ resp = self.call_func(req, *args, **kw) File "/usr/lib/python3/dist-packages/webob/dec.py", line 193, in call_func return self.func(req, *args, **kwargs) File "/usr/lib/python3/dist-packages/oslo_middleware/base.py", line 124, in __call__ response = req.get_response(self.application) File "/usr/lib/python3/dist-packages/webob/request.py", line 1313, in send status, headers, app_iter = self.call_application( File "/usr/lib/python3/dist-packages/webob/request.py", line 1278, in call_application app_iter = application(self.environ, start_response) File "/usr/lib/python3/dist-packages/webob/dec.py", line 129, in __call__ resp = self.call_func(req, *args, **kw) File "/usr/lib/python3/dist-packages/webob/dec.py", line 193, in call_func return self.func(req, *args, **kwargs) File "/usr/lib/python3/dist-packages/oslo_middleware/base.py", line 124, in __call__ response = req.get_response(self.application) File "/usr/lib/python3/dist-packages/webob/request.py", line 1313, in send status, headers, app_iter = self.call_application( File "/usr/lib/python3/dist-packages/webob/request.py", line 1278, in call_application app_iter = application(self.environ, start_response) File "/usr/lib/python3/dist-packages/webob/dec.py", line 129, in __call__ resp = self.call_func(req, *args, **kw) File "/usr/lib/python3/dist-packages/webob/dec.py", line 193, in call_func return self.func(req, *args, **kwargs) File "/usr/lib/python3/dist-packages/oslo_middleware/request_id.py", line 58, in __call__ response = req.get_response(self.application) File "/usr/lib/python3/dist-packages/webob/request.py", line 1313, in send status, headers, app_iter = self.call_application( File "/usr/lib/python3/dist-packages/webob/request.py", line 1278, in call_application app_iter = application(self.environ, start_response) File "/usr/lib/python3/dist-packages/webob/dec.py", line 129, in __call__ resp = self.call_func(req, *args, **kw) File "/usr/lib/python3/dist-packages/webob/dec.py", line 193, in call_func return self.func(req, *args, **kwargs) File "/usr/lib/python3/dist-packages/oslo_middleware/catch_errors.py", line 40, in __call__ response = req.get_response(self.application) File "/usr/lib/python3/dist-packages/webob/request.py", line 1313, in send status, headers, app_iter = self.call_application( File "/usr/lib/python3/dist-packages/webob/request.py", line 1278, in call_application app_iter = application(self.environ, start_response) File "/usr/lib/python3/dist-packages/webob/dec.py", line 129, in __call__ resp = self.call_func(req, *args, **kw) File "/usr/lib/python3/dist-packages/webob/dec.py", line 193, in call_func return self.func(req, *args, **kwargs) File "/usr/lib/python3/dist-packages/keystonemiddleware/auth_token/__init__.py", line 341, in __call__ response = req.get_response(self._app) File "/usr/lib/python3/dist-packages/webob/request.py", line 1313, in send status, headers, app_iter = self.call_application( File "/usr/lib/python3/dist-packages/webob/request.py", line 1278, in call_application app_iter = application(self.environ, start_response) File "/usr/lib/python3/dist-packages/webob/dec.py", line 143, in __call__ return resp(environ, start_response) File "/usr/lib/python3/dist-packages/webob/dec.py", line 143, in __call__ return resp(environ, start_response) File "/usr/lib/python3/dist-packages/routes/middleware.py", line 153, in __call__ response = self.app(environ, start_response) File "/usr/lib/python3/dist-packages/webob/dec.py", line 143, in __call__ return resp(environ, start_response) File "/usr/lib/python3/dist-packages/pecan/middleware/recursive.py", line 56, in __call__ return self.application(environ, start_response) File "/usr/lib/python3/dist-packages/pecan/core.py", line 852, in __call__ return super(Pecan, self).__call__(environ, start_response) File "/usr/lib/python3/dist-packages/pecan/core.py", line 745, in __call__ self.handle_hooks( File "/usr/lib/python3/dist-packages/pecan/core.py", line 877, in handle_hooks return super(Pecan, self).handle_hooks(hooks, *args, **kw) File "/usr/lib/python3/dist-packages/pecan/core.py", line 342, in handle_hooks result = getattr(hook, hook_type)(*args) File "/usr/lib/python3/dist-packages/neutron_lib/db/api.py", line 138, in wrapped return f(*args, **kwargs) File "/usr/lib/python3/dist-packages/oslo_db/api.py", line 142, in wrapper return f(*args, **kwargs) File "/usr/lib/python3/dist-packages/neutron_lib/db/api.py", line 184, in wrapped return f(*dup_args, **dup_kwargs) File "/usr/lib/python3/dist-packages/neutron/pecan_wsgi/hooks/quota_enforcement.py", line 74, in after resource_registry.resync_resource( File "/usr/lib/python3/dist-packages/neutron/quota/resource_registry.py", line 83, in resync_resource res.resync(context, tenant_id) File "/usr/lib/python3/dist-packages/neutron/quota/resource.py", line 267, in resync project_id=project_id).count() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 3145, in count return self._from_self(col).enable_eagerloads(False).scalar() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 2879, in scalar ret = self.one() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 2856, in one return self._iter().one() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 2894, in _iter result = self.session.execute( File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 1673, in execute result = fn(orm_exec_state) To manage notifications about this bug go to: https://bugs.launchpad.net/cloud-archive/+bug/1995738/+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
