Analysis of OSM events in Bugzilla

Date and time of the report: 2024-04-01 05:00:05.329145

Analysed period: 2020-07-01 to 2024-04-01.

Bugs considered recent: Since 2024-03-11.

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	20	5	25
Robot-tests	11	0	11
Total	70	21	91

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	65	17	82
CONFIRMED	5	1	6
IN_PROGRESS	0	3	3
Total	70	21	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	142.000000	111.216006	27.0	88.50	150.0	199.50	249.0
1	Documentation / Wiki	4.0	289.000000	10.099505	283.0	283.00	284.5	290.50	304.0
2	IM-NBI	19.0	147.789474	123.572551	1.0	13.00	142.0	213.00	369.0
3	LCM	14.0	160.142857	174.581194	1.0	30.00	110.0	183.25	564.0
4	N2VC	1.0	249.000000	NaN	249.0	249.00	249.0	249.00	249.0
5	NG-SA	1.0	61.000000	NaN	61.0	61.00	61.0	61.00	61.0
6	NG-UI	3.0	24.333333	1.154701	23.0	24.00	25.0	25.00	25.0
7	OSMClient	8.0	247.375000	172.686287	1.0	197.00	279.0	293.50	548.0
8	POL	2.0	75.500000	99.702056	5.0	40.25	75.5	110.75	146.0
9	RO	25.0	198.080000	230.243697	2.0	21.00	143.0	261.00	982.0
10	Robot-tests	11.0	170.272727	94.867372	102.0	102.00	102.0	285.00	304.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
NG-SA	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	47	65.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	982	15.0	224.400000	292.791686	9.0	20.5	24.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2024-03-31 23:59:59	False	319	982
1	NaN	2176	2024-03-22 13:35:30	548	7.0	282.571429	152.409380	23.0	261.5	290.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	382	548
2	NaN	2252	2024-03-13 00:00:19	304	4.0	289.000000	10.099505	283.0	283.0	284.5	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-31 23:59:59	False	0	304
3	NaN	2270	2024-03-11 17:26:24	261	9.0	152.444444	73.080625	2.0	138.0	146.0	...	rahul.k4@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-31 23:59:59	False	0	261
4	NaN	2281	2024-03-11 17:26:36	240	9.0	152.444444	73.080625	2.0	138.0	146.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	240

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	639	15.0	224.400000	292.791686	9.0	20.50	24.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	248	639
1	NaN	2164	2024-03-11 17:25:10	564	3.0	291.000000	240.576391	110.0	154.50	199.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	138	564
2	NaN	2195	2024-03-11 17:25:24	499	15.0	224.400000	292.791686	9.0	20.50	24.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	499
3	NaN	2214	2024-03-11 17:25:40	431	4.0	253.000000	171.648866	102.0	108.00	239.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	431
4	NaN	2233	2024-03-11 17:25:49	353	15.0	224.400000	292.791686	9.0	20.50	24.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-31 23:59:59	False	0	353
5	NaN	2241	2024-03-11 16:03:32	338	4.0	294.500000	69.294059	191.0	290.75	324.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	338
6	NaN	2251	2024-03-13 00:00:17	304	7.0	282.571429	152.409380	23.0	261.50	290.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-31 23:59:59	False	0	304
7	NaN	2253	2024-03-13 00:00:21	304	7.0	209.285714	100.581168	102.0	102.00	285.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-31 23:59:59	False	0	304
8	NaN	2284	2024-03-11 17:26:38	235	13.0	88.076923	80.656123	1.0	12.00	138.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	235
9	NaN	2299	2024-03-11 17:26:50	153	13.0	88.076923	80.656123	1.0	12.00	138.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	153
10	NaN	2305	2024-03-11 17:26:59	146	2.0	75.500000	99.702056	5.0	40.25	75.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	146
11	NaN	2319	2024-03-21 01:00:10	136	6.0	42.500000	62.924558	1.0	1.00	3.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-31 23:59:59	False	125	136
12	NaN	2324	2024-03-11 17:27:26	110	6.0	42.500000	62.924558	1.0	1.00	3.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	110

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	369	1.0	369.000000	NaN	369.0	369.00	369.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	369
1	NaN	2230	2024-03-11 17:25:47	369	4.0	253.000000	171.648866	102.0	108.00	239.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-31 23:59:59	False	0	369
2	NaN	2235	2024-03-11 17:25:51	348	15.0	224.400000	292.791686	9.0	20.50	24.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-31 23:59:59	False	0	348
3	NaN	2243	2024-03-11 17:29:12	325	4.0	294.500000	69.294059	191.0	290.75	324.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-31 23:59:59	False	305	325
4	NaN	2245	2024-02-21 12:49:36	324	4.0	294.500000	69.294059	191.0	290.75	324.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59	False	0	324
5	NaN	2259	2024-03-12 17:32:24	290	7.0	282.571429	152.409380	23.0	261.50	290.0	...	gerardo.garciadeblas@telefonica.com	2024-03-31 23:59:59	RECENT	1.0	assigned_to	RECENT	2024-03-31 23:59:59	False	0	290
6	NaN	2260	2024-03-12 17:32:32	290	7.0	282.571429	152.409380	23.0	261.50	290.0	...	gerardo.garciadeblas@telefonica.com	2024-03-31 23:59:59	RECENT	1.0	assigned_to	RECENT	2024-03-31 23:59:59	False	0	290
7	NaN	2261	2024-03-11 17:26:07	286	4.0	289.000000	10.099505	283.0	283.00	284.5	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-31 23:59:59	False	0	286
8	NaN	2263	2024-03-11 17:26:10	285	7.0	209.285714	100.581168	102.0	102.00	285.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-31 23:59:59	False	0	285
9	NaN	2264	2024-03-11 17:26:12	285	7.0	209.285714	100.581168	102.0	102.00	285.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-31 23:59:59	False	0	285
10	NaN	2265	2024-03-11 17:26:14	285	7.0	209.285714	100.581168	102.0	102.00	285.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-31 23:59:59	False	0	285
11	NaN	2266	2024-03-11 17:26:17	283	4.0	289.000000	10.099505	283.0	283.00	284.5	...	rahul.k4@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-31 23:59:59	False	0	283
12	NaN	2267	2024-03-11 17:26:19	283	4.0	289.000000	10.099505	283.0	283.00	284.5	...	deepika.e@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-31 23:59:59	False	0	283
13	NaN	2269	2024-03-11 17:26:21	268	7.0	282.571429	152.409380	23.0	261.50	290.0	...	ramerama@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-31 23:59:59	False	0	268
14	NaN	2271	2024-03-11 17:26:26	261	15.0	224.400000	292.791686	9.0	20.50	24.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	261
15	NaN	2274	2024-03-11 17:26:28	255	7.0	282.571429	152.409380	23.0	261.50	290.0	...	deepika.e@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-31 23:59:59	False	0	255
16	NaN	2277	2024-03-11 17:26:31	249	1.0	249.000000	NaN	249.0	249.00	249.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	249
17	NaN	2278	2024-03-11 17:26:33	249	1.0	249.000000	NaN	249.0	249.00	249.0	...	guillermo.calvino@canonical.com	2023-07-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-31 23:59:59	False	0	249
18	NaN	2286	2024-03-11 17:26:41	214	1.0	214.000000	NaN	214.0	214.00	214.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	214
19	NaN	2287	2024-03-11 17:26:43	199	3.0	291.000000	240.576391	110.0	154.50	199.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	199
20	NaN	2288	2024-03-11 17:26:45	191	4.0	294.500000	69.294059	191.0	290.75	324.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	191
21	NaN	2298	2024-03-11 17:26:47	157	9.0	152.444444	73.080625	2.0	138.00	146.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	157
22	NaN	2301	2024-03-11 17:26:52	150	1.0	150.000000	NaN	150.0	150.00	150.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	150
23	NaN	2303	2024-03-11 17:26:54	149	9.0	152.444444	73.080625	2.0	138.00	146.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	149
24	NaN	2306	2024-03-11 17:27:01	146	9.0	152.444444	73.080625	2.0	138.00	146.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	146
25	NaN	2307	2024-02-20 16:25:14	144	13.0	88.076923	80.656123	1.0	12.00	138.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59	False	0	144
26	NaN	2308	2024-02-20 16:24:22	144	13.0	88.076923	80.656123	1.0	12.00	138.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59	False	0	144
27	NaN	2310	2024-03-11 17:27:04	143	9.0	152.444444	73.080625	2.0	138.00	146.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	143
28	NaN	2312	2024-03-19 00:00:37	142	13.0	88.076923	80.656123	1.0	12.00	138.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-31 23:59:59	False	0	142
29	NaN	2313	2024-03-22 00:00:41	138	13.0	88.076923	80.656123	1.0	12.00	138.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-31 23:59:59	False	0	138
30	NaN	2314	2024-02-20 16:27:21	138	13.0	88.076923	80.656123	1.0	12.00	138.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59	False	0	138
31	NaN	2316	2024-03-11 17:27:12	138	9.0	152.444444	73.080625	2.0	138.00	146.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	138
32	NaN	2318	2024-03-11 17:27:14	136	9.0	152.444444	73.080625	2.0	138.00	146.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	136
33	NaN	2320	2024-03-11 17:27:19	130	15.0	224.400000	292.791686	9.0	20.50	24.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	130
34	NaN	2322	2024-03-11 17:27:21	116	1.0	116.000000	NaN	116.0	116.00	116.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	116
35	NaN	2323	2024-03-11 17:27:23	110	4.0	253.000000	171.648866	102.0	108.00	239.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	110
36	NaN	2325	2024-03-11 17:27:28	110	3.0	291.000000	240.576391	110.0	154.50	199.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	110
37	NaN	2326	2024-02-05 18:34:33	102	4.0	102.000000	0.000000	102.0	102.00	102.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	comment	CURRENT	2024-02-29 23:59:59	False	0	102
38	NaN	2328	2024-03-14 15:35:49	102	4.0	253.000000	171.648866	102.0	108.00	239.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-31 23:59:59	False	85	102
39	NaN	2329	2024-03-21 00:35:22	102	1.0	102.000000	NaN	102.0	102.00	102.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-31 23:59:59	False	91	102
40	NaN	2330	2024-03-11 17:27:36	102	7.0	209.285714	100.581168	102.0	102.00	285.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-31 23:59:59	False	0	102
41	NaN	2331	2024-03-11 17:27:39	102	4.0	102.000000	0.000000	102.0	102.00	102.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-31 23:59:59	False	0	102
42	NaN	2332	2024-02-02 14:50:02	102	7.0	209.285714	100.581168	102.0	102.00	285.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59	False	0	102
43	NaN	2333	2024-03-11 17:27:42	102	4.0	102.000000	0.000000	102.0	102.00	102.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	102
44	NaN	2334	2024-03-11 17:27:44	102	7.0	209.285714	100.581168	102.0	102.00	285.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	102
45	NaN	2335	2024-03-11 17:27:46	102	4.0	102.000000	0.000000	102.0	102.00	102.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	102
46	NaN	2337	2024-02-06 11:50:52	61	1.0	61.000000	NaN	61.0	61.00	61.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59	False	0	61

47 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs