Analysis of OSM events in Bugzilla

Date and time of the report: 2024-03-25 05:00:05.735175

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

Bugs considered recent: Since 2024-03-04.

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:

81

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	4	16
LCM	7	3	10
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	20	81

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	57	15	72
CONFIRMED	4	2	6
IN_PROGRESS	0	3	3
Total	61	20	81

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	135.000000	111.216006	20.0	81.50	143.0	192.50	242.0
1	Documentation / Wiki	4.0	282.000000	10.099505	276.0	276.00	277.5	283.50	297.0
2	IM-NBI	16.0	167.687500	115.911299	5.0	125.50	137.0	250.25	362.0
3	LCM	10.0	216.300000	168.850394	95.0	103.00	116.0	319.50	557.0
4	N2VC	1.0	242.000000	NaN	242.0	242.00	242.0	242.00	242.0
5	NG-SA	1.0	54.000000	NaN	54.0	54.00	54.0	54.00	54.0
6	NG-UI	3.0	17.333333	1.154701	16.0	17.00	18.0	18.00	18.0
7	OSMClient	7.0	275.571429	152.409380	16.0	254.50	283.0	290.00	541.0
8	POL	1.0	139.000000	NaN	139.0	139.00	139.0	139.00	139.0
9	RO	24.0	199.250000	231.464384	2.0	16.25	137.5	254.00	975.0
10	Robot-tests	11.0	163.272727	94.867372	95.0	95.00	95.0	278.00	297.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	975	15.0	217.400000	292.791686	2.0	13.50	17.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2024-03-25 04:00:05.761895	False	319	975
1	NaN	2176	2024-03-22 13:35:30	541	7.0	275.571429	152.409380	16.0	254.50	283.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	382	541
2	NaN	2252	2024-03-13 00:00:19	297	4.0	282.000000	10.099505	276.0	276.00	277.5	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-25 04:00:05.761895	False	0	297
3	NaN	2270	2024-03-11 17:26:24	254	8.0	164.250000	49.660994	129.0	134.75	140.5	...	rahul.k4@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-25 04:00:05.761895	False	0	254
4	NaN	2281	2024-03-11 17:26:36	233	8.0	164.250000	49.660994	129.0	134.75	140.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	233

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	632	15.0	217.400000	292.791686	2.0	13.50	17.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	248	632
1	NaN	2164	2024-03-11 17:25:10	557	3.0	284.000000	240.576391	103.0	147.50	192.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	138	557
2	NaN	2195	2024-03-11 17:25:24	492	15.0	217.400000	292.791686	2.0	13.50	17.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	492
3	NaN	2214	2024-03-11 17:25:40	424	4.0	246.000000	171.648866	95.0	101.00	232.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	424
4	NaN	2233	2024-03-11 17:25:49	346	15.0	217.400000	292.791686	2.0	13.50	17.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-25 04:00:05.761895	False	0	346
5	NaN	2241	2024-03-11 16:03:32	331	4.0	287.500000	69.294059	184.0	283.75	317.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	331
6	NaN	2251	2024-03-13 00:00:17	297	7.0	275.571429	152.409380	16.0	254.50	283.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-25 04:00:05.761895	False	0	297
7	NaN	2253	2024-03-13 00:00:21	297	7.0	202.285714	100.581168	95.0	95.00	278.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-25 04:00:05.761895	False	0	297
8	NaN	2284	2024-03-11 17:26:38	228	10.0	106.200000	75.053759	5.0	37.25	133.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	228
9	NaN	2299	2024-03-11 17:26:50	146	10.0	106.200000	75.053759	5.0	37.25	133.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	146
10	NaN	2319	2024-03-21 01:00:10	129	2.0	116.000000	18.384776	103.0	109.50	116.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-25 04:00:05.761895	False	125	129

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	362	1.0	362.000000	NaN	362.0	362.00	362.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	362
1	NaN	2230	2024-03-11 17:25:47	362	4.0	246.000000	171.648866	95.0	101.00	232.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-25 04:00:05.761895	False	0	362
2	NaN	2235	2024-03-11 17:25:51	341	15.0	217.400000	292.791686	2.0	13.50	17.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-25 04:00:05.761895	False	0	341
3	NaN	2243	2024-03-11 17:29:12	318	4.0	287.500000	69.294059	184.0	283.75	317.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-25 04:00:05.761895	False	305	318
4	NaN	2245	2024-02-21 12:49:36	317	4.0	287.500000	69.294059	184.0	283.75	317.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	317
5	NaN	2259	2024-03-12 17:32:24	283	7.0	275.571429	152.409380	16.0	254.50	283.0	...	gerardo.garciadeblas@telefonica.com	2024-03-25 04:00:05.761895	RECENT	1.0	assigned_to	RECENT	2024-03-25 04:00:05.761895	False	0	283
6	NaN	2260	2024-03-12 17:32:32	283	7.0	275.571429	152.409380	16.0	254.50	283.0	...	gerardo.garciadeblas@telefonica.com	2024-03-25 04:00:05.761895	RECENT	1.0	assigned_to	RECENT	2024-03-25 04:00:05.761895	False	0	283
7	NaN	2261	2024-03-11 17:26:07	279	4.0	282.000000	10.099505	276.0	276.00	277.5	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-25 04:00:05.761895	False	0	279
8	NaN	2263	2024-03-11 17:26:10	278	7.0	202.285714	100.581168	95.0	95.00	278.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-25 04:00:05.761895	False	0	278
9	NaN	2264	2024-03-11 17:26:12	278	7.0	202.285714	100.581168	95.0	95.00	278.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-25 04:00:05.761895	False	0	278
10	NaN	2265	2024-03-11 17:26:14	278	7.0	202.285714	100.581168	95.0	95.00	278.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-25 04:00:05.761895	False	0	278
11	NaN	2266	2024-03-11 17:26:17	276	4.0	282.000000	10.099505	276.0	276.00	277.5	...	rahul.k4@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-25 04:00:05.761895	False	0	276
12	NaN	2267	2024-03-11 17:26:19	276	4.0	282.000000	10.099505	276.0	276.00	277.5	...	deepika.e@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-25 04:00:05.761895	False	0	276
13	NaN	2269	2024-03-11 17:26:21	261	7.0	275.571429	152.409380	16.0	254.50	283.0	...	ramerama@tataelxsi.co.in	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-25 04:00:05.761895	False	0	261
14	NaN	2271	2024-03-11 17:26:26	254	15.0	217.400000	292.791686	2.0	13.50	17.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	254
15	NaN	2274	2024-03-11 17:26:28	248	7.0	275.571429	152.409380	16.0	254.50	283.0	...	deepika.e@tataelxsi.co.in	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-25 04:00:05.761895	False	0	248
16	NaN	2277	2024-03-11 17:26:31	242	1.0	242.000000	NaN	242.0	242.00	242.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	242
17	NaN	2278	2024-03-11 17:26:33	242	1.0	242.000000	NaN	242.0	242.00	242.0	...	guillermo.calvino@canonical.com	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-25 04:00:05.761895	False	0	242
18	NaN	2286	2024-03-11 17:26:41	207	1.0	207.000000	NaN	207.0	207.00	207.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	207
19	NaN	2287	2024-03-11 17:26:43	192	3.0	284.000000	240.576391	103.0	147.50	192.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	192
20	NaN	2288	2024-03-11 17:26:45	184	4.0	287.500000	69.294059	184.0	283.75	317.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	184
21	NaN	2298	2024-03-11 17:26:47	150	8.0	164.250000	49.660994	129.0	134.75	140.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	150
22	NaN	2301	2024-03-11 17:26:52	143	1.0	143.000000	NaN	143.0	143.00	143.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	143
23	NaN	2303	2024-03-11 17:26:54	142	8.0	164.250000	49.660994	129.0	134.75	140.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	142
24	NaN	2305	2024-03-11 17:26:59	139	1.0	139.000000	NaN	139.0	139.00	139.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	139
25	NaN	2306	2024-03-11 17:27:01	139	8.0	164.250000	49.660994	129.0	134.75	140.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	139
26	NaN	2307	2024-02-20 16:25:14	137	10.0	106.200000	75.053759	5.0	37.25	133.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	137
27	NaN	2308	2024-02-20 16:24:22	137	10.0	106.200000	75.053759	5.0	37.25	133.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	137
28	NaN	2310	2024-03-11 17:27:04	136	8.0	164.250000	49.660994	129.0	134.75	140.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	136
29	NaN	2312	2024-03-19 00:00:37	135	10.0	106.200000	75.053759	5.0	37.25	133.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-25 04:00:05.761895	False	0	135
30	NaN	2313	2024-03-22 00:00:41	131	10.0	106.200000	75.053759	5.0	37.25	133.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-25 04:00:05.761895	False	0	131
31	NaN	2314	2024-02-20 16:27:21	131	10.0	106.200000	75.053759	5.0	37.25	133.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	131
32	NaN	2316	2024-03-11 17:27:12	131	8.0	164.250000	49.660994	129.0	134.75	140.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	131
33	NaN	2318	2024-03-11 17:27:14	129	8.0	164.250000	49.660994	129.0	134.75	140.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	129
34	NaN	2320	2024-03-11 17:27:19	123	15.0	217.400000	292.791686	2.0	13.50	17.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	123
35	NaN	2322	2024-03-11 17:27:21	109	1.0	109.000000	NaN	109.0	109.00	109.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	109
36	NaN	2323	2024-03-11 17:27:23	103	4.0	246.000000	171.648866	95.0	101.00	232.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	103
37	NaN	2324	2024-03-11 17:27:26	103	2.0	116.000000	18.384776	103.0	109.50	116.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	103
38	NaN	2325	2024-03-11 17:27:28	103	3.0	284.000000	240.576391	103.0	147.50	192.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	103
39	NaN	2326	2024-02-05 18:34:33	95	4.0	95.000000	0.000000	95.0	95.00	95.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	95
40	NaN	2328	2024-03-14 15:35:49	95	4.0	246.000000	171.648866	95.0	101.00	232.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-25 04:00:05.761895	False	85	95
41	NaN	2329	2024-03-21 00:35:22	95	1.0	95.000000	NaN	95.0	95.00	95.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-25 04:00:05.761895	False	91	95
42	NaN	2330	2024-03-11 17:27:36	95	7.0	202.285714	100.581168	95.0	95.00	278.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-25 04:00:05.761895	False	0	95
43	NaN	2331	2024-03-11 17:27:39	95	4.0	95.000000	0.000000	95.0	95.00	95.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-25 04:00:05.761895	False	0	95
44	NaN	2332	2024-02-02 14:50:02	95	7.0	202.285714	100.581168	95.0	95.00	278.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	95
45	NaN	2333	2024-03-11 17:27:42	95	4.0	95.000000	0.000000	95.0	95.00	95.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	95
46	NaN	2334	2024-03-11 17:27:44	95	7.0	202.285714	100.581168	95.0	95.00	278.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	95
47	NaN	2335	2024-03-11 17:27:46	95	4.0	95.000000	0.000000	95.0	95.00	95.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-25 04:00:05.761895	False	0	95

48 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs