OpenStack Compute (nova)

No foreign key relationships between projects, users and user-project associations

Bug #740344 reported by Tushar Patil
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
OpenStack Compute (nova)
Invalid
Low
Naveed Massjouni

Bug Description

I create a project "project1" and user "user1". After that I add the user "user1" to project "project1", this would add an entry in the table user_project_association. Now I can simply go and delete project "project1" from project DB table leaving user_project_association reference dangling .

I believe this also applies for rest of the foreign key references.
for e.g. instances->fixed_ips

See original description
Tushar Patil (tpatil)
description: updated
Thierry Carrez (ttx)
Changed in nova:
importance: Undecided → Low
status: New → Confirmed
Revision history for this message
John Tran (jtran) wrote :

I'm unable to reproduce the problem.

:~/openstack/trunk$ bin/nova-manage project add --project project1 --user jsmith
:~/openstack/trunk$ sqlite3 lib/nova/nova.sqlite
sqlite> select * from user_project_association;
2011-08-11 21:31:42.372661|||0|admin|defaultproj
2011-08-11 21:34:21.569945|||0|admin|project1
2011-08-11 21:34:42.480300|||0|jsmith|project1
:~/openstack/trunk$ bin/nova-manage project delete project1
:~/openstack/trunk$ sqlite3 lib/nova/nova.sqlite
sqlite> select * from user_project_association;
2011-08-11 21:31:42.372661|||0|admin|defaultproj
sqlite>

Revision history for this message
Rohit Karajgi (rohitk) wrote :

This bug was filed quite some time ago (during Cactus). There's a high probability of it being fixed in Diablo. Which release did you try to reproduce this on?

Revision history for this message
Naveed Massjouni (ironcamel) wrote :

I just tested this and this bug still exists. I tested with a devstack deployment using a mysql backend. I added a user and a project via nova-manage. Then I deleted the project through the database. The user_project_association still exists for the deleted project.

Naveed Massjouni (ironcamel)
Changed in nova:
assignee: nobody → Naveed Massjouni (ironcamel)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to nova (master)

Fix proposed to branch: master
Review: https://review.openstack.org/4828

Changed in nova:
status: Confirmed → In Progress
Revision history for this message
Tom Fifield (fifieldt) wrote :

Patch was abandoned, quoth Vish: "Users and Projects in nova are going away as soon as folsom opens"

Marking as invalid

Changed in nova:
status: In Progress → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.