Downgrading cinder schema fails when running 018_add_qos_specs.py

Bug #1264360 reported by Alan Meadows on 2013-12-26
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Cinder
Undecided
Alan Meadows

Bug Description

Downgrading the cinder schema fails when running 018_add_qos_specs.py under MySQL. The upgrade path of this schema patch adds the foreign key volume_types_ibfk_1 on table volume_types, and the downgrade does not correspondingly remove it before attempting to drop the qos_specs_id column.

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

Changed in cinder:
assignee: nobody → Alan Meadows (alan-meadows)
status: New → In Progress

Reviewed: https://review.openstack.org/64193
Committed: https://git.openstack.org/cgit/openstack/cinder/commit/?id=8328fc46d783f4ec9286eededafa91afae89cba0
Submitter: Jenkins
Branch: master

commit 8328fc46d783f4ec9286eededafa91afae89cba0
Author: Alan Meadows <email address hidden>
Date: Thu Dec 26 11:12:37 2013 -0800

    Bugfix missing foreign key removal for mysql

    Downgrading the cinder schema fails when running 018_add_qos_specs.py
    under MySQL. The upgrade path of this schema patch adds the foreign
    key volume_types_ibfk_1 on table volume_types, and the downgrade does
    not correspondingly remove it before attempting to drop the
    qos_specs_id column. This update removes the foreign key when
    the engine is mysql prior to dropping the column.

    Change-Id: Ibd3b35ad3b0bd41ad04ab7aeeb28c3ba7e5d255d
    Closes-Bug: #1264360

Changed in cinder:
status: In Progress → Fix Committed
Thierry Carrez (ttx) on 2014-01-22
Changed in cinder:
milestone: none → icehouse-2
status: Fix Committed → Fix Released
Thierry Carrez (ttx) on 2014-04-17
Changed in cinder:
milestone: icehouse-2 → 2014.1
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers