mysql downgrade fails in 002_quota_class.py

Bug #1265944 reported by Jay Bryant on 2014-01-04
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Cinder
Undecided
Jay Bryant

Bug Description

mysql downgrade fails due to an attempt to delete the quota_classes table where the reservations table still has a foreign key defined.

Similar to the changes made in migration 018_add_qos_specs.py the foreign key needs to be deleted before the table can be deleted.

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

Changed in cinder:
assignee: nobody → Jay Bryant (jsbryant)
status: New → In Progress

Reviewed: https://review.openstack.org/65131
Committed: https://git.openstack.org/cgit/openstack/cinder/commit/?id=1babca0b8ffc86918729f2d4ad604c32f0b8deeb
Submitter: Jenkins
Branch: master

commit 1babca0b8ffc86918729f2d4ad604c32f0b8deeb
Author: Jay S. Bryant <email address hidden>
Date: Mon Jan 6 12:44:26 2014 -0600

    Fix downgrade in 002_quota_class.py for MySQL

    Downgrade in the script 002_quota_class.py is failing for MySQL
    because there is an attempt to delete the quota_classes table
    while the reservations table still has a foreign key defined.
    The foreign key causes the delete of the quota_classes table to fail.

    This change is based upon commit 8328fc46d783f4ec9286eededafa91afae89cba0
    which makes a similar change to 018_add_qos_specs.py .

    Change-Id: I81844a2da4fb3b831f1f9dead3634e82f54e559e
    Closes-bug: 1265944

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