Analysis of OSM events in Bugzilla

Date and time of the report: 2022-08-10 05:00:08.215485

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

Bugs considered recent: Since 2022-07-20.

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:

108

Bugs present in multiple branches:

	BUG_DESCRIPTION	NUM_BRANCHES	RELEASE	MODULE	TIMESTAMP
0	"osm repo-index" command deletes package direc...	2	[v10.0, v11.0]	OSMClient	2022-06-10 13:13:35
1	Additional params not accepted for Hybrid Netw...	3	[Master, v11.0, v10.0]	IM-NBI	2022-05-20 16:20:13
2	An user is not able to use a VDU/KDU scaling c...	3	[Master, Master, Master]	LCM	2022-07-04 16:35:49
3	GCP connector doesn't provide internet access ...	2	[Master, v11.0]	RO	2021-12-13 11:54:22
4	N2VC fails to scale a KNF based on Helm Charts...	2	[Master, v12.0]	N2VC	2022-07-07 17:16:22
5	The Dockerfile.local Ubuntu version causes the...	3	[Master, v11.0, v10.0]	IM-NBI	2022-04-03 19:24:33
6	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
7	The edge case of first scaling down an Helm Ch...	2	[Master, v12.0]	N2VC	2022-07-07 17:16:01
8	The validation of the instantiation parameters...	3	[Master, v11.0, v10.0]	IM-NBI	2022-03-31 12:43:17
9	When we have more than one scalable resources ...	2	[Master, v12.0]	N2VC	2022-07-07 21:45:41
10	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	2	2	4
Gerrit	1	0	1
IM-NBI	36	0	36
LCM	12	3	15
MON	3	1	4
N2VC	13	5	18
NG-UI	3	3	6
OSMClient	4	0	4
RO	14	0	14
Robot-tests	1	1	2
common	3	0	3
Total	93	15	108

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	60	11	71
CONFIRMED	29	4	33
IN_PROGRESS	4	0	4
Total	93	15	108

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	49.000000	NaN	49.0	49.00	49.0	49.00	49.0
1	DEVOPS	4.0	42.500000	49.749372	8.0	14.75	23.0	50.75	116.0
2	Gerrit	1.0	105.000000	NaN	105.0	105.00	105.0	105.00	105.0
3	IM-NBI	36.0	260.638889	196.910879	33.0	128.00	237.0	327.50	764.0
4	LCM	15.0	84.666667	100.919110	11.0	32.00	52.0	80.00	414.0
5	MON	4.0	57.750000	48.002604	20.0	26.75	42.5	73.50	126.0
6	N2VC	18.0	111.111111	167.581021	5.0	33.00	61.0	66.75	683.0
7	NG-UI	6.0	84.500000	51.048017	20.0	45.00	89.5	128.75	136.0
8	OSMClient	4.0	70.750000	46.197944	27.0	51.75	60.0	79.00	136.0
9	RO	14.0	139.071429	117.292838	26.0	33.75	103.0	211.00	382.0
10	Robot-tests	2.0	71.500000	92.630988	6.0	38.75	71.5	104.25	137.0
11	common	3.0	231.666667	190.710077	36.0	139.00	242.0	329.50	417.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	1	2.0
Gerrit	0	0	1	1.0
IM-NBI	0	9	24	33.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	1	0	1.0
RO	1	2	6	9.0
Robot-tests	0	1	0	1.0
common	0	1	1	2.0
All	3	26	42	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	1234	2022-07-29 16:06:09	683	11.0	159.545455	202.124399	17.0	47.0	66.0	...	NaN	NaT	NaN	NaN	priority	RECENT	2022-07-31 23:59:59.000000	False	672	683
1	NaN	1579	2022-07-19 17:30:57	414	6.0	97.833333	156.789562	11.0	20.0	32.5	...	glavado@whitestack.com	2022-02-28 23:59:59	CURRENT	1.0	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	414
2	NaN	1768	2022-08-04 00:00:22	267	4.0	89.750000	118.350820	26.0	26.0	33.0	...	sgallardor@indra.es	2021-11-30 23:59:59	CURRENT	1.0	comment	RECENT	2022-08-10 03:00:08.265331	False	28	267

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	764	18.0	330.277778	224.572484	36.0	131.25	325.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	764
1	NaN	1188	2022-06-28 17:33:00	729	18.0	330.277778	224.572484	36.0	131.25	325.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	729
2	NaN	1266	2022-06-28 17:32:53	659	18.0	330.277778	224.572484	36.0	131.25	325.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	659
3	NaN	1454	2022-06-28 17:32:46	530	18.0	330.277778	224.572484	36.0	131.25	325.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	530
4	NaN	1557	2022-08-03 00:00:18	432	18.0	330.277778	224.572484	36.0	131.25	325.0	...	gerardo.garciadeblas@telefonica.com	2022-05-31 23:59:59.000000	CURRENT	4.0	comment	RECENT	2022-08-10 03:00:08.265331	False	0	432
5	NaN	1577	2022-08-09 00:00:19	417	3.0	231.666667	190.710077	36.0	139.00	242.0	...	mark.beierl@canonical.com	2022-02-28 23:59:59.000000	CURRENT	1.0	comment	RECENT	2022-08-10 03:00:08.265331	False	0	417
6	NaN	1622	2022-06-28 17:32:40	372	7.0	197.428571	97.099360	81.0	129.50	194.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	372
7	NaN	1632	2022-07-21 18:03:47	365	11.0	159.545455	202.124399	17.0	47.00	66.0	...	NaN	NaT	NaN	NaN	version	RECENT	2022-07-31 23:59:59.000000	False	346	365
8	NaN	1752	2022-06-28 17:31:13	272	9.0	155.888889	77.608705	63.0	106.00	131.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	272
9	NaN	1769	2022-08-04 00:00:24	267	6.0	184.333333	66.629323	103.0	130.00	211.0	...	sgallardor@indra.es	2021-11-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2022-08-10 03:00:08.265331	False	28	267
10	NaN	1808	2022-06-28 17:31:04	253	9.0	155.888889	77.608705	63.0	106.00	131.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	253
11	NaN	1825	2022-06-28 17:30:57	239	7.0	197.428571	97.099360	81.0	129.50	194.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	197	239
12	NaN	1857	2022-06-20 23:59:47	211	11.0	159.545455	202.124399	17.0	47.00	66.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	211
13	NaN	1900	2022-08-04 00:00:27	158	2.0	119.000000	55.154329	80.0	99.50	119.0	...	lluis.gifre@cttc.es	2022-03-31 23:59:59.000000	CURRENT	1.0	keywords	RECENT	2022-08-10 03:00:08.265331	False	13	158
14	NaN	1921	2022-08-04 00:00:29	141	2.0	96.500000	62.932504	52.0	74.25	96.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-10 03:00:08.265331	False	0	141
15	NaN	1931	2022-06-14 10:49:12	137	2.0	71.500000	92.630988	6.0	38.75	71.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	137
16	NaN	1935	2022-06-22 10:19:14	136	2.0	98.000000	53.740115	60.0	79.00	98.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	136
17	NaN	1936	2022-08-02 17:02:54	136	2.0	133.500000	3.535534	131.0	132.25	133.5	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2022-08-10 03:00:08.265331	False	129	136
18	NaN	1979	2022-08-03 00:00:26	126	3.0	67.333333	53.901144	20.0	38.00	56.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-10 03:00:08.265331	False	0	126
19	NaN	1988	2022-08-04 00:00:33	122	4.0	60.000000	44.022721	20.0	35.75	49.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-10 03:00:08.265331	False	0	122
20	NaN	2042	2022-07-19 16:59:28	80	6.0	97.833333	156.789562	11.0	20.00	32.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	5	80
21	NaN	2043	2022-08-06 00:07:12	80	3.0	68.000000	16.643317	49.0	62.00	75.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-10 03:00:08.265331	False	9	80
22	NaN	2069	2022-07-05 17:39:25	61	2.0	40.000000	29.698485	19.0	29.50	40.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	61
23	NaN	2093	2022-07-01 10:48:59	39	3.0	33.333333	5.131601	29.0	30.50	32.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	39
24	NaN	2098	2022-07-13 13:32:21	35	2.0	24.000000	15.556349	13.0	18.50	24.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	35
25	NaN	2114	2022-08-02 16:54:20	29	3.0	18.000000	10.535654	8.0	12.50	17.0	...	mark.beierl@canonical.com	2022-08-10 03:00:08.265331	RECENT	1.0	component	RECENT	2022-08-10 03:00:08.265331	False	0	29

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	620	1.0	620.000000	NaN	620.0	620.00	620.0	...	mark.beierl@canonical.com	2021-10-31 23:59:59	CURRENT	1.0	comment	RECENT	2022-08-10 03:00:08.265331	False	0	620
1	NaN	1603	2022-08-09 00:00:22	382	1.0	382.000000	NaN	382.0	382.00	382.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-10 03:00:08.265331	False	319	382
2	NaN	1660	2022-06-28 17:32:35	329	18.0	330.277778	224.572484	36.0	131.25	325.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	287	329
3	NaN	1661	2022-06-28 17:32:29	329	18.0	330.277778	224.572484	36.0	131.25	325.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	287	329
4	NaN	1667	2022-06-28 17:32:11	327	18.0	330.277778	224.572484	36.0	131.25	325.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	285	327
5	NaN	1668	2022-06-28 17:31:57	327	18.0	330.277778	224.572484	36.0	131.25	325.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	285	327
6	NaN	1671	2022-06-28 17:31:50	323	18.0	330.277778	224.572484	36.0	131.25	325.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	280	323
7	NaN	1672	2022-06-28 17:31:45	323	18.0	330.277778	224.572484	36.0	131.25	325.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	280	323
8	NaN	1673	2022-06-28 17:31:36	323	18.0	330.277778	224.572484	36.0	131.25	325.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	280	323
9	NaN	1822	2022-08-09 00:00:27	242	3.0	231.666667	190.710077	36.0	139.00	242.0	...	mark.beierl@canonical.com	2022-02-28 23:59:59	CURRENT	1.0	comment	RECENT	2022-08-10 03:00:08.265331	False	0	242
10	NaN	1829	2022-06-28 17:30:41	237	7.0	197.428571	97.099360	81.0	129.50	194.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	195	237
11	NaN	1831	2022-06-28 17:30:32	237	9.0	155.888889	77.608705	63.0	106.00	131.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	195	237
12	NaN	1853	2022-08-07 00:00:19	211	6.0	184.333333	66.629323	103.0	130.00	211.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-10 03:00:08.265331	False	147	211
13	NaN	1855	2022-08-07 00:00:22	211	6.0	184.333333	66.629323	103.0	130.00	211.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-10 03:00:08.265331	False	147	211
14	NaN	1856	2022-08-07 00:00:24	211	6.0	184.333333	66.629323	103.0	130.00	211.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2022-08-10 03:00:08.265331	False	147	211
15	NaN	1869	2022-06-28 17:30:16	194	7.0	197.428571	97.099360	81.0	129.50	194.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	152	194
16	NaN	1890	2022-06-21 17:34:26	159	11.0	159.545455	202.124399	17.0	47.00	66.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	159
17	NaN	1942	2022-08-03 00:00:24	132	9.0	155.888889	77.608705	63.0	106.00	131.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-10 03:00:08.265331	False	0	132
18	NaN	1946	2022-06-28 17:30:07	132	18.0	330.277778	224.572484	36.0	131.25	325.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2022-06-30 23:59:59.000000	False	90	132
19	NaN	1952	2022-08-02 17:04:03	131	2.0	133.500000	3.535534	131.0	132.25	133.5	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2022-08-10 03:00:08.265331	False	124	131
20	NaN	1954	2022-06-16 16:57:06	131	18.0	330.277778	224.572484	36.0	131.25	325.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	131
21	NaN	1955	2022-06-15 00:01:42	131	9.0	155.888889	77.608705	63.0	106.00	131.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	131
22	NaN	1956	2022-06-15 00:01:44	131	7.0	197.428571	97.099360	81.0	129.50	194.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	131
23	NaN	1970	2022-06-20 18:38:35	128	18.0	330.277778	224.572484	36.0	131.25	325.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	128
24	NaN	1971	2022-06-15 00:01:48	128	9.0	155.888889	77.608705	63.0	106.00	131.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	128
25	NaN	1972	2022-06-15 00:01:50	128	7.0	197.428571	97.099360	81.0	129.50	194.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2022-06-30 23:59:59.000000	False	0	128
26	NaN	1994	2022-08-03 00:00:31	116	1.0	116.000000	NaN	116.0	116.00	116.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-10 03:00:08.265331	False	0	116
27	NaN	2009	2022-06-20 15:41:33	106	9.0	155.888889	77.608705	63.0	106.00	131.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	106
28	NaN	2015	2022-06-09 15:32:13	105	1.0	105.000000	NaN	105.0	105.00	105.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	105
29	NaN	2019	2022-08-04 00:00:37	103	6.0	184.333333	66.629323	103.0	130.00	211.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-10 03:00:08.265331	False	0	103
30	NaN	2020	2022-08-04 00:00:40	103	6.0	184.333333	66.629323	103.0	130.00	211.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-10 03:00:08.265331	False	0	103
31	NaN	2038	2022-06-30 14:48:41	81	18.0	330.277778	224.572484	36.0	131.25	325.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	81
32	NaN	2039	2022-06-30 14:48:59	81	9.0	155.888889	77.608705	63.0	106.00	131.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	81
33	NaN	2040	2022-06-30 14:49:29	81	7.0	197.428571	97.099360	81.0	129.50	194.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	81
34	NaN	2044	2022-08-06 00:06:58	80	2.0	119.000000	55.154329	80.0	99.50	119.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2022-08-10 03:00:08.265331	False	9	80
35	NaN	2049	2022-07-19 17:39:23	75	3.0	68.000000	16.643317	49.0	62.00	75.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	0	75
36	NaN	2063	2022-07-07 17:24:30	67	11.0	159.545455	202.124399	17.0	47.00	66.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	33	67
37	NaN	2065	2022-07-07 17:16:22	66	11.0	159.545455	202.124399	17.0	47.00	66.0	...	NaN	NaT	NaN	NaN	everconfirmed	CURRENT	2022-07-31 23:59:59.000000	False	32	66
38	NaN	2066	2022-07-08 00:03:19	66	11.0	159.545455	202.124399	17.0	47.00	66.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-07-31 23:59:59.000000	False	32	66
39	NaN	2068	2022-08-08 00:00:28	63	9.0	155.888889	77.608705	63.0	106.00	131.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2022-08-10 03:00:08.265331	False	0	63
40	NaN	2070	2022-06-09 12:06:32	61	1.0	61.000000	NaN	61.0	61.00	61.0	...	NaN	NaT	NaN	NaN	dependson	CURRENT	2022-06-30 23:59:59.000000	False	0	61
41	NaN	2071	2022-06-09 12:06:32	61	11.0	159.545455	202.124399	17.0	47.00	66.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2022-06-30 23:59:59.000000	False	0	61

42 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	4
Descriptor-packages	0	0	0	0	0	0
Documentation / Wiki	0	1	1	0	0	0
IM-NBI	30	34	36	35	36	36
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	4
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	3

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	-1
	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	0
	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	-1
	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	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	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	669	Other

Contributions per company:

	company	reported_bugs
0	canonical.com	451
1	telefonica.com	427
2	indra.es	171
3	riftio.com	139
4	tataelxsi.co.in	137
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.50%

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	35	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	186
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
4718	2127	2022-07-29 19:24:05	bug_status	RESOLVED	v12.0	DEVOPS	Unable to install OSM	21844	2022-07-31 23:59:59.000000	RECENT	navdeep.uniyal@bristol.ac.uk	True
4719	2131	2022-08-01 14:56:01	bug_status	OPEN-UNCONFIRMED	v12.0	DEVOPS	Cannot install OSM due to Failed to bootstrap ...	21868	2022-08-10 03:00:08.265331	RECENT	abigailxiang@outlook.com	False
4720	1936	2022-08-02 17:02:54	bug_status	CONFIRMED	v11.0	NG-UI	Strange NSI topology shown in UI	20344	2022-08-10 03:00:08.265331	RECENT	paranda@it.uc3m.es	False
4721	1952	2022-08-02 17:04:03	bug_status	CONFIRMED	v11.0	NG-UI	Uptime of running service instanced not displa...	20482	2022-08-10 03:00:08.265331	RECENT	paranda@it.uc3m.es	False
4722	2099	2022-08-02 18:41:12	bug_status	RESOLVED	v10.0	N2VC	Helm v2 init fails when stable repo URL is not...	21722	2022-08-10 03:00:08.265331	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-10 03:00:08.265331	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-10 03:00:08.265331	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...	21031	2022-08-10 03:00:08.265331	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	21874	2022-08-10 03:00:08.265331	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...	21877	2022-08-10 03:00:08.265331	RECENT	e.dah.tid@telefonica.com	False

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	21277	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	21268	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	21183	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	21808	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 ...	21866	2022-08-10 03:00:08.265331	RECENT
21794	2125	2022-08-02 16:52:53	assigned_to	mark.beierl@canonical.com	v12.0	DEVOPS	k8s monitor cannot install.	21839	2022-08-10 03:00:08.265331	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?	21793	2022-08-10 03:00:08.265331	RECENT

5.3 Last resolved bugs

	BUG_ID	TIMESTAMP	OPERATION	VALUE	RELEASE	MODULE	BUG_DESCRIPTION	ROW_NUMBER	MONTH	AGE	ISSUER	SOLVED
4707	2097	2022-07-26 17:43:55	bug_status	RESOLVED	v12.0	IM-NBI	Flavor not assigned properly while launching V...	21711	2022-07-31 23:59:59.000000	RECENT	deepika.e@tataelxsi.co.in	True
4708	2108	2022-07-26 17:44:24	bug_status	RESOLVED	v12.0	IM-NBI	Unable to edit policies in VNF descriptor for ...	21764	2022-07-31 23:59:59.000000	RECENT	deepika.e@tataelxsi.co.in	True
4709	2101	2022-07-26 17:44:47	bug_status	RESOLVED	v12.0	IM-NBI	Vertical Scaling Json schema issue	21735	2022-07-31 23:59:59.000000	RECENT	jayaprakash.g@tataelxsi.co.in	True
4716	2129	2022-07-29 18:51:45	bug_status	RESOLVED	Master	DEVOPS	Error in fetching container logs leaves VM run...	21855	2022-07-31 23:59:59.000000	RECENT	mark.beierl@canonical.com	True
4717	2128	2022-07-29 19:23:44	bug_status	RESOLVED	v12.0	DEVOPS	Charmed installer: Mongo-DB charm needs to spe...	21848	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	21844	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...	21722	2022-08-10 03:00:08.265331	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-10 03:00:08.265331	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-10 03:00:08.265331	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...	21031	2022-08-10 03:00:08.265331	RECENT	priyadarshini@tataelxsi.co.in	True

DONE

---