Reviewed: https://review.opendev.org/c/openstack/glance/+/825783 Committed: https://opendev.org/openstack/glance/commit/71c1e4b18a47f94f3302f96c359a6d3e1453ff11 Submitter: "Zuul (22348)" Branch: master
commit 71c1e4b18a47f94f3302f96c359a6d3e1453ff11 Author: Erno Kuvaja <jo...@usr.fi> Date: Fri Jan 21 12:59:01 2022 +0000 Bump SQLalchemy to version that supports PY3.9 Bumping SQLAlchemy to 1.3.14, which is first version supporting Python 3.9 runtime, this hopefully addresses the issue reported. Change-Id: I73f0c7c067fcab00a97cd925cad19edd64b6eb45 Closes-Bug: #1957167 ** Changed in: glance Status: In Progress => Fix Released -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to Glance. https://bugs.launchpad.net/bugs/1957167 Title: glance constraint for sqlalchemy is too low for xena Status in Glance: Fix Released Bug description: The glance requirement for sqlalchemy says >= 1.0.10 but using 1.3.2 gives error when trying to db sync this is xena release versions openstack-glance-21.1.0-1.el8.noarch python3-glance-store-2.3.0-2.el8.noarch python3-glanceclient-3.5.0-1.el8.noarch python3-glance-21.1.0-1.el8.noarch upgrading sqlalchemy to 1.4.18 makes it working, which means the requirements is not properly set 2022-01-11 17:38:48.627 196461 CRITICAL glance [-] Unhandled error: TypeError: 'int' object is not iterable 2022-01-11 17:38:48.627 196461 ERROR glance Traceback (most recent call last): 2022-01-11 17:38:48.627 196461 ERROR glance File "/bin/glance-manage", line 10, in <module> 2022-01-11 17:38:48.627 196461 ERROR glance sys.exit(main()) 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib/python3.6/site-packages/glance/cmd/manage.py", line 557, in main 2022-01-11 17:38:48.627 196461 ERROR glance return CONF.command.action_fn() 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib/python3.6/site-packages/glance/cmd/manage.py", line 391, in sync 2022-01-11 17:38:48.627 196461 ERROR glance self.command_object.sync(CONF.command.version) 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib/python3.6/site-packages/glance/cmd/manage.py", line 152, in sync 2022-01-11 17:38:48.627 196461 ERROR glance curr_heads = alembic_migrations.get_current_alembic_heads() 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib/python3.6/site-packages/glance/db/sqlalchemy/alembic_migrations/__init__.py", line 46, in get_current_alembic_heads 2022-01-11 17:38:48.627 196461 ERROR glance engine = db_api.get_engine() 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib/python3.6/site-packages/glance/db/sqlalchemy/api.py", line 98, in get_engine 2022-01-11 17:38:48.627 196461 ERROR glance facade = _create_facade_lazily() 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib/python3.6/site-packages/glance/db/sqlalchemy/api.py", line 88, in _create_facade_lazily 2022-01-11 17:38:48.627 196461 ERROR glance _FACADE = session.EngineFacade.from_config(CONF) 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib/python3.6/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 1370, in from_config 2022-01-11 17:38:48.627 196461 ERROR glance expire_on_commit=expire_on_commit, _conf=conf) 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib/python3.6/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 1291, in __init__ 2022-01-11 17:38:48.627 196461 ERROR glance slave_connection=slave_connection) 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib/python3.6/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 506, in _start 2022-01-11 17:38:48.627 196461 ERROR glance engine_args, maker_args) 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib/python3.6/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 530, in _setup_for_connection 2022-01-11 17:38:48.627 196461 ERROR glance sql_connection=sql_connection, **engine_kwargs) 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib/python3.6/site-packages/debtcollector/renames.py", line 43, in decorator 2022-01-11 17:38:48.627 196461 ERROR glance return wrapped(*args, **kwargs) 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib/python3.6/site-packages/oslo_db/sqlalchemy/engines.py", line 211, in create_engine 2022-01-11 17:38:48.627 196461 ERROR glance test_conn = _test_connection(engine, max_retries, retry_interval) 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib/python3.6/site-packages/oslo_db/sqlalchemy/engines.py", line 386, in _test_connection 2022-01-11 17:38:48.627 196461 ERROR glance return engine.connect() 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 2193, in connect 2022-01-11 17:38:48.627 196461 ERROR glance return self._connection_cls(self, **kwargs) 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 125, in __init__ 2022-01-11 17:38:48.627 196461 ERROR glance self.dispatch.engine_connect(self, self.__branch) 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib64/python3.6/site-packages/sqlalchemy/event/attr.py", line 297, in __call__ 2022-01-11 17:38:48.627 196461 ERROR glance fn(*args, **kw) 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib/python3.6/site-packages/oslo_db/sqlalchemy/engines.py", line 73, in _connect_ping_listener 2022-01-11 17:38:48.627 196461 ERROR glance connection.scalar(select(1)) 2022-01-11 17:38:48.627 196461 ERROR glance File "<string>", line 2, in select 2022-01-11 17:38:48.627 196461 ERROR glance File "<string>", line 2, in __init__ 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/deprecations.py", line 130, in warned 2022-01-11 17:38:48.627 196461 ERROR glance return fn(*args, **kwargs) 2022-01-11 17:38:48.627 196461 ERROR glance File "/usr/lib64/python3.6/site-packages/sqlalchemy/sql/selectable.py", line 2929, in __init__ 2022-01-11 17:38:48.627 196461 ERROR glance for c in columns: 2022-01-11 17:38:48.627 196461 ERROR glance TypeError: 'int' object is not iterable 2022-01-11 17:38:48.627 196461 ERROR glance To manage notifications about this bug go to: https://bugs.launchpad.net/glance/+bug/1957167/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp