Analysis of OSM events in Bugzilla

Date and time of the report: 2024-03-20 05:00:05.744508

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

Bugs considered recent: Since 2024-02-28.

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:

83

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:21:06
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	4	16
LCM	11	1	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	8	24
Robot-tests	11	0	11
Total	65	18	83

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	59	15	74
CONFIRMED	4	2	6
IN_PROGRESS	2	1	3
Total	65	18	83

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	130.000000	111.216006	15.0	76.50	138.0	187.50	237.0
1	Documentation / Wiki	4.0	277.000000	10.099505	271.0	271.00	272.5	278.50	292.0
2	IM-NBI	16.0	162.687500	115.911299	0.0	120.50	132.0	245.25	357.0
3	LCM	12.0	206.250000	154.491027	90.0	98.00	129.0	260.25	552.0
4	N2VC	1.0	237.000000	NaN	237.0	237.00	237.0	237.00	237.0
5	NG-SA	1.0	49.000000	NaN	49.0	49.00	49.0	49.00	49.0
6	NG-UI	3.0	12.333333	1.154701	11.0	12.00	13.0	13.00	13.0
7	OSMClient	7.0	270.571429	152.409380	11.0	249.50	278.0	285.00	536.0
8	POL	1.0	134.000000	NaN	134.0	134.00	134.0	134.00	134.0
9	RO	24.0	194.625000	231.137981	5.0	11.25	132.5	249.00	970.0
10	Robot-tests	11.0	158.272727	94.867372	90.0	90.00	90.0	273.00	292.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	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	3	10	16.0
Robot-tests	0	1	10	11.0
All	6	10	50	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	970	15.0	213.000000	292.327605	5.0	8.50	12.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2024-03-20 04:00:05.773946	False	319	970
1	NaN	2176	2024-03-13 00:00:13	536	7.0	270.571429	152.409380	11.0	249.50	278.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-20 04:00:05.773946	False	382	536
2	NaN	2252	2024-03-13 00:00:19	292	4.0	277.000000	10.099505	271.0	271.00	272.5	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-20 04:00:05.773946	False	0	292
3	NaN	2270	2024-03-11 17:26:24	249	8.0	159.250000	49.660994	124.0	129.75	135.5	...	rahul.k4@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-20 04:00:05.773946	False	0	249
4	NaN	2280	2024-01-18 15:39:05	228	4.0	146.000000	56.733294	98.0	117.50	129.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	228
5	NaN	2281	2024-03-11 17:26:36	228	8.0	159.250000	49.660994	124.0	129.75	135.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	228

6 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	627	15.0	213.000000	292.327605	5.0	8.50	12.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	248	627
1	NaN	2164	2024-03-11 17:25:10	552	3.0	279.000000	240.576391	98.0	142.50	187.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	138	552
2	NaN	2195	2024-03-11 17:25:24	487	15.0	213.000000	292.327605	5.0	8.50	12.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	487
3	NaN	2214	2024-03-11 17:25:40	419	4.0	241.000000	171.648866	90.0	96.00	227.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	419
4	NaN	2233	2024-03-11 17:25:49	341	15.0	213.000000	292.327605	5.0	8.50	12.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-20 04:00:05.773946	False	0	341
5	NaN	2241	2024-03-11 16:03:32	326	4.0	282.500000	69.294059	179.0	278.75	312.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	326
6	NaN	2251	2024-03-13 00:00:17	292	7.0	270.571429	152.409380	11.0	249.50	278.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-20 04:00:05.773946	False	0	292
7	NaN	2253	2024-03-13 00:00:21	292	7.0	197.285714	100.581168	90.0	90.00	273.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-20 04:00:05.773946	False	0	292
8	NaN	2284	2024-03-11 17:26:38	223	10.0	101.200000	75.053759	0.0	32.25	128.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	223
9	NaN	2299	2024-03-11 17:26:50	141	10.0	101.200000	75.053759	0.0	32.25	128.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	141

10 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	357	1.0	357.000000	NaN	357.0	357.00	357.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	357
1	NaN	2230	2024-03-11 17:25:47	357	4.0	241.000000	171.648866	90.0	96.00	227.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-20 04:00:05.773946	False	0	357
2	NaN	2235	2024-03-11 17:25:51	336	15.0	213.000000	292.327605	5.0	8.50	12.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-20 04:00:05.773946	False	0	336
3	NaN	2243	2024-03-11 17:29:12	313	4.0	282.500000	69.294059	179.0	278.75	312.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-20 04:00:05.773946	False	305	313
4	NaN	2245	2024-02-21 12:49:36	312	4.0	282.500000	69.294059	179.0	278.75	312.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	312
5	NaN	2259	2024-03-12 17:32:24	278	7.0	270.571429	152.409380	11.0	249.50	278.0	...	gerardo.garciadeblas@telefonica.com	2024-03-20 04:00:05.773946	RECENT	1.0	assigned_to	RECENT	2024-03-20 04:00:05.773946	False	0	278
6	NaN	2260	2024-03-12 17:32:32	278	7.0	270.571429	152.409380	11.0	249.50	278.0	...	gerardo.garciadeblas@telefonica.com	2024-03-20 04:00:05.773946	RECENT	1.0	assigned_to	RECENT	2024-03-20 04:00:05.773946	False	0	278
7	NaN	2261	2024-03-11 17:26:07	274	4.0	277.000000	10.099505	271.0	271.00	272.5	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-20 04:00:05.773946	False	0	274
8	NaN	2263	2024-03-11 17:26:10	273	7.0	197.285714	100.581168	90.0	90.00	273.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-20 04:00:05.773946	False	0	273
9	NaN	2264	2024-03-11 17:26:12	273	7.0	197.285714	100.581168	90.0	90.00	273.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-20 04:00:05.773946	False	0	273
10	NaN	2265	2024-03-11 17:26:14	273	7.0	197.285714	100.581168	90.0	90.00	273.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-20 04:00:05.773946	False	0	273
11	NaN	2266	2024-03-11 17:26:17	271	4.0	277.000000	10.099505	271.0	271.00	272.5	...	rahul.k4@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-20 04:00:05.773946	False	0	271
12	NaN	2267	2024-03-11 17:26:19	271	4.0	277.000000	10.099505	271.0	271.00	272.5	...	deepika.e@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-20 04:00:05.773946	False	0	271
13	NaN	2269	2024-03-11 17:26:21	256	7.0	270.571429	152.409380	11.0	249.50	278.0	...	ramerama@tataelxsi.co.in	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-20 04:00:05.773946	False	0	256
14	NaN	2271	2024-03-11 17:26:26	249	15.0	213.000000	292.327605	5.0	8.50	12.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	249
15	NaN	2274	2024-03-11 17:26:28	243	7.0	270.571429	152.409380	11.0	249.50	278.0	...	deepika.e@tataelxsi.co.in	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-20 04:00:05.773946	False	0	243
16	NaN	2277	2024-03-11 17:26:31	237	1.0	237.000000	NaN	237.0	237.00	237.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	237
17	NaN	2278	2024-03-11 17:26:33	237	1.0	237.000000	NaN	237.0	237.00	237.0	...	guillermo.calvino@canonical.com	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-20 04:00:05.773946	False	0	237
18	NaN	2286	2024-03-11 17:26:41	202	1.0	202.000000	NaN	202.0	202.00	202.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	202
19	NaN	2287	2024-03-11 17:26:43	187	3.0	279.000000	240.576391	98.0	142.50	187.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	187
20	NaN	2288	2024-03-11 17:26:45	179	4.0	282.500000	69.294059	179.0	278.75	312.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	179
21	NaN	2298	2024-03-11 17:26:47	145	8.0	159.250000	49.660994	124.0	129.75	135.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	145
22	NaN	2301	2024-03-11 17:26:52	138	1.0	138.000000	NaN	138.0	138.00	138.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	138
23	NaN	2303	2024-03-11 17:26:54	137	8.0	159.250000	49.660994	124.0	129.75	135.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	137
24	NaN	2304	2024-03-11 17:26:57	134	4.0	146.000000	56.733294	98.0	117.50	129.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	21	134
25	NaN	2305	2024-03-11 17:26:59	134	1.0	134.000000	NaN	134.0	134.00	134.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	134
26	NaN	2306	2024-03-11 17:27:01	134	8.0	159.250000	49.660994	124.0	129.75	135.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	134
27	NaN	2307	2024-02-20 16:25:14	132	10.0	101.200000	75.053759	0.0	32.25	128.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	132
28	NaN	2308	2024-02-20 16:24:22	132	10.0	101.200000	75.053759	0.0	32.25	128.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	132
29	NaN	2310	2024-03-11 17:27:04	131	8.0	159.250000	49.660994	124.0	129.75	135.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	131
30	NaN	2312	2024-03-19 00:00:37	130	10.0	101.200000	75.053759	0.0	32.25	128.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-20 04:00:05.773946	False	0	130
31	NaN	2313	2024-03-11 17:27:09	126	10.0	101.200000	75.053759	0.0	32.25	128.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	126
32	NaN	2314	2024-02-20 16:27:21	126	10.0	101.200000	75.053759	0.0	32.25	128.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	126
33	NaN	2316	2024-03-11 17:27:12	126	8.0	159.250000	49.660994	124.0	129.75	135.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	126
34	NaN	2318	2024-03-11 17:27:14	124	8.0	159.250000	49.660994	124.0	129.75	135.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	124
35	NaN	2319	2024-03-11 17:27:16	124	4.0	146.000000	56.733294	98.0	117.50	129.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	124
36	NaN	2320	2024-03-11 17:27:19	118	15.0	213.000000	292.327605	5.0	8.50	12.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	118
37	NaN	2322	2024-03-11 17:27:21	104	1.0	104.000000	NaN	104.0	104.00	104.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	104
38	NaN	2323	2024-03-11 17:27:23	98	4.0	241.000000	171.648866	90.0	96.00	227.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	98
39	NaN	2324	2024-03-11 17:27:26	98	4.0	146.000000	56.733294	98.0	117.50	129.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	98
40	NaN	2325	2024-03-11 17:27:28	98	3.0	279.000000	240.576391	98.0	142.50	187.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	98
41	NaN	2326	2024-02-05 18:34:33	90	4.0	90.000000	0.000000	90.0	90.00	90.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	90
42	NaN	2328	2024-03-14 15:35:49	90	4.0	241.000000	171.648866	90.0	96.00	227.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-20 04:00:05.773946	False	85	90
43	NaN	2329	2024-03-11 17:27:34	90	1.0	90.000000	NaN	90.0	90.00	90.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	90
44	NaN	2330	2024-03-11 17:27:36	90	7.0	197.285714	100.581168	90.0	90.00	273.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-20 04:00:05.773946	False	0	90
45	NaN	2331	2024-03-11 17:27:39	90	4.0	90.000000	0.000000	90.0	90.00	90.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-20 04:00:05.773946	False	0	90
46	NaN	2332	2024-02-02 14:50:02	90	7.0	197.285714	100.581168	90.0	90.00	273.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	90
47	NaN	2333	2024-03-11 17:27:42	90	4.0	90.000000	0.000000	90.0	90.00	90.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	90
48	NaN	2334	2024-03-11 17:27:44	90	7.0	197.285714	100.581168	90.0	90.00	273.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	90
49	NaN	2335	2024-03-11 17:27:46	90	4.0	90.000000	0.000000	90.0	90.00	90.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-20 04:00:05.773946	False	0	90

50 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs