Analysis of OSM events in Bugzilla

Date and time of the report: 2023-11-07 05:00:05.076061

Analysed period: 2020-07-01 to 2023-11-07.

Bugs considered recent: Since 2023-10-17.

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:

75

Bugs present in multiple branches:

	BUG_DESCRIPTION	NUM_BRANCHES	RELEASE	MODULE	TIMESTAMP
0	Registration of K8s cluster fails through the GUI	3	[Master, v13.0, v12.0]	NG-UI	2023-03-15 17:43:13
1	Unable to install OSM in air-gapped environmet	2	[Master, v14.0]	DEVOPS	2023-11-02 10:16:24

Number of bugs per module

AGE	CURRENT	RECENT	Total
MODULE
Bugzilla	1	0	1
DEVOPS	5	2	7
Documentation / Wiki	4	0	4
Gerrit	1	0	1
IM-NBI	6	1	7
LCM	6	1	7
MON	2	0	2
N2VC	2	0	2
NG-SA	0	1	1
NG-UI	12	0	12
OSMClient	7	2	9
POL	0	1	1
RO	13	4	17
Robot-tests	4	0	4
Total	63	12	75

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	56	10	66
CONFIRMED	6	2	8
IN_PROGRESS	1	0	1
Total	63	12	75

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	Bugzilla	1.0	762.000000	NaN	762.0	762.00	762.0	762.00	762.0
1	DEVOPS	7.0	170.714286	132.119535	4.0	53.50	252.0	252.00	328.0
2	Documentation / Wiki	4.0	143.000000	10.099505	137.0	137.00	138.5	144.50	158.0
3	Gerrit	1.0	559.000000	NaN	559.0	559.00	559.0	559.00	559.0
4	IM-NBI	7.0	130.428571	82.897240	7.0	67.00	178.0	185.50	223.0
5	LCM	7.0	252.000000	241.618156	0.0	73.50	223.0	351.50	691.0
6	MON	2.0	234.000000	49.497475	199.0	216.50	234.0	251.50	269.0
7	N2VC	2.0	142.500000	55.861436	103.0	122.75	142.5	162.25	182.0
8	NG-SA	1.0	12.000000	NaN	12.0	12.00	12.0	12.00	12.0
9	NG-UI	12.0	114.416667	107.949027	24.0	25.00	33.5	236.00	257.0
10	OSMClient	9.0	197.444444	118.412532	103.0	122.00	144.0	196.00	402.0
11	POL	1.0	0.000000	NaN	0.0	0.00	0.0	0.00	0.0
12	RO	17.0	215.470588	231.805446	0.0	68.00	125.0	334.00	836.0
13	Robot-tests	4.0	143.750000	9.500000	139.0	139.00	139.0	143.75	158.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
Bugzilla	0	0	1	1.0
DEVOPS	0	1	4	5.0
Documentation / Wiki	1	0	3	4.0
Gerrit	0	0	1	1.0
IM-NBI	0	2	3	5.0
LCM	0	3	2	5.0
MON	0	0	2	2.0
N2VC	0	0	2	2.0
NG-UI	1	1	4	6.0
OSMClient	0	2	7	9.0
RO	0	4	9	13.0
Robot-tests	1	0	3	4.0
All	3	13	41	57.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	2252	2023-08-24 16:59:46	158	4.0	143.000000	10.099505	137.0	137.0	138.5	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	assigned_to	CURRENT	2023-08-31 23:59:59	False	0	158
1	NaN	2253	2023-08-24 16:59:30	158	4.0	143.750000	9.500000	139.0	139.0	139.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	cc	CURRENT	2023-08-31 23:59:59	False	0	158
2	NaN	2289	2023-10-11 11:28:41	41	7.0	27.428571	6.023762	24.0	25.0	25.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-10-31 23:59:59	False	0	41

3 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	1603	2023-02-15 00:00:12	836	11.0	306.545455	242.594874	4.0	135.50	207.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	keywords	CURRENT	2023-02-28 23:59:59	False	319	836
1	NaN	1830	2023-10-07 00:50:10	691	3.0	399.666667	254.199397	223.0	254.00	285.0	...	srojas@whitestack.com	2023-07-31 23:59:59	CURRENT	3.0	comment	CURRENT	2023-10-31 23:59:59	False	581	691
2	NaN	2019	2023-10-03 15:03:31	557	11.0	306.545455	242.594874	4.0	135.50	207.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-10-31 23:59:59	False	193	557
3	NaN	2093	2023-07-19 17:19:49	493	11.0	306.545455	242.594874	4.0	135.50	207.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-07-31 23:59:59	False	248	493
4	NaN	2164	2023-10-17 17:21:22	418	2.0	235.500000	258.093975	53.0	144.25	235.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2023-10-31 23:59:59	False	138	418
5	NaN	2176	2023-10-17 16:56:24	402	6.0	231.000000	134.747171	109.0	131.00	177.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2023-10-31 23:59:59	False	382	402
6	NaN	2177	2023-10-17 17:02:41	399	6.0	231.000000	134.747171	109.0	131.00	177.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2023-10-31 23:59:59	False	379	399
7	NaN	2219	2023-02-22 17:40:55	257	3.0	236.333333	20.502032	216.0	226.00	236.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59	False	0	257
8	NaN	2223	2023-03-03 13:23:34	252	2.0	128.000000	175.362482	4.0	66.00	128.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-03-31 23:59:59	False	0	252
9	NaN	2241	2023-04-28 14:57:23	192	4.0	148.500000	69.294059	45.0	144.75	178.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-04-30 23:59:59	False	0	192
10	NaN	2270	2023-08-04 11:07:18	115	5.0	44.600000	55.329016	0.0	3.00	11.0	...	rahul.k4@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	version	CURRENT	2023-08-31 23:59:59	False	0	115
11	NaN	2280	2023-08-24 19:42:22	94	2.0	47.000000	66.468037	0.0	23.50	47.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-08-31 23:59:59	False	0	94
12	NaN	2284	2023-08-09 11:49:19	89	2.0	48.000000	57.982756	7.0	27.50	48.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-08-31 23:59:59	False	0	89

13 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	1683	2023-06-14 13:12:23	762	1.0	762.000000	NaN	762.0	762.00	762.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-06-30 23:59:59.000000	False	617	762
1	NaN	2015	2023-06-14 14:52:04	559	1.0	559.000000	NaN	559.0	559.00	559.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-06-30 23:59:59.000000	False	317	559
2	NaN	2195	2023-05-15 14:29:20	353	11.0	306.545455	242.594874	4.0	135.50	207.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-05-31 23:59:59.000000	False	0	353
3	NaN	2200	2023-02-07 00:00:27	334	11.0	306.545455	242.594874	4.0	135.50	207.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59.000000	False	0	334
4	NaN	2205	2023-02-13 00:00:24	328	1.0	328.000000	NaN	328.0	328.00	328.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59.000000	False	0	328
5	NaN	2214	2023-03-07 05:29:42	285	3.0	399.666667	254.199397	223.0	254.00	285.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-03-31 23:59:59.000000	False	0	285
6	NaN	2215	2023-02-13 13:26:07	269	1.0	269.000000	NaN	269.0	269.00	269.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59.000000	False	0	269
7	NaN	2221	2023-02-27 15:30:34	252	2.0	252.000000	0.000000	252.0	252.00	252.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59.000000	False	0	252
8	NaN	2222	2023-02-27 15:53:28	252	2.0	252.000000	0.000000	252.0	252.00	252.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59.000000	False	0	252
9	NaN	2225	2023-06-21 13:04:50	236	3.0	236.333333	20.502032	216.0	226.00	236.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	2.0	assigned_to	CURRENT	2023-06-30 23:59:59.000000	False	0	236
10	NaN	2226	2023-03-15 17:53:51	236	1.0	236.000000	NaN	236.0	236.00	236.0	...	NaN	NaT	NaN	NaN	dependson	CURRENT	2023-03-31 23:59:59.000000	False	0	236
11	NaN	2227	2023-03-15 17:53:51	236	1.0	236.000000	NaN	236.0	236.00	236.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-03-31 23:59:59.000000	False	0	236
12	NaN	2229	2023-03-30 11:29:33	223	1.0	223.000000	NaN	223.0	223.00	223.0	...	NaN	NaT	NaN	NaN	short_desc	CURRENT	2023-03-31 23:59:59.000000	False	0	223
13	NaN	2230	2023-03-28 19:37:13	223	3.0	399.666667	254.199397	223.0	254.00	285.0	...	NaN	NaT	NaN	NaN	cc	CURRENT	2023-03-31 23:59:59.000000	False	0	223
14	NaN	2232	2023-09-19 06:21:23	216	3.0	236.333333	20.502032	216.0	226.00	236.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-09-30 23:59:59.000000	False	0	216
15	NaN	2233	2023-04-13 10:02:45	207	11.0	306.545455	242.594874	4.0	135.50	207.0	...	NaN	NaT	NaN	NaN	cc	CURRENT	2023-04-30 23:59:59.000000	False	0	207
16	NaN	2235	2023-06-11 19:42:11	202	11.0	306.545455	242.594874	4.0	135.50	207.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-06-30 23:59:59.000000	False	0	202
17	NaN	2238	2023-04-21 14:35:51	199	1.0	199.000000	NaN	199.0	199.00	199.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-04-30 23:59:59.000000	False	0	199
18	NaN	2240	2023-04-24 16:52:54	196	6.0	231.000000	134.747171	109.0	131.00	177.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-04-30 23:59:59.000000	False	0	196
19	NaN	2242	2023-05-12 12:45:47	182	1.0	182.000000	NaN	182.0	182.00	182.0	...	NaN	NaT	NaN	NaN	version	CURRENT	2023-05-31 23:59:59.000000	False	0	182
20	NaN	2243	2023-05-11 09:09:17	179	4.0	148.500000	69.294059	45.0	144.75	178.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-05-31 23:59:59.000000	False	0	179
21	NaN	2245	2023-07-07 15:44:24	178	4.0	148.500000	69.294059	45.0	144.75	178.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-07-31 23:59:59.000000	False	0	178
22	NaN	2251	2023-08-24 16:59:52	158	6.0	231.000000	134.747171	109.0	131.00	177.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	assigned_to	CURRENT	2023-08-31 23:59:59.000000	False	0	158
23	NaN	2255	2023-08-24 16:59:09	146	11.0	306.545455	242.594874	4.0	135.50	207.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	assigned_to	CURRENT	2023-08-31 23:59:59.000000	False	0	146
24	NaN	2259	2023-06-15 17:15:02	144	2.0	144.000000	0.000000	144.0	144.00	144.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-06-30 23:59:59.000000	False	0	144
25	NaN	2260	2023-06-15 17:18:45	144	2.0	144.000000	0.000000	144.0	144.00	144.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-06-30 23:59:59.000000	False	0	144
26	NaN	2261	2023-06-21 13:01:39	140	4.0	143.000000	10.099505	137.0	137.00	138.5	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	assigned_to	CURRENT	2023-06-30 23:59:59.000000	False	0	140
27	NaN	2263	2023-06-21 12:59:45	139	4.0	143.750000	9.500000	139.0	139.00	139.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	assigned_to	CURRENT	2023-06-30 23:59:59.000000	False	0	139
28	NaN	2264	2023-06-21 12:59:58	139	4.0	143.750000	9.500000	139.0	139.00	139.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	assigned_to	CURRENT	2023-06-30 23:59:59.000000	False	0	139
29	NaN	2265	2023-06-21 13:00:12	139	4.0	143.750000	9.500000	139.0	139.00	139.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	assigned_to	CURRENT	2023-06-30 23:59:59.000000	False	0	139
30	NaN	2266	2023-06-22 15:10:37	137	4.0	143.000000	10.099505	137.0	137.00	138.5	...	rahul.k4@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	assigned_to	CURRENT	2023-06-30 23:59:59.000000	False	0	137
31	NaN	2267	2023-06-22 15:10:07	137	4.0	143.000000	10.099505	137.0	137.00	138.5	...	deepika.e@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	assigned_to	CURRENT	2023-06-30 23:59:59.000000	False	0	137
32	NaN	2268	2023-11-06 12:52:19	125	11.0	306.545455	242.594874	4.0	135.50	207.0	...	gerardo.garciadeblas@telefonica.com	2023-07-31 23:59:59	CURRENT	1.0	comment	RECENT	2023-11-07 04:00:05.104186	False	0	125
33	NaN	2269	2023-07-07 16:05:57	122	6.0	231.000000	134.747171	109.0	131.00	177.0	...	ramerama@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	version	CURRENT	2023-07-31 23:59:59.000000	False	0	122
34	NaN	2271	2023-07-19 18:53:57	115	11.0	306.545455	242.594874	4.0	135.50	207.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-07-31 23:59:59.000000	False	0	115
35	NaN	2274	2023-07-20 15:08:35	109	6.0	231.000000	134.747171	109.0	131.00	177.0	...	deepika.e@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	assigned_to	CURRENT	2023-07-31 23:59:59.000000	False	0	109
36	NaN	2277	2023-07-26 11:00:06	103	1.0	103.000000	NaN	103.0	103.00	103.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-07-31 23:59:59.000000	False	0	103
37	NaN	2278	2023-08-10 09:39:19	103	1.0	103.000000	NaN	103.0	103.00	103.0	...	guillermo.calvino@canonical.com	2023-07-31 23:59:59	CURRENT	1.0	bug_severity	CURRENT	2023-08-31 23:59:59.000000	False	0	103
38	NaN	2279	2023-07-27 01:01:52	103	1.0	103.000000	NaN	103.0	103.00	103.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-07-31 23:59:59.000000	False	0	103
39	NaN	2281	2023-08-04 08:10:19	94	5.0	44.600000	55.329016	0.0	3.00	11.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-08-31 23:59:59.000000	False	0	94
40	NaN	2286	2023-09-08 11:17:57	68	1.0	68.000000	NaN	68.0	68.00	68.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-09-30 23:59:59.000000	False	0	68

41 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs