[Yahoo-eng-team] [Bug 1957167] [NEW] glance constraint for sqlalchemy is too low for xena

Tobias Urdin Wed, 12 Jan 2022 04:05:59 -0800

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


-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp

[Yahoo-eng-team] [Bug 1957167] [NEW] glance constraint for sqlalchemy is too low for xena

Reply via email to