Analysis of OSM events in Bugzilla

Date and time of the report: 2023-11-23 05:00:04.971064

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

Bugs considered recent: Since 2023-11-02.

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:

77

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	3	8
Documentation / Wiki	4	0	4
Gerrit	1	0	1
IM-NBI	7	6	13
LCM	5	4	9
MON	2	0	2
N2VC	2	0	2
NG-UI	4	0	4
OSMClient	9	0	9
POL	0	2	2
RO	12	6	18
Robot-tests	4	0	4
Total	56	21	77

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	47	19	66
CONFIRMED	8	1	9
IN_PROGRESS	1	1	2
Total	56	21	77

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	778.000000	NaN	778.0	778.00	778.0	778.00	778.0
1	DEVOPS	8.0	163.375000	138.995311	0.0	20.00	193.5	268.00	344.0
2	Documentation / Wiki	4.0	159.000000	10.099505	153.0	153.00	154.5	160.50	174.0
3	Gerrit	1.0	575.000000	NaN	575.0	575.00	575.0	575.00	575.0
4	IM-NBI	13.0	84.153846	91.328022	8.0	13.00	23.0	194.00	239.0
5	LCM	9.0	209.888889	238.916536	6.0	16.00	110.0	301.00	707.0
6	MON	2.0	250.000000	49.497475	215.0	232.50	250.0	267.50	285.0
7	N2VC	2.0	158.500000	55.861436	119.0	138.75	158.5	178.25	198.0
8	NG-UI	4.0	257.250000	10.500000	252.0	252.00	252.0	257.25	273.0
9	OSMClient	9.0	213.444444	118.412532	119.0	138.00	160.0	212.00	418.0
10	POL	2.0	12.000000	5.656854	8.0	10.00	12.0	14.00	16.0
11	RO	18.0	202.166667	241.153661	0.0	16.75	120.5	318.25	852.0
12	Robot-tests	4.0	159.750000	9.500000	155.0	155.00	155.0	159.75	174.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	2	4	6.0
Documentation / Wiki	1	0	3	4.0
Gerrit	0	0	1	1.0
IM-NBI	1	2	4	7.0
LCM	1	2	3	6.0
MON	0	0	2	2.0
N2VC	0	0	2	2.0
NG-UI	0	1	3	4.0
OSMClient	0	2	7	9.0
POL	0	1	0	1.0
RO	2	2	7	11.0
Robot-tests	1	0	3	4.0
All	6	12	40	58.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	174	4.0	159.000	10.099505	153.0	153.00	154.5	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59.000000	CURRENT	2.0	assigned_to	CURRENT	2023-08-31 23:59:59.000000	False	0	174
1	NaN	2253	2023-08-24 16:59:30	174	4.0	159.750	9.500000	155.0	155.00	155.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59.000000	CURRENT	2.0	cc	CURRENT	2023-08-31 23:59:59.000000	False	0	174
2	NaN	2270	2023-11-10 08:21:04	131	8.0	41.250	49.660994	6.0	11.75	17.5	...	rahul.k4@tataelxsi.co.in	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2023-11-23 04:00:04.996315	False	0	131
3	NaN	2280	2023-11-13 21:03:17	110	4.0	34.750	50.367814	6.0	6.75	11.5	...	rahul.k4@tataelxsi.co.in	2023-11-23 04:00:04.996315	RECENT	1.0	everconfirmed	RECENT	2023-11-23 04:00:04.996315	False	101	110
4	NaN	2281	2023-08-04 08:10:19	110	8.0	41.250	49.660994	6.0	11.75	17.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-08-31 23:59:59.000000	False	0	110
5	NaN	2284	2023-08-09 11:49:19	105	8.0	24.625	32.810876	8.0	11.00	13.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-08-31 23:59:59.000000	False	0	105

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	1603	2023-02-15 00:00:12	852	9.0	358.333333	257.576202	0.0	218.00	350.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	keywords	CURRENT	2023-02-28 23:59:59.000000	False	319	852
1	NaN	1830	2023-11-08 06:14:48	707	3.0	415.666667	254.199397	239.0	270.00	301.0	...	srojas@whitestack.com	2023-07-31 23:59:59	CURRENT	3.0	comment	RECENT	2023-11-23 04:00:04.996315	False	581	707
2	NaN	2019	2023-10-03 15:03:31	573	9.0	358.333333	257.576202	0.0	218.00	350.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-10-31 23:59:59.000000	False	193	573
3	NaN	2164	2023-10-17 17:21:22	434	2.0	251.500000	258.093975	69.0	160.25	251.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-10-31 23:59:59.000000	False	138	434
4	NaN	2176	2023-10-17 16:56:24	418	6.0	247.000000	134.747171	125.0	147.00	193.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-10-31 23:59:59.000000	False	382	418
5	NaN	2177	2023-10-17 17:02:41	415	6.0	247.000000	134.747171	125.0	147.00	193.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-10-31 23:59:59.000000	False	379	415
6	NaN	2219	2023-02-22 17:40:55	273	2.0	262.500000	14.849242	252.0	257.25	262.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59.000000	False	0	273
7	NaN	2223	2023-03-03 13:23:34	268	2.0	144.000000	175.362482	20.0	82.00	144.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-03-31 23:59:59.000000	False	0	268
8	NaN	2241	2023-04-28 14:57:23	208	4.0	164.500000	69.294059	61.0	160.75	194.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-04-30 23:59:59.000000	False	0	208
9	NaN	2299	2023-10-30 17:35:50	23	8.0	24.625000	32.810876	8.0	11.00	13.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-10-31 23:59:59.000000	False	0	23
10	NaN	2301	2023-11-02 10:16:46	20	2.0	10.000000	14.142136	0.0	5.00	10.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2023-11-23 04:00:04.996315	False	0	20
11	NaN	2305	2023-11-06 21:11:09	16	2.0	12.000000	5.656854	8.0	10.00	12.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2023-11-23 04:00:04.996315	False	0	16

12 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	778	1.0	778.000000	NaN	778.0	778.00	778.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-06-30 23:59:59.000000	False	617	778
1	NaN	2015	2023-06-14 14:52:04	575	1.0	575.000000	NaN	575.0	575.00	575.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-06-30 23:59:59.000000	False	317	575
2	NaN	2093	2023-07-19 17:19:49	509	9.0	358.333333	257.576202	0.0	218.00	350.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-07-31 23:59:59.000000	False	248	509
3	NaN	2195	2023-05-15 14:29:20	369	9.0	358.333333	257.576202	0.0	218.00	350.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-05-31 23:59:59.000000	False	0	369
4	NaN	2200	2023-02-07 00:00:27	350	9.0	358.333333	257.576202	0.0	218.00	350.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59.000000	False	0	350
5	NaN	2205	2023-02-13 00:00:24	344	1.0	344.000000	NaN	344.0	344.00	344.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59.000000	False	0	344
6	NaN	2214	2023-03-07 05:29:42	301	3.0	415.666667	254.199397	239.0	270.00	301.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-03-31 23:59:59.000000	False	0	301
7	NaN	2215	2023-02-13 13:26:07	285	1.0	285.000000	NaN	285.0	285.00	285.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59.000000	False	0	285
8	NaN	2221	2023-02-27 15:30:34	268	2.0	268.000000	0.000000	268.0	268.00	268.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59.000000	False	0	268
9	NaN	2222	2023-02-27 15:53:28	268	2.0	268.000000	0.000000	268.0	268.00	268.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59.000000	False	0	268
10	NaN	2225	2023-06-21 13:04:50	252	2.0	262.500000	14.849242	252.0	257.25	262.5	...	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	252
11	NaN	2226	2023-03-15 17:53:51	252	1.0	252.000000	NaN	252.0	252.00	252.0	...	NaN	NaT	NaN	NaN	dependson	CURRENT	2023-03-31 23:59:59.000000	False	0	252
12	NaN	2227	2023-11-08 10:03:11	252	1.0	252.000000	NaN	252.0	252.00	252.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2023-11-23 04:00:04.996315	False	0	252
13	NaN	2229	2023-03-30 11:29:33	239	1.0	239.000000	NaN	239.0	239.00	239.0	...	NaN	NaT	NaN	NaN	short_desc	CURRENT	2023-03-31 23:59:59.000000	False	0	239
14	NaN	2230	2023-03-28 19:37:13	239	3.0	415.666667	254.199397	239.0	270.00	301.0	...	NaN	NaT	NaN	NaN	cc	CURRENT	2023-03-31 23:59:59.000000	False	0	239
15	NaN	2233	2023-04-13 10:02:45	223	9.0	358.333333	257.576202	0.0	218.00	350.0	...	NaN	NaT	NaN	NaN	cc	CURRENT	2023-04-30 23:59:59.000000	False	0	223
16	NaN	2235	2023-06-11 19:42:11	218	9.0	358.333333	257.576202	0.0	218.00	350.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-06-30 23:59:59.000000	False	0	218
17	NaN	2238	2023-04-21 14:35:51	215	1.0	215.000000	NaN	215.0	215.00	215.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-04-30 23:59:59.000000	False	0	215
18	NaN	2240	2023-04-24 16:52:54	212	6.0	247.000000	134.747171	125.0	147.00	193.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-04-30 23:59:59.000000	False	0	212
19	NaN	2242	2023-05-12 12:45:47	198	1.0	198.000000	NaN	198.0	198.00	198.0	...	NaN	NaT	NaN	NaN	version	CURRENT	2023-05-31 23:59:59.000000	False	0	198
20	NaN	2243	2023-05-11 09:09:17	195	4.0	164.500000	69.294059	61.0	160.75	194.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-05-31 23:59:59.000000	False	0	195
21	NaN	2245	2023-07-07 15:44:24	194	4.0	164.500000	69.294059	61.0	160.75	194.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-07-31 23:59:59.000000	False	0	194
22	NaN	2251	2023-08-24 16:59:52	174	6.0	247.000000	134.747171	125.0	147.00	193.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	174
23	NaN	2259	2023-06-15 17:15:02	160	2.0	160.000000	0.000000	160.0	160.00	160.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-06-30 23:59:59.000000	False	0	160
24	NaN	2260	2023-06-15 17:18:45	160	2.0	160.000000	0.000000	160.0	160.00	160.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-06-30 23:59:59.000000	False	0	160
25	NaN	2261	2023-06-21 13:01:39	156	4.0	159.000000	10.099505	153.0	153.00	154.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	156
26	NaN	2263	2023-06-21 12:59:45	155	4.0	159.750000	9.500000	155.0	155.00	155.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	155
27	NaN	2264	2023-06-21 12:59:58	155	4.0	159.750000	9.500000	155.0	155.00	155.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	155
28	NaN	2265	2023-06-21 13:00:12	155	4.0	159.750000	9.500000	155.0	155.00	155.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	155
29	NaN	2266	2023-06-22 15:10:37	153	4.0	159.000000	10.099505	153.0	153.00	154.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	153
30	NaN	2267	2023-06-22 15:10:07	153	4.0	159.000000	10.099505	153.0	153.00	154.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	153
31	NaN	2269	2023-07-07 16:05:57	138	6.0	247.000000	134.747171	125.0	147.00	193.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	138
32	NaN	2271	2023-07-19 18:53:57	131	9.0	358.333333	257.576202	0.0	218.00	350.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-07-31 23:59:59.000000	False	0	131
33	NaN	2274	2023-07-20 15:08:35	125	6.0	247.000000	134.747171	125.0	147.00	193.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	125
34	NaN	2277	2023-07-26 11:00:06	119	1.0	119.000000	NaN	119.0	119.00	119.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-07-31 23:59:59.000000	False	0	119
35	NaN	2278	2023-08-10 09:39:19	119	1.0	119.000000	NaN	119.0	119.00	119.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	119
36	NaN	2279	2023-11-20 21:24:24	119	1.0	119.000000	NaN	119.0	119.00	119.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2023-11-23 04:00:04.996315	False	0	119
37	NaN	2286	2023-09-08 11:17:57	84	1.0	84.000000	NaN	84.0	84.00	84.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-09-30 23:59:59.000000	False	0	84
38	NaN	2287	2023-09-18 23:58:26	69	2.0	251.500000	258.093975	69.0	160.25	251.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-09-30 23:59:59.000000	False	0	69
39	NaN	2288	2023-09-22 15:22:41	61	4.0	164.500000	69.294059	61.0	160.75	194.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-09-30 23:59:59.000000	False	0	61

40 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs