Migration 152 harms indexes with `deleted` columns

Bug #1191724 reported by Viktor Serhieiev
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
OpenStack Compute (nova)
Fix Released
High
Viktor Serhieiev

Bug Description

Migration 152 changed the type of `deleted` column from Boolean to table.id.type.
Also (as side effect) this migration removed column `deleted` from indexes in mysql and dropped indexes in postgresql.

Tags: db
Changed in nova:
assignee: nobody → Victor Sergeyev (vsergeyev)
Revision history for this message
Boris Pavlovic (boris-42) wrote :

Yeah we should fix this thing at all

Changed in nova:
importance: Undecided → High
milestone: none → havana-2
Changed in nova:
status: New → In Progress
Revision history for this message
Attila Fazekas (afazekas) wrote :

This issue affects the grizzly release as well.

tags: added: grizzly-backport-potential
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to nova (master)

Reviewed: https://review.openstack.org/31175
Committed: http://github.com/openstack/nova/commit/3645ee110c9c1d55f33a51f4fd7a158abf40b2b0
Submitter: Jenkins
Branch: master

commit 3645ee110c9c1d55f33a51f4fd7a158abf40b2b0
Author: Victor Sergeyev <email address hidden>
Date: Fri May 31 12:37:01 2013 +0300

    Fixed columns list in indexes.

    Migration 152 changed the type of `deleted` column from Boolean to
    table.id.type for all tables. Also (as side effect) this migration
    removed column `deleted` from indexes (in MySQL) or removed whole
    indexes (in PostgreSQL). Current migration fixes these indexes.

    Fixes bug 1191724

    Change-Id: I3d95d102f379c3817bb372fefb1b12cf5de8a4db

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: havana-2 → 2013.2
Alan Pevec (apevec)
tags: removed: grizzly-backport-potential
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

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