Analysis of OSM events in Bugzilla

Date and time of the report: 2022-08-16 05:00:07.407461

Analysed period: 2020-07-01 to 2022-08-16.

Bugs considered recent: Since 2022-07-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:

105

Bugs present in multiple branches:

	BUG_DESCRIPTION	NUM_BRANCHES	RELEASE	MODULE	TIMESTAMP
0	Additional params not accepted for Hybrid Netw...	3	[Master, v11.0, v10.0]	IM-NBI	2022-05-20 16:20:13
1	An user is not able to use a VDU/KDU scaling c...	3	[Master, Master, Master]	LCM	2022-07-04 16:35:49
2	GCP connector doesn't provide internet access ...	2	[Master, v11.0]	RO	2021-12-13 11:54:22
3	N2VC fails to scale a KNF based on Helm Charts...	2	[Master, v12.0]	N2VC	2022-07-07 17:16:22
4	The Dockerfile.local Ubuntu version causes the...	3	[Master, v11.0, v10.0]	IM-NBI	2022-04-03 19:24:33
5	The VCA Status for an NS with both a KNF and a...	4	[Master, v11.0, v10.0, Master]	NG-UI	2022-05-27 01:22:04
6	The edge case of first scaling down an Helm Ch...	2	[Master, v12.0]	N2VC	2022-07-07 17:16:01
7	The validation of the instantiation parameters...	3	[Master, v11.0, v10.0]	IM-NBI	2022-03-31 12:43:17
8	When we have more than one scalable resources ...	2	[Master, v12.0]	N2VC	2022-07-07 21:45:41
9	juju-bundle init failed when adding a k8s clus...	3	[v10.0, v11.0, Master]	N2VC	2022-06-09 12:05:04

Number of bugs per module

AGE	CURRENT	RECENT	Total
MODULE
Any	1	0	1
DEVOPS	1	1	2
Gerrit	1	0	1
IM-NBI	36	1	37
LCM	13	2	15
MON	4	0	4
N2VC	16	2	18
NG-UI	4	2	6
OSMClient	1	1	2
RO	14	0	14
Robot-tests	1	0	1
common	3	1	4
Total	95	10	105

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	61	5	66
CONFIRMED	30	4	34
IN_PROGRESS	4	1	5
Total	95	10	105

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	Any	1.0	55.000000	NaN	55.0	55.00	55.0	55.00	55.0
1	DEVOPS	2.0	18.500000	6.363961	14.0	16.25	18.5	20.75	23.0
2	Gerrit	1.0	111.000000	NaN	111.0	111.00	111.0	111.00	111.0
3	IM-NBI	37.0	259.567568	198.864211	5.0	134.00	243.0	333.00	770.0
4	LCM	15.0	89.733333	101.691035	5.0	38.00	58.0	86.00	420.0
5	MON	4.0	63.750000	48.002604	26.0	32.75	48.5	79.50	132.0
6	N2VC	18.0	117.111111	167.581021	11.0	39.00	67.0	72.75	689.0
7	NG-UI	6.0	90.500000	51.048017	26.0	51.00	95.5	134.75	142.0
8	OSMClient	2.0	104.000000	53.740115	66.0	85.00	104.0	123.00	142.0
9	RO	14.0	145.071429	117.292838	32.0	39.75	109.0	217.00	388.0
10	Robot-tests	1.0	143.000000	NaN	143.0	143.00	143.0	143.00	143.0
11	common	4.0	179.500000	194.371637	5.0	32.75	145.0	291.75	423.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	1. Open outliers	2. Open beyond q3	3. Open beyond 2 months	All
MODULE
DEVOPS	0	1	0	1.0
Gerrit	0	0	1	1.0
IM-NBI	0	10	24	34.0
LCM	1	5	2	8.0
MON	0	1	1	2.0
N2VC	1	3	6	10.0
NG-UI	0	2	2	4.0
OSMClient	0	0	2	2.0
RO	1	2	6	9.0
Robot-tests	0	0	1	1.0
common	0	1	1	2.0
All	3	25	46	74.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	NaN	1234	2022-07-29 16:06:09	689	11.0	165.545455	202.124399	23.0	53.0	72.0	...	NaN	NaT	NaN	NaN	priority	RECENT	2022-07-31 23:59:59.000000	False	672	689
1	NaN	1579	2022-07-19 17:30:57	420	6.0	103.833333	156.789562	17.0	26.0	38.5	...	glavado@whitestack.com	2022-02-28 23:59:59	CURRENT	1.0	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	420
2	NaN	1768	2022-08-04 00:00:22	273	4.0	95.750000	118.350820	32.0	32.0	39.0	...	sgallardor@indra.es	2021-11-30 23:59:59	CURRENT	1.0	comment	RECENT	2022-08-16 03:00:07.453940	False	28	273

3 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	1123	2022-06-28 17:29:42	770	18.0	336.277778	224.572484	42.0	137.25	331.0	...	gerardo.garciadeblas@telefonica.com	2022-03-31 23:59:59.000000	CURRENT	3.0	resolution	CURRENT	2022-06-30 23:59:59.000000	False	722	770
1	NaN	1188	2022-06-28 17:33:00	735	18.0	336.277778	224.572484	42.0	137.25	331.0	...	gerardo.garciadeblas@telefonica.com	2022-03-31 23:59:59.000000	CURRENT	4.0	resolution	CURRENT	2022-06-30 23:59:59.000000	False	687	735
2	NaN	1266	2022-06-28 17:32:53	665	18.0	336.277778	224.572484	42.0	137.25	331.0	...	jmguzman@whitestack.com	2021-12-31 23:59:59.000000	CURRENT	1.0	resolution	CURRENT	2022-06-30 23:59:59.000000	False	617	665
3	NaN	1454	2022-06-28 17:32:46	536	18.0	336.277778	224.572484	42.0	137.25	331.0	...	agarcia@whitestack.com	2021-07-31 23:59:59.000000	CURRENT	2.0	resolution	CURRENT	2022-06-30 23:59:59.000000	False	487	536
4	NaN	1557	2022-08-03 00:00:18	438	18.0	336.277778	224.572484	42.0	137.25	331.0	...	gerardo.garciadeblas@telefonica.com	2022-05-31 23:59:59.000000	CURRENT	4.0	comment	RECENT	2022-08-16 03:00:07.453940	False	0	438
5	NaN	1577	2022-08-09 00:00:19	423	3.0	237.666667	190.710077	42.0	145.00	248.0	...	mark.beierl@canonical.com	2022-02-28 23:59:59.000000	CURRENT	1.0	comment	RECENT	2022-08-16 03:00:07.453940	False	0	423
6	NaN	1622	2022-06-28 17:32:40	378	7.0	203.428571	97.099360	87.0	135.50	200.0	...	gerardo.garciadeblas@telefonica.com	2022-03-31 23:59:59.000000	CURRENT	1.0	resolution	CURRENT	2022-06-30 23:59:59.000000	False	330	378
7	NaN	1632	2022-07-21 18:03:47	371	11.0	165.545455	202.124399	23.0	53.00	72.0	...	NaN	NaT	NaN	NaN	version	CURRENT	2022-07-31 23:59:59.000000	False	346	371
8	NaN	1752	2022-06-28 17:31:13	278	9.0	161.888889	77.608705	69.0	112.00	137.0	...	gerardo.garciadeblas@telefonica.com	2022-05-31 23:59:59.000000	CURRENT	3.0	resolution	CURRENT	2022-06-30 23:59:59.000000	False	230	278
9	NaN	1769	2022-08-04 00:00:24	273	6.0	190.333333	66.629323	109.0	136.00	217.0	...	sgallardor@indra.es	2021-11-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2022-08-16 03:00:07.453940	False	28	273
10	NaN	1808	2022-06-28 17:31:04	259	9.0	161.888889	77.608705	69.0	112.00	137.0	...	jmguzman@whitestack.com	2021-11-30 23:59:59.000000	CURRENT	1.0	resolution	CURRENT	2022-06-30 23:59:59.000000	False	211	259
11	NaN	1825	2022-06-28 17:30:57	245	7.0	203.428571	97.099360	87.0	135.50	200.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	197	245
12	NaN	1857	2022-06-20 23:59:47	217	11.0	165.545455	202.124399	23.0	53.00	72.0	...	emin.aktas@ulakhaberlesme.com.tr	2022-01-31 23:59:59.000000	CURRENT	1.0	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	217
13	NaN	1900	2022-08-04 00:00:27	164	2.0	125.000000	55.154329	86.0	105.50	125.0	...	lluis.gifre@cttc.es	2022-03-31 23:59:59.000000	CURRENT	1.0	keywords	RECENT	2022-08-16 03:00:07.453940	False	13	164
14	NaN	1921	2022-08-04 00:00:29	147	2.0	102.500000	62.932504	58.0	80.25	102.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-16 03:00:07.453940	False	0	147
15	NaN	1936	2022-08-02 17:02:54	142	2.0	139.500000	3.535534	137.0	138.25	139.5	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2022-08-16 03:00:07.453940	False	129	142
16	NaN	1979	2022-08-03 00:00:26	132	3.0	73.333333	53.901144	26.0	44.00	62.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-16 03:00:07.453940	False	0	132
17	NaN	1988	2022-08-04 00:00:33	128	4.0	66.000000	44.022721	26.0	41.75	55.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-16 03:00:07.453940	False	0	128
18	NaN	2042	2022-07-19 16:59:28	86	6.0	103.833333	156.789562	17.0	26.00	38.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	5	86
19	NaN	2043	2022-08-06 00:07:12	86	3.0	74.000000	16.643317	55.0	68.00	81.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-16 03:00:07.453940	False	9	86
20	NaN	2069	2022-07-05 17:39:25	67	2.0	46.000000	29.698485	25.0	35.50	46.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	67
21	NaN	2093	2022-07-01 10:48:59	45	3.0	39.333333	5.131601	35.0	36.50	38.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	45
22	NaN	2098	2022-07-13 13:32:21	41	2.0	23.000000	25.455844	5.0	14.00	23.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	41
23	NaN	2103	2022-08-11 11:25:49	39	2.0	22.000000	24.041631	5.0	13.50	22.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-16 03:00:07.453940	False	0	39
24	NaN	2125	2022-08-10 21:28:38	23	2.0	18.500000	6.363961	14.0	16.25	18.5	...	mark.beierl@canonical.com	2022-08-16 03:00:07.453940	RECENT	1.0	comment	RECENT	2022-08-16 03:00:07.453940	False	0	23

25 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	1301	2022-08-04 00:00:18	626	1.0	626.000000	NaN	626.0	626.00	626.0	...	mark.beierl@canonical.com	2021-10-31 23:59:59	CURRENT	1.0	comment	RECENT	2022-08-16 03:00:07.453940	False	0	626
1	NaN	1603	2022-08-09 00:00:22	388	1.0	388.000000	NaN	388.0	388.00	388.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-16 03:00:07.453940	False	319	388
2	NaN	1660	2022-06-28 17:32:35	335	18.0	336.277778	224.572484	42.0	137.25	331.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	287	335
3	NaN	1661	2022-06-28 17:32:29	335	18.0	336.277778	224.572484	42.0	137.25	331.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	287	335
4	NaN	1667	2022-06-28 17:32:11	333	18.0	336.277778	224.572484	42.0	137.25	331.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	285	333
5	NaN	1668	2022-06-28 17:31:57	333	18.0	336.277778	224.572484	42.0	137.25	331.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	285	333
6	NaN	1671	2022-06-28 17:31:50	329	18.0	336.277778	224.572484	42.0	137.25	331.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	280	329
7	NaN	1672	2022-06-28 17:31:45	329	18.0	336.277778	224.572484	42.0	137.25	331.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	280	329
8	NaN	1673	2022-06-28 17:31:36	329	18.0	336.277778	224.572484	42.0	137.25	331.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	280	329
9	NaN	1822	2022-08-09 00:00:27	248	3.0	237.666667	190.710077	42.0	145.00	248.0	...	mark.beierl@canonical.com	2022-02-28 23:59:59	CURRENT	1.0	comment	RECENT	2022-08-16 03:00:07.453940	False	0	248
10	NaN	1829	2022-06-28 17:30:41	243	7.0	203.428571	97.099360	87.0	135.50	200.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	195	243
11	NaN	1831	2022-06-28 17:30:32	243	9.0	161.888889	77.608705	69.0	112.00	137.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	195	243
12	NaN	1853	2022-08-07 00:00:19	217	6.0	190.333333	66.629323	109.0	136.00	217.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-16 03:00:07.453940	False	147	217
13	NaN	1855	2022-08-07 00:00:22	217	6.0	190.333333	66.629323	109.0	136.00	217.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-16 03:00:07.453940	False	147	217
14	NaN	1856	2022-08-07 00:00:24	217	6.0	190.333333	66.629323	109.0	136.00	217.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-16 03:00:07.453940	False	147	217
15	NaN	1869	2022-06-28 17:30:16	200	7.0	203.428571	97.099360	87.0	135.50	200.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	152	200
16	NaN	1890	2022-06-21 17:34:26	165	11.0	165.545455	202.124399	23.0	53.00	72.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	165
17	NaN	1931	2022-08-15 00:00:26	143	1.0	143.000000	NaN	143.0	143.00	143.0	...	emin.aktas@ulakhaberlesme.com.tr	2022-03-31 23:59:59	CURRENT	1.0	comment	RECENT	2022-08-16 03:00:07.453940	False	0	143
18	NaN	1935	2022-08-10 16:16:41	142	1.0	142.000000	NaN	142.0	142.00	142.0	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2022-08-16 03:00:07.453940	False	137	142
19	NaN	1942	2022-08-03 00:00:24	138	9.0	161.888889	77.608705	69.0	112.00	137.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-16 03:00:07.453940	False	0	138
20	NaN	1946	2022-06-28 17:30:07	138	18.0	336.277778	224.572484	42.0	137.25	331.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	90	138
21	NaN	1952	2022-08-02 17:04:03	137	2.0	139.500000	3.535534	137.0	138.25	139.5	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2022-08-16 03:00:07.453940	False	124	137
22	NaN	1954	2022-06-16 16:57:06	137	18.0	336.277778	224.572484	42.0	137.25	331.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	137
23	NaN	1955	2022-06-15 00:01:42	137	9.0	161.888889	77.608705	69.0	112.00	137.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	137
24	NaN	1956	2022-06-15 00:01:44	137	7.0	203.428571	97.099360	87.0	135.50	200.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	137
25	NaN	1970	2022-06-20 18:38:35	134	18.0	336.277778	224.572484	42.0	137.25	331.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	134
26	NaN	1971	2022-06-15 00:01:48	134	9.0	161.888889	77.608705	69.0	112.00	137.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	134
27	NaN	1972	2022-06-15 00:01:50	134	7.0	203.428571	97.099360	87.0	135.50	200.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	134
28	NaN	2009	2022-06-20 15:41:33	112	9.0	161.888889	77.608705	69.0	112.00	137.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	112
29	NaN	2015	2022-08-10 11:02:45	111	1.0	111.000000	NaN	111.0	111.00	111.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-16 03:00:07.453940	False	0	111
30	NaN	2019	2022-08-04 00:00:37	109	6.0	190.333333	66.629323	109.0	136.00	217.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-16 03:00:07.453940	False	0	109
31	NaN	2020	2022-08-04 00:00:40	109	6.0	190.333333	66.629323	109.0	136.00	217.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-16 03:00:07.453940	False	0	109
32	NaN	2038	2022-06-30 14:48:41	87	18.0	336.277778	224.572484	42.0	137.25	331.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	87
33	NaN	2039	2022-06-30 14:48:59	87	9.0	161.888889	77.608705	69.0	112.00	137.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	87
34	NaN	2040	2022-06-30 14:49:29	87	7.0	203.428571	97.099360	87.0	135.50	200.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	87
35	NaN	2044	2022-08-06 00:06:58	86	2.0	125.000000	55.154329	86.0	105.50	125.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-16 03:00:07.453940	False	9	86
36	NaN	2049	2022-07-19 17:39:23	81	3.0	74.000000	16.643317	55.0	68.00	81.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	81
37	NaN	2063	2022-07-07 17:24:30	73	11.0	165.545455	202.124399	23.0	53.00	72.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	33	73
38	NaN	2065	2022-07-07 17:16:22	72	11.0	165.545455	202.124399	23.0	53.00	72.0	...	NaN	NaT	NaN	NaN	everconfirmed	CURRENT	2022-07-31 23:59:59.000000	False	32	72
39	NaN	2066	2022-07-08 00:03:19	72	11.0	165.545455	202.124399	23.0	53.00	72.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	32	72
40	NaN	2068	2022-08-08 00:00:28	69	9.0	161.888889	77.608705	69.0	112.00	137.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-16 03:00:07.453940	False	0	69
41	NaN	2070	2022-08-11 00:00:34	67	1.0	67.000000	NaN	67.0	67.00	67.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-16 03:00:07.453940	False	0	67
42	NaN	2071	2022-08-11 00:00:36	67	11.0	165.545455	202.124399	23.0	53.00	72.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-16 03:00:07.453940	False	0	67
43	NaN	2074	2022-08-10 16:35:39	66	1.0	66.000000	NaN	66.0	66.00	66.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-16 03:00:07.453940	False	0	66
44	NaN	2078	2022-07-06 04:55:36	63	4.0	66.000000	44.022721	26.0	41.75	55.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	63
45	NaN	2079	2022-06-28 16:42:18	62	3.0	73.333333	53.901144	26.0	44.00	62.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	62

46 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	2022-03	2022-04	2022-05	2022-06	2022-07	2022-08
MODULE
Any	0	0	0	1	1	1
DEVOPS	30	28	27	2	4	2
Descriptor-packages	0	0	0	0	0	0
Documentation / Wiki	0	1	1	0	0	0
IM-NBI	30	34	36	35	36	37
LCM	14	20	18	13	15	15
MON	4	3	3	3	5	4
N2VC	23	46	20	9	18	18
NG-UI	21	19	15	5	6	6
OSMClient	6	6	6	5	5	2
Other	0	0	0	0	0	0
PLA	1	1	1	0	0	0
POL	0	0	0	0	0	0
RO	25	27	22	13	14	14
Robot-tests	4	4	4	1	1	1
Unknown	1	1	1	0	0	0
common	3	3	3	2	3	4

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

	MONTH	2022-03	2022-04	2022-05	2022-06	2022-07	2022-08
MODULE	variable
Any	CLOSED	0	0	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
DEVOPS	CLOSED	-6	-7	-1	-31	-4	-4
	FALSE_CLOSED	0	0	0	0	-2	0
	OPENED	8	5	0	6	6	2
	REOPENED	0	0	0	0	2	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	-1	0	-1	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	2	0	0	0	0
	REOPENED	0	0	0	0	0	0
IM-NBI	CLOSED	-4	-5	-4	-22	-4	0
	FALSE_CLOSED	0	-1	0	-19	0	0
	OPENED	10	9	6	21	5	1
	REOPENED	0	1	0	20	0	0
LCM	CLOSED	-4	-4	-15	-10	-6	-1
	FALSE_CLOSED	0	-1	0	0	0	0
	OPENED	6	10	13	5	8	1
	REOPENED	1	1	0	0	1	0
MON	CLOSED	0	-4	0	-1	0	-1
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	3	0	1	2	0
	REOPENED	0	0	0	0	0	0
N2VC	CLOSED	-9	-2	-32	-23	-1	-1
	FALSE_CLOSED	-2	0	0	0	-1	0
	OPENED	11	25	6	12	10	1
	REOPENED	2	3	0	0	3	0
NG-UI	CLOSED	0	-7	-5	-12	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	16	5	1	2	1	0
	REOPENED	0	0	0	0	0	0
OSMClient	CLOSED	-1	0	0	-6	-1	-4
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	2	0	0	5	1	1
	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	-1	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	-1	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	0	0	1	0
	REOPENED	0	0	0	0	0	0
RO	CLOSED	-12	-1	-12	-11	-4	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	15	3	7	2	5	0
	REOPENED	1	0	0	0	0	0
Robot-tests	CLOSED	-1	0	0	-3	0	-1
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	2	0	0	0	0	1
	REOPENED	0	0	0	0	0	0
Unknown	CLOSED	0	0	0	-1	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	1	0	0	0	0	0
	REOPENED	0	0	0	0	0	0
common	CLOSED	0	-1	-1	-2	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	1	1	1	1	1
	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	207	telefonica.com
1	david.garcia@canonical.com	135	canonical.com
2	eduardo.sousa@canonical.com	122	canonical.com
3	alfonso.tiernosepulveda@telefonica.com	101	telefonica.com
4	mark.beierl@canonical.com	97	canonical.com
5	glavado@whitestack.com	85	whitestack.com
6	escaleira@av.it.pt	83	av.it.pt
7	mmarchetti@sandvine.com	73	sandvine.com
8	adam.israel@canonical.com	70	canonical.com
9	e.dah.tid@telefonica.com	65	telefonica.com
10	daguilarh@indra.es	60	indra.es
11	garomero@indra.es	54	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	mbeierl@vmware.com	26	vmware.com
16	preethika.p@tataelxsi.co.in	22	tataelxsi.co.in
17	philip.joseph@riftio.com	19	riftio.com
18	kiran.kashalkar@riftio.com	19	riftio.com
19	ravi.chamarty@riftio.com	19	riftio.com
20	vijay.r@tataelxsi.co.in	19	tataelxsi.co.in
21	bdiaz@whitestack.com	17	whitestack.com
22	felipe.vicens@atos.net	17	atos.net
23	alimonj@indra.es	16	indra.es
24	sarathipriya.r@tataelxsi.co.in	16	tataelxsi.co.in
25	Other	673	Other

Contributions per company:

	company	reported_bugs
0	canonical.com	453
1	telefonica.com	427
2	indra.es	172
3	riftio.com	139
4	tataelxsi.co.in	138
5	whitestack.com	128
6	av.it.pt	91
7	sandvine.com	73
8	etsi.org	62
9	gmail.com	59
10	vmware.com	52
11	altran.com	48
12	atos.net	30
13	techmahindra.com	18
14	ulakhaberlesme.com.tr	18
15	Other	219

4.2 Bugs assignments

Share of bugs with owner: 34.46%

Top assignees of bugs still open:

	company	n_bugs
0	canonical.com	11
1	telefonica.com	5
2	whitestack.com	4
3	indra.es	2
4	ulakhaberlesme.com.tr	2
5	cttc.es	1

4.3 Top closers of bugs

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

	company	n_bugs
0	canonical.com	187
1	riftio.com	152
2	telefonica.com	132
3	whitestack.com	56
4	altran.com	43
5	vmware.com	38
6	etsi.org	12
7	atos.net	11
8	indra.es	10
9	sandvine.com	10
10	tataelxsi.co.in	9
11	techmahindra.com	7
12	intel.com	7
13	cnit.it	6
14	cttc.es	5
15	ulakhaberlesme.com.tr	5
16	dataart.com	3
17	sensinov.com	2
18	everyup.it	2
19	aricent.com	1
20	telenity.com	1
21	bt.com	1
22	fotonik.dtu.dk	1
23	stevens.edu	1
24	eantc.de	1
25	proceranetworks.com	1
26	nexius.com	1
27	keynetic.es	1
28	ehu.eus	1
29	adlinktech.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
4730	2135	2022-08-10 13:01:14	bug_status	OPEN-UNCONFIRMED	v12.0	common	Not master error when MongoDb is in replica-se...	21935	2022-08-16 03:00:07.453940	RECENT	deepika.e@tataelxsi.co.in	False
4731	1935	2022-08-10 16:16:41	bug_status	CONFIRMED	v11.0	OSMClient	Autocompletion for BASH not created	20338	2022-08-16 03:00:07.453940	RECENT	paranda@it.uc3m.es	False
4732	1994	2022-08-10 16:26:10	bug_status	RESOLVED	unspecified	DEVOPS	Stage 3 doesn't build according to latest chan...	20872	2022-08-16 03:00:07.453940	RECENT	jpedrofonseca@av.it.pt	True
4733	2075	2022-08-10 16:31:40	bug_status	RESOLVED	v11.0	OSMClient	"osm repo-index" command deletes package direc...	21585	2022-08-16 03:00:07.453940	RECENT	e.dah.tid@telefonica.com	True
4734	2114	2022-08-10 16:38:20	bug_status	RESOLVED	v12.0	DEVOPS	Proper way to Restart OSM after Reboot?	21832	2022-08-16 03:00:07.453940	RECENT	tayloreisman2012@gmail.com	True
4736	2126	2022-08-11 00:44:35	bug_status	RESOLVED	Master	LCM	Issue in identifying target VDU in multi VDU NS	21890	2022-08-16 03:00:07.453940	RECENT	rahul.k4@tataelxsi.co.in	True
4737	2136	2022-08-11 00:46:10	bug_status	IN_PROGRESS	v12.0	LCM	Issue in identifying target VDU in multi VDU NS	21940	2022-08-16 03:00:07.453940	RECENT	gcuba@whitestack.com	False
4738	2132	2022-08-12 03:50:54	bug_status	RESOLVED	Master	Robot-tests	New features for v12.0 included in prepare step	21922	2022-08-16 03:00:07.453940	RECENT	mark.beierl@canonical.com	True
4742	2137	2022-08-12 16:00:52	bug_status	RESOLVED	Master	DEVOPS	License check fails if file is binary	21943	2022-08-16 03:00:07.453940	RECENT	mark.beierl@canonical.com	True
4743	2138	2022-08-12 22:28:47	bug_status	RESOLVED	v12.0	OSMClient	OSM Client package-create error	21949	2022-08-16 03:00:07.453940	RECENT	fjmunoza@indra.es	True

5.2 Last bug assignments

	BUG_ID	TIMESTAMP	OPERATION	VALUE	RELEASE	MODULE	BUG_DESCRIPTION	ROW_NUMBER	MONTH	AGE
19850	1611	2022-05-13 18:28:41	assigned_to	mark.beierl@canonical.com	Master	OSMClient	Error deleting VNFD by name	17199	2022-05-31 23:59:59.000000	CURRENT
19852	1557	2022-05-13 18:28:50	assigned_to	gerardo.garciadeblas@telefonica.com	Master	IM-NBI	Multiple VNFs using same VNFD ID at NSD can't ...	16593	2022-05-31 23:59:59.000000	CURRENT
19921	2033	2022-05-19 16:04:00	assigned_to	mark.beierl@canonical.com	v10.0	IM-NBI	NBI leaves files orphaned in fsmongo	21290	2022-05-31 23:59:59.000000	CURRENT
20001	2032	2022-05-25 20:08:59	assigned_to	mark.beierl@canonical.com	v11.0	IM-NBI	NBI leaves files orphaned in fsmongo	21281	2022-05-31 23:59:59.000000	CURRENT
20008	2024	2022-05-25 20:27:25	assigned_to	mark.beierl@canonical.com	Master	IM-NBI	NBI leaves files orphaned in fsmongo	21196	2022-05-31 23:59:59.000000	CURRENT
21640	2117	2022-07-14 15:54:25	assigned_to	guillermo.calvino@canonical.com	Master	N2VC	Day-2 primitives based on helm charts EE fail	21853	2022-07-31 23:59:59.000000	CURRENT
21791	2131	2022-08-02 16:52:02	assigned_to	mark.beierl@canonical.com	v12.0	DEVOPS	Cannot install OSM due to Failed to bootstrap ...	21917	2022-08-16 03:00:07.453940	RECENT
21794	2125	2022-08-02 16:52:53	assigned_to	mark.beierl@canonical.com	v12.0	DEVOPS	k8s monitor cannot install.	21884	2022-08-16 03:00:07.453940	RECENT
21797	2114	2022-08-02 16:54:20	assigned_to	mark.beierl@canonical.com	v12.0	DEVOPS	Proper way to Restart OSM after Reboot?	21831	2022-08-16 03:00:07.453940	RECENT
21929	2133	2022-08-12 03:51:58	assigned_to	mark.beierl@canonical.com	v12.0	N2VC	Error in execution of day-2 primitive based on...	21931	2022-08-16 03:00:07.453940	RECENT

5.3 Last resolved bugs

	BUG_ID	TIMESTAMP	OPERATION	VALUE	RELEASE	MODULE	BUG_DESCRIPTION	ROW_NUMBER	MONTH	AGE	ISSUER	SOLVED
4724	1709	2022-08-03 20:02:10	bug_status	RESOLVED	unspecified	DEVOPS	Keystone container runs as root	18138	2022-08-16 03:00:07.453940	RECENT	eduardo.sousa@canonical.com	True
4725	2011	2022-08-03 20:03:07	bug_status	RESOLVED	v11.0	MON	MON build failure "missing 1 required position...	21041	2022-08-16 03:00:07.453940	RECENT	priyadarshini@tataelxsi.co.in	True
4728	2116	2022-08-10 02:38:53	bug_status	RESOLVED	Master	OSMClient	The ns-op-list command fails with exception wh...	21845	2022-08-16 03:00:07.453940	RECENT	escaleira@av.it.pt	True
4732	1994	2022-08-10 16:26:10	bug_status	RESOLVED	unspecified	DEVOPS	Stage 3 doesn't build according to latest chan...	20872	2022-08-16 03:00:07.453940	RECENT	jpedrofonseca@av.it.pt	True
4733	2075	2022-08-10 16:31:40	bug_status	RESOLVED	v11.0	OSMClient	"osm repo-index" command deletes package direc...	21585	2022-08-16 03:00:07.453940	RECENT	e.dah.tid@telefonica.com	True
4734	2114	2022-08-10 16:38:20	bug_status	RESOLVED	v12.0	DEVOPS	Proper way to Restart OSM after Reboot?	21832	2022-08-16 03:00:07.453940	RECENT	tayloreisman2012@gmail.com	True
4736	2126	2022-08-11 00:44:35	bug_status	RESOLVED	Master	LCM	Issue in identifying target VDU in multi VDU NS	21890	2022-08-16 03:00:07.453940	RECENT	rahul.k4@tataelxsi.co.in	True
4738	2132	2022-08-12 03:50:54	bug_status	RESOLVED	Master	Robot-tests	New features for v12.0 included in prepare step	21922	2022-08-16 03:00:07.453940	RECENT	mark.beierl@canonical.com	True
4742	2137	2022-08-12 16:00:52	bug_status	RESOLVED	Master	DEVOPS	License check fails if file is binary	21943	2022-08-16 03:00:07.453940	RECENT	mark.beierl@canonical.com	True
4743	2138	2022-08-12 22:28:47	bug_status	RESOLVED	v12.0	OSMClient	OSM Client package-create error	21949	2022-08-16 03:00:07.453940	RECENT	fjmunoza@indra.es	True

DONE

---