Glance

031 migration script failed on DB2

Bug #1256816 reported by Feilong Wang
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Glance
Fix Released
Medium
Ma Wen Cheng
Glance 2014.1 "icehouse"

Bug Description

031 script doesn't work on DB2, because DB2 doesn't support GROUP BY against TEXT. So this bug is opened to track seeking a better way to implement it cross-database. See https://review.openstack.org/#/c/56663/13

Feilong Wang (flwang)
Changed in glance:
assignee: nobody → Fei Long Wang (flwang)
Revision history for this message
Flavio Percoco (flaper87) wrote :

FWIW, the first version of the migration was pure python.

https://review.openstack.org/#/c/56663/4/glance/db/sqlalchemy/migrate_repo/versions/031_remove_duplicated_locations.py

Changed in glance:
importance: Undecided → Low
importance: Low → Medium
status: New → Triaged
Revision history for this message
Zhi Yan Liu (lzy-dev) wrote :

Current I have one question here is that from markwash's historical comment/message [1], seems we have no plan to make Glance support db2, are we?

[1] https://review.openstack.org/#/c/54281/ comments in PS4.

Revision history for this message
Feilong Wang (flwang) wrote :

@zhiyan, Glance will support DB2 in Icehouse. See https://review.openstack.org/#/c/35178/

Ma Wen Cheng (mars914)
Changed in glance:
assignee: Fei Long Wang (flwang) → Ma Wen Cheng (mars914)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to glance (master)

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

Changed in glance:
status: Triaged → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to glance (master)

Reviewed: https://review.openstack.org/59630
Committed: https://git.openstack.org/cgit/openstack/glance/commit/?id=4d43ab797dd46c4183fa685ac6b9501caa1115d4
Submitter: Jenkins
Branch: master

commit 4d43ab797dd46c4183fa685ac6b9501caa1115d4
Author: Wen Cheng Ma <email address hidden>
Date: Tue Dec 3 14:05:33 2013 +0800

    Fix 031 migration failed on DB2

    031 migration script failed on DB2, because DB2 doesn't support
    GROUP BY with clob data type.
    Add if condition to judge DB2 connection, if yes, make another sql query
    supported by DB2.

    Fixes bug #1256816

    Change-Id: I7e3a8cd89edd91c167c619365ab863ec53787f8f

Changed in glance:
status: In Progress → Fix Committed
Thierry Carrez (ttx)
Changed in glance:
milestone: none → icehouse-3
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in glance:
milestone: icehouse-3 → 2014.1
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.