After Upgrade to 16.1, some databases are not migrated

Solution In Progress - Updated -

Issue

  • After Upgrade to 16.1, some databases are not migrated and the following error is seen in /var/log/containers/cinder/cinder-api.log:
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters [req-a7743c67-4870-4e97-b4b2-0291cc01a3c4 cd2eb6cce6f94dde92722e77a2f81e4e 121be694a55a4cdbb9b2a9d4e9897d42 - default default]
 DBAPIError exception wrapped from (pymysql.err.InternalError) (1054, "Unknown column 'transfers.no_snapshots' in 'field list'")
[SQL: SELECT transfers.created_at AS transfers_created_at, transfers.updated_at AS transfers_updated_at, transfers.deleted_at AS transfers_deleted_at, transfers.deleted AS transfers_deleted,
 transfers.id AS transfers_id, transfers.volume_id AS transfers_volume_id, transfers.display_name AS transfers_display_name, transfers.salt AS transfers_salt, transfers.crypt_hash AS transfe
rs_crypt_hash, transfers.expires_at AS transfers_expires_at, transfers.no_snapshots AS transfers_no_snapshots, transfers.source_project_id AS transfers_source_project_id, transfers.destinati
on_project_id AS transfers_destination_project_id, transfers.accepted AS transfers_accepted 
FROM transfers, volumes 
WHERE transfers.deleted = false AND volumes.id = transfers.volume_id AND volumes.project_id = %(project_id_1)s ORDER BY transfers.created_at ASC, transfers.id ASC]
[parameters: {'project_id_1': '121be694a55a4cdbb9b2a9d4e9897d42'}]
(Background on this error at: http://sqlalche.me/e/2j85): pymysql.err.InternalError: (1054, "Unknown column 'transfers.no_snapshots' in 'field list'")
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters     cursor, statement, parameters, context
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters     cursor.execute(statement, parameters)
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python3.6/site-packages/pymysql/cursors.py", line 165, in execute
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters     result = self._query(query)
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python3.6/site-packages/pymysql/cursors.py", line 321, in _query
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters     conn.query(q)
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 860, in query
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 1061, in _read_query_result
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters     result.read()
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 1349, in read
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters     first_packet = self.connection._read_packet()
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 1018, in _read_packet
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters     packet.check_error()
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 384, in check_error
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters     err.raise_mysql_exception(self._data)
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python3.6/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters     raise errorclass(errno, errval)
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters pymysql.err.InternalError: (1054, "Unknown column 'transfers.no_snapshots' in 'field list'")
2021-10-08 16:04:54.488 32 ERROR oslo_db.sqlalchemy.exc_filters 
2021-10-08 16:04:54.490 32 ERROR cinder.api.middleware.fault [req-a7743c67-4870-4e97-b4b2-0291cc01a3c4 cd2eb6cce6f94dde92722e77a2f81e4e 121be694a55a4cdbb9b2a9d4e9897d42 - default default] Ca
ught error: <class 'oslo_db.exception.DBError'> (pymysql.err.InternalError) (1054, "Unknown column 'transfers.no_snapshots' in 'field list'")
[SQL: SELECT transfers.created_at AS transfers_created_at, transfers.updated_at AS transfers_updated_at, transfers.deleted_at AS transfers_deleted_at, transfers.deleted AS transfers_deleted,
 transfers.id AS transfers_id, transfers.volume_id AS transfers_volume_id, transfers.display_name AS transfers_display_name, transfers.salt AS transfers_salt, transfers.crypt_hash AS transfe
rs_crypt_hash, transfers.expires_at AS transfers_expires_at, transfers.no_snapshots AS transfers_no_snapshots, transfers.source_project_id AS transfers_source_project_id, transfers.destinati
on_project_id AS transfers_destination_project_id, transfers.accepted AS transfers_accepted 

Environment

  • Red Hat OpenStack Platform 16.2 (RHOSP)
  • Red Hat OpenStack Platform 16.1 (RHOSP)

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content