Analysis of OSM events in Bugzilla

Date and time of the report: 2024-03-31 05:00:05.152751

Analysed period: 2020-07-01 to 2024-03-31.

Bugs considered recent: Since 2024-03-10.

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:

91

Bugs present in multiple branches:

	BUG_DESCRIPTION	NUM_BRANCHES	RELEASE	MODULE	TIMESTAMP
0	NS deletion takes longer than expected for bas...	2	[Master, v15.0]	LCM	2024-03-14 15:35:49
1	Operational-status is not getting updated when...	2	[v14.0, v14.0]	LCM	2024-03-30 17:07:09
2	Robot testsuite heal_02 fails in a step when c...	2	[Master, v15.0]	Robot-tests	2023-12-20 15:09:20
3	Robot testsuite heal_03 fails when checking if...	2	[Master, v15.0]	Robot-tests	2023-12-20 17:06:32
4	Robot testsuite lcmop_01 fails in daily job wh...	2	[Master, v15.0]	Robot-tests	2023-12-20 14:23:08
5	Updating a VNF instance with an NS update oper...	3	[Master, v14.0, v12.0]	LCM	2023-12-12 11:11:02

Number of bugs per module

AGE	CURRENT	RECENT	Total
MODULE
DEVOPS	3	0	3
Documentation / Wiki	4	0	4
IM-NBI	12	7	19
LCM	7	7	14
N2VC	1	0	1
NG-SA	1	0	1
NG-UI	3	0	3
OSMClient	7	1	8
POL	1	1	2
RO	18	7	25
Robot-tests	11	0	11
Total	68	23	91

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	63	19	82
CONFIRMED	5	1	6
IN_PROGRESS	0	3	3
Total	68	23	91

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	141.000000	111.216006	26.0	87.50	149.0	198.50	248.0
1	Documentation / Wiki	4.0	288.000000	10.099505	282.0	282.00	283.5	289.50	303.0
2	IM-NBI	19.0	146.789474	123.572551	0.0	12.00	141.0	212.00	368.0
3	LCM	14.0	159.142857	174.581194	0.0	29.00	109.0	182.25	563.0
4	N2VC	1.0	248.000000	NaN	248.0	248.00	248.0	248.00	248.0
5	NG-SA	1.0	60.000000	NaN	60.0	60.00	60.0	60.00	60.0
6	NG-UI	3.0	23.333333	1.154701	22.0	23.00	24.0	24.00	24.0
7	OSMClient	8.0	246.375000	172.686287	0.0	196.00	278.0	292.50	547.0
8	POL	2.0	74.500000	99.702056	4.0	39.25	74.5	109.75	145.0
9	RO	25.0	197.080000	230.243697	1.0	20.00	142.0	260.00	981.0
10	Robot-tests	11.0	169.272727	94.867372	101.0	101.00	101.0	284.00	303.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	0	2	2.0
Documentation / Wiki	1	0	3	4.0
IM-NBI	0	3	10	13.0
LCM	0	4	6	10.0
N2VC	0	0	1	1.0
OSMClient	1	1	4	6.0
POL	0	1	0	1.0
RO	3	3	10	16.0
Robot-tests	0	1	10	11.0
All	5	13	46	64.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	1603	2024-03-11 17:25:03	981	15.0	223.400000	292.791686	8.0	19.5	23.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2024-03-31 03:00:05.181920	False	319	981
1	NaN	2176	2024-03-22 13:35:30	547	7.0	281.571429	152.409380	22.0	260.5	289.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	382	547
2	NaN	2252	2024-03-13 00:00:19	303	4.0	288.000000	10.099505	282.0	282.0	283.5	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-31 03:00:05.181920	False	0	303
3	NaN	2270	2024-03-11 17:26:24	260	9.0	151.444444	73.080625	1.0	137.0	145.0	...	rahul.k4@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-31 03:00:05.181920	False	0	260
4	NaN	2281	2024-03-11 17:26:36	239	9.0	151.444444	73.080625	1.0	137.0	145.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	239

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	2093	2024-03-11 17:25:08	638	15.0	223.400000	292.791686	8.0	19.50	23.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	248	638
1	NaN	2164	2024-03-11 17:25:10	563	3.0	290.000000	240.576391	109.0	153.50	198.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	138	563
2	NaN	2195	2024-03-11 17:25:24	498	15.0	223.400000	292.791686	8.0	19.50	23.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	498
3	NaN	2214	2024-03-11 17:25:40	430	4.0	252.000000	171.648866	101.0	107.00	238.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	430
4	NaN	2233	2024-03-11 17:25:49	352	15.0	223.400000	292.791686	8.0	19.50	23.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-31 03:00:05.181920	False	0	352
5	NaN	2241	2024-03-11 16:03:32	337	4.0	293.500000	69.294059	190.0	289.75	323.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	337
6	NaN	2251	2024-03-13 00:00:17	303	7.0	281.571429	152.409380	22.0	260.50	289.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-31 03:00:05.181920	False	0	303
7	NaN	2253	2024-03-13 00:00:21	303	7.0	208.285714	100.581168	101.0	101.00	284.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-31 03:00:05.181920	False	0	303
8	NaN	2284	2024-03-11 17:26:38	234	13.0	87.076923	80.656123	0.0	11.00	137.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	234
9	NaN	2299	2024-03-11 17:26:50	152	13.0	87.076923	80.656123	0.0	11.00	137.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	152
10	NaN	2305	2024-03-11 17:26:59	145	2.0	74.500000	99.702056	4.0	39.25	74.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	145
11	NaN	2319	2024-03-21 01:00:10	135	6.0	41.500000	62.924558	0.0	0.00	2.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-31 03:00:05.181920	False	125	135
12	NaN	2324	2024-03-11 17:27:26	109	6.0	41.500000	62.924558	0.0	0.00	2.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	109

13 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	2229	2024-03-11 17:25:45	368	1.0	368.000000	NaN	368.0	368.00	368.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	368
1	NaN	2230	2024-03-11 17:25:47	368	4.0	252.000000	171.648866	101.0	107.00	238.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-31 03:00:05.181920	False	0	368
2	NaN	2235	2024-03-11 17:25:51	347	15.0	223.400000	292.791686	8.0	19.50	23.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-31 03:00:05.181920	False	0	347
3	NaN	2243	2024-03-11 17:29:12	324	4.0	293.500000	69.294059	190.0	289.75	323.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-31 03:00:05.181920	False	305	324
4	NaN	2245	2024-02-21 12:49:36	323	4.0	293.500000	69.294059	190.0	289.75	323.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	323
5	NaN	2259	2024-03-12 17:32:24	289	7.0	281.571429	152.409380	22.0	260.50	289.0	...	gerardo.garciadeblas@telefonica.com	2024-03-31 03:00:05.181920	RECENT	1.0	assigned_to	RECENT	2024-03-31 03:00:05.181920	False	0	289
6	NaN	2260	2024-03-12 17:32:32	289	7.0	281.571429	152.409380	22.0	260.50	289.0	...	gerardo.garciadeblas@telefonica.com	2024-03-31 03:00:05.181920	RECENT	1.0	assigned_to	RECENT	2024-03-31 03:00:05.181920	False	0	289
7	NaN	2261	2024-03-11 17:26:07	285	4.0	288.000000	10.099505	282.0	282.00	283.5	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-31 03:00:05.181920	False	0	285
8	NaN	2263	2024-03-11 17:26:10	284	7.0	208.285714	100.581168	101.0	101.00	284.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-31 03:00:05.181920	False	0	284
9	NaN	2264	2024-03-11 17:26:12	284	7.0	208.285714	100.581168	101.0	101.00	284.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-31 03:00:05.181920	False	0	284
10	NaN	2265	2024-03-11 17:26:14	284	7.0	208.285714	100.581168	101.0	101.00	284.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-31 03:00:05.181920	False	0	284
11	NaN	2266	2024-03-11 17:26:17	282	4.0	288.000000	10.099505	282.0	282.00	283.5	...	rahul.k4@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-31 03:00:05.181920	False	0	282
12	NaN	2267	2024-03-11 17:26:19	282	4.0	288.000000	10.099505	282.0	282.00	283.5	...	deepika.e@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-31 03:00:05.181920	False	0	282
13	NaN	2269	2024-03-11 17:26:21	267	7.0	281.571429	152.409380	22.0	260.50	289.0	...	ramerama@tataelxsi.co.in	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-31 03:00:05.181920	False	0	267
14	NaN	2271	2024-03-11 17:26:26	260	15.0	223.400000	292.791686	8.0	19.50	23.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	260
15	NaN	2274	2024-03-11 17:26:28	254	7.0	281.571429	152.409380	22.0	260.50	289.0	...	deepika.e@tataelxsi.co.in	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-31 03:00:05.181920	False	0	254
16	NaN	2277	2024-03-11 17:26:31	248	1.0	248.000000	NaN	248.0	248.00	248.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	248
17	NaN	2278	2024-03-11 17:26:33	248	1.0	248.000000	NaN	248.0	248.00	248.0	...	guillermo.calvino@canonical.com	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-31 03:00:05.181920	False	0	248
18	NaN	2286	2024-03-11 17:26:41	213	1.0	213.000000	NaN	213.0	213.00	213.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	213
19	NaN	2287	2024-03-11 17:26:43	198	3.0	290.000000	240.576391	109.0	153.50	198.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	198
20	NaN	2288	2024-03-11 17:26:45	190	4.0	293.500000	69.294059	190.0	289.75	323.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	190
21	NaN	2298	2024-03-11 17:26:47	156	9.0	151.444444	73.080625	1.0	137.00	145.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	156
22	NaN	2301	2024-03-11 17:26:52	149	1.0	149.000000	NaN	149.0	149.00	149.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	149
23	NaN	2303	2024-03-11 17:26:54	148	9.0	151.444444	73.080625	1.0	137.00	145.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	148
24	NaN	2306	2024-03-11 17:27:01	145	9.0	151.444444	73.080625	1.0	137.00	145.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	145
25	NaN	2307	2024-02-20 16:25:14	143	13.0	87.076923	80.656123	0.0	11.00	137.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	143
26	NaN	2308	2024-02-20 16:24:22	143	13.0	87.076923	80.656123	0.0	11.00	137.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	143
27	NaN	2310	2024-03-11 17:27:04	142	9.0	151.444444	73.080625	1.0	137.00	145.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	142
28	NaN	2312	2024-03-19 00:00:37	141	13.0	87.076923	80.656123	0.0	11.00	137.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-31 03:00:05.181920	False	0	141
29	NaN	2313	2024-03-22 00:00:41	137	13.0	87.076923	80.656123	0.0	11.00	137.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-31 03:00:05.181920	False	0	137
30	NaN	2314	2024-02-20 16:27:21	137	13.0	87.076923	80.656123	0.0	11.00	137.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	137
31	NaN	2316	2024-03-11 17:27:12	137	9.0	151.444444	73.080625	1.0	137.00	145.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	137
32	NaN	2318	2024-03-11 17:27:14	135	9.0	151.444444	73.080625	1.0	137.00	145.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	135
33	NaN	2320	2024-03-11 17:27:19	129	15.0	223.400000	292.791686	8.0	19.50	23.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	129
34	NaN	2322	2024-03-11 17:27:21	115	1.0	115.000000	NaN	115.0	115.00	115.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	115
35	NaN	2323	2024-03-11 17:27:23	109	4.0	252.000000	171.648866	101.0	107.00	238.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	109
36	NaN	2325	2024-03-11 17:27:28	109	3.0	290.000000	240.576391	109.0	153.50	198.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	109
37	NaN	2326	2024-02-05 18:34:33	101	4.0	101.000000	0.000000	101.0	101.00	101.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59.000000	CURRENT	1.0	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	101
38	NaN	2328	2024-03-14 15:35:49	101	4.0	252.000000	171.648866	101.0	107.00	238.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-31 03:00:05.181920	False	85	101
39	NaN	2329	2024-03-21 00:35:22	101	1.0	101.000000	NaN	101.0	101.00	101.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-31 03:00:05.181920	False	91	101
40	NaN	2330	2024-03-11 17:27:36	101	7.0	208.285714	100.581168	101.0	101.00	284.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-31 03:00:05.181920	False	0	101
41	NaN	2331	2024-03-11 17:27:39	101	4.0	101.000000	0.000000	101.0	101.00	101.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-31 03:00:05.181920	False	0	101
42	NaN	2332	2024-02-02 14:50:02	101	7.0	208.285714	100.581168	101.0	101.00	284.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	101
43	NaN	2333	2024-03-11 17:27:42	101	4.0	101.000000	0.000000	101.0	101.00	101.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	101
44	NaN	2334	2024-03-11 17:27:44	101	7.0	208.285714	100.581168	101.0	101.00	284.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	101
45	NaN	2335	2024-03-11 17:27:46	101	4.0	101.000000	0.000000	101.0	101.00	101.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 03:00:05.181920	False	0	101

46 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs