octavia

  1. Bug #2061303
  2. Activity log

Activity log for bug #2061303

Date Who What changed Old value New value Message
2024-04-14 17:08:42 Takashi Kajinami bug added bug
2024-04-14 17:09:09 Takashi Kajinami octavia: assignee Takashi Kajinami (kajinamit)
2024-04-14 17:16:19 OpenStack Infra octavia: status New In Progress
2024-04-14 17:17:01 Takashi Kajinami description In the attempt to bump sqlalchemy to 2.0[1] it was caught that octavia-manage command fails with the traceback dumped below. ``` 2024-04-12 11:04:49.332750 | controller | CRITICAL octavia-db-manage Unhandled error: TypeError: Additional arguments should be named <dialectname>_<argument>, got 'autoload' 2024-04-12 11:04:49.332785 | controller | ERROR octavia-db-manage Traceback (most recent call last): 2024-04-12 11:04:49.332803 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/bin/octavia-db-manage", line 10, in <module> 2024-04-12 11:04:49.332816 | controller | ERROR octavia-db-manage sys.exit(main()) ... 2024-04-12 11:04:49.333229 | controller | ERROR octavia-db-manage File "/opt/stack/octavia/octavia/db/migration/alembic_migrations/versions/3b199c848b96_create_no_monitor_operational_status.py", line 33, in upgrade 2024-04-12 11:04:49.333240 | controller | ERROR octavia-db-manage sa.Table('operating_status', md, autoload=True, autoload_with=bind) 2024-04-12 11:04:49.333295 | controller | ERROR octavia-db-manage File "<string>", line 2, in __new__ 2024-04-12 11:04:49.333307 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned 2024-04-12 11:04:49.333319 | controller | ERROR octavia-db-manage return fn(*args, **kwargs) # type: ignore[no-any-return] 2024-04-12 11:04:49.333330 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/sql/schema.py", line 431, in __new__ 2024-04-12 11:04:49.333345 | controller | ERROR octavia-db-manage return cls._new(*args, **kw) 2024-04-12 11:04:49.333359 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/sql/schema.py", line 485, in _new 2024-04-12 11:04:49.333370 | controller | ERROR octavia-db-manage with util.safe_reraise(): 2024-04-12 11:04:49.333382 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__ 2024-04-12 11:04:49.333393 | controller | ERROR octavia-db-manage raise exc_value.with_traceback(exc_tb) 2024-04-12 11:04:49.333404 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/sql/schema.py", line 481, in _new 2024-04-12 11:04:49.333416 | controller | ERROR octavia-db-manage table.__init__(name, metadata, *args, _no_init=False, **kw) 2024-04-12 11:04:49.333427 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/sql/schema.py", line 855, in __init__ 2024-04-12 11:04:49.333440 | controller | ERROR octavia-db-manage self._extra_kwargs(**kw) 2024-04-12 11:04:49.516191 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/sql/schema.py", line 1003, in _extra_kwargs 2024-04-12 11:04:49.516232 | controller | ERROR octavia-db-manage self._validate_dialect_kwargs(kwargs) 2024-04-12 11:04:49.516247 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/sql/base.py", line 596, in _validate_dialect_kwargs 2024-04-12 11:04:49.516283 | controller | ERROR octavia-db-manage raise TypeError( 2024-04-12 11:04:49.516296 | controller | ERROR octavia-db-manage TypeError: Additional arguments should be named <dialectname>_<argument>, got 'autoload' ``` In the attempt to bump sqlalchemy to 2.0[1] it was caught that octavia-manage command fails with the traceback dumped below. [1] https://review.opendev.org/c/openstack/requirements/+/879743 https://zuul.opendev.org/t/openstack/build/77653d12aac244368428f188081db0fa ``` 2024-04-12 11:04:49.332750 | controller | CRITICAL octavia-db-manage Unhandled error: TypeError: Additional arguments should be named <dialectname>_<argument>, got 'autoload' 2024-04-12 11:04:49.332785 | controller | ERROR octavia-db-manage Traceback (most recent call last): 2024-04-12 11:04:49.332803 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/bin/octavia-db-manage", line 10, in <module> 2024-04-12 11:04:49.332816 | controller | ERROR octavia-db-manage sys.exit(main()) ... 2024-04-12 11:04:49.333229 | controller | ERROR octavia-db-manage File "/opt/stack/octavia/octavia/db/migration/alembic_migrations/versions/3b199c848b96_create_no_monitor_operational_status.py", line 33, in upgrade 2024-04-12 11:04:49.333240 | controller | ERROR octavia-db-manage sa.Table('operating_status', md, autoload=True, autoload_with=bind) 2024-04-12 11:04:49.333295 | controller | ERROR octavia-db-manage File "<string>", line 2, in __new__ 2024-04-12 11:04:49.333307 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned 2024-04-12 11:04:49.333319 | controller | ERROR octavia-db-manage return fn(*args, **kwargs) # type: ignore[no-any-return] 2024-04-12 11:04:49.333330 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/sql/schema.py", line 431, in __new__ 2024-04-12 11:04:49.333345 | controller | ERROR octavia-db-manage return cls._new(*args, **kw) 2024-04-12 11:04:49.333359 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/sql/schema.py", line 485, in _new 2024-04-12 11:04:49.333370 | controller | ERROR octavia-db-manage with util.safe_reraise(): 2024-04-12 11:04:49.333382 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__ 2024-04-12 11:04:49.333393 | controller | ERROR octavia-db-manage raise exc_value.with_traceback(exc_tb) 2024-04-12 11:04:49.333404 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/sql/schema.py", line 481, in _new 2024-04-12 11:04:49.333416 | controller | ERROR octavia-db-manage table.__init__(name, metadata, *args, _no_init=False, **kw) 2024-04-12 11:04:49.333427 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/sql/schema.py", line 855, in __init__ 2024-04-12 11:04:49.333440 | controller | ERROR octavia-db-manage self._extra_kwargs(**kw) 2024-04-12 11:04:49.516191 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/sql/schema.py", line 1003, in _extra_kwargs 2024-04-12 11:04:49.516232 | controller | ERROR octavia-db-manage self._validate_dialect_kwargs(kwargs) 2024-04-12 11:04:49.516247 | controller | ERROR octavia-db-manage File "/opt/stack/data/venv/lib/python3.10/site-packages/sqlalchemy/sql/base.py", line 596, in _validate_dialect_kwargs 2024-04-12 11:04:49.516283 | controller | ERROR octavia-db-manage raise TypeError( 2024-04-12 11:04:49.516296 | controller | ERROR octavia-db-manage TypeError: Additional arguments should be named <dialectname>_<argument>, got 'autoload' ```
2024-04-15 03:09:53 Takashi Kajinami summary SQLAlchemy 2.0: octavia-manage fails with "TypeError: Additional arguments should be named <dialectname>_<argument>, got 'autoload'" SQLAlchemy 2.0: octavia-db-manage fails with "TypeError: Additional arguments should be named <dialectname>_<argument>, got 'autoload'"
2024-04-16 10:18:20 OpenStack Infra octavia: status In Progress Fix Released