[Bug 959294] Re: Can't delete users
** Also affects: keystone (Ubuntu Precise) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to keystone in Ubuntu. https://bugs.launchpad.net/bugs/959294 Title: Can't delete users To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/959294/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 959294] Re: Can't delete users
Seems the membership removal is not atomic. Opened Bug #998137 to track there. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to keystone in Ubuntu. https://bugs.launchpad.net/bugs/959294 Title: Can't delete users To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/959294/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 959294] Re: Can't delete users
I see the same issue + keystone tenant-delete 6e491a65755745aba0b3062952481d0f No handlers could be found for logger keystoneclient.client An unexpected error prevented the server from fulfilling your request. (IntegrityError) (1451, 'Cannot delete or update a parent row: a foreign key constraint fails (`keystone`.`user_tenant_membership`, CONSTRAINT `user_tenant_membership_ibfk_2` FOREIGN KEY (`tenant_id`) REFERENCES `tenant` (`id`))') 'DELETE FROM tenant WHERE tenant.id = %s' ('6e491a65755745aba0b3062952481d0f',) (HTTP 500) -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to keystone in Ubuntu. https://bugs.launchpad.net/bugs/959294 Title: Can't delete users To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/959294/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 959294] Re: Can't delete users
Something strange is going on. Tested on a fresh folsom devstack: http://paste.ubuntu.com/980372/ It looks like after the 4th failure. After trying this a few times it seems to succeed after a varying number of failed attempts -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to keystone in Ubuntu. https://bugs.launchpad.net/bugs/959294 Title: Can't delete users To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/959294/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 959294] Re: Can't delete users
I was running Keystone with a Postgresql backend. It seems the patch above doesn't solve the problem for Postgresql, I get lots of IntegrityErrors still. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to keystone in Ubuntu. https://bugs.launchpad.net/bugs/959294 Title: Can't delete users To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/959294/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 959294] Re: Can't delete users
** Changed in: keystone (Ubuntu) Status: Confirmed = Fix Released -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to keystone in Ubuntu. https://bugs.launchpad.net/bugs/959294 Title: Can't delete users To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/959294/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 959294] Re: Can't delete users
jdsn: please open a separate bug for this fix ** Changed in: keystone Status: In Progress = Fix Released ** Changed in: keystone Milestone: essex-rc2 = None ** Changed in: keystone Assignee: J. Daniel Schmidt (jdsn) = (unassigned) ** Changed in: keystone Milestone: None = 2012.1 -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to keystone in Ubuntu. https://bugs.launchpad.net/bugs/959294 Title: Can't delete users To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/959294/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 959294] Re: Can't delete users
opened new bug 974199 to track the open issues -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to keystone in Ubuntu. https://bugs.launchpad.net/bugs/959294 Title: Can't delete users To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/959294/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 959294] Re: Can't delete users
FYI: remove tenant * does not delete user association: in bug 974199 * does not delete tenant metadata: in bug 973243 remove user * does not delete tenant association: in bug 959294 * does not delete user metadata: in bug 973243 -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to keystone in Ubuntu. https://bugs.launchpad.net/bugs/959294 Title: Can't delete users To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/959294/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 959294] Re: Can't delete users
Status changed to 'Confirmed' because the bug affects multiple users. ** Changed in: keystone (Ubuntu) Status: New = Confirmed -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to keystone in Ubuntu. https://bugs.launchpad.net/bugs/959294 Title: Can't delete users To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/959294/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 959294] Re: Can't delete users
Fix proposed to branch: master Review: https://review.openstack.org/6216 ** Changed in: keystone Status: Fix Released = In Progress ** Changed in: keystone Assignee: Adam Gandelman (gandelman-a) = J. Daniel Schmidt (jdsn) -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to keystone in Ubuntu. https://bugs.launchpad.net/bugs/959294 Title: Can't delete users To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/959294/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 959294] Re: Can't delete users
** Changed in: keystone Milestone: None = essex-rc2 ** Tags removed: essex-rc-potential -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to keystone in Ubuntu. https://bugs.launchpad.net/bugs/959294 Title: Can't delete users To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/959294/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 959294] Re: Can't delete users
Reviewed: https://review.openstack.org/6109 Committed: http://github.com/openstack/keystone/commit/75a8dfef51f3566cd5d4cacee41f34bbbf9d15bd Submitter: Jenkins Branch:master commit 75a8dfef51f3566cd5d4cacee41f34bbbf9d15bd Author: Adam Gandelman ad...@canonical.com Date: Mon Apr 2 14:21:43 2012 -0700 Remove tenant membership during user deletion Remove users' tenant membership on user deletion. Resolves a FK constraint issue that previously went unnoticed due to testing against database configurations that do not support FK constraints (MyISAM). Fixes LP bug 959294. Update: * Move tenant membership cleanup to the sql identity backend * Add a test case to test_backend_sql Change-Id: Ib4f5da03033f7886b36d1ab3b8b4ac37f08b2e0e ** Changed in: keystone Status: In Progress = Fix Committed -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to keystone in Ubuntu. https://bugs.launchpad.net/bugs/959294 Title: Can't delete users To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/959294/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 959294] Re: Can't delete users
** Changed in: keystone Status: Fix Committed = Fix Released -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to keystone in Ubuntu. https://bugs.launchpad.net/bugs/959294 Title: Can't delete users To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/959294/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 959294] Re: Can't delete users
This is a bug, and is not surfacing in devstack testing because devstack hasn't yet moved to precise. Oneiric MySQL is configured with MyISAM storage engine by default, which means FK constraints are non-existent in the backend and are essentially meaningless. MySQL on Precise uses InnoDB as the default, and FK constraints described in the models exist and are enforced. Using Precise or configuring an Oneiric devstack MySQL install to use InnoDB by default (prior to syncing the database) will reproduce this issue. ** Also affects: keystone (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to keystone in Ubuntu. https://bugs.launchpad.net/bugs/959294 Title: Can't delete users To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/959294/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 959294] Re: Can't delete users
Fix proposed to branch: master Review: https://review.openstack.org/6109 ** Changed in: keystone Status: Incomplete = In Progress ** Changed in: keystone Assignee: Dolph Mathews (dolph) = Adam Gandelman (gandelman-a) -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to keystone in Ubuntu. https://bugs.launchpad.net/bugs/959294 Title: Can't delete users To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/959294/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs