Analysis of Robot reports from OSM Jenkins

Date and time of the report: 2023-01-11 08:20:32.290531

Analysed period: 2022-12-21 to 2023-01-11.

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 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
suites
Basic 01-Crud Operations On Vim Targets	0.000000	21.584618	21.584618	0.000000	0.000000	21.499884	21.499884	0.000000	0.000000	20.708912	20.708912	0.000000	0.000000	21.627674	21.627674	0.000000
Basic 05-Instantiation Parameters In Cloud Init	7.999907	13.584711	21.584618	0.370630	7.999907	13.499977	21.499884	0.372091	0.999988	19.708924	20.708912	0.048288	5.999907	15.627766	21.627674	0.277418
Basic 06-Vnf With Charm	8.999907	12.584711	21.584618	0.416959	8.999896	12.499988	21.499884	0.418602	2.999919	17.708993	20.708912	0.144861	6.999907	14.627766	21.627674	0.323655
Basic 07-Secure Key Management	8.999907	12.584711	21.584618	0.416959	9.999896	11.499988	21.499884	0.465114	2.999919	17.708993	20.708912	0.144861	6.999907	14.627766	21.627674	0.323655
Basic 08-Disable Port Security Network Level	7.999896	13.584722	21.584618	0.370629	9.999896	11.499988	21.499884	0.465114	2.999919	17.708993	20.708912	0.144861	7.999907	13.627766	21.627674	0.369892
Basic 09-Manual Vdu Scaling	6.999896	14.584722	21.584618	0.324300	7.999907	13.499977	21.499884	0.372091	2.999919	17.708993	20.708912	0.144861	6.999907	14.627766	21.627674	0.323655
Basic 11-Native Charms	6.999896	14.584722	21.584618	0.324300	7.999907	13.499977	21.499884	0.372091	2.999919	17.708993	20.708912	0.144861	6.999907	14.627766	21.627674	0.323655
Basic 12-Ns Primitives	3.584653	17.999965	21.584618	0.166074	7.999907	13.499977	21.499884	0.372091	2.999919	17.708993	20.708912	0.144861	1.000000	20.627674	21.627674	0.046237
Basic 13-Ns Relations	8.584560	13.000058	21.584618	0.397717	8.999896	12.499988	21.499884	0.418602	2.999919	17.708993	20.708912	0.144861	0.000000	21.627674	21.627674	0.000000
Basic 14-Vnf Relations	6.999896	14.584722	21.584618	0.324300	7.999907	13.499977	21.499884	0.372091	2.999919	17.708993	20.708912	0.144861	0.000000	21.627674	21.627674	0.000000
Basic 15-Rbac Configurations	0.000000	21.584618	21.584618	0.000000	0.000000	21.499884	21.499884	0.000000	0.000000	20.708912	20.708912	0.000000	0.000000	21.627674	21.627674	0.000000
Basic 16-Advanced Onboarding And Scaling	7.999907	13.584711	21.584618	0.370630	9.999896	11.499988	21.499884	0.465114	4.999803	15.709109	20.708912	0.241432	6.999907	14.627766	21.627674	0.323655
Basic 17-Delete Vnf Package	0.000000	21.584618	21.584618	0.000000	0.000000	21.499884	21.499884	0.000000	0.000000	20.708912	20.708912	0.000000	0.000000	21.627674	21.627674	0.000000
Basic 18-Ns Ip Profile	6.999896	14.584722	21.584618	0.324300	7.999907	13.499977	21.499884	0.372091	2.999919	17.708993	20.708912	0.144861	0.000000	21.627674	21.627674	0.000000
Basic 19-Vnf Ip Profile	1.999988	19.584630	21.584618	0.092658	8.999907	12.499977	21.499884	0.418603	2.999919	17.708993	20.708912	0.144861	0.000000	21.627674	21.627674	0.000000
Basic 20-Manual Native Charm Vdu Scaling	6.999896	14.584722	21.584618	0.324300	9.999896	11.499988	21.499884	0.465114	2.999919	17.708993	20.708912	0.144861	5.999907	15.627766	21.627674	0.277418
Basic 21-Persistent Volumes	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
Basic 21-Support Of Volumes	1.999988	19.584630	21.584618	0.092658	0.000000	0.000000	0.000000	0.000000	0.999988	19.708924	20.708912	0.048288	0.000000	21.627674	21.627674	0.000000
Basic 22-Cross Model Relations	8.999907	12.584711	21.584618	0.416959	0.000000	0.000000	0.000000	0.000000	6.999884	13.709028	20.708912	0.338013	8.999907	12.627766	21.627674	0.416129
Basic 23-Sol004 Sol007 Packages	0.000000	21.584618	21.584618	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	20.708912	20.708912	0.000000	0.000000	21.627674	21.627674	0.000000
Basic 24-Affinity Groups	3.000000	18.584618	21.584618	0.138988	8.999907	12.499977	21.499884	0.418603	2.999919	17.708993	20.708912	0.144861	6.999907	14.627766	21.627674	0.323655
Basic 25-Update Charm In Running Vnf Instance	1.999988	19.584630	21.584618	0.092658	0.000000	0.000000	0.000000	0.000000	2.999919	17.708993	20.708912	0.144861	5.999907	15.627766	21.627674	0.277418
Basic 26-Secure Helm Execution Environment	1.999988	19.584630	21.584618	0.092658	0.000000	0.000000	0.000000	0.000000	0.999988	19.708924	20.708912	0.048288	0.000000	0.000000	0.000000	0.000000
Basic 27-Update Helm Ee In Running Vnf Instance	9.999931	11.584688	21.584618	0.463290	0.000000	0.000000	0.000000	0.000000	6.000035	14.708877	20.708912	0.289732	0.000000	0.000000	0.000000	0.000000
Basic 28-Keep Persistent Volumes	0.000000	6.584722	6.584722	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
Epa 01-Epa Sriov	6.999896	14.584722	21.584618	0.324300	3.999988	17.499896	21.499884	0.186047	0.999988	19.708924	20.708912	0.048288	5.999907	15.627766	21.627674	0.277418
Epa 02-Additional Capabilities	1.999988	19.584630	21.584618	0.092658	3.999988	17.499896	21.499884	0.186047	0.999988	19.708924	20.708912	0.048288	5.999907	15.627766	21.627674	0.277418
Epa 03-Crud Operations On Sdnc	0.000000	21.584618	21.584618	0.000000	0.000000	21.499884	21.499884	0.000000	0.000000	20.708912	20.708912	0.000000	0.000000	21.627674	21.627674	0.000000
Epa 04-Epa Underlay Sriov	6.000000	15.584618	21.584618	0.277976	12.999942	8.499942	21.499884	0.604652	2.999919	17.708993	20.708912	0.144861	6.627627	15.000046	21.627674	0.306442
Epa 05-Epa Underlay Passthrough	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
Fail 01-Insufficient Resources	0.000000	21.584618	21.584618	0.000000	0.000000	21.499884	21.499884	0.000000	0.000000	20.708912	20.708912	0.000000	0.000000	21.627674	21.627674	0.000000
Hackfest Basic	0.000000	21.584618	21.584618	0.000000	7.999919	13.499965	21.499884	0.372091	0.999988	19.708924	20.708912	0.048288	0.000000	21.627674	21.627674	0.000000
Hackfest Cloudinit	7.999907	13.584711	21.584618	0.370630	9.999896	11.499988	21.499884	0.465114	4.999803	15.709109	20.708912	0.241432	7.999907	13.627766	21.627674	0.369892
Hackfest Multivdu	3.000000	18.584618	21.584618	0.138988	9.999896	11.499988	21.499884	0.465114	4.999803	15.709109	20.708912	0.241432	8.999907	12.627766	21.627674	0.416129
Heal 01-Volume Vdu Healing	3.000000	18.584618	21.584618	0.138988	0.000000	0.000000	0.000000	0.000000	4.999803	15.709109	20.708912	0.241432	7.999907	13.627766	21.627674	0.369892
Heal 02-Scale Vdu Healing	7.999907	13.584711	21.584618	0.370630	0.000000	0.000000	0.000000	0.000000	4.999803	15.709109	20.708912	0.241432	7.999907	13.627766	21.627674	0.369892
Heal 03-Multiple Healing	7.999907	13.584711	21.584618	0.370630	0.000000	0.000000	0.000000	0.000000	5.999896	14.709016	20.708912	0.289725	7.999907	13.627766	21.627674	0.369892
Heal 04-Autohealing	3.000000	18.584618	21.584618	0.138988	0.000000	0.000000	0.000000	0.000000	3.999803	16.709109	20.708912	0.193144	1.000000	20.627674	21.627674	0.046237
K8S 01-Create K8S Cluster	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 02-K8Scluster Creation	0.000000	21.584618	21.584618	0.000000	0.000000	21.499884	21.499884	0.000000	0.000000	20.708912	20.708912	0.000000	0.000000	21.627674	21.627674	0.000000
K8S 03-Simple K8S	1.999988	19.584630	21.584618	0.092658	4.999977	16.499907	21.499884	0.232558	1.999988	18.708924	20.708912	0.096576	0.000000	21.627674	21.627674	0.000000
K8S 04-Openldap Helm	0.000000	21.584618	21.584618	0.000000	0.000000	21.499884	21.499884	0.000000	0.000000	20.708912	20.708912	0.000000	0.000000	21.627674	21.627674	0.000000
K8S 05-K8S Proxy Charms	3.000000	18.584618	21.584618	0.138988	4.999977	16.499907	21.499884	0.232558	4.999803	15.709109	20.708912	0.241432	2.000000	19.627674	21.627674	0.092474
K8S 06-K8S Secure Key Management	7.999907	13.584711	21.584618	0.370630	5.999977	15.499907	21.499884	0.279070	5.999896	14.709016	20.708912	0.289725	7.999907	13.627766	21.627674	0.369892
K8S 07-Dummy Helm	0.000000	21.584618	21.584618	0.000000	0.000000	21.499884	21.499884	0.000000	0.000000	20.708912	20.708912	0.000000	0.000000	21.627674	21.627674	0.000000
K8S 08-Simple K8S Scaling	1.999988	19.584630	21.584618	0.092658	4.999977	16.499907	21.499884	0.232558	1.999988	18.708924	20.708912	0.096576	0.000000	21.627674	21.627674	0.000000
K8S 09-Pebble Charm K8S	1.999988	19.584630	21.584618	0.092658	0.000000	0.000000	0.000000	0.000000	1.999988	18.708924	20.708912	0.096576	0.000000	21.627674	21.627674	0.000000
K8S 10-Sol004 Sol007 With K8S Proxy Charms	1.999988	19.584630	21.584618	0.092658	0.000000	0.000000	0.000000	0.000000	5.999896	14.709016	20.708912	0.289725	7.999907	13.627766	21.627674	0.369892
K8S 11-Simple Helm K8S Scaling	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 12-Openldap Helm Day-2	1.999988	19.584630	21.584618	0.092658	0.000000	0.000000	0.000000	0.000000	1.999988	18.708924	20.708912	0.096576	0.000000	21.627674	21.627674	0.000000
Quotas 01-Quota Enforcement	0.000000	21.584618	21.584618	0.000000	0.000000	21.499884	21.499884	0.000000	0.000000	20.708912	20.708912	0.000000	0.000000	21.627674	21.627674	0.000000
Sa 01-Vnf With Vim Metrics	11.999873	9.584745	21.584618	0.555946	9.999896	11.499988	21.499884	0.465114	11.999931	8.708981	20.708912	0.579457	11.999873	9.627801	21.627674	0.554839
Sa 02-Vnf With Vim Metrics And Autoscaling	11.999873	9.584745	21.584618	0.555946	9.999896	11.499988	21.499884	0.465114	11.999931	8.708981	20.708912	0.579457	11.999873	9.627801	21.627674	0.554839
Sa 07-Alarms From Sa-Related Vnfs	11.999873	9.584745	21.584618	0.555946	9.999896	11.499988	21.499884	0.465114	11.999931	8.708981	20.708912	0.579457	11.999873	9.627801	21.627674	0.554839
Sa 08-Vnf With Vnf Indicators Snmp	21.584618	0.000000	21.584618	1.000000	0.000000	21.499884	21.499884	0.000000	3.999873	16.709039	20.708912	0.193147	0.000000	21.627674	21.627674	0.000000
Slice 01-Network Slicing	1.999988	19.584630	21.584618	0.092658	7.999907	13.499977	21.499884	0.372091	7.999896	12.709016	20.708912	0.386302	6.999907	14.627766	21.627674	0.323655
Slice 02-Shared Network Slicing	7.999907	13.584711	21.584618	0.370630	7.999907	13.499977	21.499884	0.372091	6.999907	13.709005	20.708912	0.338014	7.999907	13.627766	21.627674	0.369892
Sol003 01-Vnf-Lifecycle-Management	0.000000	21.584618	21.584618	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	20.708912	20.708912	0.000000	0.000000	21.627674	21.627674	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
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

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	2450	2023-01-11 02:06:13	15382373	UNSTABLE	FAIL	562.0	6.0
1	osm-stage_3-merge/v13.0	73	2023-01-10 23:07:12	14536134	SUCCESS	PASS	558.0	0.0
2	osm-stage_3-merge/v12.0	268	2023-01-11 01:04:13	14422168	SUCCESS	FAIL	528.0	2.0
3	osm-stage_3-merge/v10.0	684	2023-01-11 04:08:08	8997030	SUCCESS	PASS	380.0	0.0

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

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

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

Click to see the details of build 684 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	2023-01-11 02:54:28	2023-01-11 02:57:29	6	3	Instantiate NS	Create Network Service
84	Basic 13-Ns Relations	FAIL	2023-01-11 02:57:29	2023-01-11 03:01:59	7	1	Instantiate Charm Network Service	Create Network Service
126	Sa 08-Vnf With Vnf Indicators Snmp	FAIL	2023-01-11 05:50:24	2023-01-11 06:06:01	5	2	Instantiate Network Service	Create Network Service

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
193	Epa 04-Epa Underlay Sriov	FAIL	2023-01-11 02:44:19	2023-01-11 02:47:50	7	2	Ping from Vnf1 to Vnf2	Execute Remote Command Check Rc Return Output

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	2023-01-11 02:54:36	2023-01-11 02:56:23
11	Basic 12-Ns Primitives	Check NS Charm Application Name	Get Application Name NS Level Charm	FAIL	2023-01-11 02:56:23	2023-01-11 02:56:23
14	Basic 12-Ns Primitives	Check VDU Charm Application Name	Get Application Name VDU Level Charm	FAIL	2023-01-11 02:56:23	2023-01-11 02:56:23
25	Basic 13-Ns Relations	Instantiate Charm Network Service	Create Network Service	FAIL	2023-01-11 02:57:37	2023-01-11 03:01:01
33	Sa 08-Vnf With Vnf Indicators Snmp	Instantiate Network Service	Create Network Service	FAIL	2023-01-11 05:50:28	2023-01-11 05:56:04
39	Sa 08-Vnf With Vnf Indicators Snmp	Get VNF SNMP Metrics	Wait Until Keyword Succeeds	FAIL	2023-01-11 05:56:04	2023-01-11 06:05:04

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
60	Epa 04-Epa Underlay Sriov	Ping from Vnf1 to Vnf2	Execute Remote Command Check Rc Return Output	FAIL	2023-01-11 02:46:42	2023-01-11 02:46:45
63	Epa 04-Epa Underlay Sriov	Ping from Vnf2 to Vnf1	Execute Remote Command Check Rc Return Output	FAIL	2023-01-11 02:46:45	2023-01-11 02:46:53

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

	suite_name	test_name	keyword_name	status	starttime	endtime

---

---