yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

** Changed in: glance
       Status: Fix Committed => Fix Released

** Changed in: glance
    Milestone: None => icehouse-rc1

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Glance.
https://bugs.launchpad.net/bugs/1287087

Title:
  Migration 031_remove_duplicated_locations.py fails with DB2

Status in OpenStack Image Registry and Delivery Service (Glance):
  Fix Released

Bug description:
  glance-manage db_sync

  2014-03-03 03:09:03.899 18584 CRITICAL glance [-] ProgrammingError:
  (ProgrammingError) ibm_db_dbi::ProgrammingError: SQLNumResultCols
  failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N  An unexpected
  token "AND" was found following ".meta_data) AND true".  Expected
  tokens may include:  "<interval_qualifier>".  SQLSTATE=42601
  SQLCODE=-104 'SELECT image_locations_1.id \nFROM image_locations AS
  image_locations_1 \nWHERE image_locations_1.id > (SELECT
  min(image_locations.id) AS min_1 \nFROM image_locations \nWHERE
  image_locations.image_id = image_locations_1.image_id AND
  image_locations."value" = image_locations_1."value" AND
  image_locations.meta_data = image_locations_1.meta_data) AND true AND
  image_locations_1.deleted = ?' ('0',)

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1287087/+subscriptions