yahoo-eng-team team mailing list archive

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

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Tobias Urdin <1957167@xxxxxxxxxxxxxxxxxx>
Date: Wed, 12 Jan 2022 12:00:00 -0000
Reply-to: Bug 1957167 <1957167@xxxxxxxxxxxxxxxxxx>
Sender: noreply@xxxxxxxxxxxxx
Public bug reported:

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

** Affects: glance
     Importance: Undecided
         Status: New

-- 
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:
  New

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
Follow ups

[Bug 1957167] Re: glance constraint for sqlalchemy is too low for xena
From: OpenStack Infra, 2022-01-25