[Bug 998137] Re: [SRU] Keystone user tenant membership not always removed
** Changed in: keystone Milestone: folsom-1 => 2012.2 -- 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/998137 Title: [SRU] Keystone user tenant membership not always removed To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/998137/+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 998137] Re: [SRU] Keystone user tenant membership not always removed
This bug was fixed in the package keystone - 2012.1+stable~20120608-aff45d6-0ubuntu1 --- keystone (2012.1+stable~20120608-aff45d6-0ubuntu1) precise-proposed; urgency=low * New usptream snapshot. (LP: #1010473) * Resynchronize with stable/essex: - aff45d6 - Make import_nova_auth only create roles which don't already exist (LP: #959294) * debian/patches/0013-Flush-tenant-membership-deletion-before-user.patch: Backported fix for "Flush tenant membership deletion before user." (LP: #998137) -- Chuck ShortTue, 05 Jun 2012 11:24:02 -0400 ** Changed in: keystone (Ubuntu Precise) 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/998137 Title: [SRU] Keystone user tenant membership not always removed To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/998137/+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 998137] Re: [SRU] Keystone user tenant membership not always removed
Test coverage log. ** Attachment added: "2012.1+stable~20120608-aff45d6-0ubuntu1.log" https://bugs.launchpad.net/bugs/998137/+attachment/3217908/+files/2012.1%2Bstable%7E20120608-aff45d6-0ubuntu1.log ** Tags removed: verification-needed ** Tags added: verification-done -- 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/998137 Title: [SRU] Keystone user tenant membership not always removed To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/998137/+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 998137] Re: [SRU] Keystone user tenant membership not always removed
This update is in proposed for 26 days, could somebody using that software verify the fix so the SRU can be moved to updates? -- 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/998137 Title: [SRU] Keystone user tenant membership not always removed To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/998137/+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 998137] Re: [SRU] Keystone user tenant membership not always removed
** Changed in: keystone (Ubuntu Precise) Milestone: None => ubuntu-12.04.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/998137 Title: [SRU] Keystone user tenant membership not always removed To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/998137/+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 998137] Re: [SRU] Keystone user tenant membership not always removed
** Changed in: keystone/essex 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/998137 Title: [SRU] Keystone user tenant membership not always removed To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/998137/+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 998137] Re: [SRU] Keystone user tenant membership not always removed
** Also affects: keystone/essex Importance: Undecided Status: New ** Changed in: keystone/essex Status: New => Fix Committed ** Changed in: keystone/essex Milestone: None => 2012.1.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/998137 Title: [SRU] Keystone user tenant membership not always removed To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/998137/+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 998137] Re: [SRU] Keystone user tenant membership not always removed
** Branch linked: lp:ubuntu/precise-proposed/keystone -- 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/998137 Title: [SRU] Keystone user tenant membership not always removed To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/998137/+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 998137] Re: [SRU] Keystone user tenant membership not always removed
Hello Adam, or anyone else affected, Accepted keystone into precise-proposed. The package will build now and be available in a few hours. Please test and give feedback here. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation how to enable and use -proposed. Thank you in advance! ** Changed in: keystone (Ubuntu Precise) Status: Confirmed => Fix Committed ** Tags added: verification-needed -- 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/998137 Title: [SRU] Keystone user tenant membership not always removed To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/998137/+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 998137] Re: [SRU] Keystone user tenant membership not always removed
Putting everything in one place, here is the test case: ubuntu@ip-10-252-87-70:~$ tenant_id=$(keystone tenant-create --name testingtenant | grep id | awk '{ print $4 }') ubuntu@ip-10-252-87-70:~$ user_id=$(keystone user-create --name testinguser --pass testing --tenant_id $tenant_id | grep id | awk '{ print $4 }') ubuntu@ip-10-252-87-70:~$ echo $user_id e5e045e898694f46a55fb9483a1c03c4 ubuntu@ip-10-252-87-70:~$ keystone user-delete $user_id 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_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`))') 'DELETE FROM user WHERE user.id = %s' ('e5e045e898694f46a55fb9483a1c03c4',) (HTTP 500) ubuntu@ip-10-252-87-70:~$ keystone user-delete $user_id 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_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`))') 'DELETE FROM user WHERE user.id = %s' ('e5e045e898694f46a55fb9483a1c03c4',) (HTTP 500) ubuntu@ip-10-252-87-70:~$ keystone user-delete $user_id 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_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`))') 'DELETE FROM user WHERE user.id = %s' ('e5e045e898694f46a55fb9483a1c03c4',) (HTTP 500) ubuntu@ip-10-252-87-70:~$ keystone user-delete $user_id 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_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`))') 'DELETE FROM user WHERE user.id = %s' ('e5e045e898694f46a55fb9483a1c03c4',) (HTTP 500) ubuntu@ip-10-252-87-70:~$ keystone user-delete $user_id ubuntu@ip-10-252-87-70:~$ -- 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/998137 Title: [SRU] Keystone user tenant membership not always removed To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/998137/+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 998137] Re: [SRU] Keystone user tenant membership not always removed
** Impact ** The fix for Bug #959294 removes tenant association before attempting to delete the user to avoid a FK constraint error. On some configurations, this is not always reliable. The integirty error still happens, although subsequent attempts to delete user eventually succeed. See shell log at http://paste.ubuntu.com/980372/ ** Development Fix ** This has been addressed in https://review.openstack.org/7353 and fixed in quantal ** Stable Fix ** This has been address in https://review.openstack.org/8403. ** Test case ** Please see http://paste.ubuntu.com/980372/ ** Regression Potential ** Minimal this has been tested in the openstack-ci lab -- 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/998137 Title: [SRU] Keystone user tenant membership not always removed To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/998137/+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 998137] Re: [SRU] Keystone user tenant membership not always removed
** Summary changed: - Keystone user tenant membership not always removed + [SRU] Keystone user tenant membership not always removed -- 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/998137 Title: [SRU] Keystone user tenant membership not always removed To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/998137/+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