Glance

glance constraint for sqlalchemy is too low for xena

Bug #1957167 reported by Tobias Urdin on 2022-01-12

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	Glance	Fix Released	Undecided	Erno Kuvaja	Glance xena-3

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

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2022-01-21: Fix proposed to glance (master)

Fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/glance/+/825783

Changed in glance:
status:	New → In Progress

Erno Kuvaja (jokke) on 2022-01-21

Changed in glance:
milestone:	none → xena-3
assignee:	nobody → Erno Kuvaja (jokke)

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2022-01-25: Fix merged to glance (master)

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 <email address hidden>
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

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2022-01-25: Fix proposed to glance (stable/xena)

Fix proposed to branch: stable/xena
Review: https://review.opendev.org/c/openstack/glance/+/826220

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2022-03-03: Fix included in openstack/glance 24.0.0.0rc1

This issue was fixed in the openstack/glance 24.0.0.0rc1 release candidate.

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2022-07-07: Change abandoned on glance (stable/xena)

Change abandoned by "Abhishek Kekane <email address hidden>" on branch: stable/xena
Review: https://review.opendev.org/c/openstack/glance/+/826220
Reason: Not required any more!

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.