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)
same thing with the CAM_DATA_MAINTENANCE value too
and the same thing with baseline frequency and dataset
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).
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
This bug was previously known as http://jira.rhq-project.org/browse/RHQ-1511