db sync on federation failed if there is existing data
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Identity (keystone) |
Fix Released
|
High
|
Marek Denis |
Bug Description
If you have an existing entry in the identity_provider table, when updating from juno to kilo, it fails with the following error
OperationalError: (OperationalError) (1048, "Column 'remote_id' cannot be null") 'INSERT INTO idp_remote_ids (idp_id, remote_id) VALUES (%s, %s)' ('https:/
The migrate_repo goes from 2 to 6 and it failes in step 7.
The issue is linked to a new field created on identity_provider table called 'remote_id' that it is created in step 3 and left empty.
Then on step 7 it tries to read to insert into the idp_remote_ids that does not accept null values.
2015-07-28 15:04:00.247 18168 TRACE keystone Traceback (most recent call last):
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/bin/
2015-07-28 15:04:00.247 18168 TRACE keystone cli.main(
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib/
2015-07-28 15:04:00.247 18168 TRACE keystone CONF.command.
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib/
2015-07-28 15:04:00.247 18168 TRACE keystone migration_
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib/
2015-07-28 15:04:00.247 18168 TRACE keystone _sync_extension
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib/
2015-07-28 15:04:00.247 18168 TRACE keystone init_version=
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib/
2015-07-28 15:04:00.247 18168 TRACE keystone return versioning_
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib/
2015-07-28 15:04:00.247 18168 TRACE keystone return _migrate(url, repository, version, upgrade=True, err=err, **opts)
2015-07-28 15:04:00.247 18168 TRACE keystone File "<string>", line 2, in _migrate
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib/
2015-07-28 15:04:00.247 18168 TRACE keystone return f(*a, **kw)
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib/
2015-07-28 15:04:00.247 18168 TRACE keystone schema.
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib/
2015-07-28 15:04:00.247 18168 TRACE keystone change.
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib/
2015-07-28 15:04:00.247 18168 TRACE keystone script_func(engine)
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib/
2015-07-28 15:04:00.247 18168 TRACE keystone remote_
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib64/
2015-07-28 15:04:00.247 18168 TRACE keystone return e._execute_
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib64/
2015-07-28 15:04:00.247 18168 TRACE keystone return connection.
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib64/
2015-07-28 15:04:00.247 18168 TRACE keystone compiled_sql, distilled_params
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib64/
2015-07-28 15:04:00.247 18168 TRACE keystone context)
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib/
2015-07-28 15:04:00.247 18168 TRACE keystone e, statement, parameters, cursor, context)
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib64/
2015-07-28 15:04:00.247 18168 TRACE keystone util.raise_
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib64/
2015-07-28 15:04:00.247 18168 TRACE keystone reraise(
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib64/
2015-07-28 15:04:00.247 18168 TRACE keystone context)
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib64/
2015-07-28 15:04:00.247 18168 TRACE keystone cursor.
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib64/
2015-07-28 15:04:00.247 18168 TRACE keystone self.errorhandl
2015-07-28 15:04:00.247 18168 TRACE keystone File "/usr/lib64/
2015-07-28 15:04:00.247 18168 TRACE keystone raise errorclass, errorvalue
2015-07-28 15:04:00.247 18168 TRACE keystone OperationalError: (OperationalError) (1048, "Column 'remote_id' cannot be null") 'INSERT INTO idp_remote_ids (idp_id, remote_id) VALUES (%s, %s)' ('https:/
Changed in keystone: | |
assignee: | nobody → Marek Denis (marek-denis) |
tags: | added: federation sql |
Changed in keystone: | |
status: | New → Triaged |
importance: | Undecided → High |
tags: | added: rc-potential |
Changed in keystone: | |
milestone: | none → liberty-rc2 |
status: | Fix Committed → Fix Released |
Changed in keystone: | |
milestone: | liberty-rc2 → 8.0.0 |
Fix proposed to branch: master /review. openstack. org/206561
Review: https:/