Analysis of OSM events in Bugzilla

Date and time of the report: 2024-04-05 05:00:04.776208

Analysed period: 2020-07-01 to 2024-04-05.

Bugs considered recent: Since 2024-03-15.

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:

93

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	Operational-status is not getting updated when...	2	[v14.0, v14.0]	LCM	2024-03-30 17:07:09
2	Robot testsuite heal_02 fails in a step when c...	2	[Master, v15.0]	Robot-tests	2023-12-20 15:09:20
3	Robot testsuite heal_03 fails when checking if...	2	[Master, v15.0]	Robot-tests	2023-12-20 17:06:32
4	Robot testsuite lcmop_01 fails in daily job wh...	2	[Master, v15.0]	Robot-tests	2023-12-20 14:23:08
5	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	3	0	3
Documentation / Wiki	4	0	4
IM-NBI	11	7	18
LCM	8	10	18
N2VC	1	0	1
NG-SA	1	0	1
NG-UI	3	0	3
OSMClient	7	1	8
POL	1	1	2
RO	23	1	24
Robot-tests	11	0	11
Total	73	20	93

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	67	18	85
CONFIRMED	5	0	5
IN_PROGRESS	1	2	3
Total	73	20	93

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	146.000000	111.216006	31.0	92.50	154.0	203.50	253.0
1	Documentation / Wiki	4.0	293.000000	10.099505	287.0	287.00	288.5	294.50	308.0
2	IM-NBI	18.0	121.388889	108.472897	3.0	16.25	142.0	154.75	342.0
3	LCM	18.0	128.222222	167.597401	2.0	5.00	106.0	133.50	568.0
4	N2VC	1.0	253.000000	NaN	253.0	253.00	253.0	253.00	253.0
5	NG-SA	1.0	65.000000	NaN	65.0	65.00	65.0	65.00	65.0
6	NG-UI	3.0	28.333333	1.154701	27.0	28.00	29.0	29.00	29.0
7	OSMClient	8.0	223.500000	129.932950	5.0	201.00	283.0	297.50	329.0
8	POL	2.0	79.500000	99.702056	9.0	44.25	79.5	114.75	150.0
9	RO	24.0	209.958333	231.728004	6.0	27.25	148.5	265.00	986.0
10	Robot-tests	11.0	174.272727	94.867372	106.0	106.00	106.0	289.00	308.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	5	6	11.0
LCM	2	3	6	11.0
N2VC	0	0	1	1.0
NG-SA	0	0	1	1.0
OSMClient	0	1	5	6.0
POL	0	1	0	1.0
RO	3	3	10	16.0
Robot-tests	0	1	10	11.0
All	6	14	44	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	986	14.0	243.785714	297.485146	21.0	25.0	81.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	CURRENT	2024-03-31 23:59:59	False	319	986
1	NaN	2252	2024-03-13 00:00:19	308	4.0	293.000000	10.099505	287.0	287.0	288.5	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	CURRENT	2024-03-31 23:59:59	False	0	308
2	NaN	2270	2024-03-11 17:26:24	265	9.0	156.444444	73.080625	6.0	142.0	150.0	...	rahul.k4@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	comment	CURRENT	2024-03-31 23:59:59	False	0	265
3	NaN	2281	2024-03-11 17:26:36	244	9.0	156.444444	73.080625	6.0	142.0	150.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	244
4	NaN	2319	2024-03-21 01:00:10	140	10.0	28.900000	52.116216	2.0	3.0	5.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-31 23:59:59	False	125	140
5	NaN	2324	2024-03-11 17:27:26	114	10.0	28.900000	52.116216	2.0	3.0	5.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	114

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	643	14.0	243.785714	297.485146	21.0	25.00	81.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	248	643
1	NaN	2164	2024-04-04 17:28:20	568	3.0	295.000000	240.576391	114.0	158.50	203.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-05 03:00:04.803950	False	138	568
2	NaN	2195	2024-03-11 17:25:24	503	14.0	243.785714	297.485146	21.0	25.00	81.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	503
3	NaN	2214	2024-03-11 17:25:40	435	4.0	257.000000	171.648866	106.0	112.00	243.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	435
4	NaN	2233	2024-03-11 17:25:49	357	14.0	243.785714	297.485146	21.0	25.00	81.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	357
5	NaN	2241	2024-03-11 16:03:32	342	3.0	288.333333	81.131580	195.0	261.50	328.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	342
6	NaN	2251	2024-03-13 00:00:17	308	6.0	242.333333	106.936741	27.0	262.25	283.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	308
7	NaN	2253	2024-03-13 00:00:21	308	7.0	213.285714	100.581168	106.0	106.00	289.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	308
8	NaN	2284	2024-03-11 17:26:38	239	14.0	85.714286	81.066382	3.0	11.50	79.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	239
9	NaN	2299	2024-03-11 17:26:50	157	14.0	85.714286	81.066382	3.0	11.50	79.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	157
10	NaN	2305	2024-03-11 17:26:59	150	2.0	79.500000	99.702056	9.0	44.25	79.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	150
11	NaN	2307	2024-02-20 16:25:14	148	14.0	85.714286	81.066382	3.0	11.50	79.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	148
12	NaN	2308	2024-02-20 16:24:22	148	14.0	85.714286	81.066382	3.0	11.50	79.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	148
13	NaN	2355	2024-03-25 04:52:49	10	10.0	28.900000	52.116216	2.0	3.00	5.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59.000000	False	0	10

14 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	2230	2024-03-11 17:25:47	373	4.0	257.000000	171.648866	106.0	112.00	243.5	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	373
1	NaN	2235	2024-03-11 17:25:51	352	14.0	243.785714	297.485146	21.0	25.00	81.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	352
2	NaN	2243	2024-04-02 17:29:43	329	1.0	329.000000	NaN	329.0	329.00	329.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-05 03:00:04.803950	False	305	329
3	NaN	2245	2024-04-02 17:35:28	328	3.0	288.333333	81.131580	195.0	261.50	328.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-05 03:00:04.803950	False	0	328
4	NaN	2259	2024-03-12 17:32:24	294	6.0	242.333333	106.936741	27.0	262.25	283.0	...	gerardo.garciadeblas@telefonica.com	2024-03-31 23:59:59	CURRENT	1.0	assigned_to	CURRENT	2024-03-31 23:59:59.000000	False	0	294
5	NaN	2260	2024-03-12 17:32:32	294	6.0	242.333333	106.936741	27.0	262.25	283.0	...	gerardo.garciadeblas@telefonica.com	2024-03-31 23:59:59	CURRENT	1.0	assigned_to	CURRENT	2024-03-31 23:59:59.000000	False	0	294
6	NaN	2261	2024-03-11 17:26:07	290	4.0	293.000000	10.099505	287.0	287.00	288.5	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	290
7	NaN	2263	2024-03-11 17:26:10	289	7.0	213.285714	100.581168	106.0	106.00	289.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	289
8	NaN	2264	2024-03-11 17:26:12	289	7.0	213.285714	100.581168	106.0	106.00	289.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	289
9	NaN	2265	2024-03-11 17:26:14	289	7.0	213.285714	100.581168	106.0	106.00	289.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	289
10	NaN	2266	2024-03-11 17:26:17	287	4.0	293.000000	10.099505	287.0	287.00	288.5	...	rahul.k4@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	287
11	NaN	2267	2024-03-11 17:26:19	287	4.0	293.000000	10.099505	287.0	287.00	288.5	...	deepika.e@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	287
12	NaN	2269	2024-03-11 17:26:21	272	6.0	242.333333	106.936741	27.0	262.25	283.0	...	ramerama@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	272
13	NaN	2271	2024-03-11 17:26:26	265	14.0	243.785714	297.485146	21.0	25.00	81.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	265
14	NaN	2274	2024-03-11 17:26:28	259	6.0	242.333333	106.936741	27.0	262.25	283.0	...	deepika.e@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	259
15	NaN	2277	2024-03-11 17:26:31	253	1.0	253.000000	NaN	253.0	253.00	253.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	253
16	NaN	2278	2024-03-11 17:26:33	253	1.0	253.000000	NaN	253.0	253.00	253.0	...	guillermo.calvino@canonical.com	2023-07-31 23:59:59	CURRENT	1.0	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	253
17	NaN	2286	2024-03-11 17:26:41	218	1.0	218.000000	NaN	218.0	218.00	218.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	218
18	NaN	2287	2024-03-11 17:26:43	203	3.0	295.000000	240.576391	114.0	158.50	203.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	203
19	NaN	2288	2024-03-11 17:26:45	195	3.0	288.333333	81.131580	195.0	261.50	328.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	195
20	NaN	2298	2024-03-11 17:26:47	161	9.0	156.444444	73.080625	6.0	142.00	150.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	161
21	NaN	2301	2024-03-11 17:26:52	154	1.0	154.000000	NaN	154.0	154.00	154.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	154
22	NaN	2303	2024-03-11 17:26:54	153	9.0	156.444444	73.080625	6.0	142.00	150.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	153
23	NaN	2306	2024-03-11 17:27:01	150	9.0	156.444444	73.080625	6.0	142.00	150.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	150
24	NaN	2310	2024-03-11 17:27:04	147	9.0	156.444444	73.080625	6.0	142.00	150.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	147
25	NaN	2312	2024-03-19 00:00:37	146	14.0	85.714286	81.066382	3.0	11.50	79.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-31 23:59:59.000000	False	0	146
26	NaN	2313	2024-03-22 00:00:41	142	14.0	85.714286	81.066382	3.0	11.50	79.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-31 23:59:59.000000	False	0	142
27	NaN	2314	2024-02-20 16:27:21	142	14.0	85.714286	81.066382	3.0	11.50	79.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	142
28	NaN	2316	2024-03-11 17:27:12	142	9.0	156.444444	73.080625	6.0	142.00	150.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	142
29	NaN	2318	2024-03-11 17:27:14	140	9.0	156.444444	73.080625	6.0	142.00	150.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	140
30	NaN	2320	2024-03-11 17:27:19	134	14.0	243.785714	297.485146	21.0	25.00	81.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	134
31	NaN	2322	2024-03-11 17:27:21	120	1.0	120.000000	NaN	120.0	120.00	120.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	120
32	NaN	2323	2024-03-11 17:27:23	114	4.0	257.000000	171.648866	106.0	112.00	243.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	114
33	NaN	2325	2024-03-11 17:27:28	114	3.0	295.000000	240.576391	114.0	158.50	203.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	114
34	NaN	2326	2024-02-05 18:34:33	106	4.0	106.000000	0.000000	106.0	106.00	106.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	106
35	NaN	2328	2024-03-14 15:35:49	106	4.0	257.000000	171.648866	106.0	112.00	243.5	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2024-03-31 23:59:59.000000	False	85	106
36	NaN	2329	2024-03-21 00:35:22	106	1.0	106.000000	NaN	106.0	106.00	106.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-31 23:59:59.000000	False	91	106
37	NaN	2330	2024-03-11 17:27:36	106	7.0	213.285714	100.581168	106.0	106.00	289.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	106
38	NaN	2331	2024-03-11 17:27:39	106	4.0	106.000000	0.000000	106.0	106.00	106.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	106
39	NaN	2332	2024-04-04 00:00:48	106	7.0	213.285714	100.581168	106.0	106.00	289.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-05 03:00:04.803950	False	0	106
40	NaN	2333	2024-03-11 17:27:42	106	4.0	106.000000	0.000000	106.0	106.00	106.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	106
41	NaN	2334	2024-03-11 17:27:44	106	7.0	213.285714	100.581168	106.0	106.00	289.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	106
42	NaN	2335	2024-03-11 17:27:46	106	4.0	106.000000	0.000000	106.0	106.00	106.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	106
43	NaN	2337	2024-02-06 11:50:52	65	1.0	65.000000	NaN	65.0	65.00	65.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	65

44 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs