yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1957167] Re: glance constraint for sqlalchemy is too low for xena

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: OpenStack Infra <1957167@xxxxxxxxxxxxxxxxxx>
Date: Tue, 25 Jan 2022 16:01:37 -0000
Reply-to: Bug 1957167 <1957167@xxxxxxxxxxxxxxxxxx>
Sender: noreply@xxxxxxxxxxxxx
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 <jokke@xxxxxx>
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
References

[Bug 1957167] [NEW] glance constraint for sqlalchemy is too low for xena
From: Tobias Urdin, 2022-01-12