Bug 534745 (RHQ-1511)

Summary: purge values are calculated incorrectly into millis
Product: [Other] RHQ Project Reporter: John Mazzitelli <mazz>
Component: Core UIAssignee: John Mazzitelli <mazz>
Status: CLOSED NEXTRELEASE QA Contact: Jeff Weiss <jweiss>
Severity: medium Docs Contact:
Priority: high    
Version: unspecifiedCC: dajohnso
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: All   
URL: http://jira.rhq-project.org/browse/RHQ-1511
Whiteboard:
Fixed In Version: 1.2 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 534365    

Description John Mazzitelli 2009-02-09 19:21:00 UTC
select property_key, property_value from rhq_system_config where property_key like '%_PURGE'

RT_DATA_PURGE	2678400000
ALERT_PURGE	2678400000
EVENT_PURGE	1209600000
TRAIT_PURGE	31536000000
AVAILABILITY_PURGE	31536000000

now go to admin>server config and change the values. Make them all 1 day:

RT_DATA_PURGE	60000
ALERT_PURGE	60000
EVENT_PURGE	60000
TRAIT_PURGE	60000
AVAILABILITY_PURGE	60000

Someone broke the conversion code. 1 day should result in "86400000", not 60000 (which is 1 minute)

Comment 1 John Mazzitelli 2009-02-09 19:24:36 UTC
same thing with the CAM_DATA_MAINTENANCE value too

Comment 2 John Mazzitelli 2009-02-09 19:25:47 UTC
and the same thing with baseline frequency and dataset

Comment 3 John Mazzitelli 2009-02-09 20:59:11 UTC
recently, the admin page was split into several sub .jsp pages.

The <hq:constant> tags need to be added to two of those subpages.

The description shows how to test - just change the values and use SQL to look at the values of the properties in RHQ_SYSTEM_CONFIG. The property_key values you need to look at are:

RT_DATA_PURGE
ALERT_PURGE
EVENT_PURGE
TRAIT_PURGE
AVAILABILITY_PURGE 
CAM_BASELINE_FREQUENCY
CAM_BASELINE_DATASET
CAM_DATA_MAINTENANCE

The numbers should be high (6 digits or less is too low).

Comment 4 Jeff Weiss 2009-02-23 21:34:22 UTC
Fixed, rev3078

property_key	property_value
ALERT_PURGE	86400000
EVENT_PURGE	86400000
TRAIT_PURGE	86400000
AVAILABILITY_PURGE	86400000
RT_DATA_PURGE	86400000
property_key	property_value
Query Time=1

Comment 5 Red Hat Bugzilla 2009-11-10 20:34:41 UTC
This bug was previously known as http://jira.rhq-project.org/browse/RHQ-1511