yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1419481] [NEW] endpoint filter database doesn't upgrade to schema 002

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Steve Martinelli <stevemar@xxxxxxxxxx>
Date: Sun, 08 Feb 2015 17:29:05 -0000
Reply-to: Bug 1419481 <1419481@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

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' ()

** Affects: keystone
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Keystone.
https://bugs.launchpad.net/bugs/1419481

Title:
  endpoint filter database doesn't upgrade to schema 002

Status in OpenStack Identity (Keystone):
  New

Bug description:
  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' ()

To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1419481/+subscriptions
Follow ups

[Bug 1419481] [NEW] endpoint filter database doesn't upgrade to schema 002
From: Steve Martinelli, 2015-02-08
References

[Bug 1419481] [NEW] endpoint filter database doesn't upgrade to schema 002
From: Steve Martinelli, 2015-02-08