Bug 892995

Summary: users/powerusers cannot consume quota on an upgraded pre-quota DB
Product: Red Hat Enterprise Virtualization Manager Reporter: ofri <omasad>
Component: ovirt-engineAssignee: Gilad Chaplik <gchaplik>
Status: CLOSED CURRENTRELEASE QA Contact: Ondra Machacek <omachace>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 3.1.0CC: acathrow, dfediuck, gchaplik, iheim, jkt, lpeer, oramraz, Rhev-m-bugs, yeylon
Target Milestone: ---Keywords: Regression, TestBlocker
Target Release: 3.2.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: sla
Fixed In Version: sf4 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-03-26 21:06:58 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: SLA RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description ofri 2013-01-08 12:24:42 UTC 
Description of problem:
When trying to add Quota consumers, it seems like the operation succeeded but nothing happens (the consumer is not added to the list).


Version-Release number of selected component (if applicable):
3.1


How reproducible:
100%

Steps to Reproduce:
1. try to add consumer to quota
  
Actual results:
consumer not added to list


Expected results:
consumer added to list

Additional info:
Comment 1 ofri 2013-01-08 12:42:12 UTC 
the quota consumer is added to DB but not shown in the list. This happens because of missing entry in the DB role_groups table.

The missing entry is created only when DB is first created but not if the DB was upgraded. The SQL query adding the entry was accidentally added to insert_predefined_roles.sql instead of being added to a new upgrade script.

Since UI is filtering the quota consumers view by this entry - the list remains empty. Nevertheless, consumers added to the quota can still consume it.
Comment 3 Doron Fediuck 2013-01-09 08:27:03 UTC 
Since the users are actually getting the right permissions,
this is mostly an ugly UI/UX issue. Consumers should be able to
work as needed.
Comment 4 ofri 2013-01-09 13:16:30 UTC 
posted upstream: http://gerrit.ovirt.org/#/c/10746/
Comment 7 Gilad Chaplik 2013-01-09 14:13:52 UTC 
merged upstream (http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=commit;h=a06bcb3f88afed27b28b2e6aff38ceafa3b7909f)
Comment 10 Ondra Machacek 2013-11-19 16:23:03 UTC 
ok in latest sf, upgrade from ic159 to si29.4 to sf21.1. User can consume quota.