missing UC on virtual_interfaces.address in sqlite
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
Fix Released
|
Medium
|
Yuriy Zveryanskyy |
Bug Description
This affects only sqlite: (So probably it is not so important)
In sqlite we are not able to drop Constraints so we are not able to drop columns with constraints.
And deleted columns have type of Boolean which in sqlite has constraint (in (0,1))
So only way that I found was to use shadow tables. (Create new table with correct type of deleted) and copy data from old table to new.. and then drop old table and rename new to old name.
Unfortunately there is probably one more bug in sqlalchemy, for some reason there is no uC in table's constraints.
So we lost all UC in sqlite that ware used.
There is only one table with such problem virtual_
To fix this bug I should add one more db.migration.
I think that this is not so important and could wait for Havana. How do you think?
By the way, I think that we should remove UC on address and make it on
(address, deleted). Then we will be able to use soft_delete instead of delete. So probably it is better to fix it in Havana-1.
Changed in nova: | |
assignee: | nobody → Boris Pavlovic (boris-42) |
status: | New → Incomplete |
status: | Incomplete → New |
description: | updated |
Changed in nova: | |
milestone: | none → grizzly-rc1 |
status: | Fix Committed → Fix Released |
Changed in nova: | |
status: | Fix Released → Confirmed |
importance: | Undecided → Medium |
milestone: | grizzly-rc1 → havana-1 |
Changed in nova: | |
milestone: | havana-1 → none |
Changed in nova: | |
milestone: | none → havana-2 |
status: | Confirmed → In Progress |
Changed in nova: | |
assignee: | Boris Pavlovic (boris-42) → Yuriy Zveryanskyy (yzveryanskyy) |
Changed in nova: | |
status: | Fix Committed → Fix Released |
Changed in nova: | |
milestone: | havana-2 → 2013.2 |
Fix proposed to branch: master /review. openstack. org/24606
Review: https:/