Open Stack

Hi,

I am trying to upgrade glance from wallaby to xena. The package upgrade
goes successful. Vut When I am doing database upgrade. Its showing me below
error. Can you guys please advise on it.

su -s /bin/bash glance -c "glance-manage db_upgrade"
2021-10-18 12:23:59.852 20534 DEBUG oslo_db.sqlalchemy.engines [-] MySQL
server mode set to
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
_check_effective_sql_mode
/usr/lib/python3/dist-packages/oslo_db/sqlalchemy/engines.py:314
2021-10-18 12:23:59.868 20534 CRITICAL glance [-] Unhandled error:
TypeError: argument of type 'NoneType' is not iterable
2021-10-18 12:23:59.868 20534 ERROR glance Traceback (most recent call
last):
2021-10-18 12:23:59.868 20534 ERROR glance   File "/usr/bin/glance-manage",
line 10, in <module>
2021-10-18 12:23:59.868 20534 ERROR glance     sys.exit(main())
2021-10-18 12:23:59.868 20534 ERROR glance   File
"/usr/lib/python3/dist-packages/glance/cmd/manage.py", line 557, in main
2021-10-18 12:23:59.868 20534 ERROR glance     return
CONF.command.action_fn()
2021-10-18 12:23:59.868 20534 ERROR glance   File
"/usr/lib/python3/dist-packages/glance/cmd/manage.py", line 385, in upgrade
2021-10-18 12:23:59.868 20534 ERROR glance
self.command_object.upgrade(CONF.command.version)
2021-10-18 12:23:59.868 20534 ERROR glance   File
"/usr/lib/python3/dist-packages/glance/cmd/manage.py", line 127, in upgrade
2021-10-18 12:23:59.868 20534 ERROR glance     self._sync(version)
2021-10-18 12:23:59.868 20534 ERROR glance   File
"/usr/lib/python3/dist-packages/glance/cmd/manage.py", line 176, in _sync
2021-10-18 12:23:59.868 20534 ERROR glance
alembic_command.upgrade(a_config, version)
2021-10-18 12:23:59.868 20534 ERROR glance   File
"/usr/lib/python3/dist-packages/alembic/command.py", line 277, in upgrade
2021-10-18 12:23:59.868 20534 ERROR glance     if ":" in revision:
2021-10-18 12:23:59.868 20534 ERROR glance TypeError: argument of type
'NoneType' is not iterable
2021-10-18 12:23:59.868 20534 ERROR glance

However the db_sync was successful and below is the DB version detail.

su -s /bin/bash glance -c "glance-manage db_version"
2021-10-18 12:25:14.780 20683 DEBUG oslo_db.sqlalchemy.engines [-] MySQL
server mode set to
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
_check_effective_sql_mode
/usr/lib/python3/dist-packages/oslo_db/sqlalchemy/engines.py:314
2021-10-18 12:25:14.783 20683 INFO alembic.runtime.migration [-] Context
impl MySQLImpl.
2021-10-18 12:25:14.784 20683 INFO alembic.runtime.migration [-] Will
assume non-transactional DDL.
wallaby_contract01

su -s /bin/bash glance -c "glance-manage db_sync"
2021-10-18 12:25:25.773 20712 DEBUG oslo_db.sqlalchemy.engines [-] MySQL
server mode set to
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
_check_effective_sql_mode
/usr/lib/python3/dist-packages/oslo_db/sqlalchemy/engines.py:314
2021-10-18 12:25:25.776 20712 INFO alembic.runtime.migration [-] Context
impl MySQLImpl.
2021-10-18 12:25:25.776 20712 INFO alembic.runtime.migration [-] Will
assume non-transactional DDL.
Database is up to date. No migrations needed.

-- 
Regards,


Syed Ammad Ali
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20211018/dd67d4df/attachment.htm>