Some volume performance samples are missing in AIQUM repository database
Applies to
Active IQ Unified Manager (AIQUM) 9.10
Issue
- Some volume performance sample records are missing in
sample_qos_volume_workload_<OBJID>table of AIQUM repository database
Example: Samples between 5:30 AM and 5:55 are missing
mysql> select from_unixtime(time/1000), latency from netapp_performance.sample_qos_volume_workload_1 WHERE
-> objId=313 and from_unixtime(time/1000) >= "2022-04-13 5:25:00.0000" order by time;
+--------------------------+---------+
| from_unixtime(time/1000) | latency |
+--------------------------+---------+
| 2022-04-13 05:25:08.9680 | 682.594 |
| 2022-04-13 06:00:08.9680 | 456.219 |
| 2022-04-13 06:05:08.9680 | 470.533 |
| 2022-04-13 06:10:08.9690 | 476.03 |
| 2022-04-13 06:15:08.9690 | 516.153 |
| 2022-04-13 06:20:08.9680 | 669.719 |
| 2022-04-13 06:25:08.9680 | 462.034 |
+--------------------------+---------+
7 rows in set (0.00 sec)
- There is no suspicious error or warning in
ocum_server.logandau.log - Performance recording file includes the volume performance data