yahoo-eng-team team mailing list archive

[Ma Wen Cheng <mars914@xxxxxxx>]

Public bug reported:

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',)

** Affects: glance
     Importance: Undecided
     Assignee: Ma Wen Cheng (mars914)
         Status: In Progress

** Changed in: glance
     Assignee: (unassigned) => Ma Wen Cheng (mars914)

** Changed in: glance
       Status: New => In Progress

-- 
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:
  glance-manage db_sync failed in X bvt

Status in OpenStack Image Registry and Delivery Service (Glance):
  In Progress

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