Analysis of OSM events in Bugzilla

Date and time of the report: 2024-03-21 05:00:05.407814

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

Bugs considered recent: Since 2024-02-29.

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	131.000000	111.216006	16.0	77.50	139.0	188.50	238.0
1	Documentation / Wiki	4.0	278.000000	10.099505	272.0	272.00	273.5	279.50	293.0
2	IM-NBI	16.0	163.687500	115.911299	1.0	121.50	133.0	246.25	358.0
3	LCM	12.0	207.250000	154.491027	91.0	99.00	130.0	261.25	553.0
4	N2VC	1.0	238.000000	NaN	238.0	238.00	238.0	238.00	238.0
5	NG-SA	1.0	50.000000	NaN	50.0	50.00	50.0	50.00	50.0
6	NG-UI	3.0	13.333333	1.154701	12.0	13.00	14.0	14.00	14.0
7	OSMClient	7.0	271.571429	152.409380	12.0	250.50	279.0	286.00	537.0
8	POL	1.0	135.000000	NaN	135.0	135.00	135.0	135.00	135.0
9	RO	24.0	195.625000	231.137981	6.0	12.25	133.5	250.00	971.0
10	Robot-tests	11.0	159.272727	94.867372	91.0	91.00	91.0	274.00	293.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	971	15.0	214.000000	292.327605	6.0	9.50	13.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2024-03-21 04:00:05.436106	False	319	971
1	NaN	2176	2024-03-13 00:00:13	537	7.0	271.571429	152.409380	12.0	250.50	279.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-21 04:00:05.436106	False	382	537
2	NaN	2252	2024-03-13 00:00:19	293	4.0	278.000000	10.099505	272.0	272.00	273.5	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-21 04:00:05.436106	False	0	293
3	NaN	2270	2024-03-11 17:26:24	250	8.0	160.250000	49.660994	125.0	130.75	136.5	...	rahul.k4@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-21 04:00:05.436106	False	0	250
4	NaN	2280	2024-03-20 00:00:29	229	4.0	147.000000	56.733294	99.0	118.50	130.0	...	rahul.k4@tataelxsi.co.in	2023-11-30 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-21 04:00:05.436106	False	101	229
5	NaN	2281	2024-03-11 17:26:36	229	8.0	160.250000	49.660994	125.0	130.75	136.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	229

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	628	15.0	214.000000	292.327605	6.0	9.50	13.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	248	628
1	NaN	2164	2024-03-11 17:25:10	553	3.0	280.000000	240.576391	99.0	143.50	188.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	138	553
2	NaN	2195	2024-03-11 17:25:24	488	15.0	214.000000	292.327605	6.0	9.50	13.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	488
3	NaN	2214	2024-03-11 17:25:40	420	4.0	242.000000	171.648866	91.0	97.00	228.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	420
4	NaN	2233	2024-03-11 17:25:49	342	15.0	214.000000	292.327605	6.0	9.50	13.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-21 04:00:05.436106	False	0	342
5	NaN	2241	2024-03-11 16:03:32	327	4.0	283.500000	69.294059	180.0	279.75	313.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	327
6	NaN	2251	2024-03-13 00:00:17	293	7.0	271.571429	152.409380	12.0	250.50	279.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-21 04:00:05.436106	False	0	293
7	NaN	2253	2024-03-13 00:00:21	293	7.0	198.285714	100.581168	91.0	91.00	274.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-21 04:00:05.436106	False	0	293
8	NaN	2284	2024-03-11 17:26:38	224	10.0	102.200000	75.053759	1.0	33.25	129.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	224
9	NaN	2299	2024-03-11 17:26:50	142	10.0	102.200000	75.053759	1.0	33.25	129.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	142

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	358	1.0	358.000000	NaN	358.0	358.00	358.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	358
1	NaN	2230	2024-03-11 17:25:47	358	4.0	242.000000	171.648866	91.0	97.00	228.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-21 04:00:05.436106	False	0	358
2	NaN	2235	2024-03-11 17:25:51	337	15.0	214.000000	292.327605	6.0	9.50	13.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-21 04:00:05.436106	False	0	337
3	NaN	2243	2024-03-11 17:29:12	314	4.0	283.500000	69.294059	180.0	279.75	313.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-21 04:00:05.436106	False	305	314
4	NaN	2245	2024-02-21 12:49:36	313	4.0	283.500000	69.294059	180.0	279.75	313.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	313
5	NaN	2259	2024-03-12 17:32:24	279	7.0	271.571429	152.409380	12.0	250.50	279.0	...	gerardo.garciadeblas@telefonica.com	2024-03-21 04:00:05.436106	RECENT	1.0	assigned_to	RECENT	2024-03-21 04:00:05.436106	False	0	279
6	NaN	2260	2024-03-12 17:32:32	279	7.0	271.571429	152.409380	12.0	250.50	279.0	...	gerardo.garciadeblas@telefonica.com	2024-03-21 04:00:05.436106	RECENT	1.0	assigned_to	RECENT	2024-03-21 04:00:05.436106	False	0	279
7	NaN	2261	2024-03-11 17:26:07	275	4.0	278.000000	10.099505	272.0	272.00	273.5	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-21 04:00:05.436106	False	0	275
8	NaN	2263	2024-03-11 17:26:10	274	7.0	198.285714	100.581168	91.0	91.00	274.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-21 04:00:05.436106	False	0	274
9	NaN	2264	2024-03-11 17:26:12	274	7.0	198.285714	100.581168	91.0	91.00	274.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-21 04:00:05.436106	False	0	274
10	NaN	2265	2024-03-11 17:26:14	274	7.0	198.285714	100.581168	91.0	91.00	274.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-21 04:00:05.436106	False	0	274
11	NaN	2266	2024-03-11 17:26:17	272	4.0	278.000000	10.099505	272.0	272.00	273.5	...	rahul.k4@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-21 04:00:05.436106	False	0	272
12	NaN	2267	2024-03-11 17:26:19	272	4.0	278.000000	10.099505	272.0	272.00	273.5	...	deepika.e@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-21 04:00:05.436106	False	0	272
13	NaN	2269	2024-03-11 17:26:21	257	7.0	271.571429	152.409380	12.0	250.50	279.0	...	ramerama@tataelxsi.co.in	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-21 04:00:05.436106	False	0	257
14	NaN	2271	2024-03-11 17:26:26	250	15.0	214.000000	292.327605	6.0	9.50	13.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	250
15	NaN	2274	2024-03-11 17:26:28	244	7.0	271.571429	152.409380	12.0	250.50	279.0	...	deepika.e@tataelxsi.co.in	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-21 04:00:05.436106	False	0	244
16	NaN	2277	2024-03-11 17:26:31	238	1.0	238.000000	NaN	238.0	238.00	238.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	238
17	NaN	2278	2024-03-11 17:26:33	238	1.0	238.000000	NaN	238.0	238.00	238.0	...	guillermo.calvino@canonical.com	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-21 04:00:05.436106	False	0	238
18	NaN	2286	2024-03-11 17:26:41	203	1.0	203.000000	NaN	203.0	203.00	203.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	203
19	NaN	2287	2024-03-11 17:26:43	188	3.0	280.000000	240.576391	99.0	143.50	188.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	188
20	NaN	2288	2024-03-11 17:26:45	180	4.0	283.500000	69.294059	180.0	279.75	313.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	180
21	NaN	2298	2024-03-11 17:26:47	146	8.0	160.250000	49.660994	125.0	130.75	136.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	146
22	NaN	2301	2024-03-11 17:26:52	139	1.0	139.000000	NaN	139.0	139.00	139.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	139
23	NaN	2303	2024-03-11 17:26:54	138	8.0	160.250000	49.660994	125.0	130.75	136.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	138
24	NaN	2304	2024-03-20 20:45:59	135	4.0	147.000000	56.733294	99.0	118.50	130.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	21	135
25	NaN	2305	2024-03-11 17:26:59	135	1.0	135.000000	NaN	135.0	135.00	135.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	135
26	NaN	2306	2024-03-11 17:27:01	135	8.0	160.250000	49.660994	125.0	130.75	136.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	135
27	NaN	2307	2024-02-20 16:25:14	133	10.0	102.200000	75.053759	1.0	33.25	129.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	133
28	NaN	2308	2024-02-20 16:24:22	133	10.0	102.200000	75.053759	1.0	33.25	129.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	133
29	NaN	2310	2024-03-11 17:27:04	132	8.0	160.250000	49.660994	125.0	130.75	136.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	132
30	NaN	2312	2024-03-19 00:00:37	131	10.0	102.200000	75.053759	1.0	33.25	129.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-21 04:00:05.436106	False	0	131
31	NaN	2313	2024-03-11 17:27:09	127	10.0	102.200000	75.053759	1.0	33.25	129.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	127
32	NaN	2314	2024-02-20 16:27:21	127	10.0	102.200000	75.053759	1.0	33.25	129.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	127
33	NaN	2316	2024-03-11 17:27:12	127	8.0	160.250000	49.660994	125.0	130.75	136.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	127
34	NaN	2318	2024-03-11 17:27:14	125	8.0	160.250000	49.660994	125.0	130.75	136.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	125
35	NaN	2319	2024-03-11 17:27:16	125	4.0	147.000000	56.733294	99.0	118.50	130.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	125
36	NaN	2320	2024-03-11 17:27:19	119	15.0	214.000000	292.327605	6.0	9.50	13.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	119
37	NaN	2322	2024-03-11 17:27:21	105	1.0	105.000000	NaN	105.0	105.00	105.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	105
38	NaN	2323	2024-03-11 17:27:23	99	4.0	242.000000	171.648866	91.0	97.00	228.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	99
39	NaN	2324	2024-03-11 17:27:26	99	4.0	147.000000	56.733294	99.0	118.50	130.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	99
40	NaN	2325	2024-03-11 17:27:28	99	3.0	280.000000	240.576391	99.0	143.50	188.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	99
41	NaN	2326	2024-02-05 18:34:33	91	4.0	91.000000	0.000000	91.0	91.00	91.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	91
42	NaN	2328	2024-03-14 15:35:49	91	4.0	242.000000	171.648866	91.0	97.00	228.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-21 04:00:05.436106	False	85	91
43	NaN	2329	2024-03-11 17:27:34	91	1.0	91.000000	NaN	91.0	91.00	91.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	91
44	NaN	2330	2024-03-11 17:27:36	91	7.0	198.285714	100.581168	91.0	91.00	274.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-21 04:00:05.436106	False	0	91
45	NaN	2331	2024-03-11 17:27:39	91	4.0	91.000000	0.000000	91.0	91.00	91.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-21 04:00:05.436106	False	0	91
46	NaN	2332	2024-02-02 14:50:02	91	7.0	198.285714	100.581168	91.0	91.00	274.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	91
47	NaN	2333	2024-03-11 17:27:42	91	4.0	91.000000	0.000000	91.0	91.00	91.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	91
48	NaN	2334	2024-03-11 17:27:44	91	7.0	198.285714	100.581168	91.0	91.00	274.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	91
49	NaN	2335	2024-03-11 17:27:46	91	4.0	91.000000	0.000000	91.0	91.00	91.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-21 04:00:05.436106	False	0	91

50 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs