← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1419546] [NEW] endpoint filter tables cannot drop from v002

 

Public bug reported:

$ keystone-manage db_sync --extension endpoint_filter 1

28997 DEBUG migrate.versioning.repository [-] Config: OrderedDict([('db_settings', OrderedDict([('__name__', 'db_settings'), ('repository_id', 'endpoint_filter'), ('version_table', 'migrate_version'), ('required_dbs', '[]'), ('use_timestamp_numbering', 'False')]))]) __init__ /usr/local/lib/python2.7/dist-packages/migrate/versioning/repository.py:83
28997 INFO migrate.versioning.api [-] 2 -> 1... 
28997 ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped from (IntegrityError) (1217, 'Cannot delete or update a parent row: a foreign key constraint fails') '\nDROP TABLE endpoint_group' ()
28997 TRACE oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
28997 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
28997 TRACE oslo_db.sqlalchemy.exc_filters     context)
28997 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 436, in do_execute
28997 TRACE oslo_db.sqlalchemy.exc_filters     cursor.execute(statement, parameters)
28997 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
28997 TRACE oslo_db.sqlalchemy.exc_filters     self.errorhandler(self, exc, value)
28997 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
28997 TRACE oslo_db.sqlalchemy.exc_filters     raise errorclass, errorvalue
28997 TRACE oslo_db.sqlalchemy.exc_filters IntegrityError: (1217, 'Cannot delete or update a parent row: a foreign key constraint fails')
28997 TRACE oslo_db.sqlalchemy.exc_filters 
28997 CRITICAL keystone [-] DBError: (IntegrityError) (1217, 'Cannot delete or update a parent row: a foreign key constraint fails') '\nDROP TABLE endpoint_group' ()

** Affects: keystone
     Importance: Undecided
     Assignee: Steve Martinelli (stevemar)
         Status: In Progress

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

Title:
  endpoint filter tables cannot drop from v002

Status in OpenStack Identity (Keystone):
  In Progress

Bug description:
  $ keystone-manage db_sync --extension endpoint_filter 1

  28997 DEBUG migrate.versioning.repository [-] Config: OrderedDict([('db_settings', OrderedDict([('__name__', 'db_settings'), ('repository_id', 'endpoint_filter'), ('version_table', 'migrate_version'), ('required_dbs', '[]'), ('use_timestamp_numbering', 'False')]))]) __init__ /usr/local/lib/python2.7/dist-packages/migrate/versioning/repository.py:83
  28997 INFO migrate.versioning.api [-] 2 -> 1... 
  28997 ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped from (IntegrityError) (1217, 'Cannot delete or update a parent row: a foreign key constraint fails') '\nDROP TABLE endpoint_group' ()
  28997 TRACE oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
  28997 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
  28997 TRACE oslo_db.sqlalchemy.exc_filters     context)
  28997 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 436, in do_execute
  28997 TRACE oslo_db.sqlalchemy.exc_filters     cursor.execute(statement, parameters)
  28997 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
  28997 TRACE oslo_db.sqlalchemy.exc_filters     self.errorhandler(self, exc, value)
  28997 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
  28997 TRACE oslo_db.sqlalchemy.exc_filters     raise errorclass, errorvalue
  28997 TRACE oslo_db.sqlalchemy.exc_filters IntegrityError: (1217, 'Cannot delete or update a parent row: a foreign key constraint fails')
  28997 TRACE oslo_db.sqlalchemy.exc_filters 
  28997 CRITICAL keystone [-] DBError: (IntegrityError) (1217, 'Cannot delete or update a parent row: a foreign key constraint fails') '\nDROP TABLE endpoint_group' ()

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


Follow ups

References