new keystone db migrations require either SUPER or log_bin_trust_function_creators=1
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Identity (keystone) |
Fix Released
|
Medium
|
Richard | ||
puppet-keystone |
Won't Fix
|
Undecided
|
Unassigned |
Bug Description
Upgrade Process Docs: http://
The new keystone upgrade features (keystone-manage db_sync --expand) require either that the keystone user has SUPER or that
set global log_bin_
I'm not sure which is the better option but logging this anyway.
Without that you get this error:
root@dev01-
2016-11-01 19:56:17.803 1 INFO migrate.
2016-11-01 19:56:17.821 1 INFO migrate.
2016-11-01 19:56:17.821 1 INFO migrate.
2016-11-01 19:56:17.839 1 INFO migrate.
2016-11-01 19:56:17.839 1 INFO migrate.
2016-11-01 19:56:17.855 1 INFO migrate.
2016-11-01 19:56:17.856 1 INFO migrate.
2016-11-01 19:56:17.897 1 INFO migrate.
2016-11-01 19:56:17.897 1 INFO migrate.
2016-11-01 19:56:17.961 1 INFO migrate.
2016-11-01 19:56:17.961 1 INFO migrate.
2016-11-01 19:56:18.108 1 INFO migrate.
2016-11-01 19:56:18.109 1 INFO migrate.
2016-11-01 19:56:18.132 1 INFO migrate.
2016-11-01 19:56:18.132 1 INFO migrate.
2016-11-01 19:56:18.454 1 INFO migrate.
2016-11-01 19:56:18.455 1 INFO migrate.
2016-11-01 19:56:18.680 1 INFO migrate.
2016-11-01 19:56:18.680 1 INFO migrate.
2016-11-01 19:56:18.968 1 INFO migrate.
2016-11-01 19:56:18.968 1 INFO migrate.
2016-11-01 19:56:19.324 1 INFO migrate.
2016-11-01 19:56:19.325 1 INFO migrate.
2016-11-01 19:56:19.477 1 INFO migrate.
2016-11-01 19:56:19.534 1 INFO migrate.
2016-11-01 19:56:19.550 1 INFO migrate.
2016-11-01 19:56:19.550 1 INFO migrate.
2016-11-01 19:56:19.569 1 INFO migrate.
2016-11-01 19:56:19.569 1 INFO migrate.
2016-11-01 19:56:19.881 1 CRITICAL keystone [-] OperationalError: (_mysql_
2016-11-01 19:56:19.881 1 ERROR keystone Traceback (most recent call last):
2016-11-01 19:56:19.881 1 ERROR keystone File "/usr/bin/
2016-11-01 19:56:19.881 1 ERROR keystone sys.exit(main())
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone cli.main(
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone CONF.command.
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone migration_
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone _sync_repo(
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone init_version=
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone migration = versioning_
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone return _migrate(url, repository, version, upgrade=True, err=err, **opts)
2016-11-01 19:56:19.881 1 ERROR keystone File "<decorator-
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone return f(*a, **kw)
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone schema.
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone change.
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone script_func(engine)
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone migrate_
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone return connection.
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone return self._execute_
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone statement, parameters
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone context)
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone util.raise_
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone reraise(
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone context)
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone cursor.
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone self.errorhandl
2016-11-01 19:56:19.881 1 ERROR keystone File "/venv/
2016-11-01 19:56:19.881 1 ERROR keystone raise errorclass, errorvalue
2016-11-01 19:56:19.881 1 ERROR keystone OperationalError: (_mysql_
at minimum we need to update our upgrade docs