yahoo-eng-team team mailing list archive

[wangxiyuan <wangxiyuan@xxxxxxxxxx>]

Public bug reported:

version: master  db: postgreSQL

reproduce:

1.create one or more images without data, like:
glance image-create --name xxx  or  glance image-create 

then we will get image information though 'glance image-list', like:

+--------------------------------------+--------------------------+-------------+------------------+---------+--------+
| ID                                   | Name                     | Disk Format | Container Format | Size    | Status |
+--------------------------------------+--------------------------+-------------+------------------+---------+--------+
| 67b47035-3e70-4dd0-a5a7-3fc3350a26ee | cirros-0.3.0-x86_64-disk | qcow2       | bare             | 9761280 | active |
| bf8022ef-3e3a-4bef-8d13-ccea9000828f | test                     |             |                  |         | queued |
| 0180e9f2-6506-46c7-be07-e67ee6d5dab8 | test2                    |             |                  |         | queued |
| 505bbc97-f470-44b7-bb59-315a5d92d8e0 | test3                    |             |                  |         | queued |
| 03ef4387-f276-40dc-9aa6-ad811eb3c466 | test5                    |             |                  |         | queued |
| 5af5d95d-8c2f-4bec-9fdd-74ce9ce3a4ca |                          |             |                  |         | queued |
+--------------------------------------+--------------------------+-------------+------------------+---------+--------+

2.list image like : glance image-list --sort-key=size --page-size=3
(sort-key must be 'size', and page-size must be less than or equal to
image amount )

then, glance will return an error:
HTTPInternalServerError (HTTP 500)


P.S.:When use mysql db, I didn't encounter this problem.

** Affects: glance
     Importance: Undecided
     Assignee: wangxiyuan (wangxiyuan)
         Status: New

** Changed in: glance
     Assignee: (unassigned) => wangxiyuan (wangxiyuan)

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

Title:
  Glace return HTTPInternalServerError when use postgresql

Status in Glance:
  New

Bug description:
  version: master  db: postgreSQL

  reproduce:

  1.create one or more images without data, like:
  glance image-create --name xxx  or  glance image-create 

  then we will get image information though 'glance image-list', like:

  +--------------------------------------+--------------------------+-------------+------------------+---------+--------+
  | ID                                   | Name                     | Disk Format | Container Format | Size    | Status |
  +--------------------------------------+--------------------------+-------------+------------------+---------+--------+
  | 67b47035-3e70-4dd0-a5a7-3fc3350a26ee | cirros-0.3.0-x86_64-disk | qcow2       | bare             | 9761280 | active |
  | bf8022ef-3e3a-4bef-8d13-ccea9000828f | test                     |             |                  |         | queued |
  | 0180e9f2-6506-46c7-be07-e67ee6d5dab8 | test2                    |             |                  |         | queued |
  | 505bbc97-f470-44b7-bb59-315a5d92d8e0 | test3                    |             |                  |         | queued |
  | 03ef4387-f276-40dc-9aa6-ad811eb3c466 | test5                    |             |                  |         | queued |
  | 5af5d95d-8c2f-4bec-9fdd-74ce9ce3a4ca |                          |             |                  |         | queued |
  +--------------------------------------+--------------------------+-------------+------------------+---------+--------+

  2.list image like : glance image-list --sort-key=size --page-size=3
  (sort-key must be 'size', and page-size must be less than or equal to
  image amount )

  then, glance will return an error:
  HTTPInternalServerError (HTTP 500)

  
  P.S.:When use mysql db, I didn't encounter this problem.

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