yahoo-eng-team team mailing list archive

[Wayne <wayne.okuma@xxxxxx>]

Public bug reported:

The following failure appears in the glance-api.log file when trying to run:
glance --os-image-api-version 2 md-resource-type-associate --name name-of-resource name-of-namespace
in postgresql (this error does NOT appear if running mysql or sqlite).

DBAPIError exception wrapped from (ProgrammingError) column "protected" is of type boolean but expression is of type integer
LINE 1: ...'2015-07-02T23:46:18.125563'::timestamp, 'myrt3', 0) RETURNING...
                                                             ^
HINT:  You will need to rewrite or cast the expression.
 'INSERT INTO metadef_resource_types (created_at, updated_at, name, protected) VALUES (%(created_at)s, %(updated_at)s, %(name)s, %(protected)s) RETURNING metadef_resource_types.id' {'created_at': datetime.datetime(2015, 7, 2, 23, 46, 18, 125552), 'protected': 0, 'updated_at': datetime.datetime(2015, 7, 2, 23, 46, 18, 125563), 'name': u'myrt3'}

** Affects: glance
     Importance: Undecided
     Assignee: Wayne (wayne-okuma)
         Status: New

** Changed in: glance
     Assignee: (unassigned) => Wayne (wayne-okuma)

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

Title:
  glance metadef resource-type-associate fails in postgresql

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

Bug description:
  The following failure appears in the glance-api.log file when trying to run:
  glance --os-image-api-version 2 md-resource-type-associate --name name-of-resource name-of-namespace
  in postgresql (this error does NOT appear if running mysql or sqlite).

  DBAPIError exception wrapped from (ProgrammingError) column "protected" is of type boolean but expression is of type integer
  LINE 1: ...'2015-07-02T23:46:18.125563'::timestamp, 'myrt3', 0) RETURNING...
                                                               ^
  HINT:  You will need to rewrite or cast the expression.
   'INSERT INTO metadef_resource_types (created_at, updated_at, name, protected) VALUES (%(created_at)s, %(updated_at)s, %(name)s, %(protected)s) RETURNING metadef_resource_types.id' {'created_at': datetime.datetime(2015, 7, 2, 23, 46, 18, 125552), 'protected': 0, 'updated_at': datetime.datetime(2015, 7, 2, 23, 46, 18, 125563), 'name': u'myrt3'}

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