Analysis of OSM events in Bugzilla

Date and time of the report: 2025-05-12 05:00:05.155216

Analysed period: 2020-07-01 to 2025-05-12.

Bugs considered recent: Since 2025-04-21.

1. Imports and cleans raw source data with all Bugzilla events

DONE

2. Current state of open bugs

2.1 Number of open bugs

Total number of open bugs:

6

Bugs present in multiple branches:

	BUG_DESCRIPTION	NUM_BRANCHES	RELEASE	MODULE	TIMESTAMP

Number of bugs per module

AGE	CURRENT	Total
MODULE
IM-NBI	3	3
NG-UI	1	1
RO	1	1
Robot-tests	1	1
Total	6	6

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	Total
VALUE
CONFIRMED	4	4
IN_PROGRESS	2	2
Total	6	6

Age distribution per module

NOTE: To see how a boxplot representation works, you may refer to this article.

Table with distributions of ages of currently open bugs:

	MODULE	count	mean	std	min	25%	50%	75%	max
0	IM-NBI	3.0	264.0	164.015243	75.0	211.5	348.0	358.5	369.0
1	NG-UI	1.0	66.0	NaN	66.0	66.0	66.0	66.0	66.0
2	RO	1.0	66.0	NaN	66.0	66.0	66.0	66.0	66.0
3	Robot-tests	1.0	508.0	NaN	508.0	508.0	508.0	508.0	508.0

2.3 Outliers

Four types of bug age outliers are identified:

1. Too old bugs.
2. Pure outliers for boxplot: Beyond Q3+1.5IQR for the MDG.
3. Beyond 3rd quartile of ages.
4. Age beyond 2 months.

Recommendations file does not exist.

Summary table of outliers:

AGE	2. Open beyond q3	3. Open beyond 2 months	All
MODULE
IM-NBI	1	2	3.0
NG-UI	0	1	1.0
RO	0	1	1.0
Robot-tests	0	1	1.0
All	1	5	6.0

Outlier details

Too old bugs:

	RECOMMENDATION	BUG_ID	BUG_DESCRIPTION	ISSUER	CREATION_TIME	CREATION_AGE	MONTH	STATE	STATE_UPDATE_TIME	STATE_UPDATE_AGE	...	LAST_ASSIGNMENT_MONTH	LAST_ASSIGNMENT_AGE	OWNER_CHANGES	LAST_EVENT	LAST_EVENT_TIME	LAST_EVENT_AGE	LAST_EVENT_MONTH	SOLVED	BUG_RESOLUTION_TIME	TIME_SINCE_CREATION

0 rows × 29 columns

Pure outliers:

	RECOMMENDATION	BUG_ID	LAST_EVENT_TIME	Time bug open (days)	count	mean	std	min	25%	50%	...	OWNER	LAST_ASSIGNMENT_MONTH	LAST_ASSIGNMENT_AGE	OWNER_CHANGES	LAST_EVENT	LAST_EVENT_AGE	LAST_EVENT_MONTH	SOLVED	BUG_RESOLUTION_TIME	TIME_SINCE_CREATION

0 rows × 40 columns

Beyond Q3:

	RECOMMENDATION	BUG_ID	LAST_EVENT_TIME	Time bug open (days)	count	mean	std	min	25%	50%	...	OWNER	LAST_ASSIGNMENT_MONTH	LAST_ASSIGNMENT_AGE	OWNER_CHANGES	LAST_EVENT	LAST_EVENT_AGE	LAST_EVENT_MONTH	SOLVED	BUG_RESOLUTION_TIME	TIME_SINCE_CREATION
0	NaN	2372	2025-03-25 07:03:09	369	2.0	222.0	207.889394	75.0	148.5	222.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2025-03-31 23:59:59	False	321	369

1 rows × 40 columns

Beyond 2 months:

	RECOMMENDATION	BUG_ID	LAST_EVENT_TIME	Time bug open (days)	count	mean	std	min	25%	50%	...	OWNER	LAST_ASSIGNMENT_MONTH	LAST_ASSIGNMENT_AGE	OWNER_CHANGES	LAST_EVENT	LAST_EVENT_AGE	LAST_EVENT_MONTH	SOLVED	BUG_RESOLUTION_TIME	TIME_SINCE_CREATION
0	NaN	2331	2025-03-25 16:48:39	508	1.0	508.0	NaN	508.0	508.0	508.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	version	CURRENT	2025-03-31 23:59:59.000000	False	405	508
1	NaN	2377	2025-05-08 14:23:15	348	1.0	348.0	NaN	348.0	348.0	348.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2025-05-12 03:00:05.184094	False	300	348
2	NaN	2399	2025-03-25 06:49:20	75	2.0	222.0	207.889394	75.0	148.5	222.0	...	NaN	NaT	NaN	NaN	everconfirmed	CURRENT	2025-03-31 23:59:59.000000	False	27	75
3	NaN	2401	2025-03-24 17:21:07	66	1.0	66.0	NaN	66.0	66.0	66.0	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2025-03-31 23:59:59.000000	False	18	66
4	NaN	2402	2025-03-24 17:20:50	66	1.0	66.0	NaN	66.0	66.0	66.0	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2025-03-31 23:59:59.000000	False	18	66

5 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs

Recent evolution of open bugs:

3.2 Age of open bugs

Recent evolution of age of open bugs:

3.3 Monthly activity

Recent evolution of bug resolution activity:

Evolution of the number of open bugs per module in the last 6 months:

MONTH	2024-12	2025-01	2025-02	2025-03	2025-04	2025-05
MODULE
Any	0	0	0	0	0	0
DEVOPS	0	0	0	0	0	0
Descriptor-packages	0	0	0	0	0	0
Documentation / Wiki	0	0	0	0	0	0
IM-NBI	12	7	2	6	4	3
LCM	7	6	4	0	0	0
MON	0	0	0	0	0	0
N2VC	0	0	0	0	0	0
NG-UI	2	0	0	1	1	1
OSMClient	0	0	0	0	0	0
Other	0	0	0	0	0	0
PLA	0	0	0	0	0	0
POL	0	0	0	0	0	0
RO	2	1	0	1	1	1
Robot-tests	0	1	1	1	1	1
Unknown	0	0	0	0	0	0
common	0	0	0	0	0	0

Reasons for the variation in the number of open bugs per module in the last 6 months:

	MONTH	2024-12	2025-01	2025-02	2025-03	2025-04	2025-05
MODULE	variable
Any	CLOSED	0	0	0	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	0	0	0	0
	REOPENED	0	0	0	0	0	0
DEVOPS	CLOSED	0	0	0	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	0	0	0	0
	REOPENED	0	0	0	0	0	0
Descriptor-packages	CLOSED	0	0	0	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	0	0	0	0
	REOPENED	0	0	0	0	0	0
Documentation / Wiki	CLOSED	0	0	0	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	0	0	0	0
	REOPENED	0	0	0	0	0	0
IM-NBI	CLOSED	-3	-7	-7	-2	-3	-1
	FALSE_CLOSED	0	-1	-1	0	0	0
	OPENED	0	2	2	6	1	0
	REOPENED	0	2	1	5	0	0
LCM	CLOSED	0	-2	-2	-5	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	1	1	0	1	0	0
	REOPENED	0	0	0	0	0	0
MON	CLOSED	0	0	0	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	0	0	0	0
	REOPENED	0	0	0	0	0	0
N2VC	CLOSED	0	0	0	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	0	0	0	0
	REOPENED	0	0	0	0	0	0
NG-UI	CLOSED	0	-2	0	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	0	1	0	0
	REOPENED	0	0	0	0	0	0
OSMClient	CLOSED	0	0	0	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	0	0	0	0
	REOPENED	0	0	0	0	0	0
Other	CLOSED	0	0	0	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	0	0	0	0
	REOPENED	0	0	0	0	0	0
PLA	CLOSED	0	0	0	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	0	0	0	0
	REOPENED	0	0	0	0	0	0
POL	CLOSED	0	0	0	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	0	0	0	0
	REOPENED	0	0	0	0	0	0
RO	CLOSED	0	-1	-1	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	0	1	0	0
	REOPENED	0	0	0	0	0	0
Robot-tests	CLOSED	-1	0	0	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	1	0	0	0	0
	REOPENED	0	1	0	0	0	0
Unknown	CLOSED	0	0	0	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	0	0	0	0
	REOPENED	0	0	0	0	0	0
common	CLOSED	0	0	0	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	0	0	0	0
	REOPENED	0	0	0	0	0	0

4. Top contributors

4.1 Top reporters of bugs

Individual contributors:

	issuer	reported_bugs	company
0	gerardo.garciadeblas@telefonica.com	236	telefonica.com
1	david.garcia@canonical.com	135	canonical.com
2	eduardo.sousa@canonical.com	122	canonical.com
3	mark.beierl@canonical.com	109	canonical.com
4	alfonso.tiernosepulveda@telefonica.com	101	telefonica.com
5	escaleira@av.it.pt	97	av.it.pt
6	glavado@whitestack.com	85	whitestack.com
7	e.dah.tid@telefonica.com	77	telefonica.com
8	mmarchetti@sandvine.com	73	sandvine.com
9	adam.israel@canonical.com	70	canonical.com
10	daguilarh@indra.es	63	indra.es
11	garomero@indra.es	56	indra.es
12	silvia.almagia@etsi.org	44	etsi.org
13	pablo.montesmoreno@telefonica.com	37	telefonica.com
14	rajesh.velandy@riftio.com	31	riftio.com
15	gulsum.atici@canonical.com	29	canonical.com
16	mbeierl@vmware.com	26	vmware.com
17	guillermo.calvino@canonical.com	25	canonical.com
18	preethika.p@tataelxsi.co.in	22	tataelxsi.co.in
19	philip.joseph@riftio.com	19	riftio.com
20	vijay.r@tataelxsi.co.in	19	tataelxsi.co.in
21	kiran.kashalkar@riftio.com	19	riftio.com
22	alimonj@indra.es	19	indra.es
23	ravi.chamarty@riftio.com	19	riftio.com
24	adurti.v@tataelxsi.co.in	18	tataelxsi.co.in
25	Other	842	Other

Contributions per company:

	company	reported_bugs
0	canonical.com	516
1	telefonica.com	468
2	tataelxsi.co.in	234
3	indra.es	180
4	riftio.com	139
5	whitestack.com	138
6	av.it.pt	107
7	sandvine.com	73
8	gmail.com	63
9	etsi.org	62
10	vmware.com	52
11	altran.com	48
12	atos.net	31
13	techmahindra.com	18
14	ulakhaberlesme.com.tr	18
15	Other	246

4.2 Bugs assignments

Share of bugs with owner: 32.43%

Top assignees of bugs still open:

	company	n_bugs
0	telefonica.com	1

4.3 Top closers of bugs

	closer	n_bugs	company
0	gerardo.garciadeblas@telefonica.com	96	telefonica.com
1	eduardo.sousa@canonical.com	82	canonical.com
2	mark.beierl@canonical.com	41	canonical.com
3	alfonso.tiernosepulveda@telefonica.com	39	telefonica.com
4	adam.israel@canonical.com	26	canonical.com
5	gulsum.atici@canonical.com	25	canonical.com
6	philip.joseph@riftio.com	20	riftio.com
7	fbravo@whitestack.com	19	whitestack.com
8	david.garcia@canonical.com	19	canonical.com
9	rajesh.velandy@riftio.com	19	riftio.com
10	subhankar.pal@altran.com	17	altran.com
11	jeremy.mordkoff@riftio.com	16	riftio.com
12	jmguzman@whitestack.com	13	whitestack.com
13	vlittle@vmware.com	13	vmware.com
14	ramerama@tataelxsi.co.in	13	tataelxsi.co.in
15	pedro.delacruzramos@altran.com	13	altran.com
16	agarcia@whitestack.com	12	whitestack.com
17	anurag.dwivedi@riftio.com	12	riftio.com
18	pkasar@vmware.com	11	vmware.com
19	laurence.maultsby@riftio.com	10	riftio.com
20	mmarchetti@sandvine.com	10	sandvine.com
21	ravi.chamarty@riftio.com	10	riftio.com
22	glavado@whitestack.com	9	whitestack.com
23	ananda.baitharu@riftio.com	9	riftio.com
24	hashir.mohammed@riftio.com	8	riftio.com
25	Other	213	Other

	company	n_bugs
0	canonical.com	204
1	riftio.com	152
2	telefonica.com	145
3	whitestack.com	67
4	altran.com	43
5	vmware.com	38
6	tataelxsi.co.in	30
7	etsi.org	12
8	indra.es	11
9	atos.net	11
10	sandvine.com	10
11	ulakhaberlesme.com.tr	7
12	techmahindra.com	7
13	intel.com	7
14	cttc.es	6
15	cnit.it	6
16	dataart.com	3
17	sensinov.com	2
18	everyup.it	2
19	telenity.com	1
20	stevens.edu	1
21	adlinktech.com	1
22	proceranetworks.com	1
23	nexius.com	1
24	keynetic.es	1
25	fotonik.dtu.dk	1
26	ehu.eus	1
27	eantc.de	1
28	bt.com	1
29	aricent.com	1
30	indracompany.com	1

5. Last significant events

5.1 Last reported bugs

	BUG_ID	TIMESTAMP	OPERATION	VALUE	RELEASE	MODULE	BUG_DESCRIPTION	ROW_NUMBER	MONTH	AGE	ISSUER	SOLVED
5605	2402	2025-03-24 17:20:50	bug_status	CONFIRMED	Master	NG-UI	Unable to create Ns Config template from Ui	11650	2025-03-31 23:59:59.000000	CURRENT	udaisankar.p@tataelxsi.co.in	False
5606	2401	2025-03-24 17:21:07	bug_status	CONFIRMED	Master	RO	Security Group is not getting attached with th...	11648	2025-03-31 23:59:59.000000	CURRENT	udaisankar.p@tataelxsi.co.in	False
5607	2399	2025-03-25 06:49:20	bug_status	CONFIRMED	Master	IM-NBI	BAD_REQUEST error when creating NS while speci...	11640	2025-03-31 23:59:59.000000	CURRENT	alexandre.sabbadin@laas.fr	False
5613	2372	2025-03-25 07:03:09	bug_status	IN_PROGRESS	Master	IM-NBI	Vnf Descriptor is getting updated without givi...	11476	2025-03-31 23:59:59.000000	CURRENT	adurti.v@tataelxsi.co.in	False
5615	2377	2025-03-25 07:04:30	bug_status	IN_PROGRESS	v14.0	IM-NBI	NS-Update operation does not work for KNF	11519	2025-03-31 23:59:59.000000	CURRENT	p.korchagin@nexign.com	False
5617	2400	2025-03-31 16:12:17	bug_status	RESOLVED	Master	LCM	Kubeconfig Token warning is distorting the ins...	11646	2025-03-31 23:59:59.000000	CURRENT	uuniyal@indracompany.com	True
5619	2371	2025-04-29 16:43:27	bug_status	RESOLVED	Master	IM-NBI	Able to update sfc nsd descriptor even with in...	11459	2025-04-30 23:59:59.000000	RECENT	adurti.v@tataelxsi.co.in	True
5620	2392	2025-04-29 16:45:28	bug_status	RESOLVED	v14.0	IM-NBI	Error in getting data when logged in user upda...	11606	2025-04-30 23:59:59.000000	RECENT	adurti.v@tataelxsi.co.in	True
5621	2394	2025-04-29 16:46:01	bug_status	RESOLVED	Master	IM-NBI	Unable to update Ns config template completely	11621	2025-04-30 23:59:59.000000	RECENT	kayalvizhi.v@tataelxsi.co.in	True
5623	2404	2025-05-06 16:36:11	bug_status	RESOLVED	master	IM-NBI	The current password storage procedure is not ...	11659	2025-05-12 03:00:05.184094	RECENT	escaleira@av.it.pt	True

5.2 Last bug assignments

	BUG_ID	TIMESTAMP	OPERATION	VALUE	RELEASE	MODULE	BUG_DESCRIPTION	ROW_NUMBER	MONTH	AGE
24509	2327	2023-12-20 14:31:53	assigned_to	gerardo.garciadeblas@telefonica.com	Master	Robot-tests	Robot testsuite sol003_02 fails in the verific...	11097	2023-12-31 23:59:59	CURRENT
24510	2326	2023-12-20 14:32:03	assigned_to	gerardo.garciadeblas@telefonica.com	v15.0	Robot-tests	Robot testsuite sol003_02 fails in the verific...	11090	2023-12-31 23:59:59	CURRENT
24792	2240	2024-03-12 10:07:44	assigned_to	gerardo.garciadeblas@telefonica.com	Master	OSMClient	VNF packages are listed with "id" but retrieve...	10574	2024-03-31 23:59:59	CURRENT
24806	2259	2024-03-12 17:32:24	assigned_to	gerardo.garciadeblas@telefonica.com	Master	OSMClient	osm repo-index fails with NS packages	10660	2024-03-31 23:59:59	CURRENT
24808	2260	2024-03-12 17:32:32	assigned_to	gerardo.garciadeblas@telefonica.com	Master	OSMClient	osm nfpkg-repo-show fails for valid packages	10671	2024-03-31 23:59:59	CURRENT
24845	2348	2024-03-21 00:33:55	assigned_to	gcuba@whitestack.com	Master	LCM	NS Update getting failed while using SFC feature	11252	2024-03-31 23:59:59	CURRENT
24864	2354	2024-03-22 09:10:20	assigned_to	uuniyal@indracompany.com	Master	RO	Periodic checks of VM status in VIM not disabl...	11304	2024-03-31 23:59:59	CURRENT
24917	2176	2024-04-03 09:27:35	assigned_to	gerardo.garciadeblas@telefonica.com	Master	OSMClient	vca-update using ID modifies the name of the V...	10326	2024-04-30 23:59:59	CURRENT
26020	2396	2024-11-25 11:38:22	assigned_to	sandhya.j@tataelxsi.co.in	Master	NG-UI	Inconsistent behavior in user creation between...	11628	2024-11-30 23:59:59	CURRENT
26067	2366	2024-12-03 16:37:50	assigned_to	sandhya.j@tataelxsi.co.in	v14.0	NG-UI	Static Inactive session timeout for a user	11406	2024-12-31 23:59:59	CURRENT

5.3 Last resolved bugs

	BUG_ID	TIMESTAMP	OPERATION	VALUE	RELEASE	MODULE	BUG_DESCRIPTION	ROW_NUMBER	MONTH	AGE	ISSUER	SOLVED
5598	2368	2025-03-23 22:07:16	bug_status	RESOLVED	Master	LCM	Mac address is missing in Additional params se...	11425	2025-03-31 23:59:59.000000	CURRENT	jegan.s@tataelxsi.co.in	True
5599	2361	2025-03-23 22:10:36	bug_status	RESOLVED	Master	LCM	VM is not getting deleted from openstack after...	11375	2025-03-31 23:59:59.000000	CURRENT	jegan.s@tataelxsi.co.in	True
5601	2403	2025-03-24 09:30:45	bug_status	RESOLVED	Master	IM-NBI	Able to change username of other users with no...	11653	2025-03-31 23:59:59.000000	CURRENT	adurti.v@tataelxsi.co.in	True
5602	2393	2025-03-24 17:15:30	bug_status	RESOLVED	Master	IM-NBI	Able to change password of other users with no...	11611	2025-03-31 23:59:59.000000	CURRENT	adurti.v@tataelxsi.co.in	True
5603	2398	2025-03-24 17:19:47	bug_status	RESOLVED	v15.0	LCM	cant found k8s repo because adding full url of...	11639	2025-03-31 23:59:59.000000	CURRENT	mahhah53@gmail.com	True
5617	2400	2025-03-31 16:12:17	bug_status	RESOLVED	Master	LCM	Kubeconfig Token warning is distorting the ins...	11646	2025-03-31 23:59:59.000000	CURRENT	uuniyal@indracompany.com	True
5619	2371	2025-04-29 16:43:27	bug_status	RESOLVED	Master	IM-NBI	Able to update sfc nsd descriptor even with in...	11459	2025-04-30 23:59:59.000000	RECENT	adurti.v@tataelxsi.co.in	True
5620	2392	2025-04-29 16:45:28	bug_status	RESOLVED	v14.0	IM-NBI	Error in getting data when logged in user upda...	11606	2025-04-30 23:59:59.000000	RECENT	adurti.v@tataelxsi.co.in	True
5621	2394	2025-04-29 16:46:01	bug_status	RESOLVED	Master	IM-NBI	Unable to update Ns config template completely	11621	2025-04-30 23:59:59.000000	RECENT	kayalvizhi.v@tataelxsi.co.in	True
5623	2404	2025-05-06 16:36:11	bug_status	RESOLVED	master	IM-NBI	The current password storage procedure is not ...	11659	2025-05-12 03:00:05.184094	RECENT	escaleira@av.it.pt	True

DONE

---

Powered by osm-analytics