Analysis of Robot reports from OSM Jenkins

Date and time of the report: 2022-11-26 08:20:50.566963

Analysed period: 2022-11-05 to 2022-11-26.

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

Empty dataframe. Skipping.

3.2 Overall success of Jenkins builds and Robot tests

3.3 Sequences of pass/fails per test suites

Empty dataframe. Skipping.

3.4 Failing days per test suite

Empty dataframe. Skipping.

job	Master branch				Release TEN				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
suites
Basic 01-Crud Operations On Vim Targets	1.737847	14.495174	16.233021	0.107056	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Basic 05-Instantiation Parameters In Cloud Init	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Basic 06-Vnf With Charm	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.588461	15.627824	16.216285	0.036288
Basic 07-Secure Key Management	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.588461	15.627824	16.216285	0.036288
Basic 08-Disable Port Security Network Level	2.386100	13.846921	16.233021	0.146990	0.000000	14.500000	14.5	0.000000	0.588461	15.627824	16.216285	0.036288
Basic 09-Manual Vdu Scaling	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.588461	15.627824	16.216285	0.036288
Basic 11-Native Charms	1.512627	14.720394	16.233021	0.093182	0.000000	14.500000	14.5	0.000000	0.588461	15.627824	16.216285	0.036288
Basic 12-Ns Primitives	1.232975	15.000046	16.233021	0.075955	0.000000	14.500000	14.5	0.000000	0.588461	15.627824	16.216285	0.036288
Basic 13-Ns Relations	0.878218	15.354803	16.233021	0.054101	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Basic 14-Vnf Relations	0.878218	15.354803	16.233021	0.054101	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Basic 15-Rbac Configurations	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Basic 16-Advanced Onboarding And Scaling	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Basic 17-Delete Vnf Package	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Basic 18-Ns Ip Profile	0.013843	16.219178	16.233021	0.000853	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Basic 19-Vnf Ip Profile	0.013843	16.219178	16.233021	0.000853	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Basic 20-Manual Native Charm Vdu Scaling	1.173044	15.059977	16.233021	0.072263	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Basic 21-Persistent Volumes	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.0	0.000000	0.000000	0.000000	0.000000	0.000000
Basic 21-Support Of Volumes	0.000000	16.233021	16.233021	0.000000	0.000000	0.000000	0.0	0.000000	0.000000	16.216285	16.216285	0.000000
Basic 22-Cross Model Relations	2.526516	13.706505	16.233021	0.155641	0.000000	0.000000	0.0	0.000000	3.337153	12.879132	16.216285	0.205790
Basic 23-Sol004 Sol007 Packages	0.000000	16.233021	16.233021	0.000000	0.000000	0.000000	0.0	0.000000	0.000000	16.216285	16.216285	0.000000
Basic 24-Affinity Groups	0.634410	15.598611	16.233021	0.039081	0.000000	14.500000	14.5	0.000000	1.308623	14.907662	16.216285	0.080698
Basic 25-Update Charm In Running Vnf Instance	0.000000	16.233021	16.233021	0.000000	0.000000	0.000000	0.0	0.000000	0.000000	16.216285	16.216285	0.000000
Basic 26-Secure Helm Execution Environment	0.000000	0.584722	0.584722	0.000000	0.000000	0.000000	0.0	0.000000	0.000000	0.000000	0.000000	0.000000
Basic 27-Update Helm Ee In Running Vnf Instance	7.584734	0.000000	7.584734	1.000000	0.000000	0.000000	0.0	0.000000	0.000000	0.000000	0.000000	0.000000
Epa 01-Epa Sriov	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Epa 02-Additional Capabilities	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Epa 03-Crud Operations On Sdnc	1.737847	14.495174	16.233021	0.107056	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Epa 04-Epa Underlay Sriov	1.435150	14.797870	16.233021	0.088409	0.000000	14.500000	14.5	0.000000	1.693762	14.522523	16.216285	0.104448
Epa 05-Epa Underlay Passthrough	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.0	0.000000	0.000000	0.000000	0.000000	0.000000
Fail 01-Insufficient Resources	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Hackfest Basic	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Hackfest Cloudinit	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Hackfest Multivdu	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Heal 01-Volume Vdu Healing	1.878171	14.354850	16.233021	0.115701	0.000000	0.000000	0.0	0.000000	0.000000	16.216285	16.216285	0.000000
Heal 02-Scale Vdu Healing	1.512627	14.720394	16.233021	0.093182	0.000000	0.000000	0.0	0.000000	0.747940	15.468345	16.216285	0.046123
Heal 03-Multiple Healing	0.878218	15.354803	16.233021	0.054101	0.000000	0.000000	0.0	0.000000	0.748657	15.467627	16.216285	0.046167
Heal 04-Autohealing	3.737847	12.495174	16.233021	0.230262	0.000000	0.000000	0.0	0.000000	0.748657	15.467627	16.216285	0.046167
K8S 01-Create K8S Cluster	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.0	0.000000	0.000000	0.000000	0.000000	0.000000
K8S 02-K8Scluster Creation	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
K8S 03-Simple K8S	1.648299	14.584722	16.233021	0.101540	0.000000	14.500000	14.5	0.000000	2.588495	13.627789	16.216285	0.159623
K8S 04-Openldap Helm	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
K8S 05-K8S Proxy Charms	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
K8S 06-K8S Secure Key Management	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
K8S 07-Dummy Helm	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
K8S 08-Simple K8S Scaling	1.648299	14.584722	16.233021	0.101540	0.000000	14.500000	14.5	0.000000	2.588495	13.627789	16.216285	0.159623
K8S 09-Pebble Charm K8S	1.648299	14.584722	16.233021	0.101540	0.000000	0.000000	0.0	0.000000	2.588495	13.627789	16.216285	0.159623
K8S 10-Sol004 Sol007 With K8S Proxy Charms	0.000000	16.233021	16.233021	0.000000	0.000000	0.000000	0.0	0.000000	0.000000	16.216285	16.216285	0.000000
K8S 11-Simple Helm K8S Scaling	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.0	0.000000	0.000000	0.000000	0.000000	0.000000
K8S 12-Openldap Helm Day-2	1.648299	14.584722	16.233021	0.101540	0.000000	0.000000	0.0	0.000000	2.588495	13.627789	16.216285	0.159623
Quotas 01-Quota Enforcement	0.000000	16.233021	16.233021	0.000000	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Sa 01-Vnf With Vim Metrics	6.016157	10.216863	16.233021	0.370612	0.000000	14.500000	14.5	0.000000	2.627778	13.588507	16.216285	0.162046
Sa 02-Vnf With Vim Metrics And Autoscaling	6.016157	10.216863	16.233021	0.370612	0.000000	14.500000	14.5	0.000000	3.627789	12.588495	16.216285	0.223713
Sa 07-Alarms From Sa-Related Vnfs	6.016157	10.216863	16.233021	0.370612	0.000000	14.500000	14.5	0.000000	4.627813	11.588472	16.216285	0.285381
Sa 08-Vnf With Vnf Indicators Snmp	1.306412	14.926609	16.233021	0.080479	2.000012	12.499988	14.5	0.137932	0.000000	16.216285	16.216285	0.000000
Slice 01-Network Slicing	0.584722	15.648299	16.233021	0.036021	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Slice 02-Shared Network Slicing	0.584722	15.648299	16.233021	0.036021	0.000000	14.500000	14.5	0.000000	0.000000	16.216285	16.216285	0.000000
Sol003 01-Vnf-Lifecycle-Management	0.000000	16.233021	16.233021	0.000000	0.000000	0.000000	0.0	0.000000	0.000000	16.216285	16.216285	0.000000
basic 23-delete vnf package SOL004 SOL007	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.0	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.0	0.000000	0.000000	0.000000	0.000000	0.000000

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	2394	2022-11-26 02:06:18	14772996	UNSTABLE	FAIL	519.0	27.0
1	osm-stage_3-merge/v12.0	220	2022-11-26 01:04:18	27977	FAILURE	UNAVAILABLE	NaN	NaN
2	osm-stage_3-merge/v11.0	332	2022-08-08 23:00:14	11064864	SUCCESS	PASS	421.0	0.0
3	osm-stage_3-merge/v10.0	636	2022-11-26 04:08:18	9407666	SUCCESS	PASS	380.0	0.0

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

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

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

Click to see the details of build 636 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
83	Basic 12-Ns Primitives	FAIL	2022-11-26 02:52:37	2022-11-26 02:55:42	6	3	Instantiate NS	Create Network Service
98	Basic 27-Update Helm Ee In Running Vnf Instance	FAIL	2022-11-26 03:42:45	2022-11-26 03:44:16	6	10	Instantiate Network Service	Create Network Service
125	Sa 08-Vnf With Vnf Indicators Snmp	FAIL	2022-11-26 05:47:40	2022-11-26 05:59:17	5	2	Instantiate Network Service	Create Network Service
126	Slice 01-Network Slicing	FAIL	2022-11-26 05:59:17	2022-11-26 06:03:12	8	5	Network Slice Instance Test	Create Network Slice
127	Slice 02-Shared Network Slicing	FAIL	2022-11-26 06:03:12	2022-11-26 06:08:13	13	7	Network Slice First Instance	Create Network Slice

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

	name	status	starttime	endtime	pass	fail	failed_test_name	failed_keyword

osm-stage_3-merge/v11.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
8	Basic 12-Ns Primitives	Instantiate NS	Create Network Service	FAIL	2022-11-26 02:52:44	2022-11-26 02:54:33
11	Basic 12-Ns Primitives	Check NS Charm Application Name	Get Application Name NS Level Charm	FAIL	2022-11-26 02:54:33	2022-11-26 02:54:33
14	Basic 12-Ns Primitives	Check VDU Charm Application Name	Get Application Name VDU Level Charm	FAIL	2022-11-26 02:54:33	2022-11-26 02:54:33
25	Basic 27-Update Helm Ee In Running Vnf Instance	Instantiate Network Service	Create Network Service	FAIL	2022-11-26 03:42:49	2022-11-26 03:43:31
27	Basic 27-Update Helm Ee In Running Vnf Instance	Set NS Update Config	Variable Should Exist	FAIL	2022-11-26 03:43:31	2022-11-26 03:43:31
32	Basic 27-Update Helm Ee In Running Vnf Instance	Get Management Ip Address	Get Vnf Management Ip Address	FAIL	2022-11-26 03:43:31	2022-11-26 03:43:31
35	Basic 27-Update Helm Ee In Running Vnf Instance	Test SSH Access	Variable Should Exist	FAIL	2022-11-26 03:43:31	2022-11-26 03:43:31
38	Basic 27-Update Helm Ee In Running Vnf Instance	Check Remote Files Created Via Day 1 Operation	Check If remote File Exists	FAIL	2022-11-26 03:43:31	2022-11-26 03:43:31
39	Basic 27-Update Helm Ee In Running Vnf Instance	Execute Day 2 Operation	Variable Should Exist	FAIL	2022-11-26 03:43:31	2022-11-26 03:43:31
41	Basic 27-Update Helm Ee In Running Vnf Instance	Check Remote File Created Via Day 2 Operation	Check If remote File Exists	FAIL	2022-11-26 03:43:31	2022-11-26 03:43:31
43	Basic 27-Update Helm Ee In Running Vnf Instance	Update Running VNF Instance	Update Network Service	FAIL	2022-11-26 03:43:34	2022-11-26 03:43:34
44	Basic 27-Update Helm Ee In Running Vnf Instance	Execute Day 2 Operation on Upgraded Helm EE	Variable Should Exist	FAIL	2022-11-26 03:43:34	2022-11-26 03:43:34
46	Basic 27-Update Helm Ee In Running Vnf Instance	Check Remote Folder Created Via Day 2 Operation	Check If Remote Folder Exists	FAIL	2022-11-26 03:43:34	2022-11-26 03:43:34
52	Sa 08-Vnf With Vnf Indicators Snmp	Instantiate Network Service	Create Network Service	FAIL	2022-11-26 05:47:44	2022-11-26 05:49:33
58	Sa 08-Vnf With Vnf Indicators Snmp	Get VNF SNMP Metrics	Wait Until Keyword Succeeds	FAIL	2022-11-26 05:49:33	2022-11-26 05:58:33
70	Slice 01-Network Slicing	Network Slice Instance Test	Create Network Slice	FAIL	2022-11-26 05:59:26	2022-11-26 05:59:31
83	Slice 01-Network Slicing	Test Middle Ns Ping	Test Connectivity	FAIL	2022-11-26 06:00:41	2022-11-26 06:01:11
85	Slice 01-Network Slicing	Test Middle Vnf SSH Access	Test SSH Connection	FAIL	2022-11-26 06:01:41	2022-11-26 06:01:41
86	Slice 01-Network Slicing	Test Slice Connectivity	Ping Many	FAIL	2022-11-26 06:01:41	2022-11-26 06:01:41
99	Slice 02-Shared Network Slicing	Network Slice First Instance	Create Network Slice	FAIL	2022-11-26 06:03:23	2022-11-26 06:03:28
101	Slice 02-Shared Network Slicing	Network Slice Second Instance	Create Network Slice	FAIL	2022-11-26 06:03:28	2022-11-26 06:03:33
111	Slice 02-Shared Network Slicing	Get First Slice Vnf IPs	Get Slice Vnf Ip Addresses	FAIL	2022-11-26 06:03:40	2022-11-26 06:03:46
115	Slice 02-Shared Network Slicing	Test Middle Ns Ping	Test Connectivity	FAIL	2022-11-26 06:04:46	2022-11-26 06:05:16
117	Slice 02-Shared Network Slicing	Test Middle Vnf SSH Access	Test SSH Connection	FAIL	2022-11-26 06:05:46	2022-11-26 06:05:46
118	Slice 02-Shared Network Slicing	Test First Slice Connectivity	Ping Many	FAIL	2022-11-26 06:05:46	2022-11-26 06:05:46
127	Slice 02-Shared Network Slicing	Test Second Slice Connectivity	Ping Many	FAIL	2022-11-26 06:06:30	2022-11-26 06:06:30

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

	suite_name	test_name	keyword_name	status	starttime	endtime

osm-stage_3-merge/v11.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

---

---