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>
I'm unable to reproduce the problem.
:~/openstack/trunk$ bin/nova-manage project add --project project1 --user jsmith nova.sqlite association; 372661| ||0|admin| defaultproj 569945| ||0|admin| project1 480300| ||0|jsmith| project1 nova.sqlite association; 372661| ||0|admin| defaultproj
:~/openstack/trunk$ sqlite3 lib/nova/
sqlite> select * from user_project_
2011-08-11 21:31:42.
2011-08-11 21:34:21.
2011-08-11 21:34:42.
:~/openstack/trunk$ bin/nova-manage project delete project1
:~/openstack/trunk$ sqlite3 lib/nova/
sqlite> select * from user_project_
2011-08-11 21:31:42.
sqlite>