Bug ID 595918: Aggregation issues in 'last day' and 'last month' data in AVR-related charts

Last Modified: Mar 04, 2019

Bug Tracker

Affected Product:  See more info
BIG-IP AFM, ASM, AVR(all modules)

Known Affected Versions:
11.6.0, 11.6.0 HF1, 11.6.0 HF2, 11.6.0 HF3, 11.6.0 HF4, 11.6.0 HF5, 11.6.0 HF6, 11.6.0 HF7, 11.6.0 HF8, 11.6.1, 11.6.1 HF1, 11.6.1 HF2, 11.6.2, 11.6.2 HF1, 11.6.3, 11.6.3.1, 11.6.3.2, 11.6.3.3, 11.6.3.4, 12.0.0, 12.0.0 HF1, 12.0.0 HF2, 12.0.0 HF3, 12.0.0 HF4, 12.1.0, 12.1.0 HF1, 12.1.0 HF2, 12.1.1, 12.1.1 HF1, 12.1.1 HF2, 12.1.2, 12.1.2 HF1, 12.1.2 HF2, 12.1.3, 12.1.3.1, 12.1.3.2, 12.1.3.3, 12.1.3.4, 12.1.3.5, 12.1.3.6, 12.1.3.7, 12.1.4, 13.0.0, 13.0.0 HF1, 13.0.0 HF2, 13.0.0 HF3, 13.0.1

Fixed In:
13.1.0

Opened: May 26, 2016
Severity: 3-Major

Symptoms

AVR aggregates data with the following resolutions: 1 Hour: every 5 minutes (12 data points). 4 Hours: every 1 hour (4 data points). 1 Day: every 4 hours (6 data points). 1 Week: every 1 day (7 data points). 1 Month: every 1 week (4 data points). Older: every 1 month. This can lead to situations in time-charts report a very limited number of data points, which results in data that is not useful.

Impact

Data that is not useful.

Conditions

Viewing 'last day' and 'last month' data in AVR-related charts.

Workaround

No workaround.

Fix Information

Historical statistics are now shown in a better time resolution.

Behavior Change

The intervals of 'last day' and 'last month' in all AVR-related charts has changed. -- 'last day' is represented by 24 points, each of which represents 1 hour (changed from 6 points that each represented 4 hours). -- 'last month' is now represented by 30 points, each of which represents 1 day (changed from 4 points that each represented a week). Immediately after upgrade, you might notice some data missing from the 'last day' and 'last month' reports. For example, you might see only the most recent 4 hours (represented by 4 points) in 'last day', but not the points that preceded those 4 hours, as you might expect when viewing data for the 'last day'. Similarly, you might see 7 points representing 1 week when selecting 'last month', but not the three weeks before that. In both cases the data is not lost (assuming you did not change the default db variable avr.stats.aggregation which is set to medium). You can view the data by selecting a different interval. For example, you can select 'last week' to see the last day (specifically, the day = 1 point), and you can select 'last year' to see the last month's data. After an interval (one week, or one month, depending on the type of chart), the time periods will sync up with the data, so the charts show a full representation of the data, as expected.