Activity log for bug #1757334

Date Who What changed Old value New value Message
2018-03-21 05:12:39 Parth Sarupria bug added bug
2018-03-21 05:12:49 Parth Sarupria information type Proprietary Public
2018-03-21 05:14:49 Prashanth Nageshappa description In a setup with UVE pushed for 5 days, we have observed that when the query is made for last 7 days ("start_time": "now-7d"), we see time take around 5 secs (returning around 208 samples). When we do for last 31 days ("start_time": "now-31d"), we see time take around 25 secs (returning same 208 samples). Query used: {"select_fields": ["app_metrics_diff_link_1d.value.session_duration", "app_metrics_diff_link_1d.value.session_count", "app_metrics_diff_link_1d.value.total_bytes", "app_metrics_diff_link_1d.value.input_bytes", "app_metrics_diff_link_1d.value.output_bytes", "app_metrics_diff_link_1d.value.sla_violation_duration", "app_metrics_diff_link_1d.value.sla_violation_count", "app_metrics_diff_link_1d.value.session_switch_count", "app_metrics_diff_link_1d.value.jitter_violation_count", "app_metrics_diff_link_1d.value.rtt_violation_count", "app_metrics_diff_link_1d.value.pkt_loss_violation_count", "app_metrics_diff_link_1d.__key", "T", "name"], "start_time": "now-7d", "where": [[{"name": "name", "value": "", "op": 7}]], "end_time": "now", "table": "StatTable.SDWANMetricsRecord.app_metrics_diff_link_1d.value"} Contrail analytics api query response time increase when the duration is increased, even though the number of samples returned is the same. In a setup with UVE pushed for 5 days, we have observed that when the query is made for last 7 days ("start_time": "now-7d"), we see time take around 5 secs (returning around 208 samples). When we do for last 31 days ("start_time": "now-31d"), we see time take around 25 secs (returning same 208 samples). Query used: {"select_fields": ["app_metrics_diff_link_1d.value.session_duration", "app_metrics_diff_link_1d.value.session_count", "app_metrics_diff_link_1d.value.total_bytes", "app_metrics_diff_link_1d.value.input_bytes", "app_metrics_diff_link_1d.value.output_bytes", "app_metrics_diff_link_1d.value.sla_violation_duration", "app_metrics_diff_link_1d.value.sla_violation_count", "app_metrics_diff_link_1d.value.session_switch_count", "app_metrics_diff_link_1d.value.jitter_violation_count", "app_metrics_diff_link_1d.value.rtt_violation_count", "app_metrics_diff_link_1d.value.pkt_loss_violation_count", "app_metrics_diff_link_1d.__key", "T", "name"], "start_time": "now-7d", "where": [[{"name": "name", "value": "", "op": 7}]], "end_time": "now", "table": "StatTable.SDWANMetricsRecord.app_metrics_diff_link_1d.value"}
2018-03-21 07:22:57 Jeba Paulaiyan nominated for series juniperopenstack/trunk
2018-03-21 07:22:57 Jeba Paulaiyan bug task added juniperopenstack/trunk
2018-03-21 07:23:24 Jeba Paulaiyan nominated for series juniperopenstack/r4.0
2018-03-21 07:23:24 Jeba Paulaiyan bug task added juniperopenstack/r4.0
2018-03-21 07:23:24 Jeba Paulaiyan nominated for series juniperopenstack/r3.2
2018-03-21 07:23:24 Jeba Paulaiyan bug task added juniperopenstack/r3.2
2018-03-21 07:23:24 Jeba Paulaiyan nominated for series juniperopenstack/r4.1
2018-03-21 07:23:24 Jeba Paulaiyan bug task added juniperopenstack/r4.1
2018-03-21 07:23:33 Jeba Paulaiyan juniperopenstack/r3.2: milestone r3.2.11.0
2018-03-21 07:23:51 Jeba Paulaiyan juniperopenstack/r4.0: milestone r4.0.4.0
2018-03-21 07:23:54 Jeba Paulaiyan juniperopenstack/r4.1: milestone r4.1.2.0
2018-03-21 07:23:57 Jeba Paulaiyan juniperopenstack/trunk: milestone r5.0.1
2018-03-21 07:24:04 Jeba Paulaiyan bug task deleted juniperopenstack/r4.1
2018-03-21 07:24:09 Jeba Paulaiyan bug task deleted juniperopenstack/r4.0
2018-03-21 07:24:13 Jeba Paulaiyan bug task deleted juniperopenstack/r3.2
2018-03-21 07:24:17 Jeba Paulaiyan juniperopenstack/trunk: status New Incomplete
2018-03-21 07:24:20 Jeba Paulaiyan juniperopenstack/trunk: importance Undecided Medium
2018-03-21 07:24:31 Jeba Paulaiyan juniperopenstack/trunk: assignee Parth Sarupria (psarupria)
2018-03-21 22:16:11 Jeba Paulaiyan nominated for series juniperopenstack/r4.1
2018-03-21 22:16:11 Jeba Paulaiyan bug task added juniperopenstack/r4.1
2018-03-21 22:16:35 Jeba Paulaiyan juniperopenstack/trunk: status Incomplete New
2018-03-21 22:16:40 Jeba Paulaiyan juniperopenstack/r4.1: importance Undecided Medium
2018-03-21 22:16:54 Jeba Paulaiyan juniperopenstack/r4.1: assignee Sundaresan Rajangam (srajanga)
2018-03-21 22:17:00 Jeba Paulaiyan juniperopenstack/trunk: assignee Parth Sarupria (psarupria) Sundaresan Rajangam (srajanga)
2018-03-21 22:17:05 Jeba Paulaiyan juniperopenstack/r4.1: milestone r4.1.2.0
2018-03-21 22:18:14 Jeba Paulaiyan nominated for series juniperopenstack/r4.0
2018-03-21 22:18:14 Jeba Paulaiyan bug task added juniperopenstack/r4.0
2018-03-21 22:18:18 Jeba Paulaiyan juniperopenstack/r4.0: importance Undecided Medium
2018-03-21 22:18:30 Jeba Paulaiyan juniperopenstack/r4.0: assignee Sundaresan Rajangam (srajanga)
2018-03-21 22:18:39 Jeba Paulaiyan juniperopenstack/r4.0: milestone r4.0.4.0
2018-03-22 00:56:38 Sundaresan Rajangam juniperopenstack/r4.0: status New Incomplete
2018-03-22 00:56:39 Sundaresan Rajangam juniperopenstack/r4.1: status New Incomplete
2018-03-22 00:56:41 Sundaresan Rajangam juniperopenstack/trunk: status New Incomplete
2018-03-22 00:56:52 Sundaresan Rajangam juniperopenstack/r4.0: assignee Sundaresan Rajangam (srajanga) Parth Sarupria (psarupria)
2018-03-22 00:57:00 Sundaresan Rajangam juniperopenstack/r4.1: assignee Sundaresan Rajangam (srajanga) Parth Sarupria (psarupria)
2018-03-22 00:57:07 Sundaresan Rajangam juniperopenstack/trunk: assignee Sundaresan Rajangam (srajanga) Parth Sarupria (psarupria)
2018-03-22 04:33:20 Parth Sarupria bug added subscriber Prashanth Nageshappa
2018-03-22 22:42:24 Sundaresan Rajangam juniperopenstack/r4.0: status Incomplete Invalid
2018-03-22 22:42:26 Sundaresan Rajangam juniperopenstack/r4.1: status Incomplete Invalid
2018-03-22 22:42:28 Sundaresan Rajangam juniperopenstack/trunk: status Incomplete Invalid