Bug 663343

Summary: [ Cli/Server ] not more than 60 datapoints can be returned from MDM.findDataForResource()
Product: [Other] RHQ Project Reporter: Heiko W. Rupp <hrupp>
Component: Core ServerAssignee: RHQ Project Maintainer <rhq-maint>
Status: CLOSED CURRENTRELEASE QA Contact: Mike Foley <mfoley>
Severity: medium Docs Contact:
Priority: low    
Version: 4.0.0CC: jshaughn, nyiri.mark
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-07-01 14:14:45 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Heiko W. Rupp 2010-12-15 13:43:05 UTC
org.rhq.enterprise.server.measurement.MeasurementDataManagerBean#findDataForResource()
offers (also on the remote interface to the CLI ) to specify a number of datapoints.
But doing so only works correctly when #datapoints = 60

This comes from calling into
org.rhq.enterprise.server.measurement.util.MeasurementDataManagerUtility#getMeasurementDataAggregatesForContext
then 
org.rhq.enterprise.server.measurement.util.MeasurementDataManagerUtility#getFullQuery

where the SQL is constructed

        + "   ) data GROUP BY timestamp) \n"
            + "   UNION ALL (select ? + (? * i) as timestamp, null as av, null as peak, null as low from RHQ_numbers where i < ?) ) alldata \n"


but RHQ_numbers only has 60 rows

Comment 2 Jay Shaughnessy 2014-07-01 14:14:45 UTC
No longer true using StorageNode/Cassandra