Analysis of Robot reports from OSM Jenkins

Date and time of the report: 2023-08-15 08:20:35.793399

Analysed period: 2023-07-25 to 2023-08-15.

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

job	Master branch				Release FOURTEEN				Release TEN				Release THIRTEEN				Release TWELVE
	days_failing	days_passing	days_run	error_rate	days_failing	days_passing	days_run	error_rate	days_failing	days_passing	days_run	error_rate	days_failing	days_passing	days_run	error_rate	days_failing	days_passing	days_run	error_rate
suites
Basic 01-Crud Operations On Vim Targets	0.000000	20.584815	20.584815	0.000000	0.000000	18.708345	18.708345	0.000000	0.000000	21.500058	21.500058	0.000000	0.000000	20.792477	20.792477	0.000000	0.000000	21.627859	21.627859	0.000000
Basic 05-Instantiation Parameters In Cloud Init	1.000000	19.584815	20.584815	0.048579	0.000000	18.708345	18.708345	0.000000	0.999977	20.500081	21.500058	0.046510	0.000000	20.792477	20.792477	0.000000	0.000000	21.627859	21.627859	0.000000
Basic 06-Vnf With Charm	1.000000	19.584815	20.584815	0.048579	0.000000	18.708345	18.708345	0.000000	1.999988	19.500069	21.500058	0.093022	0.000000	20.792477	20.792477	0.000000	0.000000	21.627859	21.627859	0.000000
Basic 07-Secure Key Management	1.000000	19.584815	20.584815	0.048579	0.000000	18.708345	18.708345	0.000000	2.999965	18.500093	21.500058	0.139533	0.000000	20.792477	20.792477	0.000000	0.000000	21.627859	21.627859	0.000000
Basic 08-Disable Port Security Network Level	1.000000	19.584815	20.584815	0.048579	1.000000	17.708345	18.708345	0.053452	1.999988	19.500069	21.500058	0.093022	0.000000	20.792477	20.792477	0.000000	0.000000	21.627859	21.627859	0.000000
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
Slice 01-Network Slicing	0.346829	20.237986	20.584815	0.016849	2.000023	16.708322	18.708345	0.106905	1.999988	19.500069	21.500058	0.093022	1.000000	19.792477	20.792477	0.048094	2.000000	19.627859	21.627859	0.092473
Slice 02-Shared Network Slicing	1.346829	19.237986	20.584815	0.065428	1.000000	17.708345	18.708345	0.053452	0.999977	20.500081	21.500058	0.046510	1.999965	18.792512	20.792477	0.096187	2.999988	18.627870	21.627859	0.138709
Sol003 01-Vnf-Lifecycle-Management	0.000000	20.584815	20.584815	0.000000	0.000000	18.708345	18.708345	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	20.792477	20.792477	0.000000	0.000000	21.627859	21.627859	0.000000
basic 23-delete vnf package SOL004 SOL007	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000
k8s 10-k8s proxy charms SOL004 SOL007	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000

63 rows × 20 columns

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/master	2699	2023-08-15 01:06:16	0	FAILURE	UNAVAILABLE	NaN	NaN
1	osm-stage_3-merge/v14.0	55	2023-08-14 22:08:15	17167049	FAILURE	PASS	603.0	0.0
2	osm-stage_3-merge/v13.0	276	2023-08-14 20:07:14	16401462	SUCCESS	PASS	558.0	0.0
3	osm-stage_3-merge/v12.0	471	2023-08-15 00:04:15	14961273	SUCCESS	PASS	530.0	0.0
4	osm-stage_3-merge/v10.0	886	2023-08-15 03:08:18	10106109	SUCCESS	PASS	380.0	0.0

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

Click to see the details of build 55 of osm-stage_3-merge/v14.0

Click to see the details of build 276 of osm-stage_3-merge/v13.0

Click to see the details of build 471 of osm-stage_3-merge/v12.0

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

Failed test suites per job (if any):

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

	name	status	starttime	endtime	pass	fail	failed_test_name	failed_keyword

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

	name	status	starttime	endtime	pass	fail	failed_test_name	failed_keyword

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

	name	status	starttime	endtime	pass	fail	failed_test_name	failed_keyword

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

	name	status	starttime	endtime	pass	fail	failed_test_name	failed_keyword

osm-stage_3-merge/v10.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/master: (full report)

	suite_name	test_name	keyword_name	status	starttime	endtime

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

	suite_name	test_name	keyword_name	status	starttime	endtime

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

	suite_name	test_name	keyword_name	status	starttime	endtime

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

	suite_name	test_name	keyword_name	status	starttime	endtime

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

	suite_name	test_name	keyword_name	status	starttime	endtime

---

---

---

Powered by osm-analytics