Add real unique keys to nova's database
* change soft delete to `deleted`=`id` instead of `deleted`=1.
* Add unique indexes on (`col`, `deleted`)for critical tables.
Blueprint information
- Status:
- Complete
- Approver:
- Russell Bryant
- Priority:
- High
- Drafter:
- None
- Direction:
- Approved
- Assignee:
- Boris Pavlovic
- Definition:
- Approved
- Series goal:
- Accepted for grizzly
- Implementation:
- Implemented
- Milestone target:
- 2013.1
- Started by
- Russell Bryant
- Completed by
- Vish Ishaya
Related branches
Related bugs
Sprints
Whiteboard
Gerrit topic: https:/
Addressed by: https:/
Fix error with Duplicate exception not being raised
Addressed by: https:/
Provide creating real unique indexes for columns.
Addressed by: https:/
Fix error in test_get_
Addressed by: https:/
Remove restoring soft deleted entries
Addressed by: https:/
Remove restoring soft deleted entries part 2
Changed priority from medium to high since it blocks db-archiving, which was high priority. --Russell
Addressed by: https:/
Add generic UC dropper
Addressed by: https:/
Remove race condition (in TaskLog)
Addressed by: https:/
Fix typo/bug in generic UC dropper
Addressed by: https:/
Add generic dropper for duplicate rows
Addressed by: https:/
Add DBDuplicateEntry exception for unique constraint violations
Work Items
Dependency tree
* Blueprints in grey have been implemented.