Analysis of OSM events in Bugzilla

Date and time of the report: 2024-03-13 05:00:05.784662

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

Bugs considered recent: Since 2024-02-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:

77

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	2023-12-20 14:13:28
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	1	13
LCM	12	0	12
N2VC	1	0	1
NG-SA	1	0	1
NG-UI	0	3	3
OSMClient	6	1	7
POL	1	0	1
RO	16	5	21
Robot-tests	11	0	11
Total	66	11	77

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	60	9	69
CONFIRMED	4	2	6
IN_PROGRESS	2	0	2
Total	66	11	77

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	123.000000	111.216006	8.0	69.5	131.0	180.50	230.0
1	Documentation / Wiki	4.0	270.000000	10.099505	264.0	264.0	265.5	271.50	285.0
2	IM-NBI	13.0	193.076923	93.365288	97.0	123.0	134.0	305.00	350.0
3	LCM	12.0	199.250000	154.491027	83.0	91.0	122.0	253.25	545.0
4	N2VC	1.0	230.000000	NaN	230.0	230.0	230.0	230.00	230.0
5	NG-SA	1.0	42.000000	NaN	42.0	42.0	42.0	42.00	42.0
6	NG-UI	3.0	5.333333	1.154701	4.0	5.0	6.0	6.00	6.0
7	OSMClient	7.0	263.571429	152.409380	4.0	242.5	271.0	278.00	529.0
8	POL	1.0	127.000000	NaN	127.0	127.0	127.0	127.00	127.0
9	RO	21.0	214.619048	235.196827	1.0	111.0	130.0	242.00	963.0
10	Robot-tests	11.0	151.272727	94.867372	83.0	83.0	83.0	266.00	285.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	1	2	10	13.0
LCM	1	2	9	12.0
N2VC	0	0	1	1.0
OSMClient	1	1	4	6.0
POL	0	0	1	1.0
RO	3	2	11	16.0
Robot-tests	0	1	10	11.0
All	7	8	51	66.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	963	12.0	257.833333	306.768149	1.0	4.25	176.5	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2024-03-13 04:00:05.812292	False	319	963
1	NaN	2176	2024-03-12 16:59:56	529	7.0	263.571429	152.409380	4.0	242.50	271.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	382	529
2	NaN	2252	2024-03-12 17:07:18	285	4.0	270.000000	10.099505	264.0	264.00	265.5	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	comment	RECENT	2024-03-13 04:00:05.812292	False	0	285
3	NaN	2270	2024-03-11 17:26:24	242	8.0	152.250000	49.660994	117.0	122.75	128.5	...	rahul.k4@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-13 04:00:05.812292	False	0	242
4	NaN	2280	2024-01-18 15:39:05	221	4.0	139.000000	56.733294	91.0	110.50	122.0	...	rahul.k4@tataelxsi.co.in	2023-11-30 23:59:59	CURRENT	1.0	comment	CURRENT	2024-01-31 23:59:59.000000	False	101	221
5	NaN	2281	2024-03-11 17:26:36	221	8.0	152.250000	49.660994	117.0	122.75	128.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	221
6	NaN	2284	2024-03-11 17:26:38	216	7.0	137.285714	35.074750	119.0	121.00	125.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	216

7 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	620	12.0	257.833333	306.768149	1.0	4.25	176.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	248	620
1	NaN	2164	2024-03-11 17:25:10	545	3.0	272.000000	240.576391	91.0	135.50	180.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	138	545
2	NaN	2195	2024-03-11 17:25:24	480	12.0	257.833333	306.768149	1.0	4.25	176.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	480
3	NaN	2214	2024-03-11 17:25:40	412	4.0	234.000000	171.648866	83.0	89.00	220.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	412
4	NaN	2241	2024-03-11 16:03:32	319	4.0	275.500000	69.294059	172.0	271.75	305.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	319
5	NaN	2251	2024-03-12 17:06:48	285	7.0	263.571429	152.409380	4.0	242.50	271.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	comment	RECENT	2024-03-13 04:00:05.812292	False	0	285
6	NaN	2253	2024-03-12 17:07:26	285	7.0	190.285714	100.581168	83.0	83.00	266.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	comment	RECENT	2024-03-13 04:00:05.812292	False	0	285
7	NaN	2299	2024-03-11 17:26:50	134	7.0	137.285714	35.074750	119.0	121.00	125.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	134

8 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	350	1.0	350.000000	NaN	350.0	350.00	350.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	350
1	NaN	2230	2024-03-11 17:25:47	350	4.0	234.000000	171.648866	83.0	89.00	220.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-13 04:00:05.812292	False	0	350
2	NaN	2233	2024-03-11 17:25:49	334	12.0	257.833333	306.768149	1.0	4.25	176.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-13 04:00:05.812292	False	0	334
3	NaN	2235	2024-03-11 17:25:51	329	12.0	257.833333	306.768149	1.0	4.25	176.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-13 04:00:05.812292	False	0	329
4	NaN	2243	2024-03-11 17:29:12	306	4.0	275.500000	69.294059	172.0	271.75	305.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-13 04:00:05.812292	False	305	306
5	NaN	2245	2024-02-21 12:49:36	305	4.0	275.500000	69.294059	172.0	271.75	305.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-02-29 23:59:59.000000	False	0	305
6	NaN	2259	2024-03-12 17:32:24	271	7.0	263.571429	152.409380	4.0	242.50	271.0	...	gerardo.garciadeblas@telefonica.com	2024-03-13 04:00:05.812292	RECENT	1.0	assigned_to	RECENT	2024-03-13 04:00:05.812292	False	0	271
7	NaN	2260	2024-03-12 17:32:32	271	7.0	263.571429	152.409380	4.0	242.50	271.0	...	gerardo.garciadeblas@telefonica.com	2024-03-13 04:00:05.812292	RECENT	1.0	assigned_to	RECENT	2024-03-13 04:00:05.812292	False	0	271
8	NaN	2261	2024-03-11 17:26:07	267	4.0	270.000000	10.099505	264.0	264.00	265.5	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-13 04:00:05.812292	False	0	267
9	NaN	2263	2024-03-11 17:26:10	266	7.0	190.285714	100.581168	83.0	83.00	266.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-13 04:00:05.812292	False	0	266
10	NaN	2264	2024-03-11 17:26:12	266	7.0	190.285714	100.581168	83.0	83.00	266.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-13 04:00:05.812292	False	0	266
11	NaN	2265	2024-03-11 17:26:14	266	7.0	190.285714	100.581168	83.0	83.00	266.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-13 04:00:05.812292	False	0	266
12	NaN	2266	2024-03-11 17:26:17	264	4.0	270.000000	10.099505	264.0	264.00	265.5	...	rahul.k4@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-13 04:00:05.812292	False	0	264
13	NaN	2267	2024-03-11 17:26:19	264	4.0	270.000000	10.099505	264.0	264.00	265.5	...	deepika.e@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-13 04:00:05.812292	False	0	264
14	NaN	2269	2024-03-11 17:26:21	249	7.0	263.571429	152.409380	4.0	242.50	271.0	...	ramerama@tataelxsi.co.in	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-13 04:00:05.812292	False	0	249
15	NaN	2271	2024-03-11 17:26:26	242	12.0	257.833333	306.768149	1.0	4.25	176.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	242
16	NaN	2274	2024-03-11 17:26:28	236	7.0	263.571429	152.409380	4.0	242.50	271.0	...	deepika.e@tataelxsi.co.in	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-13 04:00:05.812292	False	0	236
17	NaN	2277	2024-03-11 17:26:31	230	1.0	230.000000	NaN	230.0	230.00	230.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	230
18	NaN	2278	2024-03-11 17:26:33	230	1.0	230.000000	NaN	230.0	230.00	230.0	...	guillermo.calvino@canonical.com	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-13 04:00:05.812292	False	0	230
19	NaN	2286	2024-03-11 17:26:41	195	1.0	195.000000	NaN	195.0	195.00	195.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	195
20	NaN	2287	2024-03-11 17:26:43	180	3.0	272.000000	240.576391	91.0	135.50	180.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	180
21	NaN	2288	2024-03-11 17:26:45	172	4.0	275.500000	69.294059	172.0	271.75	305.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	172
22	NaN	2298	2024-03-11 17:26:47	138	8.0	152.250000	49.660994	117.0	122.75	128.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	138
23	NaN	2301	2024-03-11 17:26:52	131	1.0	131.000000	NaN	131.0	131.00	131.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	131
24	NaN	2303	2024-03-11 17:26:54	130	8.0	152.250000	49.660994	117.0	122.75	128.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	130
25	NaN	2304	2024-03-11 17:26:57	127	4.0	139.000000	56.733294	91.0	110.50	122.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	21	127
26	NaN	2305	2024-03-11 17:26:59	127	1.0	127.000000	NaN	127.0	127.00	127.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	127
27	NaN	2306	2024-03-11 17:27:01	127	8.0	152.250000	49.660994	117.0	122.75	128.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	127
28	NaN	2307	2024-02-20 16:25:14	125	7.0	137.285714	35.074750	119.0	121.00	125.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	125
29	NaN	2308	2024-02-20 16:24:22	125	7.0	137.285714	35.074750	119.0	121.00	125.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	125
30	NaN	2310	2024-03-11 17:27:04	124	8.0	152.250000	49.660994	117.0	122.75	128.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	124
31	NaN	2312	2024-03-11 17:27:06	123	7.0	137.285714	35.074750	119.0	121.00	125.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	123
32	NaN	2313	2024-03-11 17:27:09	119	7.0	137.285714	35.074750	119.0	121.00	125.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	119
33	NaN	2314	2024-02-20 16:27:21	119	7.0	137.285714	35.074750	119.0	121.00	125.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	119
34	NaN	2316	2024-03-11 17:27:12	119	8.0	152.250000	49.660994	117.0	122.75	128.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	119
35	NaN	2318	2024-03-11 17:27:14	117	8.0	152.250000	49.660994	117.0	122.75	128.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	117
36	NaN	2319	2024-03-11 17:27:16	117	4.0	139.000000	56.733294	91.0	110.50	122.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	117
37	NaN	2320	2024-03-11 17:27:19	111	12.0	257.833333	306.768149	1.0	4.25	176.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	111
38	NaN	2322	2024-03-11 17:27:21	97	1.0	97.000000	NaN	97.0	97.00	97.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	97
39	NaN	2323	2024-03-11 17:27:23	91	4.0	234.000000	171.648866	83.0	89.00	220.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	91
40	NaN	2324	2024-03-11 17:27:26	91	4.0	139.000000	56.733294	91.0	110.50	122.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	91
41	NaN	2325	2024-03-11 17:27:28	91	3.0	272.000000	240.576391	91.0	135.50	180.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	91
42	NaN	2326	2024-02-05 18:34:33	83	4.0	83.000000	0.000000	83.0	83.00	83.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	83
43	NaN	2328	2024-03-11 17:27:31	83	4.0	234.000000	171.648866	83.0	89.00	220.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	83
44	NaN	2329	2024-03-11 17:27:34	83	1.0	83.000000	NaN	83.0	83.00	83.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	83
45	NaN	2330	2024-03-11 17:27:36	83	7.0	190.285714	100.581168	83.0	83.00	266.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-13 04:00:05.812292	False	0	83
46	NaN	2331	2024-03-11 17:27:39	83	4.0	83.000000	0.000000	83.0	83.00	83.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-13 04:00:05.812292	False	0	83
47	NaN	2332	2024-02-02 14:50:02	83	7.0	190.285714	100.581168	83.0	83.00	266.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	83
48	NaN	2333	2024-03-11 17:27:42	83	4.0	83.000000	0.000000	83.0	83.00	83.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	83
49	NaN	2334	2024-03-11 17:27:44	83	7.0	190.285714	100.581168	83.0	83.00	266.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	83
50	NaN	2335	2024-03-11 17:27:46	83	4.0	83.000000	0.000000	83.0	83.00	83.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-13 04:00:05.812292	False	0	83

51 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs