Analysis of OSM events in Bugzilla

Date and time of the report: 2022-08-14 05:00:07.843120

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

Bugs considered recent: Since 2022-07-24.

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	0	2	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	94	11	105

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	60	6	66
CONFIRMED	30	4	34
IN_PROGRESS	4	1	5
Total	94	11	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	53.000000	NaN	53.0	53.00	53.0	53.00	53.0
1	DEVOPS	2.0	16.500000	6.363961	12.0	14.25	16.5	18.75	21.0
2	Gerrit	1.0	109.000000	NaN	109.0	109.00	109.0	109.00	109.0
3	IM-NBI	37.0	257.567568	198.864211	3.0	132.00	241.0	331.00	768.0
4	LCM	15.0	87.733333	101.691035	3.0	36.00	56.0	84.00	418.0
5	MON	4.0	61.750000	48.002604	24.0	30.75	46.5	77.50	130.0
6	N2VC	18.0	115.111111	167.581021	9.0	37.00	65.0	70.75	687.0
7	NG-UI	6.0	88.500000	51.048017	24.0	49.00	93.5	132.75	140.0
8	OSMClient	2.0	102.000000	53.740115	64.0	83.00	102.0	121.00	140.0
9	RO	14.0	143.071429	117.292838	30.0	37.75	107.0	215.00	386.0
10	Robot-tests	1.0	141.000000	NaN	141.0	141.00	141.0	141.00	141.0
11	common	4.0	177.500000	194.371637	3.0	30.75	143.0	289.75	421.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	0	1.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	45	73.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	687	11.0	163.545455	202.124399	21.0	51.0	70.0	...	NaN	NaT	NaN	NaN	priority	RECENT	2022-07-31 23:59:59.000000	False	672	687
1	NaN	1579	2022-07-19 17:30:57	418	6.0	101.833333	156.789562	15.0	24.0	36.5	...	glavado@whitestack.com	2022-02-28 23:59:59	CURRENT	1.0	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	418
2	NaN	1768	2022-08-04 00:00:22	271	4.0	93.750000	118.350820	30.0	30.0	37.0	...	sgallardor@indra.es	2021-11-30 23:59:59	CURRENT	1.0	comment	RECENT	2022-08-14 03:00:07.891365	False	28	271

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	768	18.0	334.277778	224.572484	40.0	135.25	329.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	768
1	NaN	1188	2022-06-28 17:33:00	733	18.0	334.277778	224.572484	40.0	135.25	329.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	733
2	NaN	1266	2022-06-28 17:32:53	663	18.0	334.277778	224.572484	40.0	135.25	329.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	663
3	NaN	1454	2022-06-28 17:32:46	534	18.0	334.277778	224.572484	40.0	135.25	329.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	534
4	NaN	1557	2022-08-03 00:00:18	436	18.0	334.277778	224.572484	40.0	135.25	329.0	...	gerardo.garciadeblas@telefonica.com	2022-05-31 23:59:59.000000	CURRENT	4.0	comment	RECENT	2022-08-14 03:00:07.891365	False	0	436
5	NaN	1577	2022-08-09 00:00:19	421	3.0	235.666667	190.710077	40.0	143.00	246.0	...	mark.beierl@canonical.com	2022-02-28 23:59:59.000000	CURRENT	1.0	comment	RECENT	2022-08-14 03:00:07.891365	False	0	421
6	NaN	1622	2022-06-28 17:32:40	376	7.0	201.428571	97.099360	85.0	133.50	198.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	376
7	NaN	1632	2022-07-21 18:03:47	369	11.0	163.545455	202.124399	21.0	51.00	70.0	...	NaN	NaT	NaN	NaN	version	CURRENT	2022-07-31 23:59:59.000000	False	346	369
8	NaN	1752	2022-06-28 17:31:13	276	9.0	159.888889	77.608705	67.0	110.00	135.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	276
9	NaN	1769	2022-08-04 00:00:24	271	6.0	188.333333	66.629323	107.0	134.00	215.0	...	sgallardor@indra.es	2021-11-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2022-08-14 03:00:07.891365	False	28	271
10	NaN	1808	2022-06-28 17:31:04	257	9.0	159.888889	77.608705	67.0	110.00	135.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	257
11	NaN	1825	2022-06-28 17:30:57	243	7.0	201.428571	97.099360	85.0	133.50	198.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	197	243
12	NaN	1857	2022-06-20 23:59:47	215	11.0	163.545455	202.124399	21.0	51.00	70.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	215
13	NaN	1900	2022-08-04 00:00:27	162	2.0	123.000000	55.154329	84.0	103.50	123.0	...	lluis.gifre@cttc.es	2022-03-31 23:59:59.000000	CURRENT	1.0	keywords	RECENT	2022-08-14 03:00:07.891365	False	13	162
14	NaN	1921	2022-08-04 00:00:29	145	2.0	100.500000	62.932504	56.0	78.25	100.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-14 03:00:07.891365	False	0	145
15	NaN	1936	2022-08-02 17:02:54	140	2.0	137.500000	3.535534	135.0	136.25	137.5	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2022-08-14 03:00:07.891365	False	129	140
16	NaN	1979	2022-08-03 00:00:26	130	3.0	71.333333	53.901144	24.0	42.00	60.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-14 03:00:07.891365	False	0	130
17	NaN	1988	2022-08-04 00:00:33	126	4.0	64.000000	44.022721	24.0	39.75	53.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-14 03:00:07.891365	False	0	126
18	NaN	2042	2022-07-19 16:59:28	84	6.0	101.833333	156.789562	15.0	24.00	36.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	5	84
19	NaN	2043	2022-08-06 00:07:12	84	3.0	72.000000	16.643317	53.0	66.00	79.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-14 03:00:07.891365	False	9	84
20	NaN	2069	2022-07-05 17:39:25	65	2.0	44.000000	29.698485	23.0	33.50	44.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	65
21	NaN	2093	2022-07-01 10:48:59	43	3.0	37.333333	5.131601	33.0	34.50	36.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	43
22	NaN	2098	2022-07-13 13:32:21	39	2.0	21.000000	25.455844	3.0	12.00	21.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	39
23	NaN	2103	2022-08-11 11:25:49	37	2.0	20.000000	24.041631	3.0	11.50	20.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-14 03:00:07.891365	False	0	37
24	NaN	2125	2022-08-10 21:28:38	21	2.0	16.500000	6.363961	12.0	14.25	16.5	...	mark.beierl@canonical.com	2022-08-14 03:00:07.891365	RECENT	1.0	comment	RECENT	2022-08-14 03:00:07.891365	False	0	21

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	624	1.0	624.000000	NaN	624.0	624.00	624.0	...	mark.beierl@canonical.com	2021-10-31 23:59:59	CURRENT	1.0	comment	RECENT	2022-08-14 03:00:07.891365	False	0	624
1	NaN	1603	2022-08-09 00:00:22	386	1.0	386.000000	NaN	386.0	386.00	386.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-14 03:00:07.891365	False	319	386
2	NaN	1660	2022-06-28 17:32:35	333	18.0	334.277778	224.572484	40.0	135.25	329.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	287	333
3	NaN	1661	2022-06-28 17:32:29	333	18.0	334.277778	224.572484	40.0	135.25	329.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	287	333
4	NaN	1667	2022-06-28 17:32:11	331	18.0	334.277778	224.572484	40.0	135.25	329.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	285	331
5	NaN	1668	2022-06-28 17:31:57	331	18.0	334.277778	224.572484	40.0	135.25	329.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	285	331
6	NaN	1671	2022-06-28 17:31:50	327	18.0	334.277778	224.572484	40.0	135.25	329.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	280	327
7	NaN	1672	2022-06-28 17:31:45	327	18.0	334.277778	224.572484	40.0	135.25	329.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	280	327
8	NaN	1673	2022-06-28 17:31:36	327	18.0	334.277778	224.572484	40.0	135.25	329.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	280	327
9	NaN	1822	2022-08-09 00:00:27	246	3.0	235.666667	190.710077	40.0	143.00	246.0	...	mark.beierl@canonical.com	2022-02-28 23:59:59	CURRENT	1.0	comment	RECENT	2022-08-14 03:00:07.891365	False	0	246
10	NaN	1829	2022-06-28 17:30:41	241	7.0	201.428571	97.099360	85.0	133.50	198.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	195	241
11	NaN	1831	2022-06-28 17:30:32	241	9.0	159.888889	77.608705	67.0	110.00	135.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	195	241
12	NaN	1853	2022-08-07 00:00:19	215	6.0	188.333333	66.629323	107.0	134.00	215.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-14 03:00:07.891365	False	147	215
13	NaN	1855	2022-08-07 00:00:22	215	6.0	188.333333	66.629323	107.0	134.00	215.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-14 03:00:07.891365	False	147	215
14	NaN	1856	2022-08-07 00:00:24	215	6.0	188.333333	66.629323	107.0	134.00	215.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-14 03:00:07.891365	False	147	215
15	NaN	1869	2022-06-28 17:30:16	198	7.0	201.428571	97.099360	85.0	133.50	198.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	152	198
16	NaN	1890	2022-06-21 17:34:26	163	11.0	163.545455	202.124399	21.0	51.00	70.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	163
17	NaN	1931	2022-06-14 10:49:12	141	1.0	141.000000	NaN	141.0	141.00	141.0	...	emin.aktas@ulakhaberlesme.com.tr	2022-03-31 23:59:59	CURRENT	1.0	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	141
18	NaN	1935	2022-08-10 16:16:41	140	1.0	140.000000	NaN	140.0	140.00	140.0	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2022-08-14 03:00:07.891365	False	137	140
19	NaN	1942	2022-08-03 00:00:24	136	9.0	159.888889	77.608705	67.0	110.00	135.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-14 03:00:07.891365	False	0	136
20	NaN	1946	2022-06-28 17:30:07	136	18.0	334.277778	224.572484	40.0	135.25	329.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	90	136
21	NaN	1952	2022-08-02 17:04:03	135	2.0	137.500000	3.535534	135.0	136.25	137.5	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2022-08-14 03:00:07.891365	False	124	135
22	NaN	1954	2022-06-16 16:57:06	135	18.0	334.277778	224.572484	40.0	135.25	329.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	135
23	NaN	1955	2022-06-15 00:01:42	135	9.0	159.888889	77.608705	67.0	110.00	135.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	135
24	NaN	1956	2022-06-15 00:01:44	135	7.0	201.428571	97.099360	85.0	133.50	198.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	135
25	NaN	1970	2022-06-20 18:38:35	132	18.0	334.277778	224.572484	40.0	135.25	329.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	132
26	NaN	1971	2022-06-15 00:01:48	132	9.0	159.888889	77.608705	67.0	110.00	135.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	132
27	NaN	1972	2022-06-15 00:01:50	132	7.0	201.428571	97.099360	85.0	133.50	198.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	132
28	NaN	2009	2022-06-20 15:41:33	110	9.0	159.888889	77.608705	67.0	110.00	135.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	110
29	NaN	2015	2022-08-10 11:02:45	109	1.0	109.000000	NaN	109.0	109.00	109.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-14 03:00:07.891365	False	0	109
30	NaN	2019	2022-08-04 00:00:37	107	6.0	188.333333	66.629323	107.0	134.00	215.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-14 03:00:07.891365	False	0	107
31	NaN	2020	2022-08-04 00:00:40	107	6.0	188.333333	66.629323	107.0	134.00	215.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-14 03:00:07.891365	False	0	107
32	NaN	2038	2022-06-30 14:48:41	85	18.0	334.277778	224.572484	40.0	135.25	329.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	85
33	NaN	2039	2022-06-30 14:48:59	85	9.0	159.888889	77.608705	67.0	110.00	135.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	85
34	NaN	2040	2022-06-30 14:49:29	85	7.0	201.428571	97.099360	85.0	133.50	198.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	85
35	NaN	2044	2022-08-06 00:06:58	84	2.0	123.000000	55.154329	84.0	103.50	123.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-14 03:00:07.891365	False	9	84
36	NaN	2049	2022-07-19 17:39:23	79	3.0	72.000000	16.643317	53.0	66.00	79.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	79
37	NaN	2063	2022-07-07 17:24:30	71	11.0	163.545455	202.124399	21.0	51.00	70.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	33	71
38	NaN	2065	2022-07-07 17:16:22	70	11.0	163.545455	202.124399	21.0	51.00	70.0	...	NaN	NaT	NaN	NaN	everconfirmed	CURRENT	2022-07-31 23:59:59.000000	False	32	70
39	NaN	2066	2022-07-08 00:03:19	70	11.0	163.545455	202.124399	21.0	51.00	70.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	32	70
40	NaN	2068	2022-08-08 00:00:28	67	9.0	159.888889	77.608705	67.0	110.00	135.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-14 03:00:07.891365	False	0	67
41	NaN	2070	2022-08-11 00:00:34	65	1.0	65.000000	NaN	65.0	65.00	65.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-14 03:00:07.891365	False	0	65
42	NaN	2071	2022-08-11 00:00:36	65	11.0	163.545455	202.124399	21.0	51.00	70.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-14 03:00:07.891365	False	0	65
43	NaN	2074	2022-08-10 16:35:39	64	1.0	64.000000	NaN	64.0	64.00	64.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-14 03:00:07.891365	False	0	64
44	NaN	2078	2022-07-06 04:55:36	61	4.0	64.000000	44.022721	24.0	39.75	53.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	61

45 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...	21927	2022-08-14 03:00:07.891365	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	20336	2022-08-14 03:00:07.891365	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...	20870	2022-08-14 03:00:07.891365	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...	21583	2022-08-14 03:00:07.891365	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?	21824	2022-08-14 03:00:07.891365	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	21882	2022-08-14 03:00:07.891365	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	21932	2022-08-14 03:00:07.891365	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	21914	2022-08-14 03:00:07.891365	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	21935	2022-08-14 03:00:07.891365	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	21941	2022-08-14 03:00:07.891365	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	21288	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	21279	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	21194	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	21845	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 ...	21909	2022-08-14 03:00:07.891365	RECENT
21794	2125	2022-08-02 16:52:53	assigned_to	mark.beierl@canonical.com	v12.0	DEVOPS	k8s monitor cannot install.	21876	2022-08-14 03:00:07.891365	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?	21823	2022-08-14 03:00:07.891365	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...	21923	2022-08-14 03:00:07.891365	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-14 03:00:07.891365	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...	21039	2022-08-14 03:00:07.891365	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...	21837	2022-08-14 03:00:07.891365	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...	20870	2022-08-14 03:00:07.891365	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...	21583	2022-08-14 03:00:07.891365	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?	21824	2022-08-14 03:00:07.891365	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	21882	2022-08-14 03:00:07.891365	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	21914	2022-08-14 03:00:07.891365	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	21935	2022-08-14 03:00:07.891365	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	21941	2022-08-14 03:00:07.891365	RECENT	fjmunoza@indra.es	True

DONE

---