Analysis of OSM events in Bugzilla

Date and time of the report: 2025-02-02 05:00:04.628645

Analysed period: 2020-07-01 to 2025-02-02.

Bugs considered recent: Since 2025-01-12.

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:

15

Bugs present in multiple branches:

	BUG_DESCRIPTION	NUM_BRANCHES	RELEASE	MODULE	TIMESTAMP

Number of bugs per module

AGE	CURRENT	RECENT	Total
MODULE
IM-NBI	5	2	7
LCM	5	1	6
RO	1	0	1
Robot-tests	0	1	1
Total	11	4	15

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	5	0	5
UNCONFIRMED	1	0	1
CONFIRMED	3	4	7
IN_PROGRESS	2	0	2
Total	11	4	15

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	7.0	257.571429	163.582657	89.0	94.00	313.0	382.00	449.0
1	LCM	6.0	151.166667	124.533396	25.0	66.75	108.0	255.75	308.0
2	RO	1.0	88.000000	NaN	88.0	88.00	88.0	88.00	88.0
3	Robot-tests	1.0	409.000000	NaN	409.0	409.00	409.0	409.00	409.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	2	5	7.0
LCM	1	3	4.0
RO	0	1	1.0
Robot-tests	0	1	1.0
All	3	10	13.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	2312	2025-01-23 15:50:58	449	6.0	285.666667	159.626648	92.0	150.25	316.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2025-01-31 23:59:59	False	382	449
1	NaN	2314	2025-01-30 13:12:03	445	6.0	285.666667	159.626648	92.0	150.25	316.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2025-01-31 23:59:59	False	441	445
2	NaN	2361	2025-01-28 15:37:30	308	2.0	306.500000	2.121320	305.0	305.75	306.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2025-01-31 23:59:59	False	303	308

3 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-01-28 15:36:17	409	1.0	409.000000	NaN	409.0	409.00	409.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	keywords	RECENT	2025-01-31 23:59:59	False	405	409
1	NaN	2353	2025-01-28 15:32:30	319	6.0	285.666667	159.626648	92.0	150.25	316.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2025-01-31 23:59:59	False	315	319
2	NaN	2356	2025-01-24 12:09:33	313	6.0	285.666667	159.626648	92.0	150.25	316.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2025-01-31 23:59:59	False	210	313
3	NaN	2368	2025-01-28 15:37:35	305	2.0	306.500000	2.121320	305.0	305.75	306.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2025-01-31 23:59:59	False	237	305
4	NaN	2387	2025-01-27 00:00:27	108	3.0	89.666667	31.754265	53.0	80.50	108.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2025-01-31 23:59:59	False	40	108
5	NaN	2388	2025-01-27 00:00:30	108	3.0	89.666667	31.754265	53.0	80.50	108.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2025-01-31 23:59:59	False	40	108
6	NaN	2392	2025-01-20 00:00:21	96	6.0	285.666667	159.626648	92.0	150.25	316.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2025-01-31 23:59:59	False	0	96
7	NaN	2393	2025-01-24 11:57:06	92	6.0	285.666667	159.626648	92.0	150.25	316.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2025-01-31 23:59:59	False	6	92
8	NaN	2394	2025-01-05 00:00:20	89	1.0	89.000000	NaN	89.0	89.00	89.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2025-01-31 23:59:59	False	0	89
9	NaN	2395	2025-01-08 00:00:21	88	1.0	88.000000	NaN	88.0	88.00	88.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2025-01-31 23:59:59	False	0	88

10 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-09	2024-10	2024-11	2024-12	2025-01	2025-02
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	4	12	15	12	7	7
LCM	1	5	6	7	6	6
MON	0	0	0	0	0	0
N2VC	0	0	0	0	0	0
NG-UI	2	1	2	2	0	0
OSMClient	1	1	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	1	3	2	2	1	1
Robot-tests	1	1	1	0	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-08	2024-09	2024-10	2024-11	2024-12	2025-01
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	-4	-4	-1	0	-3	-7
	FALSE_CLOSED	0	0	-1	0	0	-1
	OPENED	0	2	9	3	0	2
	REOPENED	0	0	8	1	0	2
LCM	CLOSED	-3	-2	0	0	0	-2
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	4	1	1	1
	REOPENED	0	0	3	1	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	0	-1	0	0	-2
	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	-3	-1	-1	0	0
	FALSE_CLOSED	0	0	-1	0	0	0
	OPENED	0	0	1	0	0	0
	REOPENED	0	0	1	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	-1	-3	0	-3	0	-1
	FALSE_CLOSED	0	0	0	-1	0	0
	OPENED	0	0	2	2	0	0
	REOPENED	0	0	2	1	0	0
Robot-tests	CLOSED	-2	-1	0	0	-1	0
	FALSE_CLOSED	-1	0	0	0	0	0
	OPENED	1	0	0	0	0	1
	REOPENED	1	0	0	0	0	1
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	96	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	ravi.chamarty@riftio.com	19	riftio.com
20	vijay.r@tataelxsi.co.in	19	tataelxsi.co.in
21	alimonj@indra.es	19	indra.es
22	kiran.kashalkar@riftio.com	19	riftio.com
23	philip.joseph@riftio.com	19	riftio.com
24	bdiaz@whitestack.com	17	whitestack.com
25	Other	838	Other

Contributions per company:

	company	reported_bugs
0	canonical.com	516
1	telefonica.com	468
2	tataelxsi.co.in	231
3	indra.es	180
4	riftio.com	139
5	whitestack.com	138
6	av.it.pt	106
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	ulakhaberlesme.com.tr	18
14	techmahindra.com	18
15	Other	244

4.2 Bugs assignments

Share of bugs with owner: 32.51%

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
5568	2389	2025-01-27 00:00:32	bug_status	RESOLVED	Master	NG-SA	Alarm number is not available in the payload w...	11531	2025-01-31 23:59:59.000000	RECENT	kosinepalli.s@tataelxsi.co.in	True
5569	2390	2025-01-27 00:00:35	bug_status	RESOLVED	Master	NG-SA	Repeated alarm notification is sent to the URL...	11535	2025-01-31 23:59:59.000000	RECENT	kosinepalli.s@tataelxsi.co.in	True
5570	2351	2025-01-28 15:28:01	bug_status	RESOLVED	v14.0	IM-NBI	Able to Update user role even with project use...	11267	2025-01-31 23:59:59.000000	RECENT	adurti.v@tataelxsi.co.in	True
5571	2314	2025-01-28 15:29:53	bug_status	CONFIRMED	v14.0	IM-NBI	Static IPv4 and Dual Stack IP not retained dur...	11014	2025-01-31 23:59:59.000000	RECENT	deepika.e@tataelxsi.co.in	False
5572	2353	2025-01-28 15:32:22	bug_status	CONFIRMED	v14.0	IM-NBI	Unable to update roles for few role permissions	11290	2025-01-31 23:59:59.000000	RECENT	adurti.v@tataelxsi.co.in	False
5573	2331	2025-01-28 15:36:11	bug_status	CONFIRMED	v15.0	Robot-tests	Robot testsuite lcmop_01 fails in daily job wh...	11140	2025-01-31 23:59:59.000000	RECENT	gerardo.garciadeblas@telefonica.com	False
5574	2361	2025-01-28 15:36:56	bug_status	CONFIRMED	v14.0	LCM	VM is not getting deleted from openstack after...	11349	2025-01-31 23:59:59.000000	RECENT	jegan.s@tataelxsi.co.in	False
5576	2357	2025-01-30 16:27:22	bug_status	RESOLVED	Master	IM-NBI	Session expiry while deleting non-session Proj...	11321	2025-01-31 23:59:59.000000	RECENT	adurti.v@tataelxsi.co.in	True
5577	2375	2025-01-30 16:27:55	bug_status	RESOLVED	Master	IM-NBI	Unable to get notification during NS instantia...	11458	2025-01-31 23:59:59.000000	RECENT	adurti.v@tataelxsi.co.in	True
5578	2384	2025-02-01 00:00:11	bug_status	RESOLVED	Master	NG-SA	) By stopping Gnocchi services, VM status and ...	11508	2025-02-02 04:00:04.652997	RECENT	kosinepalli.s@tataelxsi.co.in	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...	11091	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...	11084	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	11245	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...	11294	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...	11548	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	11380	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
5564	2378	2025-01-21 16:16:44	bug_status	RESOLVED	v14.0	IM-NBI	max-age and expires are exposed in API cookies	11482	2025-01-31 23:59:59.000000	RECENT	adurti.v@tataelxsi.co.in	True
5565	2366	2025-01-23 15:50:03	bug_status	RESOLVED	v14.0	NG-UI	Static Inactive session timeout for a user	11382	2025-01-31 23:59:59.000000	RECENT	jegan.s@tataelxsi.co.in	True
5566	2385	2025-01-27 00:00:19	bug_status	RESOLVED	Master	NG-SA	VIM resource overview feature is not supported...	11511	2025-01-31 23:59:59.000000	RECENT	kosinepalli.s@tataelxsi.co.in	True
5567	2386	2025-01-27 00:00:22	bug_status	RESOLVED	Master	NG-SA	Airflow DAGs should not check for VM status if...	11516	2025-01-31 23:59:59.000000	RECENT	kosinepalli.s@tataelxsi.co.in	True
5568	2389	2025-01-27 00:00:32	bug_status	RESOLVED	Master	NG-SA	Alarm number is not available in the payload w...	11531	2025-01-31 23:59:59.000000	RECENT	kosinepalli.s@tataelxsi.co.in	True
5569	2390	2025-01-27 00:00:35	bug_status	RESOLVED	Master	NG-SA	Repeated alarm notification is sent to the URL...	11535	2025-01-31 23:59:59.000000	RECENT	kosinepalli.s@tataelxsi.co.in	True
5570	2351	2025-01-28 15:28:01	bug_status	RESOLVED	v14.0	IM-NBI	Able to Update user role even with project use...	11267	2025-01-31 23:59:59.000000	RECENT	adurti.v@tataelxsi.co.in	True
5576	2357	2025-01-30 16:27:22	bug_status	RESOLVED	Master	IM-NBI	Session expiry while deleting non-session Proj...	11321	2025-01-31 23:59:59.000000	RECENT	adurti.v@tataelxsi.co.in	True
5577	2375	2025-01-30 16:27:55	bug_status	RESOLVED	Master	IM-NBI	Unable to get notification during NS instantia...	11458	2025-01-31 23:59:59.000000	RECENT	adurti.v@tataelxsi.co.in	True
5578	2384	2025-02-01 00:00:11	bug_status	RESOLVED	Master	NG-SA	) By stopping Gnocchi services, VM status and ...	11508	2025-02-02 04:00:04.652997	RECENT	kosinepalli.s@tataelxsi.co.in	True

DONE

---

Powered by osm-analytics