Analysis of OSM events in Bugzilla

Date and time of the report: 2024-10-17 05:00:05.545266

Analysed period: 2020-07-01 to 2024-10-17.

Bugs considered recent: Since 2024-09-26.

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:

16

Bugs present in multiple branches:

	BUG_DESCRIPTION	NUM_BRANCHES	RELEASE	MODULE	TIMESTAMP

Number of bugs per module

AGE	CURRENT	RECENT	Total
MODULE
IM-NBI	3	1	4
LCM	0	4	4
NG-SA	0	5	5
OSMClient	1	0	1
RO	1	0	1
Robot-tests	1	0	1
Total	6	10	16

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	4	8	12
CONFIRMED	2	2	4
Total	6	10	16

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	4.0	150.00	147.071411	31.0	33.25	116.0	232.75	337.0
1	LCM	4.0	50.25	99.834446	0.0	0.00	0.5	50.75	200.0
2	NG-SA	5.0	0.00	0.000000	0.0	0.00	0.0	0.00	0.0
3	OSMClient	1.0	153.00	NaN	153.0	153.00	153.0	153.00	153.0
4	RO	1.0	135.00	NaN	135.0	135.00	135.0	135.00	135.0
5	Robot-tests	1.0	301.00	NaN	301.0	301.00	301.0	301.00	301.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	1	3.0
LCM	1	0	1.0
OSMClient	0	1	1.0
RO	0	1	1.0
Robot-tests	0	1	1.0
All	3	4	7.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	2314	2024-09-30 15:51:50	337	2.0	267.500000	98.287843	198.0	232.75	267.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-09-30 23:59:59.000000	False	224	337
1	NaN	2361	2024-10-01 12:05:31	200	3.0	66.666667	115.470054	0.0	0.00	0.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-10-17 03:00:05.573959	False	184	200
2	NaN	2381	2024-09-12 06:46:49	34	2.0	32.500000	2.121320	31.0	31.75	32.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-09-30 23:59:59.000000	False	0	34

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	2024-09-30 17:30:57	301	1.0	301.0	NaN	301.0	301.00	301.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-09-30 23:59:59.000000	False	230	301
1	NaN	2366	2024-10-01 00:00:23	198	2.0	267.5	98.287843	198.0	232.75	267.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-10-17 03:00:05.573959	False	182	198
2	NaN	2376	2024-10-02 00:00:12	153	1.0	153.0	NaN	153.0	153.00	153.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-10-17 03:00:05.573959	False	0	153
3	NaN	2379	2024-09-20 00:00:24	135	1.0	135.0	NaN	135.0	135.00	135.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-09-30 23:59:59.000000	False	0	135

4 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-05	2024-06	2024-07	2024-08	2024-09	2024-10
MODULE
Any	0	0	0	0	0	0
DEVOPS	1	0	0	0	0	0
Descriptor-packages	0	0	0	0	0	0
Documentation / Wiki	0	0	0	0	0	0
IM-NBI	19	14	11	7	5	4
LCM	9	5	6	3	1	4
MON	1	0	0	0	0	0
N2VC	0	0	0	0	0	0
NG-UI	0	1	1	1	1	0
OSMClient	6	4	4	4	1	1
Other	0	0	0	0	0	0
PLA	0	0	0	0	0	0
POL	1	0	0	0	0	0
RO	17	5	5	4	1	1
Robot-tests	8	3	3	2	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-05	2024-06	2024-07	2024-08	2024-09	2024-10
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	-1	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	-1	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	0	-6	-3	-4	-4	-1
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	4	1	0	0	2	0
	REOPENED	1	1	0	0	0	0
LCM	CLOSED	-1	-4	0	-3	-2	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	1	0	0	3
	REOPENED	0	0	1	0	0	0
MON	CLOSED	0	-1	0	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	1	0	0	0	0	0
	REOPENED	1	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	-3	0	0	0	0	-1
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	1	0	0	0	0
	REOPENED	0	0	0	0	0	0
OSMClient	CLOSED	-1	-2	0	0	-3	-1
	FALSE_CLOSED	0	0	0	0	0	-1
	OPENED	4	0	0	0	0	1
	REOPENED	2	0	0	0	0	1
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	-1	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	-16	0	-1	-3	0
	FALSE_CLOSED	0	-1	0	0	0	0
	OPENED	6	4	0	0	0	0
	REOPENED	6	4	0	0	0	0
Robot-tests	CLOSED	-3	-5	0	-2	-1	0
	FALSE_CLOSED	-1	0	0	-1	0	0
	OPENED	8	0	0	1	0	0
	REOPENED	8	0	0	1	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	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	philip.joseph@riftio.com	19	riftio.com
20	alimonj@indra.es	19	indra.es
21	ravi.chamarty@riftio.com	19	riftio.com
22	kiran.kashalkar@riftio.com	19	riftio.com
23	vijay.r@tataelxsi.co.in	19	tataelxsi.co.in
24	felipe.vicens@atos.net	17	atos.net
25	Other	830	Other

Contributions per company:

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

4.2 Bugs assignments

Share of bugs with owner: 32.53%

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	211	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	28
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
5509	2259	2024-10-15 17:27:46	bug_status	RESOLVED	Master	OSMClient	osm repo-index fails with NS packages	10667	2024-10-17 03:00:05.573959	RECENT	ryan.mccloskey@waltoninstitute.ie	True
5510	2383	2024-10-15 17:52:48	bug_status	OPEN-UNCONFIRMED	v15.0	LCM	KNFs with metrics are not working properly	25900	2024-10-17 03:00:05.573959	RECENT	escaleira@av.it.pt	False
5511	2353	2024-10-16 00:00:09	bug_status	RESOLVED	v14.0	IM-NBI	Unable to update roles for few role permissions	11250	2024-10-17 03:00:05.573959	RECENT	adurti.v@tataelxsi.co.in	True
5512	2384	2024-10-16 10:15:26	bug_status	OPEN-UNCONFIRMED	v14.0	NG-SA	) By stopping Gnocchi services, VM status and ...	25901	2024-10-17 03:00:05.573959	RECENT	kosinepalli.s@tataelxsi.co.in	False
5513	2385	2024-10-16 10:40:08	bug_status	OPEN-UNCONFIRMED	v14.0	NG-SA	VIM resource overview feature is not supported...	25902	2024-10-17 03:00:05.573959	RECENT	kosinepalli.s@tataelxsi.co.in	False
5514	2386	2024-10-16 10:41:19	bug_status	OPEN-UNCONFIRMED	v14.0	NG-SA	Airflow DAGs should not check for VM status if...	25903	2024-10-17 03:00:05.573959	RECENT	kosinepalli.s@tataelxsi.co.in	False
5515	2387	2024-10-16 10:45:24	bug_status	OPEN-UNCONFIRMED	v14.0	LCM	Alerts (Policy updates) are not updated when N...	25904	2024-10-17 03:00:05.573959	RECENT	kosinepalli.s@tataelxsi.co.in	False
5516	2388	2024-10-16 10:46:43	bug_status	OPEN-UNCONFIRMED	v14.0	LCM	Healing is not happening for scaled out VM usi...	25905	2024-10-17 03:00:05.573959	RECENT	kosinepalli.s@tataelxsi.co.in	False
5517	2389	2024-10-16 11:19:41	bug_status	OPEN-UNCONFIRMED	v14.0	NG-SA	Alarm number is not available in the payload w...	25906	2024-10-17 03:00:05.573959	RECENT	kosinepalli.s@tataelxsi.co.in	False
5518	2390	2024-10-16 11:22:02	bug_status	OPEN-UNCONFIRMED	v14.0	NG-SA	Alarm and OK suppressions are not implemented ...	25907	2024-10-17 03:00:05.573959	RECENT	kosinepalli.s@tataelxsi.co.in	False

5.2 Last bug assignments

	BUG_ID	TIMESTAMP	OPERATION	VALUE	RELEASE	MODULE	BUG_DESCRIPTION	ROW_NUMBER	MONTH	AGE
24505	2330	2023-12-20 14:23:15	assigned_to	gerardo.garciadeblas@telefonica.com	Master	Robot-tests	Robot testsuite lcmop_01 fails in daily job wh...	11098	2023-12-31 23:59:59	CURRENT
24508	2331	2023-12-20 14:23:39	assigned_to	gerardo.garciadeblas@telefonica.com	v15.0	Robot-tests	Robot testsuite lcmop_01 fails in daily job wh...	11111	2023-12-31 23:59:59	CURRENT
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...	11082	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...	11075	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	11221	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...	11254	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

5.3 Last resolved bugs

	BUG_ID	TIMESTAMP	OPERATION	VALUE	RELEASE	MODULE	BUG_DESCRIPTION	ROW_NUMBER	MONTH	AGE	ISSUER	SOLVED
5495	2286	2024-09-12 00:00:11	bug_status	RESOLVED	v12.0	RO	Invalid VDU in VNFR if Scale Out is fail	10852	2024-09-30 23:59:59.000000	CURRENT	p.korchagin@nexign.com	True
5498	2373	2024-09-20 00:00:19	bug_status	RESOLVED	v14.0	OSMClient	OSM NS-Show command is not working while using...	11349	2024-09-30 23:59:59.000000	CURRENT	jegan.s@tataelxsi.co.in	True
5499	2372	2024-09-21 00:00:14	bug_status	RESOLVED	v14.0	IM-NBI	Vnf Descriptor is getting updated without givi...	11344	2024-09-30 23:59:59.000000	CURRENT	adurti.v@tataelxsi.co.in	True
5500	2312	2024-09-25 00:00:11	bug_status	RESOLVED	v14.0	IM-NBI	Manual healing is getting triggered, when heal...	10992	2024-09-30 23:59:59.000000	CURRENT	jegan.s@tataelxsi.co.in	True
5503	2352	2024-09-30 17:52:04	bug_status	RESOLVED	v14.0	IM-NBI	While updating roles existing roles are not ge...	11242	2024-09-30 23:59:59.000000	RECENT	adurti.v@tataelxsi.co.in	True
5505	2374	2024-09-30 22:39:52	bug_status	RESOLVED	v14.0	OSMClient	IP's are not listed properly when using vnf-li...	11355	2024-09-30 23:59:59.000000	RECENT	jegan.s@tataelxsi.co.in	True
5506	2380	2024-10-01 00:00:30	bug_status	RESOLVED	Master	NG-UI	Static Inactive session timeout for a user	11375	2024-10-17 03:00:05.573959	RECENT	sandhya.j@tataelxsi.co.in	True
5508	2337	2024-10-15 17:27:08	bug_status	RESOLVED	Master	NG-SA	Grafana dashboards do not work when NG-SA is e...	11175	2024-10-17 03:00:05.573959	RECENT	rzamre@indracompany.com	True
5509	2259	2024-10-15 17:27:46	bug_status	RESOLVED	Master	OSMClient	osm repo-index fails with NS packages	10667	2024-10-17 03:00:05.573959	RECENT	ryan.mccloskey@waltoninstitute.ie	True
5511	2353	2024-10-16 00:00:09	bug_status	RESOLVED	v14.0	IM-NBI	Unable to update roles for few role permissions	11250	2024-10-17 03:00:05.573959	RECENT	adurti.v@tataelxsi.co.in	True

DONE

---

Powered by osm-analytics