OpenStack Compute (nova)

Migration 98 subquery fails using MySQL

Bug #1047665 reported by Brian Waldon
6
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 with the following error on MySQL:

2012-08-27 13:26:54 TRACE nova OperationalError: (OperationalError) (1093, "You can't specify target table 'volumes' for update in FROM clause") 'UPDATE volumes SET attachtime_datetime=(SELECT volumes.attach_time \nFROM volumes \nWHERE volumes.id = %s) WHERE volumes.id = %s' ('2362d29a-7db1-4fc5-b131-e89d8992909c', '2362d29a-7db1-4fc5-b131-e89d8992909c')

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to nova (master)

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

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to nova (master)

Reviewed: https://review.openstack.org/12616
Committed: http://github.com/openstack/nova/commit/43ae413da583509448d82ce4ab48f8c8a66a9eb5
Submitter: Jenkins
Branch: master

commit 43ae413da583509448d82ce4ab48f8c8a66a9eb5
Author: Brian Waldon <email address hidden>
Date: Fri Sep 7 15:56:54 2012 -0700

    Execute attach_time query earlier in migration 98

    MySQL was blowing up when sqlalchemy tried to execute the subqueries
    in up/downgrade for migration 98. SQLite wasn't blowing up on this so
    the tests were passing in Jenkins.

    There are no test changes as it depends on the functional environment
    in which you run the tests, not the tests themselves.

    Fixes bug 1047665

    Change-Id: I6eb3c8dd03495cdda2574efc9b5fc2b495fbcb37

Changed in nova:
status: In Progress → Fix Committed
Thierry Carrez (ttx)
Changed in nova:
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in nova:
milestone: folsom-rc1 → 2012.2
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.