Glance

ambiguous column 'checksum' error while querying for image-list (v2)

Bug #1205330 reported by Venkatesh Sampath
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Glance
Fix Released
Undecided
Venkatesh Sampath
Glance 2013.2 "havana"
Glance Client
Fix Released
Undecided
Venkatesh Sampath

Bug Description

This happens for only a particular scenario.

In my case, When I tried the following,

~$ glance image-list --visibility "shared" --checksum "93264c3edf5972c9f1cb309543d38a5c" --os-image-api-version 2

I got Error with HTTP status code (500).

On the glance side, the exception thrown is:

Entity '<class 'glance.db.sqlalchemy.models.ImageMember'>' has no property 'checksum'

Tags: image-list
Venkatesh Sampath (venkateshsampath)
Changed in glance:
assignee: nobody → Venkatesh Sampath (venkateshsampath)
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/38806

Changed in glance:
status: New → In Progress
Venkatesh Sampath (venkateshsampath)
Changed in python-glanceclient:
assignee: nobody → Venkatesh Sampath (venkateshsampath)
assignee: Venkatesh Sampath (venkateshsampath) → nobody
status: New → In Progress
assignee: nobody → Venkatesh Sampath (venkateshsampath)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to glance (master)

Reviewed: https://review.openstack.org/38806
Committed: http://github.com/openstack/glance/commit/5679a56a7550c28ed62c0855ead0c9c9c7178c6b
Submitter: Jenkins
Branch: master

commit 5679a56a7550c28ed62c0855ead0c9c9c7178c6b
Author: Venkatesh Sampath <email address hidden>
Date: Fri Jul 26 19:04:52 2013 +0530

    ambiguous column 'checksum' error when querying image-list(v2).

    - removed ambiguity by prefixing the column with models.Image
    - based on the image_get_all() method logic, changed the
    filters.get(checksum) to filters.pop(checksum) to
    avoid multiple addition of same criteria in the where clause.
    - modified the functional db test to include this failing scenario.

    Fixes bug 1205330

    Change-Id: Ic2b5b9bed7c02865d66e2f92846dcc9c0e7e2f97

Changed in glance:
status: In Progress → Fix Committed
Revision history for this message
Venkatesh Sampath (venkateshsampath) wrote :

The fix was committed as part of the glance client code.

Changed in python-glanceclient:
status: In Progress → Fix Released
status: Fix Released → Fix Committed
Thierry Carrez (ttx)
Changed in glance:
milestone: none → havana-3
status: Fix Committed → Fix Released
Revision history for this message
Yang Yu (yuyangbj) wrote : I will be on vacation from 9/5 to 9/15, urgent call: 13811509950

I will be out of the office starting 2013-09-05 and will not return until
2013-09-15.

I will be on my marriage leave from 9/5 to 9/15, for any urgent issue
please call me before 9/7.

For daily work, please ask my scrum master Zhu Zhu for help.
For glance issue, please ask glance SME Feilong Wang for help.
For defect report, there will be no report next week.

Thierry Carrez (ttx)
Changed in glance:
milestone: havana-3 → 2013.2
Louis Taylor (kragniz)
Changed in python-glanceclient:
status: Fix Committed → Fix Released
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.