Analysis of OSM events in Bugzilla

Date and time of the report: 2024-03-26 05:00:05.276993

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

Bugs considered recent: Since 2024-03-05.

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:

84

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	Robot testsuite heal_02 fails in a step when c...	2	[Master, v15.0]	Robot-tests	2023-12-20 15:09:20
2	Robot testsuite heal_03 fails when checking if...	2	[Master, v15.0]	Robot-tests	2023-12-20 17:06:32
3	Robot testsuite lcmop_01 fails in daily job wh...	2	[Master, v15.0]	Robot-tests	2023-12-20 14:23:08
4	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	2	1	3
Documentation / Wiki	4	0	4
IM-NBI	12	6	18
LCM	7	4	11
N2VC	1	0	1
NG-SA	1	0	1
NG-UI	0	3	3
OSMClient	6	1	7
POL	1	0	1
RO	16	8	24
Robot-tests	11	0	11
Total	61	23	84

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	57	18	75
CONFIRMED	4	2	6
IN_PROGRESS	0	3	3
Total	61	23	84

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	136.000000	111.216006	21.0	82.50	144.0	193.5	243.0
1	Documentation / Wiki	4.0	283.000000	10.099505	277.0	277.00	278.5	284.5	298.0
2	IM-NBI	18.0	149.944444	121.780648	0.0	32.75	137.0	218.0	363.0
3	LCM	11.0	197.545455	173.066671	0.0	100.00	104.0	278.0	558.0
4	N2VC	1.0	243.000000	NaN	243.0	243.00	243.0	243.0	243.0
5	NG-SA	1.0	55.000000	NaN	55.0	55.00	55.0	55.0	55.0
6	NG-UI	3.0	18.333333	1.154701	17.0	18.00	19.0	19.0	19.0
7	OSMClient	7.0	276.571429	152.409380	17.0	255.50	284.0	291.0	542.0
8	POL	1.0	140.000000	NaN	140.0	140.00	140.0	140.0	140.0
9	RO	24.0	200.250000	231.464384	3.0	17.25	138.5	255.0	976.0
10	Robot-tests	11.0	164.272727	94.867372	96.0	96.00	96.0	279.0	298.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	3	7	10.0
N2VC	0	0	1	1.0
OSMClient	1	1	4	6.0
POL	0	0	1	1.0
RO	3	3	10	16.0
Robot-tests	0	1	10	11.0
All	5	11	48	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	976	15.0	218.400000	292.791686	3.0	14.50	18.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2024-03-26 04:00:05.311876	False	319	976
1	NaN	2176	2024-03-22 13:35:30	542	7.0	276.571429	152.409380	17.0	255.50	284.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	382	542
2	NaN	2252	2024-03-13 00:00:19	298	4.0	283.000000	10.099505	277.0	277.00	278.5	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-26 04:00:05.311876	False	0	298
3	NaN	2270	2024-03-11 17:26:24	255	8.0	165.250000	49.660994	130.0	135.75	141.5	...	rahul.k4@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-26 04:00:05.311876	False	0	255
4	NaN	2281	2024-03-11 17:26:36	234	8.0	165.250000	49.660994	130.0	135.75	141.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	234

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	633	15.0	218.400000	292.791686	3.0	14.50	18.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	248	633
1	NaN	2164	2024-03-11 17:25:10	558	3.0	285.000000	240.576391	104.0	148.50	193.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	138	558
2	NaN	2195	2024-03-11 17:25:24	493	15.0	218.400000	292.791686	3.0	14.50	18.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	493
3	NaN	2214	2024-03-11 17:25:40	425	4.0	247.000000	171.648866	96.0	102.00	233.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	425
4	NaN	2233	2024-03-11 17:25:49	347	15.0	218.400000	292.791686	3.0	14.50	18.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-26 04:00:05.311876	False	0	347
5	NaN	2241	2024-03-11 16:03:32	332	4.0	288.500000	69.294059	185.0	284.75	318.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	332
6	NaN	2251	2024-03-13 00:00:17	298	7.0	276.571429	152.409380	17.0	255.50	284.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-26 04:00:05.311876	False	0	298
7	NaN	2253	2024-03-13 00:00:21	298	7.0	203.285714	100.581168	96.0	96.00	279.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-26 04:00:05.311876	False	0	298
8	NaN	2284	2024-03-11 17:26:38	229	12.0	89.333333	79.687268	0.0	6.75	132.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	229
9	NaN	2299	2024-03-11 17:26:50	147	12.0	89.333333	79.687268	0.0	6.75	132.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	147
10	NaN	2319	2024-03-21 01:00:10	130	3.0	78.000000	68.789534	0.0	52.00	104.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-26 04:00:05.311876	False	125	130

11 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	363	1.0	363.000000	NaN	363.0	363.00	363.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	363
1	NaN	2230	2024-03-11 17:25:47	363	4.0	247.000000	171.648866	96.0	102.00	233.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-26 04:00:05.311876	False	0	363
2	NaN	2235	2024-03-11 17:25:51	342	15.0	218.400000	292.791686	3.0	14.50	18.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-26 04:00:05.311876	False	0	342
3	NaN	2243	2024-03-11 17:29:12	319	4.0	288.500000	69.294059	185.0	284.75	318.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-26 04:00:05.311876	False	305	319
4	NaN	2245	2024-02-21 12:49:36	318	4.0	288.500000	69.294059	185.0	284.75	318.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	318
5	NaN	2259	2024-03-12 17:32:24	284	7.0	276.571429	152.409380	17.0	255.50	284.0	...	gerardo.garciadeblas@telefonica.com	2024-03-26 04:00:05.311876	RECENT	1.0	assigned_to	RECENT	2024-03-26 04:00:05.311876	False	0	284
6	NaN	2260	2024-03-12 17:32:32	284	7.0	276.571429	152.409380	17.0	255.50	284.0	...	gerardo.garciadeblas@telefonica.com	2024-03-26 04:00:05.311876	RECENT	1.0	assigned_to	RECENT	2024-03-26 04:00:05.311876	False	0	284
7	NaN	2261	2024-03-11 17:26:07	280	4.0	283.000000	10.099505	277.0	277.00	278.5	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-26 04:00:05.311876	False	0	280
8	NaN	2263	2024-03-11 17:26:10	279	7.0	203.285714	100.581168	96.0	96.00	279.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-26 04:00:05.311876	False	0	279
9	NaN	2264	2024-03-11 17:26:12	279	7.0	203.285714	100.581168	96.0	96.00	279.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-26 04:00:05.311876	False	0	279
10	NaN	2265	2024-03-11 17:26:14	279	7.0	203.285714	100.581168	96.0	96.00	279.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-26 04:00:05.311876	False	0	279
11	NaN	2266	2024-03-11 17:26:17	277	4.0	283.000000	10.099505	277.0	277.00	278.5	...	rahul.k4@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-26 04:00:05.311876	False	0	277
12	NaN	2267	2024-03-11 17:26:19	277	4.0	283.000000	10.099505	277.0	277.00	278.5	...	deepika.e@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-26 04:00:05.311876	False	0	277
13	NaN	2269	2024-03-11 17:26:21	262	7.0	276.571429	152.409380	17.0	255.50	284.0	...	ramerama@tataelxsi.co.in	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-26 04:00:05.311876	False	0	262
14	NaN	2271	2024-03-11 17:26:26	255	15.0	218.400000	292.791686	3.0	14.50	18.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	255
15	NaN	2274	2024-03-11 17:26:28	249	7.0	276.571429	152.409380	17.0	255.50	284.0	...	deepika.e@tataelxsi.co.in	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-26 04:00:05.311876	False	0	249
16	NaN	2277	2024-03-11 17:26:31	243	1.0	243.000000	NaN	243.0	243.00	243.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	243
17	NaN	2278	2024-03-11 17:26:33	243	1.0	243.000000	NaN	243.0	243.00	243.0	...	guillermo.calvino@canonical.com	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-26 04:00:05.311876	False	0	243
18	NaN	2286	2024-03-11 17:26:41	208	1.0	208.000000	NaN	208.0	208.00	208.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	208
19	NaN	2287	2024-03-11 17:26:43	193	3.0	285.000000	240.576391	104.0	148.50	193.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	193
20	NaN	2288	2024-03-11 17:26:45	185	4.0	288.500000	69.294059	185.0	284.75	318.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	185
21	NaN	2298	2024-03-11 17:26:47	151	8.0	165.250000	49.660994	130.0	135.75	141.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	151
22	NaN	2301	2024-03-11 17:26:52	144	1.0	144.000000	NaN	144.0	144.00	144.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	144
23	NaN	2303	2024-03-11 17:26:54	143	8.0	165.250000	49.660994	130.0	135.75	141.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	143
24	NaN	2305	2024-03-11 17:26:59	140	1.0	140.000000	NaN	140.0	140.00	140.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	140
25	NaN	2306	2024-03-11 17:27:01	140	8.0	165.250000	49.660994	130.0	135.75	141.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	140
26	NaN	2307	2024-02-20 16:25:14	138	12.0	89.333333	79.687268	0.0	6.75	132.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	138
27	NaN	2308	2024-02-20 16:24:22	138	12.0	89.333333	79.687268	0.0	6.75	132.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	138
28	NaN	2310	2024-03-11 17:27:04	137	8.0	165.250000	49.660994	130.0	135.75	141.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	137
29	NaN	2312	2024-03-19 00:00:37	136	12.0	89.333333	79.687268	0.0	6.75	132.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-26 04:00:05.311876	False	0	136
30	NaN	2313	2024-03-22 00:00:41	132	12.0	89.333333	79.687268	0.0	6.75	132.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-26 04:00:05.311876	False	0	132
31	NaN	2314	2024-02-20 16:27:21	132	12.0	89.333333	79.687268	0.0	6.75	132.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	132
32	NaN	2316	2024-03-11 17:27:12	132	8.0	165.250000	49.660994	130.0	135.75	141.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	132
33	NaN	2318	2024-03-11 17:27:14	130	8.0	165.250000	49.660994	130.0	135.75	141.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	130
34	NaN	2320	2024-03-11 17:27:19	124	15.0	218.400000	292.791686	3.0	14.50	18.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	124
35	NaN	2322	2024-03-11 17:27:21	110	1.0	110.000000	NaN	110.0	110.00	110.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	110
36	NaN	2323	2024-03-11 17:27:23	104	4.0	247.000000	171.648866	96.0	102.00	233.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	104
37	NaN	2324	2024-03-11 17:27:26	104	3.0	78.000000	68.789534	0.0	52.00	104.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	104
38	NaN	2325	2024-03-11 17:27:28	104	3.0	285.000000	240.576391	104.0	148.50	193.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	104
39	NaN	2326	2024-02-05 18:34:33	96	4.0	96.000000	0.000000	96.0	96.00	96.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	96
40	NaN	2328	2024-03-14 15:35:49	96	4.0	247.000000	171.648866	96.0	102.00	233.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-26 04:00:05.311876	False	85	96
41	NaN	2329	2024-03-21 00:35:22	96	1.0	96.000000	NaN	96.0	96.00	96.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-26 04:00:05.311876	False	91	96
42	NaN	2330	2024-03-11 17:27:36	96	7.0	203.285714	100.581168	96.0	96.00	279.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-26 04:00:05.311876	False	0	96
43	NaN	2331	2024-03-11 17:27:39	96	4.0	96.000000	0.000000	96.0	96.00	96.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-26 04:00:05.311876	False	0	96
44	NaN	2332	2024-02-02 14:50:02	96	7.0	203.285714	100.581168	96.0	96.00	279.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	96
45	NaN	2333	2024-03-11 17:27:42	96	4.0	96.000000	0.000000	96.0	96.00	96.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	96
46	NaN	2334	2024-03-11 17:27:44	96	7.0	203.285714	100.581168	96.0	96.00	279.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	96
47	NaN	2335	2024-03-11 17:27:46	96	4.0	96.000000	0.000000	96.0	96.00	96.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-26 04:00:05.311876	False	0	96

48 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs