After Upgrade to 16.1, some databases are not migrated
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.