OpenStack Compute (nova)

Migration 98 fails with volume data in db

Bug #1047633 reported by Brian Waldon on 2012-09-07

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	OpenStack Compute (nova)	Fix Released	Critical	Brian Waldon	OpenStack Compute (nova) 2012.2 "folsom"

Bug Description

Database migration 98 fails when any volumes exist in the database:

2012-08-27 23:11:38 TRACE nova ProgrammingError: (ProgrammingError) (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE volumes.id = '6a8630ac-d5a6-4026-8cc5-c085586e3e4a'' at line 1") 'UPDATE volumes SET WHERE volumes.id = %s' ('6a8630ac-d5a6-4026-8cc5-c085586e3e4a',)

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2012-09-07: Fix proposed to nova (master)

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

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2012-09-07: Fix merged to nova (master)

Reviewed: https://review.openstack.org/12606
Committed: http://github.com/openstack/nova/commit/4c2f6fee6907db503504ec38af947ce790a2d38d
Submitter: Jenkins
Branch: master

commit 4c2f6fee6907db503504ec38af947ce790a2d38d
Author: Brian Waldon <email address hidden>
Date: Fri Sep 7 13:59:29 2012 -0700

Refer to correct column names in migration 98

    Database migration 98 was referring to local variables rather than
    actual column names in update calls. This patch changes those
    references to be the actual column names.

Fixes bug 1047633

Change-Id: I8ceead5be32f5f56b7d15c8bed23836b29fb382a