verdi etc # su -s /bin/sh -c "keystone-manage db_sync" keystone
2015-03-30 21:55:55.023 9662 CRITICAL keystone [-] OperationalError: (OperationalError) (1005, 'Can\'t create table `openstack_keystone`.`#sql-a06_2cc4` (errno: 150 "Foreign key constraint is incorrectly formed")') 'ALTER TABLE endpoint ADD CONSTRAINT fk_endpoint_region_id FOREIGN KEY(region_id) REFERENCES region (id)' ()
2015-03-30 21:55:55.023 9662 TRACE keystone Traceback (most recent call last):
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib/python-exec/python2.7/keystone-manage", line 44, in <module>
2015-03-30 21:55:55.023 9662 TRACE keystone     cli.main(argv=sys.argv, config_files=config_files)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/keystone/cli.py", line 307, in main
2015-03-30 21:55:55.023 9662 TRACE keystone     CONF.command.cmd_class.main()
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/keystone/cli.py", line 74, in main
2015-03-30 21:55:55.023 9662 TRACE keystone     migration_helpers.sync_database_to_version(extension, version)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/keystone/common/sql/migration_helpers.py", line 204, in sync_database_to_version
2015-03-30 21:55:55.023 9662 TRACE keystone     _sync_common_repo(version)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/keystone/common/sql/migration_helpers.py", line 160, in _sync_common_repo
2015-03-30 21:55:55.023 9662 TRACE keystone     init_version=init_version)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/oslo/db/sqlalchemy/migration.py", line 79, in db_sync
2015-03-30 21:55:55.023 9662 TRACE keystone     return versioning_api.upgrade(engine, repository, version)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
2015-03-30 21:55:55.023 9662 TRACE keystone     return _migrate(url, repository, version, upgrade=True, err=err, **opts)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "<string>", line 2, in _migrate
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/migrate/versioning/util/__init__.py", line 160, in with_engine
2015-03-30 21:55:55.023 9662 TRACE keystone     return f(*a, **kw)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
2015-03-30 21:55:55.023 9662 TRACE keystone     schema.runchange(ver, change, changeset.step)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/migrate/versioning/schema.py", line 93, in runchange
2015-03-30 21:55:55.023 9662 TRACE keystone     change.run(self.engine, step)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/migrate/versioning/script/py.py", line 148, in run
2015-03-30 21:55:55.023 9662 TRACE keystone     script_func(engine)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/keystone/common/sql/migrate_repo/versions/053_endpoint_to_region_association.py", line 138, in upgrade
2015-03-30 21:55:55.023 9662 TRACE keystone     _migrate_to_region_id(migrate_engine, region_table, endpoint_table)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/keystone/common/sql/migrate_repo/versions/053_endpoint_to_region_association.py", line 90, in _migrate_to_region_id
2015-03-30 21:55:55.023 9662 TRACE keystone     name='fk_endpoint_region_id').create()
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/migrate/changeset/constraint.py", line 44, in create
2015-03-30 21:55:55.023 9662 TRACE keystone     self.__do_imports('constraintgenerator', *a, **kw)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/migrate/changeset/constraint.py", line 32, in __do_imports
2015-03-30 21:55:55.023 9662 TRACE keystone     run_single_visitor(engine, visitorcallable, self, *a, **kw)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/migrate/changeset/databases/visitor.py", line 85, in run_single_visitor
2015-03-30 21:55:55.023 9662 TRACE keystone     fn(element, **kwargs)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/migrate/changeset/ansisql.py", line 288, in visit_migrate_foreign_key_constraint
2015-03-30 21:55:55.023 9662 TRACE keystone     self._visit_constraint(*p, **k)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/migrate/changeset/ansisql.py", line 300, in _visit_constraint
2015-03-30 21:55:55.023 9662 TRACE keystone     self.execute()
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/migrate/changeset/ansisql.py", line 44, in execute
2015-03-30 21:55:55.023 9662 TRACE keystone     return self.connection.execute(self.buffer.getvalue())
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 833, in execute
2015-03-30 21:55:55.023 9662 TRACE keystone     return self._execute_text(object, multiparams, params)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 982, in _execute_text
2015-03-30 21:55:55.023 9662 TRACE keystone     statement, parameters
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1070, in _execute_context
2015-03-30 21:55:55.023 9662 TRACE keystone     context)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1267, in _handle_dbapi_exception
2015-03-30 21:55:55.023 9662 TRACE keystone     util.raise_from_cause(newraise, exc_info)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
2015-03-30 21:55:55.023 9662 TRACE keystone     reraise(type(exception), exception, tb=exc_tb)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1063, in _execute_context
2015-03-30 21:55:55.023 9662 TRACE keystone     context)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 442, in do_execute
2015-03-30 21:55:55.023 9662 TRACE keystone     cursor.execute(statement, parameters)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
2015-03-30 21:55:55.023 9662 TRACE keystone     self.errorhandler(self, exc, value)
2015-03-30 21:55:55.023 9662 TRACE keystone   File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2015-03-30 21:55:55.023 9662 TRACE keystone     raise errorclass, errorvalue
2015-03-30 21:55:55.023 9662 TRACE keystone OperationalError: (OperationalError) (1005, 'Can\'t create table `openstack_keystone`.`#sql-a06_2cc4` (errno: 150 "Foreign key constraint is incorrectly formed")') 'ALTER TABLE endpoint ADD CONSTRAINT fk_endpoint_region_id FOREIGN KEY(region_id) REFERENCES region (id)' ()
2015-03-30 21:55:55.023 9662 TRACE keystone