Analysis of Robot reports from OSM Jenkins

Date and time of the report: 2021-12-12 16:45:22.320777

Analysed period: 2021-11-21 to 2021-12-12.

1. Retrieval of all currrent data for aggregate analytics

Database update:

Skipping...

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	58	2021-12-12 00:00:36.941	10860763	UNSTABLE	FAIL	412.0	5.0
1	osm-stage_3-merge/master	1913	2021-12-12 02:06:36.525	11754596	UNSTABLE	FAIL	412.0	5.0
2	osm-stage_3-merge/v10.0	231	2021-12-12 04:08:36.151	971923	FAILURE	UNAVAILABLE	NaN	NaN
3	osm-stage_3-merge/v9.0	407	2021-12-11 22:01:37.991	8512943	SUCCESS	PASS	297.0	0.0

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

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

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

Click to see the details of build 407 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
92	Basic 22-Cross Model Relations	FAIL	2021-12-12 01:26:12.978	2021-12-12 01:37:10.112	5	5	Delete NS Instance	Delete NS

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

	name	status	starttime	endtime	pass	fail	failed_test_name	failed_keyword
17	Basic 22-Cross Model Relations	FAIL	2021-12-12 03:48:27.477	2021-12-12 03:58:50.874	5	5	Delete NS Instance	Delete NS

osm-stage_3-merge/v10.0: (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
17	Basic 22-Cross Model Relations	Delete NS Instance	Delete NS	FAIL	2021-12-12 01:31:43.095	2021-12-12 01:35:57.185
18	Basic 22-Cross Model Relations	Remove K8s Cluster from OSM	Delete K8s Cluster	FAIL	2021-12-12 01:35:57.189	2021-12-12 01:35:59.269
19	Basic 22-Cross Model Relations	Delete NS Descriptor	Delete NSD	FAIL	2021-12-12 01:35:59.272	2021-12-12 01:36:00.349
20	Basic 22-Cross Model Relations	Delete VNF Descriptor 1	Delete VNFD	FAIL	2021-12-12 01:36:00.352	2021-12-12 01:36:02.480
21	Basic 22-Cross Model Relations	Delete VNF Descriptor 2	Delete VNFD	FAIL	2021-12-12 01:36:02.483	2021-12-12 01:36:03.599

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

	suite_name	test_name	keyword_name	status	starttime	endtime
6	Basic 22-Cross Model Relations	Delete NS Instance	Delete NS	FAIL	2021-12-12 03:54:24.117	2021-12-12 03:58:33.369
7	Basic 22-Cross Model Relations	Remove K8s Cluster from OSM	Delete K8s Cluster	FAIL	2021-12-12 03:58:33.372	2021-12-12 03:58:35.286
8	Basic 22-Cross Model Relations	Delete NS Descriptor	Delete NSD	FAIL	2021-12-12 03:58:35.289	2021-12-12 03:58:37.199
9	Basic 22-Cross Model Relations	Delete VNF Descriptor 1	Delete VNFD	FAIL	2021-12-12 03:58:37.202	2021-12-12 03:58:39.139
10	Basic 22-Cross Model Relations	Delete VNF Descriptor 2	Delete VNFD	FAIL	2021-12-12 03:58:39.142	2021-12-12 03:58:41.065

osm-stage_3-merge/v10.0: (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

---

---