Bug 1479327
Summary: | OSP10 -> OSP11 upgrade: major upgrade composable step fails on composable roles deployment while running cinder-manage db sync | ||
---|---|---|---|
Product: | Red Hat OpenStack | Reporter: | Marius Cornea <mcornea> |
Component: | openstack-tripleo-heat-templates | Assignee: | Sofer Athlan-Guyot <sathlang> |
Status: | CLOSED ERRATA | QA Contact: | Marius Cornea <mcornea> |
Severity: | urgent | Docs Contact: | |
Priority: | high | ||
Version: | 11.0 (Ocata) | CC: | ccollett, dbecker, jjoyce, mbultel, mburns, morazi, rhel-osp-director-maint, sathlang |
Target Milestone: | z3 | Keywords: | Regression, Triaged, ZStream |
Target Release: | 11.0 (Ocata) | ||
Hardware: | Unspecified | ||
OS: | Unspecified | ||
Whiteboard: | |||
Fixed In Version: | openstack-tripleo-heat-templates-6.2.1-2.el7ost | Doc Type: | Bug Fix |
Doc Text: |
Previously, upgrading a composable roles deployment running cinder-manage db sync would fail with duplicate columns in the cinder database. This was because cinder-manage db sync was run multiple times. With this update, the sync only runs only one controller. As a result, the cinder database schema successfully upgrades.
|
Story Points: | --- |
Clone Of: | Environment: | ||
Last Closed: | 2017-10-31 17:37:35 UTC | Type: | Bug |
Regression: | --- | Mount Type: | --- |
Documentation: | --- | CRM: | |
Verified Versions: | Category: | --- | |
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
Cloudforms Team: | --- | Target Upstream Version: | |
Embargoed: |
Description
Marius Cornea
2017-08-08 11:24:50 UTC
We have this exception in the cinder-manage.log of ctl0, 2017-08-08 11:10:19.121 359275 INFO migrate.versioning.api [-] 89 -> 90... 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped from (pymysql.err.InternalError) (1060, u"Duplicate column name 'race_preventer'") [SQL: u'\nALTER TABLE workers ADD race_preventer INTEGER NOT NULL DEFAULT 0'] 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last): 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters context) 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters) 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query) 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q) 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 841, in query 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered) 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1029, in _read_query_result 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters result.read() 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1312, in read 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet() 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 991, in _read_packet 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error() 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data) 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errval) 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters InternalError: (1060, u"Duplicate column name 'race_preventer'") 2017-08-08 11:10:19.137 359275 ERROR oslo_db.sqlalchemy.exc_filters 2017-08-08 11:10:19.140 359275 CRITICAL cinder [-] DBError: (pymysql.err.InternalError) (1060, u"Duplicate column name 'race_preventer'") [SQL: u'\nALTER TABLE workers ADD race_preventer INTEGER NOT NULL DEFAULT 0'] and we can see that the migration already happened on ctl1: 2017-08-08 11:10:18.959 349866 DEBUG migrate.versioning.repository [-] Config: OrderedDict([('db_settings', OrderedDict([('__name__', 'db_settings'), ('repository_id', 'cinder'), ('version_table', 'migrate_version'), ('required_dbs', '[]')]))]) __init__ /usr/lib/python2.7/site-packages/migrate/versioning/repository.py:83 2017-08-08 11:10:18.969 349866 INFO migrate.versioning.api [-] 79 -> 80... 2017-08-08 11:10:18.977 349866 INFO migrate.versioning.api [-] done 2017-08-08 11:10:18.977 349866 INFO migrate.versioning.api [-] 80 -> 81... 2017-08-08 11:10:18.982 349866 INFO migrate.versioning.api [-] done 2017-08-08 11:10:18.983 349866 INFO migrate.versioning.api [-] 81 -> 82... 2017-08-08 11:10:18.988 349866 INFO migrate.versioning.api [-] done 2017-08-08 11:10:18.989 349866 INFO migrate.versioning.api [-] 82 -> 83... 2017-08-08 11:10:18.994 349866 INFO migrate.versioning.api [-] done 2017-08-08 11:10:18.995 349866 INFO migrate.versioning.api [-] 83 -> 84... 2017-08-08 11:10:19.000 349866 INFO migrate.versioning.api [-] done 2017-08-08 11:10:19.000 349866 INFO migrate.versioning.api [-] 84 -> 85... 2017-08-08 11:10:19.025 349866 INFO migrate.versioning.api [-] done 2017-08-08 11:10:19.025 349866 INFO migrate.versioning.api [-] 85 -> 86... 2017-08-08 11:10:19.053 349866 INFO migrate.versioning.api [-] done 2017-08-08 11:10:19.053 349866 INFO migrate.versioning.api [-] 86 -> 87... 2017-08-08 11:10:19.068 349866 INFO migrate.versioning.api [-] done 2017-08-08 11:10:19.068 349866 INFO migrate.versioning.api [-] 87 -> 88... 2017-08-08 11:10:19.101 349866 INFO migrate.versioning.api [-] done 2017-08-08 11:10:19.101 349866 INFO migrate.versioning.api [-] 88 -> 89... 2017-08-08 11:10:19.117 349866 INFO migrate.versioning.api [-] done 2017-08-08 11:10:19.117 349866 INFO migrate.versioning.api [-] 89 -> 90... 2017-08-08 11:10:19.142 349866 INFO migrate.versioning.api [-] done 2017-08-08 11:10:19.142 349866 INFO migrate.versioning.api [-] 90 -> 91... 2017-08-08 11:10:19.175 349866 INFO migrate.versioning.api [-] done 2017-08-08 11:10:19.175 349866 INFO migrate.versioning.api [-] 91 -> 92... 2017-08-08 11:10:19.181 349866 INFO migrate.versioning.api [-] done 2017-08-08 11:10:19.182 349866 INFO migrate.versioning.api [-] 92 -> 93... 2017-08-08 11:10:19.187 349866 INFO migrate.versioning.api [-] done 2017-08-08 11:10:19.188 349866 INFO migrate.versioning.api [-] 93 -> 94... 2017-08-08 11:10:19.194 349866 INFO migrate.versioning.api [-] done 2017-08-08 11:10:19.194 349866 INFO migrate.versioning.api [-] 94 -> 95... 2017-08-08 11:10:19.202 349866 INFO migrate.versioning.api [-] done 2017-08-08 11:10:19.202 349866 INFO migrate.versioning.api [-] 95 -> 96... 2017-08-08 11:10:19.210 349866 INFO migrate.versioning.api [-] done hence the duplicate error. Backported to stable/ocata upstream. Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2017:3098 |