project_id filter doesn't work when listing limits with more than one filters

Bug #1780896 reported by wangxiyuan
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Identity (keystone)
Fix Released
High
wangxiyuan

Bug Description

when a non-admin list limits with a filter ("resource_name", "region_id", "service_id"), all project's related limits will return.

Because when a non-admin list limits, keystone will add "project_id" filter internal and then query db.
But the "project_id" is ignored in db query.

This can be fixed by adding the project_id filter action back in db query.

Revision history for this message
wangxiyuan (wangxiyuan) wrote :

This bug is introduced when refactor the limit db schema, really sorry about it.

Changed in keystone:
assignee: nobody → wangxiyuan (wangxiyuan)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to keystone (master)

Fix proposed to branch: master
Review: https://review.openstack.org/581177

Changed in keystone:
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to keystone (master)

Reviewed: https://review.openstack.org/581177
Committed: https://git.openstack.org/cgit/openstack/keystone/commit/?id=4cdb4a0b72701f400647cd5899d50cb7e9615cfd
Submitter: Zuul
Branch: master

commit 4cdb4a0b72701f400647cd5899d50cb7e9615cfd
Author: wangxiyuan <email address hidden>
Date: Tue Jul 10 10:55:13 2018 +0800

    Filter project_id for list limits

    When list limits, if more than one filter is provided and
    "project_id" is contained, the limits should be filtered
    with "project_id" as well.

    Closes-bug: #1780896
    Change-Id: I7c231130358ab8d7b0b2f507c52d34366ca0060a

Changed in keystone:
status: In Progress → Fix Released
Changed in keystone:
importance: Undecided → High
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/keystone 14.0.0.0rc1

This issue was fixed in the openstack/keystone 14.0.0.0rc1 release candidate.

Changed in keystone:
milestone: none → rocky-3
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.