Migrations fail going from juno -> kilo
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Identity (keystone) |
Fix Released
|
High
|
Morgan Fainberg | ||
Kilo |
Fix Released
|
Undecided
|
Unassigned | ||
oslo.db |
Invalid
|
High
|
Unassigned |
Bug Description
Trying to upgrade from Juno -> Kilo
keystone-manage db_version
55
keystone-manage db_sync
2015-06-26 16:52:47.494 6169 CRITICAL keystone [-] ProgrammingError: (ProgrammingError) (1146, "Table 'keystone_
2015-06-26 16:52:47.494 6169 TRACE keystone Traceback (most recent call last):
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/kilo/
2015-06-26 16:52:47.494 6169 TRACE keystone execfile(__file__)
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/keystone/
2015-06-26 16:52:47.494 6169 TRACE keystone cli.main(
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/keystone/
2015-06-26 16:52:47.494 6169 TRACE keystone CONF.command.
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/keystone/
2015-06-26 16:52:47.494 6169 TRACE keystone migration_
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/keystone/
2015-06-26 16:52:47.494 6169 TRACE keystone _sync_extension
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/keystone/
2015-06-26 16:52:47.494 6169 TRACE keystone _fix_federation
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/keystone/
2015-06-26 16:52:47.494 6169 TRACE keystone engine.
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/kilo/
2015-06-26 16:52:47.494 6169 TRACE keystone return connection.
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/kilo/
2015-06-26 16:52:47.494 6169 TRACE keystone return self._execute_
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/kilo/
2015-06-26 16:52:47.494 6169 TRACE keystone statement, parameters
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/kilo/
2015-06-26 16:52:47.494 6169 TRACE keystone context)
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/kilo/
2015-06-26 16:52:47.494 6169 TRACE keystone e, statement, parameters, cursor, context)
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/kilo/
2015-06-26 16:52:47.494 6169 TRACE keystone util.raise_
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/kilo/
2015-06-26 16:52:47.494 6169 TRACE keystone reraise(
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/kilo/
2015-06-26 16:52:47.494 6169 TRACE keystone context)
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/kilo/
2015-06-26 16:52:47.494 6169 TRACE keystone cursor.
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/kilo/
2015-06-26 16:52:47.494 6169 TRACE keystone self.errorhandl
2015-06-26 16:52:47.494 6169 TRACE keystone File "/opt/kilo/
2015-06-26 16:52:47.494 6169 TRACE keystone raise errorclass, errorvalue
2015-06-26 16:52:47.494 6169 TRACE keystone ProgrammingError: (ProgrammingError) (1146, "Table 'keystone_
2015-06-26 16:52:47.494 6169 TRACE keystone
If I run the command again I get:
keystone-manage db_version
67
keystone-manage db_sync
2015-06-26 16:53:25.489 6186 CRITICAL keystone [-] ValueError: Tables "endpoint_
2015-06-26 16:53:25.489 6186 TRACE keystone Traceback (most recent call last):
2015-06-26 16:53:25.489 6186 TRACE keystone File "/opt/kilo/
2015-06-26 16:53:25.489 6186 TRACE keystone execfile(__file__)
2015-06-26 16:53:25.489 6186 TRACE keystone File "/opt/keystone/
2015-06-26 16:53:25.489 6186 TRACE keystone cli.main(
2015-06-26 16:53:25.489 6186 TRACE keystone File "/opt/keystone/
2015-06-26 16:53:25.489 6186 TRACE keystone CONF.command.
2015-06-26 16:53:25.489 6186 TRACE keystone File "/opt/keystone/
2015-06-26 16:53:25.489 6186 TRACE keystone migration_
2015-06-26 16:53:25.489 6186 TRACE keystone File "/opt/keystone/
2015-06-26 16:53:25.489 6186 TRACE keystone _sync_common_
2015-06-26 16:53:25.489 6186 TRACE keystone File "/opt/keystone/
2015-06-26 16:53:25.489 6186 TRACE keystone init_version=
2015-06-26 16:53:25.489 6186 TRACE keystone File "/opt/kilo/
2015-06-26 16:53:25.489 6186 TRACE keystone _db_schema_
2015-06-26 16:53:25.489 6186 TRACE keystone File "/opt/kilo/
2015-06-26 16:53:25.489 6186 TRACE keystone ) % ','.join(
2015-06-26 16:53:25.489 6186 TRACE keystone ValueError: Tables "endpoint_
2015-06-26 16:53:25.489 6186 TRACE keystone
Changed in keystone: | |
assignee: | nobody → Morgan Fainberg (mdrnstm) |
status: | New → In Progress |
Changed in keystone: | |
importance: | Undecided → Critical |
importance: | Critical → High |
tags: |
added: utf8-charset removed: utf8-charset-again |
tags: | added: sql |
Changed in keystone: | |
milestone: | none → liberty-3 |
status: | Fix Committed → Fix Released |
Changed in keystone: | |
milestone: | liberty-3 → 8.0.0 |
Should note I'm using stable/kilo branch
Also using mysql with ?charset=utf8