Analysis of OSM events in Bugzilla

Date and time of the report: 2022-09-13 05:00:07.401505

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

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

98

Bugs present in multiple branches:

	BUG_DESCRIPTION	NUM_BRANCHES	RELEASE	MODULE	TIMESTAMP
0	A user is not able to use a VDU/KDU scaling co...	2	[Master, Master]	LCM	2022-07-04 16:37:05
1	Multiple typos/small issues prevent using IETF...	2	[v12.0, Master]	RO	2022-09-05 12:42:49
2	N2VC fails to scale a KNF based on Helm Charts...	2	[Master, v12.0]	N2VC	2022-07-07 17:16:22
3	The VCA Status for an NS with both a KNF and a...	2	[Master, Master]	NG-UI	2022-05-27 01:22:04
4	The edge case of first scaling down an Helm Ch...	2	[Master, v12.0]	N2VC	2022-07-07 17:16:01
5	The instantiation of a KNF whose NS parameter ...	4	[Master, v12.0, v11.0, v10.0]	LCM	2022-09-12 00:57:18
6	WIM is not properly selected by RO due to mult...	2	[v12.0, Master]	RO	2022-09-05 12:27:15
7	When we have more than one scalable resources ...	2	[Master, v12.0]	N2VC	2022-07-07 21:45:41
8	check_valid_wim_account fails due to wrong par...	2	[v12.0, Master]	IM-NBI	2022-08-31 11:46:20

Number of bugs per module

AGE	CURRENT	RECENT	Total
MODULE
DEVOPS	3	0	3
Gerrit	1	0	1
IM-NBI	24	7	31
LCM	9	9	18
MON	2	2	4
N2VC	14	0	14
NG-UI	4	1	5
OSMClient	2	0	2
RO	11	7	18
Robot-tests	1	0	1
common	1	0	1
Total	72	26	98

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	40	15	55
UNCONFIRMED	1	1	2
CONFIRMED	29	9	38
IN_PROGRESS	2	1	3
Total	72	26	98

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	DEVOPS	3.0	39.333333	13.203535	25.0	33.5	42.0	46.50	51.0
1	Gerrit	1.0	139.000000	NaN	139.0	139.0	139.0	139.00	139.0
2	IM-NBI	31.0	288.612903	220.214846	12.0	106.0	273.0	362.00	798.0
3	LCM	18.0	84.388889	108.359499	1.0	10.0	60.5	103.25	451.0
4	MON	4.0	74.250000	60.090903	20.0	45.5	58.5	87.25	160.0
5	N2VC	14.0	180.571429	202.416066	39.0	67.0	83.5	209.00	717.0
6	NG-UI	5.0	78.800000	51.075434	18.0	54.0	75.0	91.00	156.0
7	OSMClient	2.0	132.000000	53.740115	94.0	113.0	132.0	151.00	170.0
8	RO	18.0	116.611111	123.176172	4.0	10.0	64.5	218.00	416.0
9	Robot-tests	1.0	171.000000	NaN	171.0	171.0	171.0	171.00	171.0
10	common	1.0	276.000000	NaN	276.0	276.0	276.0	276.00	276.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	4	3	21	28.0
LCM	1	5	4	10.0
MON	0	1	1	2.0
N2VC	0	3	9	12.0
NG-UI	0	1	2	3.0
OSMClient	0	0	2	2.0
RO	0	3	7	10.0
Robot-tests	0	0	1	1.0
common	0	0	1	1.0
All	5	17	49	71.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	1123	2022-08-29 00:00:16	798	19.0	324.894737	239.007181	12.0	138.50	357.0	...	gerardo.garciadeblas@telefonica.com	2022-03-31 23:59:59.000000	CURRENT	3.0	comment	RECENT	2022-08-31 23:59:59.000000	False	722	798
1	NaN	1188	2022-08-29 00:00:18	763	19.0	324.894737	239.007181	12.0	138.50	357.0	...	gerardo.garciadeblas@telefonica.com	2022-03-31 23:59:59.000000	CURRENT	4.0	comment	RECENT	2022-08-31 23:59:59.000000	False	687	763
2	NaN	1577	2022-09-05 00:00:21	451	7.0	108.142857	155.287291	1.0	35.00	51.0	...	gcuba@whitestack.com	2022-09-13 03:00:07.449449	RECENT	2.0	keywords	RECENT	2022-09-13 03:00:07.449449	False	0	451
3	NaN	1622	2022-08-29 00:00:30	406	4.0	294.500000	77.177285	228.0	260.25	272.0	...	gerardo.garciadeblas@telefonica.com	2022-03-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2022-08-31 23:59:59.000000	False	330	406
4	NaN	1808	2022-08-23 17:55:40	287	4.0	99.750000	126.873625	12.0	27.75	50.0	...	jmguzman@whitestack.com	2021-11-30 23:59:59.000000	CURRENT	1.0	version	RECENT	2022-08-31 23:59:59.000000	False	211	287

5 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	1234	2022-09-08 19:58:07	717	10.0	228.800000	223.766148	51.0	75.25	100.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-09-13 03:00:07.449449	False	672	717
1	NaN	1266	2022-08-29 00:00:21	693	19.0	324.894737	239.007181	12.0	138.50	357.0	...	jmguzman@whitestack.com	2021-12-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2022-08-31 23:59:59.000000	False	617	693
2	NaN	1454	2022-08-29 00:00:25	564	19.0	324.894737	239.007181	12.0	138.50	357.0	...	agarcia@whitestack.com	2021-07-31 23:59:59.000000	CURRENT	2.0	comment	RECENT	2022-08-31 23:59:59.000000	False	487	564
3	NaN	1584	2022-08-16 17:57:11	447	10.0	228.800000	223.766148	51.0	75.25	100.5	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-08-31 23:59:59.000000	False	420	447
4	NaN	1630	2022-08-16 17:56:28	399	10.0	228.800000	223.766148	51.0	75.25	100.5	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-08-31 23:59:59.000000	False	372	399
5	NaN	1752	2022-08-29 00:00:52	306	3.0	181.000000	110.367568	97.0	118.50	140.0	...	gerardo.garciadeblas@telefonica.com	2022-05-31 23:59:59.000000	CURRENT	3.0	comment	RECENT	2022-08-31 23:59:59.000000	False	230	306
6	NaN	1768	2022-09-02 09:04:40	301	8.0	146.250000	123.555366	7.0	46.75	152.5	...	gulsum.atici@canonical.com	2022-09-13 03:00:07.449449	RECENT	2.0	resolution	RECENT	2022-09-13 03:00:07.449449	False	290	301
7	NaN	1900	2022-08-04 00:00:27	192	2.0	96.500000	135.057395	1.0	48.75	96.5	...	lluis.gifre@cttc.es	2022-03-31 23:59:59.000000	CURRENT	1.0	keywords	CURRENT	2022-08-31 23:59:59.000000	False	13	192
8	NaN	1921	2022-09-02 09:02:13	175	3.0	114.666667	52.271726	83.0	84.50	86.0	...	gcuba@whitestack.com	2022-09-13 03:00:07.449449	RECENT	1.0	target_milestone	RECENT	2022-09-13 03:00:07.449449	False	164	175
9	NaN	1979	2022-09-08 06:45:51	160	2.0	90.000000	98.994949	20.0	55.00	90.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-09-13 03:00:07.449449	False	155	160
10	NaN	1988	2022-08-04 00:00:33	156	4.0	94.000000	44.022721	54.0	69.75	83.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-08-31 23:59:59.000000	False	0	156
11	NaN	2042	2022-07-19 16:59:28	114	7.0	108.142857	155.287291	1.0	35.00	51.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	5	114
12	NaN	2049	2022-07-19 17:39:23	109	3.0	64.333333	56.367840	1.0	42.00	83.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	109
13	NaN	2093	2022-09-05 00:00:53	73	7.0	34.142857	31.540601	4.0	7.00	19.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-09-13 03:00:07.449449	False	0	73
14	NaN	2109	2022-09-08 00:00:47	66	7.0	34.142857	31.540601	4.0	7.00	19.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-09-13 03:00:07.449449	False	0	66
15	NaN	2125	2022-08-10 21:28:38	51	2.0	46.500000	6.363961	42.0	44.25	46.5	...	mark.beierl@canonical.com	2022-08-31 23:59:59.000000	CURRENT	1.0	comment	CURRENT	2022-08-31 23:59:59.000000	False	0	51
16	NaN	2140	2022-08-24 19:50:31	26	3.0	10.666667	13.428825	1.0	3.00	5.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-31 23:59:59.000000	False	0	26

17 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-09-03 03:21:18	654	1.0	654.000000	NaN	654.0	654.00	654.0	...	mark.beierl@canonical.com	2021-10-31 23:59:59.000000	CURRENT	1.0	resolution	RECENT	2022-09-13 03:00:07.449449	False	644	654
1	NaN	1603	2022-09-05 00:00:24	416	1.0	416.000000	NaN	416.0	416.00	416.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59.000000	CURRENT	2.0	keywords	RECENT	2022-09-13 03:00:07.449449	False	319	416
2	NaN	1660	2022-08-29 00:00:33	363	19.0	324.894737	239.007181	12.0	138.50	357.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-31 23:59:59.000000	False	287	363
3	NaN	1661	2022-08-29 00:00:36	363	19.0	324.894737	239.007181	12.0	138.50	357.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-31 23:59:59.000000	False	287	363
4	NaN	1667	2022-08-29 00:00:38	361	19.0	324.894737	239.007181	12.0	138.50	357.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-31 23:59:59.000000	False	285	361
5	NaN	1668	2022-08-29 00:00:41	361	19.0	324.894737	239.007181	12.0	138.50	357.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-31 23:59:59.000000	False	285	361
6	NaN	1671	2022-08-29 00:00:44	357	19.0	324.894737	239.007181	12.0	138.50	357.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-31 23:59:59.000000	False	280	357
7	NaN	1672	2022-08-29 00:00:47	357	19.0	324.894737	239.007181	12.0	138.50	357.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-31 23:59:59.000000	False	280	357
8	NaN	1673	2022-08-29 00:00:49	357	19.0	324.894737	239.007181	12.0	138.50	357.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-31 23:59:59.000000	False	280	357
9	NaN	1822	2022-09-05 00:00:36	276	1.0	276.000000	NaN	276.0	276.00	276.0	...	mark.beierl@canonical.com	2022-02-28 23:59:59.000000	CURRENT	1.0	keywords	RECENT	2022-09-13 03:00:07.449449	False	0	276
10	NaN	1825	2022-08-29 00:00:57	273	4.0	294.500000	77.177285	228.0	260.25	272.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-31 23:59:59.000000	False	197	273
11	NaN	1829	2022-08-29 00:00:59	271	4.0	294.500000	77.177285	228.0	260.25	272.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-31 23:59:59.000000	False	195	271
12	NaN	1853	2022-09-05 00:00:41	245	8.0	146.250000	123.555366	7.0	46.75	152.5	...	gulsum.atici@canonical.com	2022-03-31 23:59:59.000000	CURRENT	2.0	keywords	RECENT	2022-09-13 03:00:07.449449	False	147	245
13	NaN	1855	2022-09-05 00:00:43	245	8.0	146.250000	123.555366	7.0	46.75	152.5	...	gulsum.atici@canonical.com	2022-03-31 23:59:59.000000	CURRENT	2.0	keywords	RECENT	2022-09-13 03:00:07.449449	False	147	245
14	NaN	1856	2022-09-05 00:00:46	245	8.0	146.250000	123.555366	7.0	46.75	152.5	...	gulsum.atici@canonical.com	2022-03-31 23:59:59.000000	CURRENT	2.0	keywords	RECENT	2022-09-13 03:00:07.449449	False	147	245
15	NaN	1857	2022-08-21 00:00:25	245	10.0	228.800000	223.766148	51.0	75.25	100.5	...	emin.aktas@ulakhaberlesme.com.tr	2022-01-31 23:59:59.000000	CURRENT	1.0	comment	CURRENT	2022-08-31 23:59:59.000000	False	0	245
16	NaN	1869	2022-08-29 00:01:07	228	4.0	294.500000	77.177285	228.0	260.25	272.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-31 23:59:59.000000	False	152	228
17	NaN	1931	2022-08-15 00:00:26	171	1.0	171.000000	NaN	171.0	171.00	171.0	...	emin.aktas@ulakhaberlesme.com.tr	2022-03-31 23:59:59.000000	CURRENT	1.0	comment	CURRENT	2022-08-31 23:59:59.000000	False	0	171
18	NaN	1935	2022-08-10 16:16:41	170	1.0	170.000000	NaN	170.0	170.00	170.0	...	NaN	NaT	NaN	NaN	everconfirmed	CURRENT	2022-08-31 23:59:59.000000	False	137	170
19	NaN	1946	2022-08-29 00:01:13	166	19.0	324.894737	239.007181	12.0	138.50	357.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-31 23:59:59.000000	False	90	166
20	NaN	1954	2022-08-24 00:00:29	165	19.0	324.894737	239.007181	12.0	138.50	357.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-31 23:59:59.000000	False	145	165
21	NaN	1970	2022-08-24 00:00:31	162	19.0	324.894737	239.007181	12.0	138.50	357.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-31 23:59:59.000000	False	141	162
22	NaN	2009	2022-08-21 00:00:35	140	3.0	181.000000	110.367568	97.0	118.50	140.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-08-31 23:59:59.000000	False	0	140
23	NaN	2015	2022-08-10 11:02:45	139	1.0	139.000000	NaN	139.0	139.00	139.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-08-31 23:59:59.000000	False	0	139
24	NaN	2019	2022-08-04 00:00:37	137	2.0	137.000000	0.000000	137.0	137.00	137.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-08-31 23:59:59.000000	False	0	137
25	NaN	2020	2022-08-04 00:00:40	137	2.0	137.000000	0.000000	137.0	137.00	137.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-08-31 23:59:59.000000	False	0	137
26	NaN	2038	2022-08-23 16:15:43	115	19.0	324.894737	239.007181	12.0	138.50	357.0	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2022-08-31 23:59:59.000000	False	94	115
27	NaN	2063	2022-09-07 00:00:40	101	10.0	228.800000	223.766148	51.0	75.25	100.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-09-13 03:00:07.449449	False	33	101
28	NaN	2065	2022-08-19 00:21:35	100	10.0	228.800000	223.766148	51.0	75.25	100.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-08-31 23:59:59.000000	False	32	100
29	NaN	2066	2022-09-09 00:00:39	100	10.0	228.800000	223.766148	51.0	75.25	100.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-09-13 03:00:07.449449	False	32	100
30	NaN	2068	2022-08-26 00:00:32	97	3.0	181.000000	110.367568	97.0	118.50	140.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-31 23:59:59.000000	False	0	97
31	NaN	2074	2022-08-10 16:35:39	94	1.0	94.000000	NaN	94.0	94.00	94.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-08-31 23:59:59.000000	False	0	94
32	NaN	2078	2022-09-06 00:00:37	91	4.0	94.000000	44.022721	54.0	69.75	83.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-09-13 03:00:07.449449	False	0	91
33	NaN	2083	2022-08-09 19:51:32	86	3.0	114.666667	52.271726	83.0	84.50	86.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-08-31 23:59:59.000000	False	1	86
34	NaN	2087	2022-09-09 12:48:19	83	3.0	64.333333	56.367840	1.0	42.00	83.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-09-13 03:00:07.449449	False	0	83
35	NaN	2088	2022-08-30 16:54:23	83	3.0	114.666667	52.271726	83.0	84.50	86.0	...	gcuba@whitestack.com	2022-08-31 23:59:59.000000	RECENT	1.0	everconfirmed	RECENT	2022-08-31 23:59:59.000000	False	69	83
36	NaN	2089	2022-08-23 17:06:52	76	19.0	324.894737	239.007181	12.0	138.50	357.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-31 23:59:59.000000	False	0	76
37	NaN	2091	2022-09-07 12:14:51	75	4.0	94.000000	44.022721	54.0	69.75	83.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-09-13 03:00:07.449449	False	0	75
38	NaN	2094	2022-09-05 00:00:56	70	19.0	324.894737	239.007181	12.0	138.50	357.0	...	gerardo.garciadeblas@telefonica.com	2022-09-13 03:00:07.449449	RECENT	1.0	keywords	RECENT	2022-09-13 03:00:07.449449	False	0	70
39	NaN	2095	2022-09-07 15:30:32	70	19.0	324.894737	239.007181	12.0	138.50	357.0	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2022-09-13 03:00:07.449449	False	64	70
40	NaN	2096	2022-09-07 15:09:44	70	7.0	108.142857	155.287291	1.0	35.00	51.0	...	NaN	NaT	NaN	NaN	short_desc	RECENT	2022-09-13 03:00:07.449449	False	0	70
41	NaN	2103	2022-08-17 02:20:08	67	4.0	99.750000	126.873625	12.0	27.75	50.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-08-31 23:59:59.000000	False	0	67
42	NaN	2104	2022-07-22 01:21:50	67	10.0	228.800000	223.766148	51.0	75.25	100.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	67
43	NaN	2105	2022-07-21 15:30:09	67	4.0	60.000000	14.000000	39.0	60.00	67.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	67
44	NaN	2106	2022-09-07 00:00:44	67	4.0	60.000000	14.000000	39.0	60.00	67.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-09-13 03:00:07.449449	False	0	67
45	NaN	2107	2022-09-07 00:00:47	67	4.0	60.000000	14.000000	39.0	60.00	67.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-09-13 03:00:07.449449	False	0	67
46	NaN	2111	2022-09-11 00:00:42	63	1.0	63.000000	NaN	63.0	63.00	63.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-09-13 03:00:07.449449	False	0	63
47	NaN	2112	2022-09-12 00:00:46	63	7.0	34.142857	31.540601	4.0	7.00	19.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-09-13 03:00:07.449449	False	0	63
48	NaN	2117	2022-07-14 15:54:25	61	10.0	228.800000	223.766148	51.0	75.25	100.5	...	guillermo.calvino@canonical.com	2022-07-31 23:59:59.000000	CURRENT	2.0	assigned_to	CURRENT	2022-07-31 23:59:59.000000	False	0	61

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

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

	MONTH	2022-04	2022-05	2022-06	2022-07	2022-08	2022-09
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	-7	-1	-31	-4	-6	-1
	FALSE_CLOSED	0	0	0	-2	0	0
	OPENED	5	0	6	6	6	0
	REOPENED	0	0	0	2	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	-1	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	2	0	0	0	0	0
	REOPENED	0	0	0	0	0	0
IM-NBI	CLOSED	-5	-4	-22	-4	-7	-3
	FALSE_CLOSED	-1	0	-19	0	0	-1
	OPENED	9	6	21	6	3	1
	REOPENED	1	0	20	0	0	1
LCM	CLOSED	-4	-15	-10	-6	-5	-4
	FALSE_CLOSED	-1	0	0	0	0	-1
	OPENED	10	13	6	8	4	6
	REOPENED	1	0	0	1	0	2
MON	CLOSED	-4	0	-1	0	-2	-1
	FALSE_CLOSED	0	0	0	0	0	-1
	OPENED	3	0	1	2	1	1
	REOPENED	0	0	0	0	0	1
N2VC	CLOSED	-2	-32	-23	-1	-10	-1
	FALSE_CLOSED	0	0	0	-1	-3	0
	OPENED	25	6	12	10	7	0
	REOPENED	3	0	0	3	5	0
NG-UI	CLOSED	-7	-5	-12	0	0	-2
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	5	1	2	1	1	0
	REOPENED	0	0	0	0	0	0
OSMClient	CLOSED	0	0	-6	-1	-4	-2
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	5	1	3	0
	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	-1	0	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	0	0	0	0
	REOPENED	0	0	0	0	0	0
POL	CLOSED	0	0	0	-1	0	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	0	0	0	1	0	0
	REOPENED	0	0	0	0	0	0
RO	CLOSED	-1	-12	-11	-4	-1	-2
	FALSE_CLOSED	0	0	0	0	0	-1
	OPENED	3	7	2	5	1	6
	REOPENED	0	0	0	0	0	1
Robot-tests	CLOSED	0	0	-3	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
Unknown	CLOSED	0	0	-1	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	-1	-1	-2	0	-1	0
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	1	1	1	0	1	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	210	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	99	canonical.com
5	escaleira@av.it.pt	87	av.it.pt
6	glavado@whitestack.com	85	whitestack.com
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	ravi.chamarty@riftio.com	19	riftio.com
18	vijay.r@tataelxsi.co.in	19	tataelxsi.co.in
19	philip.joseph@riftio.com	19	riftio.com
20	kiran.kashalkar@riftio.com	19	riftio.com
21	felipe.vicens@atos.net	17	atos.net
22	bdiaz@whitestack.com	17	whitestack.com
23	sarathipriya.r@tataelxsi.co.in	16	tataelxsi.co.in
24	alimonj@indra.es	16	indra.es
25	Other	689	Other

Contributions per company:

	company	reported_bugs
0	canonical.com	458
1	telefonica.com	430
2	indra.es	172
3	tataelxsi.co.in	140
4	riftio.com	139
5	whitestack.com	129
6	av.it.pt	95
7	sandvine.com	73
8	etsi.org	62
9	gmail.com	60
10	vmware.com	52
11	altran.com	48
12	atos.net	30
13	techmahindra.com	18
14	ulakhaberlesme.com.tr	18
15	Other	228

4.2 Bugs assignments

Share of bugs with owner: 34.25%

Top assignees of bugs still open:

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

4.3 Top closers of bugs

	closer	n_bugs	company
0	gerardo.garciadeblas@telefonica.com	84	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	david.garcia@canonical.com	19	canonical.com
7	rajesh.velandy@riftio.com	19	riftio.com
8	fbravo@whitestack.com	19	whitestack.com
9	subhankar.pal@altran.com	17	altran.com
10	gulsum.atici@canonical.com	17	canonical.com
11	jeremy.mordkoff@riftio.com	16	riftio.com
12	vlittle@vmware.com	13	vmware.com
13	pedro.delacruzramos@altran.com	13	altran.com
14	anurag.dwivedi@riftio.com	12	riftio.com
15	agarcia@whitestack.com	11	whitestack.com
16	jmguzman@whitestack.com	11	whitestack.com
17	pkasar@vmware.com	11	vmware.com
18	mmarchetti@sandvine.com	10	sandvine.com
19	laurence.maultsby@riftio.com	10	riftio.com
20	glavado@whitestack.com	10	whitestack.com
21	ravi.chamarty@riftio.com	10	riftio.com
22	ananda.baitharu@riftio.com	9	riftio.com
23	hashir.mohammed@riftio.com	8	riftio.com
24	kiran.kashalkar@riftio.com	8	riftio.com
25	Other	182	Other

	company	n_bugs
0	canonical.com	188
1	riftio.com	152
2	telefonica.com	133
3	whitestack.com	57
4	altran.com	43
5	vmware.com	38
6	etsi.org	12
7	indra.es	11
8	atos.net	11
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
4817	2158	2022-09-07 20:36:00	bug_status	OPEN-UNCONFIRMED	v12.0	LCM	In Delete NS operation, If VDUs are deleted ex...	22406	2022-09-13 03:00:07.449449	RECENT	rahul.k4@tataelxsi.co.in	False
4818	1979	2022-09-08 06:17:16	bug_status	UNCONFIRMED	v12.0	MON	MON deadlock occurs when scaling to more than ...	20961	2022-09-13 03:00:07.449449	RECENT	priyadarshini@tataelxsi.co.in	False
4819	2152	2022-09-08 11:11:25	bug_status	RESOLVED	v12.0	OSMClient	Command wim-show shows password in clear.	22370	2022-09-13 03:00:07.449449	RECENT	lluis.gifre@cttc.es	True
4820	2153	2022-09-08 11:13:49	bug_status	RESOLVED	Master	OSMClient	Command wim-show shows password in clear.	22376	2022-09-13 03:00:07.449449	RECENT	lluis.gifre@cttc.es	True
4821	2139	2022-09-08 18:05:57	bug_status	RESOLVED	Master	DEVOPS	OSM OCI images have 172.21.1.1 as apt proxy in...	22317	2022-09-13 03:00:07.449449	RECENT	mark.beierl@canonical.com	True
4822	2159	2022-09-08 23:32:09	bug_status	OPEN-UNCONFIRMED	v12.0	RO	Provider networks not instantiated as expected	22408	2022-09-13 03:00:07.449449	RECENT	starazona@whitestack.com	False
4823	2160	2022-09-12 00:57:18	bug_status	OPEN-UNCONFIRMED	Master	LCM	The instantiation of a KNF whose NS parameter ...	22410	2022-09-13 03:00:07.449449	RECENT	escaleira@av.it.pt	False
4824	2161	2022-09-12 00:57:42	bug_status	OPEN-UNCONFIRMED	v12.0	LCM	The instantiation of a KNF whose NS parameter ...	22412	2022-09-13 03:00:07.449449	RECENT	escaleira@av.it.pt	False
4825	2162	2022-09-12 00:58:20	bug_status	OPEN-UNCONFIRMED	v11.0	LCM	The instantiation of a KNF whose NS parameter ...	22413	2022-09-13 03:00:07.449449	RECENT	escaleira@av.it.pt	False
4826	2163	2022-09-12 00:58:50	bug_status	OPEN-UNCONFIRMED	v10.0	LCM	The instantiation of a KNF whose NS parameter ...	22414	2022-09-13 03:00:07.449449	RECENT	escaleira@av.it.pt	False

5.2 Last bug assignments

	BUG_ID	TIMESTAMP	OPERATION	VALUE	RELEASE	MODULE	BUG_DESCRIPTION	ROW_NUMBER	MONTH	AGE
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 ...	22260	2022-08-31 23:59:59.000000	CURRENT
21794	2125	2022-08-02 16:52:53	assigned_to	mark.beierl@canonical.com	v12.0	DEVOPS	k8s monitor cannot install.	22223	2022-08-31 23:59:59.000000	CURRENT
21797	2114	2022-08-02 16:54:20	assigned_to	mark.beierl@canonical.com	v12.0	DEVOPS	Proper way to Restart OSM after Reboot?	22163	2022-08-31 23:59:59.000000	CURRENT
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...	22274	2022-08-31 23:59:59.000000	CURRENT
22193	2088	2022-08-30 16:54:23	assigned_to	gcuba@whitestack.com	master	LCM	Remote Code Execution in N2VC/LCM	21956	2022-08-31 23:59:59.000000	RECENT
22217	2149	2022-08-31 19:45:05	assigned_to	patricia.reinoso@canonical.com	Master	N2VC	ClusterRoleBinding is not deleted when k8s-clu...	22354	2022-08-31 23:59:59.000000	RECENT
22245	1921	2022-09-02 09:02:13	assigned_to	gcuba@whitestack.com	master	LCM	Helm EE has security risks	20357	2022-09-13 03:00:07.449449	RECENT
22251	1768	2022-09-02 09:04:40	assigned_to	gulsum.atici@canonical.com	Master	RO	GCP connector doesn't provide internet access ...	18697	2022-09-13 03:00:07.449449	RECENT
22272	2094	2022-09-04 13:29:21	assigned_to	gerardo.garciadeblas@telefonica.com	Master	IM-NBI	An user is not able to use a VDU/KDU scaling c...	22003	2022-09-13 03:00:07.449449	RECENT
22279	1577	2022-09-04 13:36:10	assigned_to	gcuba@whitestack.com	Master	LCM	NF/NS packages are not removed from LCM when t...	16841	2022-09-13 03:00:07.449449	RECENT

5.3 Last resolved bugs

	BUG_ID	TIMESTAMP	OPERATION	VALUE	RELEASE	MODULE	BUG_DESCRIPTION	ROW_NUMBER	MONTH	AGE	ISSUER	SOLVED
4797	2149	2022-09-01 17:04:13	bug_status	RESOLVED	Master	N2VC	ClusterRoleBinding is not deleted when k8s-clu...	22355	2022-09-13 03:00:07.449449	RECENT	patricia.reinoso@canonical.com	True
4802	1579	2022-09-02 19:21:18	bug_status	RESOLVED	Master	LCM	Error read ns record from database when execut...	16870	2022-09-13 03:00:07.449449	RECENT	cuongbo97@gmail.com	True
4810	2092	2022-09-05 23:35:18	bug_status	RESOLVED	Master	RO	Error deleting VMs in GCP and Azure VIMs	21986	2022-09-13 03:00:07.449449	RECENT	e.dah.tid@telefonica.com	True
4812	2098	2022-09-06 02:19:28	bug_status	RESOLVED	v12.0	LCM	VNF level manual healing through osmclient fails	22045	2022-09-13 03:00:07.449449	RECENT	priyadarshini@tataelxsi.co.in	True
4813	2110	2022-09-06 02:23:48	bug_status	RESOLVED	Master	LCM	Add scaling moment value to scaling info dicti...	22133	2022-09-13 03:00:07.449449	RECENT	escaleira@av.it.pt	True
4814	1952	2022-09-07 12:15:54	bug_status	RESOLVED	v11.0	NG-UI	Uptime of running service instanced not displa...	20641	2022-09-13 03:00:07.449449	RECENT	paranda@it.uc3m.es	True
4815	1936	2022-09-07 12:16:33	bug_status	RESOLVED	v11.0	NG-UI	Strange NSI topology shown in UI	20495	2022-09-13 03:00:07.449449	RECENT	paranda@it.uc3m.es	True
4819	2152	2022-09-08 11:11:25	bug_status	RESOLVED	v12.0	OSMClient	Command wim-show shows password in clear.	22370	2022-09-13 03:00:07.449449	RECENT	lluis.gifre@cttc.es	True
4820	2153	2022-09-08 11:13:49	bug_status	RESOLVED	Master	OSMClient	Command wim-show shows password in clear.	22376	2022-09-13 03:00:07.449449	RECENT	lluis.gifre@cttc.es	True
4821	2139	2022-09-08 18:05:57	bug_status	RESOLVED	Master	DEVOPS	OSM OCI images have 172.21.1.1 as apt proxy in...	22317	2022-09-13 03:00:07.449449	RECENT	mark.beierl@canonical.com	True

DONE

---