Tried enabling the endpoint filter extension, and it's failing, error message is:
2015-02-08 08:57:28.919 | 28397 CRITICAL keystone [-] OperationalError: (OperationalError) (1005, "Can't create table 'keystone.project_endpoint_group' (errno: 150)") '\nCREATE TABLE project_endpoint_group (\n\tendpoint_group_id VARCHAR(64) NOT NULL, \n\tproject_id VARCHAR(64) NOT NULL, \n\tPRIMARY KEY (endpoint_group_id, project_id), \n\tFOREIGN KEY(endpoint_group_id) REFERENCES endpoint_group (id)\n)\n\n' ()
More details below....
2015-02-08 08:57:28.919 | 28397 TRACE keystone Traceback (most recent call last): 2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/opt/stack/new/keystone/bin/keystone-manage", line 44, in <module> 2015-02-08 08:57:28.919 | 28397 TRACE keystone cli.main(argv=sys.argv, config_files=config_files) 2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/opt/stack/new/keystone/keystone/cli.py", line 311, in main 2015-02-08 08:57:28.919 | 28397 TRACE keystone CONF.command.cmd_class.main() 2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/opt/stack/new/keystone/keystone/cli.py", line 74, in main 2015-02-08 08:57:28.919 | 28397 TRACE keystone migration_helpers.sync_database_to_version(extension, version) 2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/opt/stack/new/keystone/keystone/common/sql/migration_helpers.py", line 210, in sync_database_to_version 2015-02-08 08:57:28.919 | 28397 TRACE keystone _sync_extension_repo(default_extension, version) 2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/opt/stack/new/keystone/keystone/common/sql/migration_helpers.py", line 200, in _sync_extension_repo 2015-02-08 08:57:28.919 | 28397 TRACE keystone init_version=init_version) 2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration.py", line 79, in db_sync 2015-02-08 08:57:28.919 | 28397 TRACE keystone return versioning_api.upgrade(engine, repository, version) 2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade 2015-02-08 08:57:28.919 | 28397 TRACE keystone return _migrate(url, repository, version, upgrade=True, err=err, **opts) 2015-02-08 08:57:28.919 | 28397 TRACE keystone File "<string>", line 2, in _migrate 2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 160, in with_engine 2015-02-08 08:57:28.919 | 28397 TRACE keystone return f(*a, **kw) 2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate 2015-02-08 08:57:28.919 | 28397 TRACE keystone schema.runchange(ver, change, changeset.step) 2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 93, in runchange 2015-02-08 08:57:28.919 | 28397 TRACE keystone change.run(self.engine, step) 2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 148, in run 2015-02-08 08:57:28.919 | 28397 TRACE keystone script_func(engine) 2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/opt/stack/new/keystone/keystone/contrib/endpoint_filter/migrate_repo/versions/002_add_endpoint_groups.py", line 41, in upgrade 2015-02-08 08:57:28.919 | 28397 TRACE keystone project_endpoint_group_table.create(migrate_engine, checkfirst=True) 2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 707, in create 2015-02-08 08:57:28.919 | 28397 TRACE keystone checkfirst=checkfirst) 2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1616, in _run_visitor 2015-02-08 08:57:28.919 | 28397 TRACE keystone conn._run_visitor(visitorcallable, element, **kwargs) 2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1245, in _run_visitor 2015-02-08 08:57:28.919 | 28397 TRACE keystone **kwargs).traverse_single(element) 2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 120, in traverse_single 2015-02-08 08:57:28.919 | 28397 TRACE keystone return meth(obj, **kw) 2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 732, in visit_table 2015-02-08 08:57:28.920 | 28397 TRACE keystone self.connection.execute(CreateTable(table)) 2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 729, in execute 2015-02-08 08:57:28.920 | 28397 TRACE keystone return meth(self, multiparams, params) 2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 69, in _execute_on_connection 2015-02-08 08:57:28.920 | 28397 TRACE keystone return connection._execute_ddl(self, multiparams, params) 2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 783, in _execute_ddl 2015-02-08 08:57:28.920 | 28397 TRACE keystone compiled 2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 958, in _execute_context 2015-02-08 08:57:28.920 | 28397 TRACE keystone context) 2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1155, in _handle_dbapi_exception 2015-02-08 08:57:28.920 | 28397 TRACE keystone util.raise_from_cause(newraise, exc_info) 2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause 2015-02-08 08:57:28.920 | 28397 TRACE keystone reraise(type(exception), exception, tb=exc_tb) 2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context 2015-02-08 08:57:28.920 | 28397 TRACE keystone context) 2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 436, in do_execute 2015-02-08 08:57:28.920 | 28397 TRACE keystone cursor.execute(statement, parameters) 2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute 2015-02-08 08:57:28.920 | 28397 TRACE keystone self.errorhandler(self, exc, value) 2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler 2015-02-08 08:57:28.920 | 28397 TRACE keystone raise errorclass, errorvalue 2015-02-08 08:57:28.920 | 28397 TRACE keystone OperationalError: (OperationalError) (1005, "Can't create table 'keystone.project_endpoint_group' (errno: 150)") '\nCREATE TABLE project_endpoint_group (\n\tendpoint_group_id VARCHAR(64) NOT NULL, \n\tproject_id VARCHAR(64) NOT NULL, \n\tPRIMARY KEY (endpoint_group_id, project_id), \n\tFOREIGN KEY(endpoint_group_id) REFERENCES endpoint_group (id)\n)\n\n' ()
Tried enabling the endpoint filter extension, and it's failing, error message is:
2015-02-08 08:57:28.919 | 28397 CRITICAL keystone [-] OperationalError: (OperationalError) (1005, "Can't create table 'keystone. project_ endpoint_ group' (errno: 150)") '\nCREATE TABLE project_ endpoint_ group (\n\tendpoint_ group_id VARCHAR(64) NOT NULL, \n\tproject_id VARCHAR(64) NOT NULL, \n\tPRIMARY KEY (endpoint_group_id, project_id), \n\tFOREIGN KEY(endpoint_ group_id) REFERENCES endpoint_group (id)\n)\n\n' ()
More details below....
2015-02-08 08:57:28.919 | 28397 TRACE keystone Traceback (most recent call last): new/keystone/ bin/keystone- manage" , line 44, in <module> argv=sys. argv, config_ files=config_ files) new/keystone/ keystone/ cli.py" , line 311, in main cmd_class. main() new/keystone/ keystone/ cli.py" , line 74, in main helpers. sync_database_ to_version( extension, version) new/keystone/ keystone/ common/ sql/migration_ helpers. py", line 210, in sync_database_ to_version _repo(default_ extension, version) new/keystone/ keystone/ common/ sql/migration_ helpers. py", line 200, in _sync_extension _repo init_version) lib/python2. 7/dist- packages/ oslo_db/ sqlalchemy/ migration. py", line 79, in db_sync api.upgrade( engine, repository, version) lib/python2. 7/dist- packages/ migrate/ versioning/ api.py" , line 186, in upgrade lib/python2. 7/dist- packages/ migrate/ versioning/ util/__ init__. py", line 160, in with_engine lib/python2. 7/dist- packages/ migrate/ versioning/ api.py" , line 366, in _migrate runchange( ver, change, changeset.step) lib/python2. 7/dist- packages/ migrate/ versioning/ schema. py", line 93, in runchange run(self. engine, step) lib/python2. 7/dist- packages/ migrate/ versioning/ script/ py.py", line 148, in run new/keystone/ keystone/ contrib/ endpoint_ filter/ migrate_ repo/versions/ 002_add_ endpoint_ groups. py", line 41, in upgrade endpoint_ group_table. create( migrate_ engine, checkfirst=True) lib/python2. 7/dist- packages/ sqlalchemy/ sql/schema. py", line 707, in create checkfirst) lib/python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1616, in _run_visitor visitor( visitorcallable , element, **kwargs) lib/python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1245, in _run_visitor .traverse_ single( element) lib/python2. 7/dist- packages/ sqlalchemy/ sql/visitors. py", line 120, in traverse_single lib/python2. 7/dist- packages/ sqlalchemy/ sql/ddl. py", line 732, in visit_table .execute( CreateTable( table)) lib/python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 729, in execute lib/python2. 7/dist- packages/ sqlalchemy/ sql/ddl. py", line 69, in _execute_ on_connection _execute_ ddl(self, multiparams, params) lib/python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 783, in _execute_ddl lib/python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 958, in _execute_context lib/python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1155, in _handle_ dbapi_exception from_cause( newraise, exc_info) lib/python2. 7/dist- packages/ sqlalchemy/ util/compat. py", line 199, in raise_from_cause type(exception) , exception, tb=exc_tb) lib/python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 951, in _execute_context lib/python2. 7/dist- packages/ sqlalchemy/ engine/ default. py", line 436, in do_execute execute( statement, parameters) python2. 7/dist- packages/ MySQLdb/ cursors. py", line 174, in execute er(self, exc, value) python2. 7/dist- packages/ MySQLdb/ connections. py", line 36, in defaulterrorhandler project_ endpoint_ group' (errno: 150)") '\nCREATE TABLE project_ endpoint_ group (\n\tendpoint_ group_id VARCHAR(64) NOT NULL, \n\tproject_id VARCHAR(64) NOT NULL, \n\tPRIMARY KEY (endpoint_group_id, project_id), \n\tFOREIGN KEY(endpoint_ group_id) REFERENCES endpoint_group (id)\n)\n\n' ()
2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/opt/stack/
2015-02-08 08:57:28.919 | 28397 TRACE keystone cli.main(
2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/opt/stack/
2015-02-08 08:57:28.919 | 28397 TRACE keystone CONF.command.
2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/opt/stack/
2015-02-08 08:57:28.919 | 28397 TRACE keystone migration_
2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/opt/stack/
2015-02-08 08:57:28.919 | 28397 TRACE keystone _sync_extension
2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/opt/stack/
2015-02-08 08:57:28.919 | 28397 TRACE keystone init_version=
2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.919 | 28397 TRACE keystone return versioning_
2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.919 | 28397 TRACE keystone return _migrate(url, repository, version, upgrade=True, err=err, **opts)
2015-02-08 08:57:28.919 | 28397 TRACE keystone File "<string>", line 2, in _migrate
2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.919 | 28397 TRACE keystone return f(*a, **kw)
2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.919 | 28397 TRACE keystone schema.
2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.919 | 28397 TRACE keystone change.
2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.919 | 28397 TRACE keystone script_func(engine)
2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/opt/stack/
2015-02-08 08:57:28.919 | 28397 TRACE keystone project_
2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.919 | 28397 TRACE keystone checkfirst=
2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.919 | 28397 TRACE keystone conn._run_
2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.919 | 28397 TRACE keystone **kwargs)
2015-02-08 08:57:28.919 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.919 | 28397 TRACE keystone return meth(obj, **kw)
2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.920 | 28397 TRACE keystone self.connection
2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.920 | 28397 TRACE keystone return meth(self, multiparams, params)
2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.920 | 28397 TRACE keystone return connection.
2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.920 | 28397 TRACE keystone compiled
2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.920 | 28397 TRACE keystone context)
2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.920 | 28397 TRACE keystone util.raise_
2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.920 | 28397 TRACE keystone reraise(
2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.920 | 28397 TRACE keystone context)
2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/local/
2015-02-08 08:57:28.920 | 28397 TRACE keystone cursor.
2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/lib/
2015-02-08 08:57:28.920 | 28397 TRACE keystone self.errorhandl
2015-02-08 08:57:28.920 | 28397 TRACE keystone File "/usr/lib/
2015-02-08 08:57:28.920 | 28397 TRACE keystone raise errorclass, errorvalue
2015-02-08 08:57:28.920 | 28397 TRACE keystone OperationalError: (OperationalError) (1005, "Can't create table 'keystone.