Analysis of OSM events in Bugzilla

Date and time of the report: 2022-08-11 05:00:07.858377

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

Bugs considered recent: Since 2022-07-21.

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:

106

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	13	5	18
NG-UI	4	2	6
OSMClient	1	1	2
RO	14	0	14
Robot-tests	1	1	2
common	3	1	4
Total	90	16	106

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	57	11	68
CONFIRMED	29	5	34
IN_PROGRESS	4	0	4
Total	90	16	106

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	50.000000	NaN	50.0	50.00	50.0	50.00	50.0
1	DEVOPS	2.0	13.500000	6.363961	9.0	11.25	13.5	15.75	18.0
2	Gerrit	1.0	106.000000	NaN	106.0	106.00	106.0	106.00	106.0
3	IM-NBI	37.0	254.567568	198.864211	0.0	129.00	238.0	328.00	765.0
4	LCM	15.0	85.666667	100.919110	12.0	33.00	53.0	81.00	415.0
5	MON	4.0	58.750000	48.002604	21.0	27.75	43.5	74.50	127.0
6	N2VC	18.0	112.111111	167.581021	6.0	34.00	62.0	67.75	684.0
7	NG-UI	6.0	85.500000	51.048017	21.0	46.00	90.5	129.75	137.0
8	OSMClient	2.0	99.000000	53.740115	61.0	80.00	99.0	118.00	137.0
9	RO	14.0	140.071429	117.292838	27.0	34.75	104.0	212.00	383.0
10	Robot-tests	2.0	72.500000	92.630988	7.0	39.75	72.5	105.25	138.0
11	common	4.0	174.500000	194.371637	0.0	27.75	140.0	286.75	418.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	1	0	1.0
common	0	1	1	2.0
All	3	26	43	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	684	11.0	160.545455	202.124399	18.0	48.0	67.0	...	NaN	NaT	NaN	NaN	priority	RECENT	2022-07-31 23:59:59.000000	False	672	684
1	NaN	1579	2022-07-19 17:30:57	415	6.0	98.833333	156.789562	12.0	21.0	33.5	...	glavado@whitestack.com	2022-02-28 23:59:59	CURRENT	1.0	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	415
2	NaN	1768	2022-08-04 00:00:22	268	4.0	90.750000	118.350820	27.0	27.0	34.0	...	sgallardor@indra.es	2021-11-30 23:59:59	CURRENT	1.0	comment	RECENT	2022-08-11 03:00:07.909896	False	28	268

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	765	18.0	331.277778	224.572484	37.0	132.25	326.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	765
1	NaN	1188	2022-06-28 17:33:00	730	18.0	331.277778	224.572484	37.0	132.25	326.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	730
2	NaN	1266	2022-06-28 17:32:53	660	18.0	331.277778	224.572484	37.0	132.25	326.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	660
3	NaN	1454	2022-06-28 17:32:46	531	18.0	331.277778	224.572484	37.0	132.25	326.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	531
4	NaN	1557	2022-08-03 00:00:18	433	18.0	331.277778	224.572484	37.0	132.25	326.0	...	gerardo.garciadeblas@telefonica.com	2022-05-31 23:59:59.000000	CURRENT	4.0	comment	RECENT	2022-08-11 03:00:07.909896	False	0	433
5	NaN	1577	2022-08-09 00:00:19	418	3.0	232.666667	190.710077	37.0	140.00	243.0	...	mark.beierl@canonical.com	2022-02-28 23:59:59.000000	CURRENT	1.0	comment	RECENT	2022-08-11 03:00:07.909896	False	0	418
6	NaN	1622	2022-06-28 17:32:40	373	7.0	198.428571	97.099360	82.0	130.50	195.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	373
7	NaN	1632	2022-07-21 18:03:47	366	11.0	160.545455	202.124399	18.0	48.00	67.0	...	NaN	NaT	NaN	NaN	version	RECENT	2022-07-31 23:59:59.000000	False	346	366
8	NaN	1752	2022-06-28 17:31:13	273	9.0	156.888889	77.608705	64.0	107.00	132.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	273
9	NaN	1769	2022-08-04 00:00:24	268	6.0	185.333333	66.629323	104.0	131.00	212.0	...	sgallardor@indra.es	2021-11-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2022-08-11 03:00:07.909896	False	28	268
10	NaN	1808	2022-06-28 17:31:04	254	9.0	156.888889	77.608705	64.0	107.00	132.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	254
11	NaN	1825	2022-06-28 17:30:57	240	7.0	198.428571	97.099360	82.0	130.50	195.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	197	240
12	NaN	1857	2022-06-20 23:59:47	212	11.0	160.545455	202.124399	18.0	48.00	67.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	212
13	NaN	1900	2022-08-04 00:00:27	159	2.0	120.000000	55.154329	81.0	100.50	120.0	...	lluis.gifre@cttc.es	2022-03-31 23:59:59.000000	CURRENT	1.0	keywords	RECENT	2022-08-11 03:00:07.909896	False	13	159
14	NaN	1921	2022-08-04 00:00:29	142	2.0	97.500000	62.932504	53.0	75.25	97.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-11 03:00:07.909896	False	0	142
15	NaN	1931	2022-06-14 10:49:12	138	2.0	72.500000	92.630988	7.0	39.75	72.5	...	emin.aktas@ulakhaberlesme.com.tr	2022-03-31 23:59:59.000000	CURRENT	1.0	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	138
16	NaN	1936	2022-08-02 17:02:54	137	2.0	134.500000	3.535534	132.0	133.25	134.5	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2022-08-11 03:00:07.909896	False	129	137
17	NaN	1979	2022-08-03 00:00:26	127	3.0	68.333333	53.901144	21.0	39.00	57.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-11 03:00:07.909896	False	0	127
18	NaN	1988	2022-08-04 00:00:33	123	4.0	61.000000	44.022721	21.0	36.75	50.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-11 03:00:07.909896	False	0	123
19	NaN	2042	2022-07-19 16:59:28	81	6.0	98.833333	156.789562	12.0	21.00	33.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	5	81
20	NaN	2043	2022-08-06 00:07:12	81	3.0	69.000000	16.643317	50.0	63.00	76.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-11 03:00:07.909896	False	9	81
21	NaN	2069	2022-07-05 17:39:25	62	2.0	41.000000	29.698485	20.0	30.50	41.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	62
22	NaN	2093	2022-07-01 10:48:59	40	3.0	34.333333	5.131601	30.0	31.50	33.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	40
23	NaN	2098	2022-07-13 13:32:21	36	2.0	25.000000	15.556349	14.0	19.50	25.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	36
24	NaN	2103	2022-07-07 17:48:50	34	2.0	17.000000	24.041631	0.0	8.50	17.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	34
25	NaN	2125	2022-08-10 21:28:38	18	2.0	13.500000	6.363961	9.0	11.25	13.5	...	mark.beierl@canonical.com	2022-08-11 03:00:07.909896	RECENT	1.0	comment	RECENT	2022-08-11 03:00:07.909896	False	0	18

26 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	621	1.0	621.000000	NaN	621.0	621.00	621.0	...	mark.beierl@canonical.com	2021-10-31 23:59:59	CURRENT	1.0	comment	RECENT	2022-08-11 03:00:07.909896	False	0	621
1	NaN	1603	2022-08-09 00:00:22	383	1.0	383.000000	NaN	383.0	383.00	383.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-11 03:00:07.909896	False	319	383
2	NaN	1660	2022-06-28 17:32:35	330	18.0	331.277778	224.572484	37.0	132.25	326.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	287	330
3	NaN	1661	2022-06-28 17:32:29	330	18.0	331.277778	224.572484	37.0	132.25	326.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	287	330
4	NaN	1667	2022-06-28 17:32:11	328	18.0	331.277778	224.572484	37.0	132.25	326.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	285	328
5	NaN	1668	2022-06-28 17:31:57	328	18.0	331.277778	224.572484	37.0	132.25	326.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	285	328
6	NaN	1671	2022-06-28 17:31:50	324	18.0	331.277778	224.572484	37.0	132.25	326.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	280	324
7	NaN	1672	2022-06-28 17:31:45	324	18.0	331.277778	224.572484	37.0	132.25	326.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	280	324
8	NaN	1673	2022-06-28 17:31:36	324	18.0	331.277778	224.572484	37.0	132.25	326.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	280	324
9	NaN	1822	2022-08-09 00:00:27	243	3.0	232.666667	190.710077	37.0	140.00	243.0	...	mark.beierl@canonical.com	2022-02-28 23:59:59	CURRENT	1.0	comment	RECENT	2022-08-11 03:00:07.909896	False	0	243
10	NaN	1829	2022-06-28 17:30:41	238	7.0	198.428571	97.099360	82.0	130.50	195.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	195	238
11	NaN	1831	2022-06-28 17:30:32	238	9.0	156.888889	77.608705	64.0	107.00	132.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	195	238
12	NaN	1853	2022-08-07 00:00:19	212	6.0	185.333333	66.629323	104.0	131.00	212.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-11 03:00:07.909896	False	147	212
13	NaN	1855	2022-08-07 00:00:22	212	6.0	185.333333	66.629323	104.0	131.00	212.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-11 03:00:07.909896	False	147	212
14	NaN	1856	2022-08-07 00:00:24	212	6.0	185.333333	66.629323	104.0	131.00	212.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-11 03:00:07.909896	False	147	212
15	NaN	1869	2022-06-28 17:30:16	195	7.0	198.428571	97.099360	82.0	130.50	195.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	152	195
16	NaN	1890	2022-06-21 17:34:26	160	11.0	160.545455	202.124399	18.0	48.00	67.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	160
17	NaN	1935	2022-08-10 16:16:41	137	1.0	137.000000	NaN	137.0	137.00	137.0	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2022-08-11 03:00:07.909896	False	137	137
18	NaN	1942	2022-08-03 00:00:24	133	9.0	156.888889	77.608705	64.0	107.00	132.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-11 03:00:07.909896	False	0	133
19	NaN	1946	2022-06-28 17:30:07	133	18.0	331.277778	224.572484	37.0	132.25	326.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	90	133
20	NaN	1952	2022-08-02 17:04:03	132	2.0	134.500000	3.535534	132.0	133.25	134.5	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2022-08-11 03:00:07.909896	False	124	132
21	NaN	1954	2022-06-16 16:57:06	132	18.0	331.277778	224.572484	37.0	132.25	326.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	132
22	NaN	1955	2022-06-15 00:01:42	132	9.0	156.888889	77.608705	64.0	107.00	132.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	132
23	NaN	1956	2022-06-15 00:01:44	132	7.0	198.428571	97.099360	82.0	130.50	195.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	132
24	NaN	1970	2022-06-20 18:38:35	129	18.0	331.277778	224.572484	37.0	132.25	326.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	129
25	NaN	1971	2022-06-15 00:01:48	129	9.0	156.888889	77.608705	64.0	107.00	132.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	129
26	NaN	1972	2022-06-15 00:01:50	129	7.0	198.428571	97.099360	82.0	130.50	195.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	129
27	NaN	2009	2022-06-20 15:41:33	107	9.0	156.888889	77.608705	64.0	107.00	132.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	107
28	NaN	2015	2022-08-10 11:02:45	106	1.0	106.000000	NaN	106.0	106.00	106.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-11 03:00:07.909896	False	0	106
29	NaN	2019	2022-08-04 00:00:37	104	6.0	185.333333	66.629323	104.0	131.00	212.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-11 03:00:07.909896	False	0	104
30	NaN	2020	2022-08-04 00:00:40	104	6.0	185.333333	66.629323	104.0	131.00	212.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-11 03:00:07.909896	False	0	104
31	NaN	2038	2022-06-30 14:48:41	82	18.0	331.277778	224.572484	37.0	132.25	326.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	82
32	NaN	2039	2022-06-30 14:48:59	82	9.0	156.888889	77.608705	64.0	107.00	132.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	82
33	NaN	2040	2022-06-30 14:49:29	82	7.0	198.428571	97.099360	82.0	130.50	195.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	82
34	NaN	2044	2022-08-06 00:06:58	81	2.0	120.000000	55.154329	81.0	100.50	120.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-11 03:00:07.909896	False	9	81
35	NaN	2049	2022-07-19 17:39:23	76	3.0	69.000000	16.643317	50.0	63.00	76.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	76
36	NaN	2063	2022-07-07 17:24:30	68	11.0	160.545455	202.124399	18.0	48.00	67.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	33	68
37	NaN	2065	2022-07-07 17:16:22	67	11.0	160.545455	202.124399	18.0	48.00	67.0	...	NaN	NaT	NaN	NaN	everconfirmed	CURRENT	2022-07-31 23:59:59.000000	False	32	67
38	NaN	2066	2022-07-08 00:03:19	67	11.0	160.545455	202.124399	18.0	48.00	67.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	32	67
39	NaN	2068	2022-08-08 00:00:28	64	9.0	156.888889	77.608705	64.0	107.00	132.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-11 03:00:07.909896	False	0	64
40	NaN	2070	2022-08-10 07:41:54	62	1.0	62.000000	NaN	62.0	62.00	62.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-11 03:00:07.909896	False	0	62
41	NaN	2071	2022-08-10 07:41:17	62	11.0	160.545455	202.124399	18.0	48.00	67.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-11 03:00:07.909896	False	0	62
42	NaN	2074	2022-08-10 16:35:39	61	1.0	61.000000	NaN	61.0	61.00	61.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-11 03:00:07.909896	False	0	61

43 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	2
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	-3
	FALSE_CLOSED	0	0	0	0	-2	0
	OPENED	8	5	0	6	6	1
	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	0
	FALSE_CLOSED	0	-1	0	0	0	0
	OPENED	6	10	13	5	8	0
	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	-3
	FALSE_CLOSED	0	0	0	0	0	0
	OPENED	2	0	0	5	1	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	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	0
	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	96	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	671	Other

Contributions per company:

	company	reported_bugs
0	canonical.com	452
1	telefonica.com	427
2	indra.es	171
3	riftio.com	139
4	tataelxsi.co.in	138
5	whitestack.com	127
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	10
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
4725	2011	2022-08-03 20:03:07	bug_status	RESOLVED	v11.0	MON	MON build failure "missing 1 required position...	21037	2022-08-11 03:00:07.909896	RECENT	priyadarshini@tataelxsi.co.in	True
4726	2132	2022-08-03 20:04:43	bug_status	OPEN-UNCONFIRMED	Master	Robot-tests	New features for v12.0 included in prepare step	21904	2022-08-11 03:00:07.909896	RECENT	mark.beierl@canonical.com	False
4727	2133	2022-08-04 12:12:11	bug_status	OPEN-UNCONFIRMED	v12.0	N2VC	Error in execution of day-2 primitive based on...	21907	2022-08-11 03:00:07.909896	RECENT	e.dah.tid@telefonica.com	False
4728	2116	2022-08-10 02:38:53	bug_status	RESOLVED	Master	OSMClient	The ns-op-list command fails with exception wh...	21827	2022-08-11 03:00:07.909896	RECENT	escaleira@av.it.pt	True
4729	2134	2022-08-10 11:10:44	bug_status	OPEN-UNCONFIRMED	v12.0	IM-NBI	"_admin:usageState" is not updated properly in...	21908	2022-08-11 03:00:07.909896	RECENT	gulsum.atici@canonical.com	False
4730	2135	2022-08-10 13:01:14	bug_status	OPEN-UNCONFIRMED	v12.0	common	Not master error when MongoDb is in replica-se...	21909	2022-08-11 03:00:07.909896	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	20335	2022-08-11 03:00:07.909896	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...	20869	2022-08-11 03:00:07.909896	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...	21579	2022-08-11 03:00:07.909896	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?	21814	2022-08-11 03:00:07.909896	RECENT	tayloreisman2012@gmail.com	True

5.2 Last bug assignments

	BUG_ID	TIMESTAMP	OPERATION	VALUE	RELEASE	MODULE	BUG_DESCRIPTION	ROW_NUMBER	MONTH	AGE
19849	1752	2022-05-13 18:28:07	assigned_to	gerardo.garciadeblas@telefonica.com	v11.0	IM-NBI	NBI does not validate manifest hashes from SOL...	18524	2022-05-31 23:59:59.000000	CURRENT
19850	1611	2022-05-13 18:28:41	assigned_to	mark.beierl@canonical.com	Master	OSMClient	Error deleting VNFD by name	17198	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 ...	16592	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	21286	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	21277	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	21192	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	21835	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 ...	21894	2022-08-11 03:00:07.909896	RECENT
21794	2125	2022-08-02 16:52:53	assigned_to	mark.beierl@canonical.com	v12.0	DEVOPS	k8s monitor cannot install.	21866	2022-08-11 03:00:07.909896	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?	21813	2022-08-11 03:00:07.909896	RECENT

5.3 Last resolved bugs

	BUG_ID	TIMESTAMP	OPERATION	VALUE	RELEASE	MODULE	BUG_DESCRIPTION	ROW_NUMBER	MONTH	AGE	ISSUER	SOLVED
4717	2128	2022-07-29 19:23:44	bug_status	RESOLVED	v12.0	DEVOPS	Charmed installer: Mongo-DB charm needs to spe...	21876	2022-07-31 23:59:59.000000	RECENT	guillermo.calvino@canonical.com	True
4718	2127	2022-07-29 19:24:05	bug_status	RESOLVED	v12.0	DEVOPS	Unable to install OSM	21872	2022-07-31 23:59:59.000000	RECENT	navdeep.uniyal@bristol.ac.uk	True
4722	2099	2022-08-02 18:41:12	bug_status	RESOLVED	v10.0	N2VC	Helm v2 init fails when stable repo URL is not...	21742	2022-08-11 03:00:07.909896	RECENT	gcuba@whitestack.com	True
4723	1611	2022-08-03 16:52:54	bug_status	RESOLVED	Master	OSMClient	Error deleting VNFD by name	17199	2022-08-11 03:00:07.909896	RECENT	david.garcia@canonical.com	True
4724	1709	2022-08-03 20:02:10	bug_status	RESOLVED	unspecified	DEVOPS	Keystone container runs as root	18137	2022-08-11 03:00:07.909896	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...	21037	2022-08-11 03:00:07.909896	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...	21827	2022-08-11 03:00:07.909896	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...	20869	2022-08-11 03:00:07.909896	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...	21579	2022-08-11 03:00:07.909896	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?	21814	2022-08-11 03:00:07.909896	RECENT	tayloreisman2012@gmail.com	True

DONE

---