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

Reply via email to