postgresql schema has leftover zones sequence (should be cells now)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
Fix Released
|
Low
|
Dan Prince |
Bug Description
Using Nova w/ PostgreSQL. It looks like we have a leftover zones sequence that needs to be renamed to its 'cell' equivalent:
--
-- Name: zones_id_seq; Type: SEQUENCE; Schema: public;
--
CREATE SEQUENCE zones_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.zones_id_seq
--
-- Name: zones_id_seq; Type: SEQUENCE OWNED BY; Schema: public;
--
ALTER SEQUENCE zones_id_seq OWNED BY cells.id;
--
-- Name: zones_id_seq; Type: SEQUENCE SET; Schema: public;
--
SELECT pg_catalog.
-------
When renaming tables in our SQLAlchemy script we'll need to be mindful that this leaves behind orphaned sequences on PostgreSQL.
Changed in nova: | |
assignee: | nobody → Dan Prince (dan-prince) |
status: | New → In Progress |
importance: | Undecided → Low |
Changed in nova: | |
milestone: | none → folsom-1 |
Changed in nova: | |
status: | Fix Committed → Fix Released |
Changed in nova: | |
milestone: | folsom-1 → 2012.2 |
Fix proposed to branch: master /review. openstack. org/7154
Review: https:/