Bug 1339638

Summary: Configuration database pagination is broken for tables and indexes
Product: Red Hat CloudForms Management Engine Reporter: Matouš Mojžíš <mmojzis>
Component: UI - OPSAssignee: Greg Piatigorski <gpiatigo>
Status: CLOSED CURRENTRELEASE QA Contact: Matouš Mojžíš <mmojzis>
Severity: high Docs Contact:
Priority: medium    
Version: 5.6.0CC: akarol, hkataria, jhardy, jprause, mpovolny, obarenbo, simaishi
Target Milestone: GAKeywords: TestOnly, ZStream
Target Release: 5.7.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: ui
Fixed In Version: 5.7.0.0 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
: 1353253 (view as bug list) Environment:
Last Closed: 2017-01-11 20:25:04 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: CFME Core Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1353253    
Attachments:
Description Flags
wrong count of entries none

Description Matouš Mojžíš 2016-05-25 13:51:08 UTC
Created attachment 1161439 [details]
wrong count of entries

Description of problem:
Pagination is broken for tables and indexes. When I set pagination=50, then it shows 17 entries...What's worse, that when I list through all the entries then I am not able to see more than 17/50 of all entries.
When I set pagination=5, then I see two entries and one second page I see three entries, where first entry is last entry from previous page. On third page I see two entries and so on...
Version-Release number of selected component (if applicable):
5.6.0.7

How reproducible:
Always

Steps to Reproduce:
1. Configure -> Database tab
2. List through Tables/Indexes
3.

Actual results:
Wrong count of entries displayed

Expected results:
Count of entries displayed as set in pagination

Additional info:
screenshot attached.

Comment 2 Greg Piatigorski 2016-06-21 15:57:21 UTC
Fix applied: https://github.com/ManageIQ/manageiq/pull/9328

Comment 3 CFME Bot 2016-06-21 22:11:26 UTC
New commit detected on ManageIQ/manageiq/master:
https://github.com/ManageIQ/manageiq/commit/70e33fac85d199533c898ff52ede50df457933a0

commit 70e33fac85d199533c898ff52ede50df457933a0
Author:     Greg Piatigorski <gpiatigo>
AuthorDate: Tue Jun 21 08:40:15 2016 -0700
Commit:     Greg Piatigorski <gpiatigo>
CommitDate: Tue Jun 21 14:33:53 2016 -0700

    Fixed has_one associations to VmdbMetrics table
    
    Applied fixes to has_one associations in VmdbTable and VmdbIndex models to fetch max(latest) performance metric from VmdbMetrics.
    
    https://bugzilla.redhat.com/show_bug.cgi?id=1339638

 app/models/vmdb_index.rb       |  3 ++-
 app/models/vmdb_table.rb       |  3 ++-
 spec/models/vmdb_index_spec.rb |  7 +++++++
 spec/models/vmdb_table_spec.rb | 21 +++++++++++++++++++++
 4 files changed, 32 insertions(+), 2 deletions(-)

Comment 4 Greg Piatigorski 2016-06-21 22:18:31 UTC
Ready for QE.

Comment 7 Matouš Mojžíš 2016-10-05 09:22:03 UTC
Verified in 5.7.0.3. Pagination works as expected.

Comment 8 Greg Piatigorski 2016-10-28 22:55:03 UTC
*** Bug 1358442 has been marked as a duplicate of this bug. ***

Comment 11 Martin Hradil 2017-07-11 10:49:27 UTC
*** Bug 1212746 has been marked as a duplicate of this bug. ***

Comment 12 Martin Hradil 2017-07-11 10:50:33 UTC
*** Bug 1242764 has been marked as a duplicate of this bug. ***