Analysis of Robot reports from OSM Jenkins

Date and time of the report: 2023-02-09 08:20:40.287554

Analysed period: 2023-01-19 to 2023-02-09.

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.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Basic 05-Instantiation Parameters In Cloud Init	1.000023	20.584769	21.584792	0.046330	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Basic 06-Vnf With Charm	6.999977	14.584815	21.584792	0.324301	0.999965	20.500081	21.500046	0.046510	6.000012	14.709074	20.709086	0.289728	2.000046	19.627778	21.627824	0.092476
Basic 07-Secure Key Management	6.999977	14.584815	21.584792	0.324301	0.999965	20.500081	21.500046	0.046510	6.000012	14.709074	20.709086	0.289728	2.000046	19.627778	21.627824	0.092476
Basic 08-Disable Port Security Network Level	2.000000	19.584792	21.584792	0.092658	0.999965	20.500081	21.500046	0.046510	2.000058	18.709028	20.709086	0.096579	2.000046	19.627778	21.627824	0.092476
Basic 09-Manual Vdu Scaling	0.000000	21.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Basic 11-Native Charms	2.000000	19.584792	21.584792	0.092658	0.999965	20.500081	21.500046	0.046510	2.000058	18.709028	20.709086	0.096579	2.000046	19.627778	21.627824	0.092476
Basic 12-Ns Primitives	6.999977	14.584815	21.584792	0.324301	0.999965	20.500081	21.500046	0.046510	6.000012	14.709074	20.709086	0.289728	2.000046	19.627778	21.627824	0.092476
Basic 13-Ns Relations	0.000000	21.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Basic 14-Vnf Relations	0.000000	21.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Basic 15-Rbac Configurations	0.000000	21.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Basic 16-Advanced Onboarding And Scaling	0.000000	21.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Basic 17-Delete Vnf Package	0.000000	21.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Basic 18-Ns Ip Profile	2.000000	19.584792	21.584792	0.092658	3.000023	18.500023	21.500046	0.139536	2.000058	18.709028	20.709086	0.096579	2.000046	19.627778	21.627824	0.092476
Basic 19-Vnf Ip Profile	2.000000	19.584792	21.584792	0.092658	0.999965	20.500081	21.500046	0.046510	2.000058	18.709028	20.709086	0.096579	2.000046	19.627778	21.627824	0.092476
Basic 20-Manual Native Charm Vdu Scaling	2.000000	19.584792	21.584792	0.092658	3.000023	18.500023	21.500046	0.139536	2.000058	18.709028	20.709086	0.096579	2.000046	19.627778	21.627824	0.092476
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	0.000000	21.584792	21.584792	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Basic 22-Cross Model Relations	2.000023	19.584769	21.584792	0.092659	0.000000	0.000000	0.000000	0.000000	1.000000	19.709086	20.709086	0.048288	1.000023	20.627801	21.627824	0.046238
Basic 23-Sol004 Sol007 Packages	0.000000	21.584792	21.584792	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Basic 24-Affinity Groups	0.000000	21.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Basic 25-Update Charm In Running Vnf Instance	6.999977	14.584815	21.584792	0.324301	0.000000	0.000000	0.000000	0.000000	6.000012	14.709074	20.709086	0.289728	2.000046	19.627778	21.627824	0.092476
Basic 26-Secure Helm Execution Environment	0.000000	21.584792	21.584792	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	0.000000	0.000000	0.000000
Basic 27-Update Helm Ee In Running Vnf Instance	4.584734	17.000058	21.584792	0.212406	0.000000	0.000000	0.000000	0.000000	4.482072	16.227014	20.709086	0.216430	0.000000	0.000000	0.000000	0.000000
Basic 28-Keep Persistent Volumes	0.000000	21.584792	21.584792	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	2.000000	19.584792	21.584792	0.092658	0.999965	20.500081	21.500046	0.046510	2.000058	18.709028	20.709086	0.096579	2.000046	19.627778	21.627824	0.092476
Epa 02-Additional Capabilities	0.000000	21.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Epa 03-Crud Operations On Sdnc	0.000000	21.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Epa 04-Epa Underlay Sriov	2.000000	19.584792	21.584792	0.092658	1.999965	19.500081	21.500046	0.093021	2.935718	17.773368	20.709086	0.141760	3.000046	18.627778	21.627824	0.138712
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	2.000000	19.584792	21.584792	0.092658	0.999965	20.500081	21.500046	0.046510	2.000058	18.709028	20.709086	0.096579	2.000046	19.627778	21.627824	0.092476
Hackfest Basic	0.000000	21.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Hackfest Cloudinit	2.000000	19.584792	21.584792	0.092658	0.999965	20.500081	21.500046	0.046510	2.000058	18.709028	20.709086	0.096579	2.000046	19.627778	21.627824	0.092476
Hackfest Multivdu	2.000000	19.584792	21.584792	0.092658	0.999965	20.500081	21.500046	0.046510	2.000058	18.709028	20.709086	0.096579	2.000046	19.627778	21.627824	0.092476
Heal 01-Volume Vdu Healing	2.000000	19.584792	21.584792	0.092658	0.000000	0.000000	0.000000	0.000000	2.000058	18.709028	20.709086	0.096579	2.000046	19.627778	21.627824	0.092476
Heal 02-Scale Vdu Healing	2.000000	19.584792	21.584792	0.092658	0.000000	0.000000	0.000000	0.000000	2.709039	18.000046	20.709086	0.130814	2.000046	19.627778	21.627824	0.092476
Heal 03-Multiple Healing	2.000000	19.584792	21.584792	0.092658	0.000000	0.000000	0.000000	0.000000	2.709039	18.000046	20.709086	0.130814	2.000046	19.627778	21.627824	0.092476
Heal 04-Autohealing	0.000000	21.584792	21.584792	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
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.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
K8S 03-Simple K8S	2.000023	19.584769	21.584792	0.092659	2.000023	19.500023	21.500046	0.093024	0.000000	20.709086	20.709086	0.000000	1.000023	20.627801	21.627824	0.046238
K8S 04-Openldap Helm	0.000000	21.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
K8S 05-K8S Proxy Charms	2.000000	19.584792	21.584792	0.092658	0.999965	20.500081	21.500046	0.046510	2.000058	18.709028	20.709086	0.096579	2.000046	19.627778	21.627824	0.092476
K8S 06-K8S Secure Key Management	2.000000	19.584792	21.584792	0.092658	0.999965	20.500081	21.500046	0.046510	2.000058	18.709028	20.709086	0.096579	2.000046	19.627778	21.627824	0.092476
K8S 07-Dummy Helm	0.000000	21.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
K8S 08-Simple K8S Scaling	2.000023	19.584769	21.584792	0.092659	2.000023	19.500023	21.500046	0.093024	0.000000	20.709086	20.709086	0.000000	1.000023	20.627801	21.627824	0.046238
K8S 09-Pebble Charm K8S	2.000023	19.584769	21.584792	0.092659	0.000000	0.000000	0.000000	0.000000	0.000000	20.709086	20.709086	0.000000	1.000023	20.627801	21.627824	0.046238
K8S 10-Sol004 Sol007 With K8S Proxy Charms	2.000000	19.584792	21.584792	0.092658	0.000000	0.000000	0.000000	0.000000	2.000058	18.709028	20.709086	0.096579	2.000046	19.627778	21.627824	0.092476
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	9.000000	12.584792	21.584792	0.416960	0.000000	0.000000	0.000000	0.000000	6.708993	14.000093	20.709086	0.323964	1.000023	20.627801	21.627824	0.046238
Quotas 01-Quota Enforcement	0.000000	21.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Sa 01-Vnf With Vim Metrics	0.000000	21.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Sa 02-Vnf With Vim Metrics And Autoscaling	0.000000	21.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Sa 07-Alarms From Sa-Related Vnfs	0.000000	21.584792	21.584792	0.000000	0.000000	21.500046	21.500046	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	0.000000
Sa 08-Vnf With Vnf Indicators Snmp	2.000000	19.584792	21.584792	0.092658	0.999965	20.500081	21.500046	0.046510	2.000058	18.709028	20.709086	0.096579	2.000046	19.627778	21.627824	0.092476
Slice 01-Network Slicing	2.000000	19.584792	21.584792	0.092658	0.999965	20.500081	21.500046	0.046510	2.000058	18.709028	20.709086	0.096579	2.000046	19.627778	21.627824	0.092476
Slice 02-Shared Network Slicing	2.000000	19.584792	21.584792	0.092658	0.999965	20.500081	21.500046	0.046510	3.000058	17.709028	20.709086	0.144867	2.000046	19.627778	21.627824	0.092476
Sol003 01-Vnf-Lifecycle-Management	11.584757	10.000035	21.584792	0.536709	0.000000	0.000000	0.000000	0.000000	0.000000	20.709086	20.709086	0.000000	0.000000	21.627824	21.627824	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	2480	2023-02-09 02:06:17	15127676	UNSTABLE	FAIL	558.0	10.0
1	osm-stage_3-merge/v13.0	104	2023-02-08 23:07:21	14255597	UNSTABLE	FAIL	534.0	24.0
2	osm-stage_3-merge/v12.0	298	2023-02-09 01:04:17	16672161	SUCCESS	PASS	530.0	0.0
3	osm-stage_3-merge/v10.0	716	2023-02-09 04:08:17	9257090	SUCCESS	PASS	380.0	0.0

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

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

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

Click to see the details of build 716 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
98	Basic 27-Update Helm Ee In Running Vnf Instance	FAIL	2023-02-09 03:50:29	2023-02-09 03:55:29	13	3	Update Running VNF Instance	Update Network Service
129	Sol003 01-Vnf-Lifecycle-Management	FAIL	2023-02-09 06:14:47	2023-02-09 06:15:17	3	7	Instantiate VNF	Post Api Request

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

	name	status	starttime	endtime	pass	fail	failed_test_name	failed_keyword
252	Heal 02-Scale Vdu Healing	FAIL	2023-02-09 01:15:03	2023-02-09 01:22:07	6	9	Network Service Instance Test	Create Network Service
253	Heal 03-Multiple Healing	FAIL	2023-02-09 01:22:07	2023-02-09 01:28:21	6	10	Network Service Instance Test	Create Network Service
264	K8S 12-Openldap Helm Day-2	FAIL	2023-02-09 02:11:43	2023-02-09 02:23:46	10	5	Create Network Service Instance	Create Network Service

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
21	Basic 27-Update Helm Ee In Running Vnf Instance	Update Running VNF Instance	Update Network Service	FAIL	2023-02-09 03:52:29	2023-02-09 03:54:48
23	Basic 27-Update Helm Ee In Running Vnf Instance	Execute Day 2 Operation on Upgraded Helm EE	Execute NS Action	FAIL	2023-02-09 03:54:48	2023-02-09 03:54:48
24	Basic 27-Update Helm Ee In Running Vnf Instance	Check Remote Folder Created Via Day 2 Operation	Check If Remote Folder Exists	FAIL	2023-02-09 03:54:48	2023-02-09 03:54:50
51	Sol003 01-Vnf-Lifecycle-Management	Instantiate VNF	Post Api Request	FAIL	2023-02-09 06:14:56	2023-02-09 06:14:56
59	Sol003 01-Vnf-Lifecycle-Management	Query VNF Instances	Should Be Equal	FAIL	2023-02-09 06:14:58	2023-02-09 06:14:58
64	Sol003 01-Vnf-Lifecycle-Management	Query VNF Instance ID	Get Api Request	FAIL	2023-02-09 06:15:00	2023-02-09 06:15:00
73	Sol003 01-Vnf-Lifecycle-Management	Query VNF LCM Ops	Set Suite Variable	FAIL	2023-02-09 06:15:02	2023-02-09 06:15:02
75	Sol003 01-Vnf-Lifecycle-Management	Query VNF LCM Ops ID	Get Api Request	FAIL	2023-02-09 06:15:04	2023-02-09 06:15:04
83	Sol003 01-Vnf-Lifecycle-Management	Scale VNF	Post Api Request	FAIL	2023-02-09 06:15:06	2023-02-09 06:15:06
96	Sol003 01-Vnf-Lifecycle-Management	Terminate VNF	Post Api Request	FAIL	2023-02-09 06:15:09	2023-02-09 06:15:09

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

	suite_name	test_name	keyword_name	status	starttime	endtime
112	Heal 02-Scale Vdu Healing	Network Service Instance Test	Create Network Service	FAIL	2023-02-09 01:15:09	2023-02-09 01:20:42
115	Heal 02-Scale Vdu Healing	Scale Out Charm VNF	Get Vnf Id	FAIL	2023-02-09 01:20:42	2023-02-09 01:20:42
124	Heal 02-Scale Vdu Healing	Get VIM Objects	Variable Should Exist	FAIL	2023-02-09 01:20:42	2023-02-09 01:20:42
129	Heal 02-Scale Vdu Healing	Get Charm VNF Info	Variable Should Exist	FAIL	2023-02-09 01:20:42	2023-02-09 01:20:42
137	Heal 02-Scale Vdu Healing	Halt Charm VDU	Variable Should Exist	FAIL	2023-02-09 01:20:42	2023-02-09 01:20:42
140	Heal 02-Scale Vdu Healing	Heal Charm VDU	Variable Should Exist	FAIL	2023-02-09 01:20:42	2023-02-09 01:20:42
142	Heal 02-Scale Vdu Healing	Check VNF After Healing	Variable Should Exist	FAIL	2023-02-09 01:20:42	2023-02-09 01:20:42
154	Heal 02-Scale Vdu Healing	Update VIM Objects	Variable Should Exist	FAIL	2023-02-09 01:20:42	2023-02-09 01:20:42
167	Heal 03-Multiple Healing	Network Service Instance Test	Create Network Service	FAIL	2023-02-09 01:22:13	2023-02-09 01:27:16
170	Heal 03-Multiple Healing	Scale Out Charm VNF	Get Vnf Id	FAIL	2023-02-09 01:27:16	2023-02-09 01:27:16
179	Heal 03-Multiple Healing	Get VIM Objects	Variable Should Exist	FAIL	2023-02-09 01:27:16	2023-02-09 01:27:16
184	Heal 03-Multiple Healing	Get Charm VNF Info	Variable Should Exist	FAIL	2023-02-09 01:27:16	2023-02-09 01:27:16
192	Heal 03-Multiple Healing	Get Volume VNF Info	Variable Should Exist	FAIL	2023-02-09 01:27:16	2023-02-09 01:27:16
204	Heal 03-Multiple Healing	Stop VDUs	Variable Should Exist	FAIL	2023-02-09 01:27:16	2023-02-09 01:27:16
210	Heal 03-Multiple Healing	Heal VDUs	Variable Should Exist	FAIL	2023-02-09 01:27:16	2023-02-09 01:27:16
213	Heal 03-Multiple Healing	Check VNFs After Healing	Variable Should Exist	FAIL	2023-02-09 01:27:16	2023-02-09 01:27:16
226	Heal 03-Multiple Healing	Update VIM Objects	Variable Should Exist	FAIL	2023-02-09 01:27:16	2023-02-09 01:27:16
239	K8S 12-Openldap Helm Day-2	Create Network Service Instance	Create Network Service	FAIL	2023-02-09 02:12:24	2023-02-09 02:17:27
247	K8S 12-Openldap Helm Day-2	Execute Day 2 Operations	Execute NS K8s Action	FAIL	2023-02-09 02:17:30	2023-02-09 02:18:36
249	K8S 12-Openldap Helm Day-2	Execute Upgrade Operation	Execute NS K8s Action	FAIL	2023-02-09 02:18:36	2023-02-09 02:19:42
253	K8S 12-Openldap Helm Day-2	Check Replicas After Upgrade Operation	Should Be Equal As Integers	FAIL	2023-02-09 02:20:14	2023-02-09 02:20:14
255	K8S 12-Openldap Helm Day-2	Execute Rollback Operation	Execute NS K8s Action	FAIL	2023-02-09 02:20:14	2023-02-09 02:21:20

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

---

---