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
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
