Analysis of Robot reports from OSM Jenkins

Date and time of the report: 2021-12-22 08:20:28.222120

Analysed period: 2021-12-01 to 2021-12-22.

1. Retrieval of all currrent data for aggregate analytics

Database update:

Retrieving from database...	

DONE

2. Aggregated analysis of stability

2.1 Restricts data to time window for analysis

2.2 Finding sequences of successful builds and Robot reports

Two values retrieved from the build are key to determine the state of the jubs and test suites at a given moment:

• build_result is the outcome of the build, reported by Jenkins. It can be: SUCCESS, FAILURE, UNSTABLE or ABORTED.
• test_result is the summary of the concerned Robot tests. It can be: FAIL, UNAVAILABLE or PASS.

Based on these two states, 3 types of temporal sequences of success/failure are identified per builds and test suites:

1. Successful builds/failed builds in a row: grp_build_result.
2. Successful test reports vs. test reports with fails in a row: grp_test_result.
3. Clean builds and tests vs. failures (of any kind) in a row: grp_success_fail.

For the identification of these sequences, the following mapping applies:

Type of sequence	Relevant state	OK sequence contains	NOK sequence contains	Ignore
grp_build_result	build_result	SUCCESS or UNSTABLE	FAILURE	ABORTED
grp_test_result	test_result	PASS	FAIL	UNAVAILABLE
grp_success_fail	test_result	PASS	FAIL or UNAVAILABLE	N/A

The different groupings of segments are detected and a label is added to each sample...

DONE

Then, the duration of each of the sequences of success/failure is determined and a specific dataframe is built summarizing such sequences, to ease their representation and analysis...

DONE

2.3 Finding sequences of pass/fails per test suite

DONE

3. Reports

3.1 Aggregated success rate per test step

3.2 Overall success of Jenkins builds and Robot tests

3.3 Sequences of pass/fails per test suites

3.4 Failing days per test suite

4. Information about the latest builds of relevant jobs

Latest build of each job

	job	build	timestamp	duration	build_result	test_result	pass_count	fail_count
0	osm-stage_3-merge/v11.0	71	2021-12-22 00:00:10	11068927	UNSTABLE	FAIL	383.0	34.0
1	osm-stage_3-merge/v10.0	241	2021-12-22 04:08:10	9507861	UNSTABLE	FAIL	338.0	34.0
2	osm-stage_3-merge/master	1924	2021-12-22 02:06:10	296465	FAILURE	UNAVAILABLE	NaN	NaN
3	osm-stage_3-merge/v9.0	411	2021-12-15 09:02:31	8722256	SUCCESS	PASS	297.0	0.0

Click to see the details of build 71 of osm-stage_3-merge/v11.0

Click to see the details of build 241 of osm-stage_3-merge/v10.0

Click to see the details of build 1924 of osm-stage_3-merge/master

Click to see the details of build 411 of osm-stage_3-merge/v9.0

Failed test suites per job (if any):

osm-stage_3-merge/v11.0: (full report)

	name	status	starttime	endtime	pass	fail	failed_test_name	failed_keyword
74	Basic 08-Disable Port Security Network Level	FAIL	2021-12-22 00:40:53	2021-12-22 00:43:07	8	1	Instantiate Network Service	Create Network Service
81	Basic 16-Advanced Onboarding And Scaling	FAIL	2021-12-22 01:08:38	2021-12-22 01:10:12	5	7	Instantiate Scaling Network Service	Create Network Service
85	Basic 20-Manual Native Charm Vdu Scaling	FAIL	2021-12-22 01:15:20	2021-12-22 01:26:48	17	4	Perform Manual Vdu Scale Out	Execute Manual VNF Scale
87	Basic 22-Cross Model Relations	FAIL	2021-12-22 01:28:44	2021-12-22 01:46:48	9	1	Instantiate Charm Network Service	Create Network Service
92	Epa 04-Epa Underlay Sriov	FAIL	2021-12-22 01:51:29	2021-12-22 01:53:02	5	4	Instantiate Network Service	Create Network Service
95	Hackfest Cloudinit	FAIL	2021-12-22 01:56:22	2021-12-22 01:58:24	5	4	Network Service Instance Test	Create Network Service
96	Hackfest Multivdu	FAIL	2021-12-22 01:58:24	2021-12-22 02:00:26	5	4	Network Service Instance Test	Create Network Service
111	Slice 01-Network Slicing	FAIL	2021-12-22 02:53:38	2021-12-22 02:57:47	10	3	Network Slice Instance Test	Create Network Slice
112	Slice 02-Shared Network Slicing	FAIL	2021-12-22 02:57:47	2021-12-22 03:03:30	14	6	Network Slice First Instance	Create Network Slice

osm-stage_3-merge/v10.0: (full report)

	name	status	starttime	endtime	pass	fail	failed_test_name	failed_keyword
36	Basic 08-Disable Port Security Network Level	FAIL	2021-12-22 04:44:29	2021-12-22 04:46:42	8	1	Instantiate Network Service	Create Network Service
43	Basic 16-Advanced Onboarding And Scaling	FAIL	2021-12-22 05:12:07	2021-12-22 05:13:38	5	7	Instantiate Scaling Network Service	Create Network Service
47	Basic 20-Manual Native Charm Vdu Scaling	FAIL	2021-12-22 05:18:43	2021-12-22 05:30:21	17	4	Perform Manual Vdu Scale Out	Execute Manual VNF Scale
51	Epa 04-Epa Underlay Sriov	FAIL	2021-12-22 05:34:44	2021-12-22 05:36:15	5	4	Instantiate Network Service	Create Network Service
54	Hackfest Cloudinit	FAIL	2021-12-22 05:39:13	2021-12-22 05:41:13	5	4	Network Service Instance Test	Create Network Service
55	Hackfest Multivdu	FAIL	2021-12-22 05:41:13	2021-12-22 05:43:13	5	4	Network Service Instance Test	Create Network Service
68	Slice 01-Network Slicing	FAIL	2021-12-22 06:34:19	2021-12-22 06:39:06	9	4	Network Slice Instance Test	Create Network Slice
69	Slice 02-Shared Network Slicing	FAIL	2021-12-22 06:39:06	2021-12-22 06:45:04	14	6	Network Slice First Instance	Create Network Slice

osm-stage_3-merge/master: (full report)

	name	status	starttime	endtime	pass	fail	failed_test_name	failed_keyword

osm-stage_3-merge/v9.0: (full report)

	name	status	starttime	endtime	pass	fail	failed_test_name	failed_keyword

Details of failed tests into failing test suites (if any):

osm-stage_3-merge/v11.0: (full report)

	suite_name	test_name	keyword_name	status	starttime	endtime
225	Basic 08-Disable Port Security Network Level	Instantiate Network Service	Create Network Service	FAIL	2021-12-22 00:41:31	2021-12-22 00:42:15
235	Basic 16-Advanced Onboarding And Scaling	Instantiate Scaling Network Service	Create Network Service	FAIL	2021-12-22 01:08:42	2021-12-22 01:09:27
237	Basic 16-Advanced Onboarding And Scaling	Get Vnf Id	Variable Should Exist	FAIL	2021-12-22 01:09:27	2021-12-22 01:09:27
241	Basic 16-Advanced Onboarding And Scaling	Check Vdus Before Scale Out	Get Vnf Vdur Names	FAIL	2021-12-22 01:09:27	2021-12-22 01:09:27
246	Basic 16-Advanced Onboarding And Scaling	Perform Manual Vdu Scale Out	Variable Should Exist	FAIL	2021-12-22 01:09:27	2021-12-22 01:09:27
248	Basic 16-Advanced Onboarding And Scaling	Check Vdus After Scale Out	Variable Should Exist	FAIL	2021-12-22 01:09:27	2021-12-22 01:09:27
253	Basic 16-Advanced Onboarding And Scaling	Perform Manual Vdu Scale In	Variable Should Exist	FAIL	2021-12-22 01:09:27	2021-12-22 01:09:27
255	Basic 16-Advanced Onboarding And Scaling	Check Vdus After Scaling In	Variable Should Exist	FAIL	2021-12-22 01:09:27	2021-12-22 01:09:27
285	Basic 20-Manual Native Charm Vdu Scaling	Perform Manual Vdu Scale Out	Execute Manual VNF Scale	FAIL	2021-12-22 01:19:41	2021-12-22 01:23:45
295	Basic 20-Manual Native Charm Vdu Scaling	Check Number of Duplicated Application Name Af...	Run Keyword Unless	FAIL	2021-12-22 01:23:49	2021-12-22 01:23:49
301	Basic 20-Manual Native Charm Vdu Scaling	Perform Manual Vdu Scale In	Execute Manual VNF Scale	FAIL	2021-12-22 01:23:49	2021-12-22 01:26:00
306	Basic 20-Manual Native Charm Vdu Scaling	Check Vdus After Scaling In	Run Keyword Unless	FAIL	2021-12-22 01:26:02	2021-12-22 01:26:02
323	Basic 22-Cross Model Relations	Instantiate Charm Network Service	Create Network Service	FAIL	2021-12-22 01:29:30	2021-12-22 01:45:01
333	Epa 04-Epa Underlay Sriov	Instantiate Network Service	Create Network Service	FAIL	2021-12-22 01:51:33	2021-12-22 01:52:17
335	Epa 04-Epa Underlay Sriov	Get Management Ip Addresses	Variable Should Exist	FAIL	2021-12-22 01:52:17	2021-12-22 01:52:17
342	Epa 04-Epa Underlay Sriov	Ping from Vnf1 to Vnf2	Variable Should Exist	FAIL	2021-12-22 01:52:17	2021-12-22 01:52:17
346	Epa 04-Epa Underlay Sriov	Ping from Vnf2 to Vnf1	Variable Should Exist	FAIL	2021-12-22 01:52:17	2021-12-22 01:52:17
354	Hackfest Cloudinit	Network Service Instance Test	Create Network Service	FAIL	2021-12-22 01:56:26	2021-12-22 01:57:11
356	Hackfest Cloudinit	Get Vnf Ip Address	Get Vnf Management Ip Address	FAIL	2021-12-22 01:57:11	2021-12-22 01:57:11
360	Hackfest Cloudinit	Test SSH Access	Test SSH Connection	FAIL	2021-12-22 01:57:41	2021-12-22 01:57:41
361	Hackfest Cloudinit	Check Remote File Injected Via Cloud-init	Execute Remote Command Check Rc Return Output	FAIL	2021-12-22 01:57:41	2021-12-22 01:57:41
370	Hackfest Multivdu	Network Service Instance Test	Create Network Service	FAIL	2021-12-22 01:58:28	2021-12-22 01:59:13
373	Hackfest Multivdu	Get Vnf Ip Address	Get Vnf Management Ip Address	FAIL	2021-12-22 01:59:13	2021-12-22 01:59:13
376	Hackfest Multivdu	Test Ping	Test Connectivity	FAIL	2021-12-22 01:59:13	2021-12-22 01:59:43
379	Hackfest Multivdu	Test SSH Access	Test SSH Connection	FAIL	2021-12-22 01:59:43	2021-12-22 01:59:43
388	Slice 01-Network Slicing	Network Slice Instance Test	Create Network Slice	FAIL	2021-12-22 02:53:48	2021-12-22 02:54:56
404	Slice 01-Network Slicing	Test Slice Connectivity	Ping Many	FAIL	2021-12-22 02:56:37	2021-12-22 02:56:37
417	Slice 02-Shared Network Slicing	Network Slice First Instance	Create Network Slice	FAIL	2021-12-22 02:57:59	2021-12-22 02:59:06
419	Slice 02-Shared Network Slicing	Network Slice Second Instance	Create Network Slice	FAIL	2021-12-22 02:59:06	2021-12-22 02:59:43
429	Slice 02-Shared Network Slicing	Get First Slice Vnf IPs	Get Slice Vnf Ip Addresses	FAIL	2021-12-22 02:59:49	2021-12-22 02:59:53
436	Slice 02-Shared Network Slicing	Test First Slice Connectivity	Ping Many	FAIL	2021-12-22 03:01:27	2021-12-22 03:01:27
442	Slice 02-Shared Network Slicing	Get Second Slice Vnf IPs	Get Slice Vnf Ip Addresses	FAIL	2021-12-22 03:02:05	2021-12-22 03:02:10
445	Slice 02-Shared Network Slicing	Test Second Slice Connectivity	Ping Many	FAIL	2021-12-22 03:02:10	2021-12-22 03:02:10

osm-stage_3-merge/v10.0: (full report)

	suite_name	test_name	keyword_name	status	starttime	endtime
4	Basic 08-Disable Port Security Network Level	Instantiate Network Service	Create Network Service	FAIL	2021-12-22 04:45:06	2021-12-22 04:45:49
14	Basic 16-Advanced Onboarding And Scaling	Instantiate Scaling Network Service	Create Network Service	FAIL	2021-12-22 05:12:10	2021-12-22 05:12:53
16	Basic 16-Advanced Onboarding And Scaling	Get Vnf Id	Variable Should Exist	FAIL	2021-12-22 05:12:53	2021-12-22 05:12:53
20	Basic 16-Advanced Onboarding And Scaling	Check Vdus Before Scale Out	Get Vnf Vdur Names	FAIL	2021-12-22 05:12:53	2021-12-22 05:12:53
25	Basic 16-Advanced Onboarding And Scaling	Perform Manual Vdu Scale Out	Variable Should Exist	FAIL	2021-12-22 05:12:53	2021-12-22 05:12:53
27	Basic 16-Advanced Onboarding And Scaling	Check Vdus After Scale Out	Variable Should Exist	FAIL	2021-12-22 05:12:53	2021-12-22 05:12:53
32	Basic 16-Advanced Onboarding And Scaling	Perform Manual Vdu Scale In	Variable Should Exist	FAIL	2021-12-22 05:12:53	2021-12-22 05:12:53
34	Basic 16-Advanced Onboarding And Scaling	Check Vdus After Scaling In	Variable Should Exist	FAIL	2021-12-22 05:12:53	2021-12-22 05:12:53
64	Basic 20-Manual Native Charm Vdu Scaling	Perform Manual Vdu Scale Out	Execute Manual VNF Scale	FAIL	2021-12-22 05:22:59	2021-12-22 05:27:17
74	Basic 20-Manual Native Charm Vdu Scaling	Check Number of Duplicated Application Name Af...	Run Keyword Unless	FAIL	2021-12-22 05:27:21	2021-12-22 05:27:21
80	Basic 20-Manual Native Charm Vdu Scaling	Perform Manual Vdu Scale In	Execute Manual VNF Scale	FAIL	2021-12-22 05:27:21	2021-12-22 05:29:32
85	Basic 20-Manual Native Charm Vdu Scaling	Check Vdus After Scaling In	Run Keyword Unless	FAIL	2021-12-22 05:29:34	2021-12-22 05:29:34
101	Epa 04-Epa Underlay Sriov	Instantiate Network Service	Create Network Service	FAIL	2021-12-22 05:34:48	2021-12-22 05:35:30
103	Epa 04-Epa Underlay Sriov	Get Management Ip Addresses	Variable Should Exist	FAIL	2021-12-22 05:35:30	2021-12-22 05:35:30
110	Epa 04-Epa Underlay Sriov	Ping from Vnf1 to Vnf2	Variable Should Exist	FAIL	2021-12-22 05:35:30	2021-12-22 05:35:30
114	Epa 04-Epa Underlay Sriov	Ping from Vnf2 to Vnf1	Variable Should Exist	FAIL	2021-12-22 05:35:30	2021-12-22 05:35:30
122	Hackfest Cloudinit	Network Service Instance Test	Create Network Service	FAIL	2021-12-22 05:39:17	2021-12-22 05:39:59
124	Hackfest Cloudinit	Get Vnf Ip Address	Get Vnf Management Ip Address	FAIL	2021-12-22 05:39:59	2021-12-22 05:39:59
128	Hackfest Cloudinit	Test SSH Access	Test SSH Connection	FAIL	2021-12-22 05:40:29	2021-12-22 05:40:29
129	Hackfest Cloudinit	Check Remote File Injected Via Cloud-init	Execute Remote Command Check Rc Return Output	FAIL	2021-12-22 05:40:29	2021-12-22 05:40:29
138	Hackfest Multivdu	Network Service Instance Test	Create Network Service	FAIL	2021-12-22 05:41:17	2021-12-22 05:42:00
141	Hackfest Multivdu	Get Vnf Ip Address	Get Vnf Management Ip Address	FAIL	2021-12-22 05:42:00	2021-12-22 05:42:00
144	Hackfest Multivdu	Test Ping	Test Connectivity	FAIL	2021-12-22 05:42:00	2021-12-22 05:42:30
147	Hackfest Multivdu	Test SSH Access	Test SSH Connection	FAIL	2021-12-22 05:42:30	2021-12-22 05:42:30
156	Slice 01-Network Slicing	Network Slice Instance Test	Create Network Slice	FAIL	2021-12-22 06:34:29	2021-12-22 06:35:36
169	Slice 01-Network Slicing	Test Middle Ns Ping	Test Connectivity	FAIL	2021-12-22 06:36:49	2021-12-22 06:37:20
171	Slice 01-Network Slicing	Test Middle Vnf SSH Access	Test SSH Connection	FAIL	2021-12-22 06:37:50	2021-12-22 06:37:50
172	Slice 01-Network Slicing	Test Slice Connectivity	Ping Many	FAIL	2021-12-22 06:37:50	2021-12-22 06:37:50
185	Slice 02-Shared Network Slicing	Network Slice First Instance	Create Network Slice	FAIL	2021-12-22 06:39:16	2021-12-22 06:40:23
187	Slice 02-Shared Network Slicing	Network Slice Second Instance	Create Network Slice	FAIL	2021-12-22 06:40:23	2021-12-22 06:40:59
197	Slice 02-Shared Network Slicing	Get First Slice Vnf IPs	Get Slice Vnf Ip Addresses	FAIL	2021-12-22 06:41:06	2021-12-22 06:41:19
204	Slice 02-Shared Network Slicing	Test First Slice Connectivity	Ping Many	FAIL	2021-12-22 06:42:53	2021-12-22 06:42:53
210	Slice 02-Shared Network Slicing	Get Second Slice Vnf IPs	Get Slice Vnf Ip Addresses	FAIL	2021-12-22 06:43:31	2021-12-22 06:43:37
213	Slice 02-Shared Network Slicing	Test Second Slice Connectivity	Ping Many	FAIL	2021-12-22 06:43:37	2021-12-22 06:43:37

osm-stage_3-merge/master: (full report)

	suite_name	test_name	keyword_name	status	starttime	endtime

osm-stage_3-merge/v9.0: (full report)

	suite_name	test_name	keyword_name	status	starttime	endtime

---

---