Analysis of OSM events in Bugzilla

Date and time of the report: 2022-08-13 05:00:07.510010

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

Bugs considered recent: Since 2022-07-23.

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	12	3	15
MON	4	0	4
N2VC	15	3	18
NG-UI	4	2	6
OSMClient	1	1	2
RO	14	0	14
Robot-tests	1	0	1
common	3	1	4
Total	92	13	105

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	58	8	66
CONFIRMED	30	4	34
IN_PROGRESS	4	1	5
Total	92	13	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	52.000000	NaN	52.0	52.00	52.0	52.00	52.0
1	DEVOPS	2.0	15.500000	6.363961	11.0	13.25	15.5	17.75	20.0
2	Gerrit	1.0	108.000000	NaN	108.0	108.00	108.0	108.00	108.0
3	IM-NBI	37.0	256.567568	198.864211	2.0	131.00	240.0	330.00	767.0
4	LCM	15.0	86.733333	101.691035	2.0	35.00	55.0	83.00	417.0
5	MON	4.0	60.750000	48.002604	23.0	29.75	45.5	76.50	129.0
6	N2VC	18.0	114.111111	167.581021	8.0	36.00	64.0	69.75	686.0
7	NG-UI	6.0	87.500000	51.048017	23.0	48.00	92.5	131.75	139.0
8	OSMClient	2.0	101.000000	53.740115	63.0	82.00	101.0	120.00	139.0
9	RO	14.0	142.071429	117.292838	29.0	36.75	106.0	214.00	385.0
10	Robot-tests	1.0	140.000000	NaN	140.0	140.00	140.0	140.00	140.0
11	common	4.0	176.500000	194.371637	2.0	29.75	142.0	288.75	420.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	1	3.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	44	72.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	686	11.0	162.545455	202.124399	20.0	50.0	69.0	...	NaN	NaT	NaN	NaN	priority	RECENT	2022-07-31 23:59:59.000000	False	672	686
1	NaN	1579	2022-07-19 17:30:57	417	6.0	100.833333	156.789562	14.0	23.0	35.5	...	glavado@whitestack.com	2022-02-28 23:59:59	CURRENT	1.0	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	417
2	NaN	1768	2022-08-04 00:00:22	270	4.0	92.750000	118.350820	29.0	29.0	36.0	...	sgallardor@indra.es	2021-11-30 23:59:59	CURRENT	1.0	comment	RECENT	2022-08-13 03:00:07.565617	False	28	270

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	767	18.0	333.277778	224.572484	39.0	134.25	328.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	767
1	NaN	1188	2022-06-28 17:33:00	732	18.0	333.277778	224.572484	39.0	134.25	328.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	732
2	NaN	1266	2022-06-28 17:32:53	662	18.0	333.277778	224.572484	39.0	134.25	328.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	662
3	NaN	1454	2022-06-28 17:32:46	533	18.0	333.277778	224.572484	39.0	134.25	328.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	533
4	NaN	1557	2022-08-03 00:00:18	435	18.0	333.277778	224.572484	39.0	134.25	328.0	...	gerardo.garciadeblas@telefonica.com	2022-05-31 23:59:59.000000	CURRENT	4.0	comment	RECENT	2022-08-13 03:00:07.565617	False	0	435
5	NaN	1577	2022-08-09 00:00:19	420	3.0	234.666667	190.710077	39.0	142.00	245.0	...	mark.beierl@canonical.com	2022-02-28 23:59:59.000000	CURRENT	1.0	comment	RECENT	2022-08-13 03:00:07.565617	False	0	420
6	NaN	1622	2022-06-28 17:32:40	375	7.0	200.428571	97.099360	84.0	132.50	197.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	375
7	NaN	1632	2022-07-21 18:03:47	368	11.0	162.545455	202.124399	20.0	50.00	69.0	...	NaN	NaT	NaN	NaN	version	CURRENT	2022-07-31 23:59:59.000000	False	346	368
8	NaN	1752	2022-06-28 17:31:13	275	9.0	158.888889	77.608705	66.0	109.00	134.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	275
9	NaN	1769	2022-08-04 00:00:24	270	6.0	187.333333	66.629323	106.0	133.00	214.0	...	sgallardor@indra.es	2021-11-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2022-08-13 03:00:07.565617	False	28	270
10	NaN	1808	2022-06-28 17:31:04	256	9.0	158.888889	77.608705	66.0	109.00	134.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	256
11	NaN	1825	2022-06-28 17:30:57	242	7.0	200.428571	97.099360	84.0	132.50	197.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	197	242
12	NaN	1857	2022-06-20 23:59:47	214	11.0	162.545455	202.124399	20.0	50.00	69.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	214
13	NaN	1900	2022-08-04 00:00:27	161	2.0	122.000000	55.154329	83.0	102.50	122.0	...	lluis.gifre@cttc.es	2022-03-31 23:59:59.000000	CURRENT	1.0	keywords	RECENT	2022-08-13 03:00:07.565617	False	13	161
14	NaN	1921	2022-08-04 00:00:29	144	2.0	99.500000	62.932504	55.0	77.25	99.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-13 03:00:07.565617	False	0	144
15	NaN	1936	2022-08-02 17:02:54	139	2.0	136.500000	3.535534	134.0	135.25	136.5	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2022-08-13 03:00:07.565617	False	129	139
16	NaN	1979	2022-08-03 00:00:26	129	3.0	70.333333	53.901144	23.0	41.00	59.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-13 03:00:07.565617	False	0	129
17	NaN	1988	2022-08-04 00:00:33	125	4.0	63.000000	44.022721	23.0	38.75	52.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-13 03:00:07.565617	False	0	125
18	NaN	2042	2022-07-19 16:59:28	83	6.0	100.833333	156.789562	14.0	23.00	35.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	5	83
19	NaN	2043	2022-08-06 00:07:12	83	3.0	71.000000	16.643317	52.0	65.00	78.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-13 03:00:07.565617	False	9	83
20	NaN	2069	2022-07-05 17:39:25	64	2.0	43.000000	29.698485	22.0	32.50	43.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	64
21	NaN	2093	2022-07-01 10:48:59	42	3.0	36.333333	5.131601	32.0	33.50	35.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	42
22	NaN	2098	2022-07-13 13:32:21	38	2.0	20.000000	25.455844	2.0	11.00	20.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	38
23	NaN	2103	2022-08-11 11:25:49	36	2.0	19.000000	24.041631	2.0	10.50	19.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-13 03:00:07.565617	False	0	36
24	NaN	2125	2022-08-10 21:28:38	20	2.0	15.500000	6.363961	11.0	13.25	15.5	...	mark.beierl@canonical.com	2022-08-13 03:00:07.565617	RECENT	1.0	comment	RECENT	2022-08-13 03:00:07.565617	False	0	20

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	623	1.0	623.000000	NaN	623.0	623.00	623.0	...	mark.beierl@canonical.com	2021-10-31 23:59:59	CURRENT	1.0	comment	RECENT	2022-08-13 03:00:07.565617	False	0	623
1	NaN	1603	2022-08-09 00:00:22	385	1.0	385.000000	NaN	385.0	385.00	385.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-13 03:00:07.565617	False	319	385
2	NaN	1660	2022-06-28 17:32:35	332	18.0	333.277778	224.572484	39.0	134.25	328.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	287	332
3	NaN	1661	2022-06-28 17:32:29	332	18.0	333.277778	224.572484	39.0	134.25	328.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	287	332
4	NaN	1667	2022-06-28 17:32:11	330	18.0	333.277778	224.572484	39.0	134.25	328.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	285	330
5	NaN	1668	2022-06-28 17:31:57	330	18.0	333.277778	224.572484	39.0	134.25	328.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	285	330
6	NaN	1671	2022-06-28 17:31:50	326	18.0	333.277778	224.572484	39.0	134.25	328.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	280	326
7	NaN	1672	2022-06-28 17:31:45	326	18.0	333.277778	224.572484	39.0	134.25	328.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	280	326
8	NaN	1673	2022-06-28 17:31:36	326	18.0	333.277778	224.572484	39.0	134.25	328.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	280	326
9	NaN	1822	2022-08-09 00:00:27	245	3.0	234.666667	190.710077	39.0	142.00	245.0	...	mark.beierl@canonical.com	2022-02-28 23:59:59	CURRENT	1.0	comment	RECENT	2022-08-13 03:00:07.565617	False	0	245
10	NaN	1829	2022-06-28 17:30:41	240	7.0	200.428571	97.099360	84.0	132.50	197.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	195	240
11	NaN	1831	2022-06-28 17:30:32	240	9.0	158.888889	77.608705	66.0	109.00	134.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	195	240
12	NaN	1853	2022-08-07 00:00:19	214	6.0	187.333333	66.629323	106.0	133.00	214.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-13 03:00:07.565617	False	147	214
13	NaN	1855	2022-08-07 00:00:22	214	6.0	187.333333	66.629323	106.0	133.00	214.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-13 03:00:07.565617	False	147	214
14	NaN	1856	2022-08-07 00:00:24	214	6.0	187.333333	66.629323	106.0	133.00	214.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-13 03:00:07.565617	False	147	214
15	NaN	1869	2022-06-28 17:30:16	197	7.0	200.428571	97.099360	84.0	132.50	197.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	152	197
16	NaN	1890	2022-06-21 17:34:26	162	11.0	162.545455	202.124399	20.0	50.00	69.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	162
17	NaN	1931	2022-06-14 10:49:12	140	1.0	140.000000	NaN	140.0	140.00	140.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	140
18	NaN	1935	2022-08-10 16:16:41	139	1.0	139.000000	NaN	139.0	139.00	139.0	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2022-08-13 03:00:07.565617	False	137	139
19	NaN	1942	2022-08-03 00:00:24	135	9.0	158.888889	77.608705	66.0	109.00	134.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-13 03:00:07.565617	False	0	135
20	NaN	1946	2022-06-28 17:30:07	135	18.0	333.277778	224.572484	39.0	134.25	328.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	90	135
21	NaN	1952	2022-08-02 17:04:03	134	2.0	136.500000	3.535534	134.0	135.25	136.5	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2022-08-13 03:00:07.565617	False	124	134
22	NaN	1954	2022-06-16 16:57:06	134	18.0	333.277778	224.572484	39.0	134.25	328.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	134
23	NaN	1955	2022-06-15 00:01:42	134	9.0	158.888889	77.608705	66.0	109.00	134.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	134
24	NaN	1956	2022-06-15 00:01:44	134	7.0	200.428571	97.099360	84.0	132.50	197.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	134
25	NaN	1970	2022-06-20 18:38:35	131	18.0	333.277778	224.572484	39.0	134.25	328.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	131
26	NaN	1971	2022-06-15 00:01:48	131	9.0	158.888889	77.608705	66.0	109.00	134.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	131
27	NaN	1972	2022-06-15 00:01:50	131	7.0	200.428571	97.099360	84.0	132.50	197.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	131
28	NaN	2009	2022-06-20 15:41:33	109	9.0	158.888889	77.608705	66.0	109.00	134.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	109
29	NaN	2015	2022-08-10 11:02:45	108	1.0	108.000000	NaN	108.0	108.00	108.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-13 03:00:07.565617	False	0	108
30	NaN	2019	2022-08-04 00:00:37	106	6.0	187.333333	66.629323	106.0	133.00	214.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-13 03:00:07.565617	False	0	106
31	NaN	2020	2022-08-04 00:00:40	106	6.0	187.333333	66.629323	106.0	133.00	214.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-13 03:00:07.565617	False	0	106
32	NaN	2038	2022-06-30 14:48:41	84	18.0	333.277778	224.572484	39.0	134.25	328.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	84
33	NaN	2039	2022-06-30 14:48:59	84	9.0	158.888889	77.608705	66.0	109.00	134.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	84
34	NaN	2040	2022-06-30 14:49:29	84	7.0	200.428571	97.099360	84.0	132.50	197.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	84
35	NaN	2044	2022-08-06 00:06:58	83	2.0	122.000000	55.154329	83.0	102.50	122.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-13 03:00:07.565617	False	9	83
36	NaN	2049	2022-07-19 17:39:23	78	3.0	71.000000	16.643317	52.0	65.00	78.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	78
37	NaN	2063	2022-07-07 17:24:30	70	11.0	162.545455	202.124399	20.0	50.00	69.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	33	70
38	NaN	2065	2022-07-07 17:16:22	69	11.0	162.545455	202.124399	20.0	50.00	69.0	...	NaN	NaT	NaN	NaN	everconfirmed	CURRENT	2022-07-31 23:59:59.000000	False	32	69
39	NaN	2066	2022-07-08 00:03:19	69	11.0	162.545455	202.124399	20.0	50.00	69.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	32	69
40	NaN	2068	2022-08-08 00:00:28	66	9.0	158.888889	77.608705	66.0	109.00	134.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-13 03:00:07.565617	False	0	66
41	NaN	2070	2022-08-11 00:00:34	64	1.0	64.000000	NaN	64.0	64.00	64.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-13 03:00:07.565617	False	0	64
42	NaN	2071	2022-08-11 00:00:36	64	11.0	162.545455	202.124399	20.0	50.00	69.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-13 03:00:07.565617	False	0	64
43	NaN	2074	2022-08-10 16:35:39	63	1.0	63.000000	NaN	63.0	63.00	63.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-13 03:00:07.565617	False	0	63

44 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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	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-13 03:00:07.565617	RECENT	fjmunoza@indra.es	True

DONE

---