Analysis of Robot reports from OSM Jenkins

Date and time of the report: 2021-12-27 08:20:26.771825

Analysed period: 2021-12-06 to 2021-12-27.

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	76	2021-12-27 00:00:53	11635731	SUCCESS	FAIL	413.0	4.0
1	osm-stage_3-merge/v10.0	246	2021-12-27 04:08:54	9042145	UNSTABLE	FAIL	365.0	7.0
2	osm-stage_3-merge/master	1929	2021-12-27 02:06:53	10455572	SUCCESS	PASS	417.0	0.0
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 76 of osm-stage_3-merge/v11.0

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

Click to see the details of build 1929 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
115	Basic 06-Vnf With Charm	FAIL	2021-12-27 00:38:26	2021-12-27 00:46:39	8	3	Delete NS Instance	Delete NS
155	Slice 02-Shared Network Slicing	FAIL	2021-12-27 03:00:33	2021-12-27 03:12:22	19	1	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
112	Slice 02-Shared Network Slicing	FAIL	2021-12-27 06:32:34	2021-12-27 06:38:43	13	7	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
64	Basic 06-Vnf With Charm	Delete NS Instance	Delete NS	FAIL	2021-12-27 00:42:16	2021-12-27 00:46:24
65	Basic 06-Vnf With Charm	Delete NS Descriptor	Delete NSD	FAIL	2021-12-27 00:46:24	2021-12-27 00:46:25
66	Basic 06-Vnf With Charm	Delete VNF Descriptor	Delete VNFD	FAIL	2021-12-27 00:46:25	2021-12-27 00:46:27
73	Slice 02-Shared Network Slicing	Network Slice First Instance	Create Network Slice	FAIL	2021-12-27 03:00:44	2021-12-27 03:07:00

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

	suite_name	test_name	keyword_name	status	starttime	endtime
6	Slice 02-Shared Network Slicing	Network Slice First Instance	Create Network Slice	FAIL	2021-12-27 06:32:45	2021-12-27 06:33:21
8	Slice 02-Shared Network Slicing	Network Slice Second Instance	Create Network Slice	FAIL	2021-12-27 06:33:21	2021-12-27 06:34:28
18	Slice 02-Shared Network Slicing	Get First Slice Vnf IPs	Get Slice Vnf Ip Addresses	FAIL	2021-12-27 06:34:34	2021-12-27 06:34:38
22	Slice 02-Shared Network Slicing	Test Middle Ns Ping	Test Connectivity	FAIL	2021-12-27 06:35:39	2021-12-27 06:36:09
24	Slice 02-Shared Network Slicing	Test Middle Vnf SSH Access	Test SSH Connection	FAIL	2021-12-27 06:36:39	2021-12-27 06:36:39
25	Slice 02-Shared Network Slicing	Test First Slice Connectivity	Ping Many	FAIL	2021-12-27 06:36:39	2021-12-27 06:36:39
34	Slice 02-Shared Network Slicing	Test Second Slice Connectivity	Ping Many	FAIL	2021-12-27 06:37:24	2021-12-27 06:37:24

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

---

---