Analysis of Robot reports from OSM Jenkins

Date and time of the report: 2023-07-08 08:20:36.493021

Analysed period: 2023-06-17 to 2023-07-08.

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.0	21.457187	21.457187	0.0	0.0	10.372442	10.372442	0.0	0.0	10.581458	10.581458	0.0	0.000000	10.500220	10.50022	0.000000
Basic 05-Instantiation Parameters In Cloud Init	0.0	21.457187	21.457187	0.0	0.0	10.372442	10.372442	0.0	0.0	10.581458	10.581458	0.0	2.000093	8.500127	10.50022	0.190481
Basic 06-Vnf With Charm	0.0	21.457187	21.457187	0.0	0.0	10.372442	10.372442	0.0	0.0	10.581458	10.581458	0.0	0.000000	10.500220	10.50022	0.000000
Basic 07-Secure Key Management	0.0	21.457187	21.457187	0.0	0.0	10.372442	10.372442	0.0	0.0	10.581458	10.581458	0.0	0.000000	10.500220	10.50022	0.000000
Basic 08-Disable Port Security Network Level	0.0	21.457187	21.457187	0.0	0.0	10.372442	10.372442	0.0	0.0	10.581458	10.581458	0.0	0.000000	10.500220	10.50022	0.000000
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
Slice 01-Network Slicing	0.0	21.457187	21.457187	0.0	0.0	10.372442	10.372442	0.0	0.0	10.581458	10.581458	0.0	0.000000	10.500220	10.50022	0.000000
Slice 02-Shared Network Slicing	0.0	21.457187	21.457187	0.0	0.0	10.372442	10.372442	0.0	0.0	10.581458	10.581458	0.0	0.000000	10.500220	10.50022	0.000000
Sol003 01-Vnf-Lifecycle-Management	0.0	21.457187	21.457187	0.0	0.0	0.000000	0.000000	0.0	0.0	10.581458	10.581458	0.0	0.000000	10.500220	10.50022	0.000000
basic 23-delete vnf package SOL004 SOL007	0.0	0.000000	0.000000	0.0	0.0	0.000000	0.000000	0.0	0.0	0.000000	0.000000	0.0	0.000000	0.000000	0.00000	0.000000
k8s 10-k8s proxy charms SOL004 SOL007	0.0	0.000000	0.000000	0.0	0.0	0.000000	0.000000	0.0	0.0	0.000000	0.000000	0.0	0.000000	0.000000	0.00000	0.000000

63 rows × 16 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	2656	2023-07-08 01:06:46	538168	FAILURE	UNAVAILABLE	NaN	NaN
1	osm-stage_3-merge/v13.0	238	2023-07-07 20:07:49	18466467	UNSTABLE	FAIL	484.0	74.0
2	osm-stage_3-merge/v12.0	433	2023-07-08 00:04:50	15127034	UNSTABLE	FAIL	440.0	90.0
3	osm-stage_3-merge/v10.0	848	2023-07-08 03:08:47	0	FAILURE	UNAVAILABLE	NaN	NaN

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

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

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

Click to see the details of build 848 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/v13.0: (full report)

	name	status	starttime	endtime	pass	fail	failed_test_name	failed_keyword
133	Basic 11-Native Charms	FAIL	2023-07-07 20:57:36	2023-07-07 21:14:23	5	4	Instantiate Charm Network Service	Create Network Service
136	Basic 14-Vnf Relations	FAIL	2023-07-07 21:23:44	2023-07-07 21:40:11	5	1	Instantiate Charm Network Service	Create Network Service
142	Basic 20-Manual Native Charm Vdu Scaling	FAIL	2023-07-07 21:49:28	2023-07-07 21:56:06	10	8	Instantiate Network Service	Create Network Service
144	Basic 22-Cross Model Relations	FAIL	2023-07-07 21:58:27	2023-07-07 22:17:24	9	1	Instantiate Charm Network Service	Create Network Service
159	Heal 02-Scale Vdu Healing	FAIL	2023-07-07 22:58:15	2023-07-07 23:05:13	6	9	Network Service Instance Test	Create Network Service
160	Heal 03-Multiple Healing	FAIL	2023-07-07 23:05:13	2023-07-07 23:37:35	10	6	Heal VDUs	Heal Network Service
162	K8S 02-K8Scluster Creation	FAIL	2023-07-07 23:43:11	2023-07-07 23:43:54	1	1	Add K8s Cluster To OSM	Create K8s Cluster
163	K8S 03-Simple K8S	FAIL	2023-07-07 23:43:54	2023-07-07 23:45:19	7	3	Add K8s Cluster To OSM	Create K8s Cluster
164	K8S 04-Openldap Helm	FAIL	2023-07-07 23:45:19	2023-07-07 23:59:49	3	11	Add K8s Cluster To OSM	Create K8s Cluster
167	K8S 07-Dummy Helm	FAIL	2023-07-08 00:10:53	2023-07-08 00:18:30	2	8	Create Package For OpenLDAP CNF	Create VNFD
168	K8S 08-Simple K8S Scaling	FAIL	2023-07-08 00:18:30	2023-07-08 00:20:01	7	7	Add K8s Cluster To OSM	Create K8s Cluster
169	K8S 09-Pebble Charm K8S	FAIL	2023-07-08 00:20:01	2023-07-08 00:21:24	7	3	Add K8s Cluster To OSM	Create K8s Cluster
171	K8S 12-Openldap Helm Day-2	FAIL	2023-07-08 00:26:20	2023-07-08 00:29:54	3	12	Create Package For OpenLDAP CNF	Create VNFD

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

	name	status	starttime	endtime	pass	fail	failed_test_name	failed_keyword
84	Basic 13-Ns Relations	FAIL	2023-07-08 01:03:20	2023-07-08 01:19:54	7	1	Instantiate Charm Network Service	Create Network Service
85	Basic 14-Vnf Relations	FAIL	2023-07-08 01:19:54	2023-07-08 01:36:21	5	1	Instantiate Charm Network Service	Create Network Service
91	Basic 20-Manual Native Charm Vdu Scaling	FAIL	2023-07-08 01:45:30	2023-07-08 01:51:51	10	8	Instantiate Network Service	Create Network Service
92	Basic 21-Support Of Volumes	FAIL	2023-07-08 01:51:51	2023-07-08 01:53:17	6	4	Network Service Instance Test	Create Network Service
93	Basic 22-Cross Model Relations	FAIL	2023-07-08 01:53:17	2023-07-08 01:54:34	8	2	Add K8s Cluster To OSM	Create K8s Cluster
105	Heal 01-Volume Vdu Healing	FAIL	2023-07-08 02:19:14	2023-07-08 02:25:14	6	10	Network Service Instance Test	Create Network Service
106	Heal 02-Scale Vdu Healing	FAIL	2023-07-08 02:25:14	2023-07-08 02:31:15	6	9	Network Service Instance Test	Create Network Service
107	Heal 03-Multiple Healing	FAIL	2023-07-08 02:31:15	2023-07-08 02:37:17	6	10	Network Service Instance Test	Create Network Service
109	K8S 02-K8Scluster Creation	FAIL	2023-07-08 02:42:55	2023-07-08 02:43:38	1	1	Add K8s Cluster To OSM	Create K8s Cluster
110	K8S 03-Simple K8S	FAIL	2023-07-08 02:43:38	2023-07-08 02:45:00	7	3	Add K8s Cluster To OSM	Create K8s Cluster
111	K8S 04-Openldap Helm	FAIL	2023-07-08 02:45:00	2023-07-08 02:59:26	3	11	Add K8s Cluster To OSM	Create K8s Cluster
114	K8S 07-Dummy Helm	FAIL	2023-07-08 03:11:01	2023-07-08 03:18:46	2	8	Create Package For OpenLDAP CNF	Create VNFD
115	K8S 08-Simple K8S Scaling	FAIL	2023-07-08 03:18:46	2023-07-08 03:20:18	7	7	Add K8s Cluster To OSM	Create K8s Cluster
116	K8S 09-Pebble Charm K8S	FAIL	2023-07-08 03:20:18	2023-07-08 03:21:44	7	3	Add K8s Cluster To OSM	Create K8s Cluster
118	K8S 12-Openldap Helm Day-2	FAIL	2023-07-08 03:27:27	2023-07-08 03:31:01	3	12	Create Package For OpenLDAP CNF	Create VNFD

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/v13.0: (full report)

	suite_name	test_name	keyword_name	status	starttime	endtime
408	Basic 11-Native Charms	Instantiate Charm Network Service	Create Network Service	FAIL	2023-07-07 20:57:40	2023-07-07 21:13:08
410	Basic 11-Native Charms	Get Management Ip Addresses	Get Vnf Management Ip Address	FAIL	2023-07-07 21:13:08	2023-07-07 21:13:08
416	Basic 11-Native Charms	Test SSH Access	Variable Should Exist	FAIL	2023-07-07 21:13:08	2023-07-07 21:13:08
421	Basic 11-Native Charms	Check Remote Files Created Via Day 1 Operations	Check If remote File Exists	FAIL	2023-07-07 21:13:08	2023-07-07 21:13:08
428	Basic 14-Vnf Relations	Instantiate Charm Network Service	Create Network Service	FAIL	2023-07-07 21:23:49	2023-07-07 21:39:14
...	...	...	...	...	...	...
717	K8S 12-Openldap Helm Day-2	Check Replicas After Upgrade Operation	Get Vnf Kdu Replica Count	FAIL	2023-07-08 00:27:18	2023-07-08 00:27:18
721	K8S 12-Openldap Helm Day-2	Execute Rollback Operation	Execute NS K8s Action	FAIL	2023-07-08 00:27:18	2023-07-08 00:27:23
723	K8S 12-Openldap Helm Day-2	Check Replicas After Rollback Operation	Get Vnf Kdu Replica Count	FAIL	2023-07-08 00:27:23	2023-07-08 00:27:23
728	K8S 12-Openldap Helm Day-2	Delete NS Descriptor Test	Delete NSD	FAIL	2023-07-08 00:27:31	2023-07-08 00:27:33
729	K8S 12-Openldap Helm Day-2	Delete VNF Descriptor Test	Delete VNFD	FAIL	2023-07-08 00:27:33	2023-07-08 00:27:35

72 rows × 6 columns

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

	suite_name	test_name	keyword_name	status	starttime	endtime
3	Basic 13-Ns Relations	Instantiate Charm Network Service	Create Network Service	FAIL	2023-07-08 01:03:27	2023-07-08 01:18:58
11	Basic 14-Vnf Relations	Instantiate Charm Network Service	Create Network Service	FAIL	2023-07-08 01:19:59	2023-07-08 01:35:23
18	Basic 20-Manual Native Charm Vdu Scaling	Instantiate Network Service	Create Network Service	FAIL	2023-07-08 01:45:35	2023-07-08 01:51:07
20	Basic 20-Manual Native Charm Vdu Scaling	Get Vnf Id	Variable Should Exist	FAIL	2023-07-08 01:51:07	2023-07-08 01:51:07
24	Basic 20-Manual Native Charm Vdu Scaling	Get Vdus Before Scale Out	Get Vnf Vdur Names	FAIL	2023-07-08 01:51:07	2023-07-08 01:51:07
...	...	...	...	...	...	...
393	K8S 12-Openldap Helm Day-2	Check Replicas After Upgrade Operation	Get Vnf Kdu Replica Count	FAIL	2023-07-08 03:28:26	2023-07-08 03:28:26
397	K8S 12-Openldap Helm Day-2	Execute Rollback Operation	Execute NS K8s Action	FAIL	2023-07-08 03:28:26	2023-07-08 03:28:31
399	K8S 12-Openldap Helm Day-2	Check Replicas After Rollback Operation	Get Vnf Kdu Replica Count	FAIL	2023-07-08 03:28:31	2023-07-08 03:28:31
404	K8S 12-Openldap Helm Day-2	Delete NS Descriptor Test	Delete NSD	FAIL	2023-07-08 03:28:39	2023-07-08 03:28:40
405	K8S 12-Openldap Helm Day-2	Delete VNF Descriptor Test	Delete VNFD	FAIL	2023-07-08 03:28:40	2023-07-08 03:28:42

86 rows × 6 columns

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

	suite_name	test_name	keyword_name	status	starttime	endtime

---

---

---

Powered by osm-analytics