Analysis of OSM events in Bugzilla

Date and time of the report: 2024-06-11 05:00:05.311688

Analysed period: 2020-07-01 to 2024-06-11.

Bugs considered recent: Since 2024-05-21.

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:

62

Bugs present in multiple branches:

	BUG_DESCRIPTION	NUM_BRANCHES	RELEASE	MODULE	TIMESTAMP
0	Operational-status is not getting updated when...	2	[v14.0, v14.0]	LCM	2024-03-30 17:08:31
1	Robot testsuite heal_02 fails in a step when c...	2	[Master, v15.0]	Robot-tests	2024-05-07 09:42:34
2	Robot testsuite heal_03 fails when checking if...	2	[Master, v15.0]	Robot-tests	2024-05-07 09:44:42
3	Robot testsuite lcmop_01 fails in daily job wh...	2	[Master, v15.0]	Robot-tests	2024-05-07 09:43:12
4	Static Inactive session timeout for a user	2	[v14.0, Master]	NG-UI	2024-04-01 13:37:44

Number of bugs per module

AGE	CURRENT	RECENT	Total
MODULE
DEVOPS	1	0	1
IM-NBI	18	2	20
LCM	6	3	9
MON	1	0	1
NG-SA	1	0	1
NG-UI	0	1	1
OSMClient	4	0	4
RO	9	9	18
Robot-tests	7	0	7
Total	47	15	62

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	32	4	36
UNCONFIRMED	2	0	2
CONFIRMED	12	9	21
IN_PROGRESS	1	2	3
Total	47	15	62

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	1.0	98.000000	NaN	98.0	98.00	98.0	98.0	98.0
1	IM-NBI	20.0	136.000000	117.001574	7.0	61.00	83.5	210.0	409.0
2	LCM	9.0	175.111111	211.173178	69.0	70.00	72.0	77.0	635.0
3	MON	1.0	217.000000	NaN	217.0	217.00	217.0	217.0	217.0
4	NG-SA	1.0	132.000000	NaN	132.0	132.00	132.0	132.0	132.0
5	NG-UI	1.0	0.000000	NaN	0.0	0.00	0.0	0.0	0.0
6	OSMClient	4.0	122.250000	182.549308	25.0	31.75	34.0	124.5	396.0
7	RO	18.0	203.777778	128.961716	7.0	89.50	215.5	304.5	424.0
8	Robot-tests	7.0	199.142857	69.167499	173.0	173.00	173.0	173.0	356.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	1	1.0
IM-NBI	0	4	11	15.0
LCM	1	0	8	9.0
MON	0	0	1	1.0
NG-SA	0	0	1	1.0
OSMClient	0	0	1	1.0
RO	1	3	12	16.0
Robot-tests	1	0	6	7.0
All	3	7	41	51.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	2263	2024-06-10 17:33:21	356	4.0	218.750000	91.500000	173.0	173.0	173.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	comment	RECENT	2024-06-11 03:00:05.341501	False	322	356
1	NaN	2281	2024-06-04 17:07:10	311	8.0	188.250000	89.961500	34.0	175.0	215.5	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2024-06-11 03:00:05.341501	False	305	311
2	NaN	2355	2024-05-26 00:00:34	77	7.0	71.571429	2.760262	69.0	69.5	72.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-05-31 23:59:59.000000	False	0	77

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	2233	2024-05-12 00:00:15	424	9.0	208.555556	164.828025	7.0	89.0	95.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-05-31 23:59:59.000000	False	0	424
1	NaN	2235	2024-05-12 00:00:18	419	9.0	208.555556	164.828025	7.0	89.0	95.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-05-31 23:59:59.000000	False	0	419
2	NaN	2241	2024-05-12 00:00:20	409	2.0	402.000000	9.899495	395.0	398.5	402.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-05-31 23:59:59.000000	False	0	409
3	NaN	2298	2024-06-04 17:20:18	228	8.0	188.250000	89.961500	34.0	175.0	215.5	...	NaN	NaT	NaN	NaN	resolution	RECENT	2024-06-11 03:00:05.341501	False	221	228
4	NaN	2307	2024-05-23 17:06:19	215	17.0	101.705882	77.416701	7.0	34.0	77.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-05-31 23:59:59.000000	False	0	215
5	NaN	2308	2024-06-10 12:45:25	215	17.0	101.705882	77.416701	7.0	34.0	77.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-06-11 03:00:05.341501	False	0	215
6	NaN	2312	2024-06-05 00:00:16	213	17.0	101.705882	77.416701	7.0	34.0	77.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-06-11 03:00:05.341501	False	0	213

7 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	2164	2024-06-10 17:26:28	635	1.0	635.000000	NaN	635.0	635.0	635.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-06-11 03:00:05.341501	False	138	635
1	NaN	2230	2024-05-29 21:53:02	440	1.0	440.000000	NaN	440.0	440.0	440.0	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2024-05-31 23:59:59.000000	False	428	440
2	NaN	2243	2024-06-10 17:31:26	396	1.0	396.000000	NaN	396.0	396.0	396.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-06-11 03:00:05.341501	False	305	396
3	NaN	2245	2024-06-03 00:00:16	395	2.0	402.000000	9.899495	395.0	398.5	402.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-06-11 03:00:05.341501	False	0	395
4	NaN	2270	2024-06-10 17:35:14	332	9.0	208.555556	164.828025	7.0	89.0	95.0	...	rahul.k4@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-06-11 03:00:05.341501	False	312	332
5	NaN	2271	2024-06-10 17:35:49	332	9.0	208.555556	164.828025	7.0	89.0	95.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-06-11 03:00:05.341501	False	326	332
6	NaN	2286	2024-04-10 08:42:42	285	1.0	285.000000	NaN	285.0	285.0	285.0	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2024-04-30 23:59:59.000000	False	223	285
7	NaN	2303	2024-05-21 17:21:01	220	8.0	188.250000	89.961500	34.0	175.0	215.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-05-31 23:59:59.000000	False	200	220
8	NaN	2305	2024-05-07 17:39:02	217	1.0	217.000000	NaN	217.0	217.0	217.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-05-31 23:59:59.000000	False	182	217
9	NaN	2306	2024-05-27 09:27:30	217	8.0	188.250000	89.961500	34.0	175.0	215.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-05-31 23:59:59.000000	False	196	217
10	NaN	2310	2024-05-21 17:17:37	214	8.0	188.250000	89.961500	34.0	175.0	215.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-05-31 23:59:59.000000	False	194	214
11	NaN	2313	2024-05-24 00:00:15	209	17.0	101.705882	77.416701	7.0	34.0	77.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-05-31 23:59:59.000000	False	0	209
12	NaN	2314	2024-05-08 00:00:12	209	17.0	101.705882	77.416701	7.0	34.0	77.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-05-31 23:59:59.000000	False	0	209
13	NaN	2316	2024-06-03 10:44:17	209	8.0	188.250000	89.961500	34.0	175.0	215.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-06-11 03:00:05.341501	False	188	209
14	NaN	2322	2024-05-20 15:57:54	187	1.0	187.000000	NaN	187.0	187.0	187.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-05-31 23:59:59.000000	False	132	187
15	NaN	2330	2024-05-07 09:43:21	173	4.0	218.750000	91.500000	173.0	173.0	173.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	keywords	CURRENT	2024-05-31 23:59:59.000000	False	138	173
16	NaN	2331	2024-05-07 09:43:47	173	3.0	173.000000	0.000000	173.0	173.0	173.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	keywords	CURRENT	2024-05-31 23:59:59.000000	False	138	173
17	NaN	2332	2024-05-07 09:42:34	173	4.0	218.750000	91.500000	173.0	173.0	173.0	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2024-05-31 23:59:59.000000	False	138	173
18	NaN	2333	2024-05-07 09:44:04	173	3.0	173.000000	0.000000	173.0	173.0	173.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2024-05-31 23:59:59.000000	False	138	173
19	NaN	2334	2024-05-07 09:44:42	173	4.0	218.750000	91.500000	173.0	173.0	173.0	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2024-05-31 23:59:59.000000	False	138	173
20	NaN	2335	2024-05-07 09:54:15	173	3.0	173.000000	0.000000	173.0	173.0	173.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2024-05-31 23:59:59.000000	False	138	173
21	NaN	2337	2024-06-10 07:31:53	132	1.0	132.000000	NaN	132.0	132.0	132.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-06-11 03:00:05.341501	False	104	132
22	NaN	2338	2024-05-14 00:00:14	98	1.0	98.000000	NaN	98.0	98.0	98.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-05-31 23:59:59.000000	False	1	98
23	NaN	2342	2024-05-16 00:00:18	95	9.0	208.555556	164.828025	7.0	89.0	95.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-05-31 23:59:59.000000	False	0	95
24	NaN	2347	2024-05-12 00:00:28	91	9.0	208.555556	164.828025	7.0	89.0	95.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-05-31 23:59:59.000000	False	0	91
25	NaN	2349	2024-05-14 00:00:22	89	9.0	208.555556	164.828025	7.0	89.0	95.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-05-31 23:59:59.000000	False	0	89
26	NaN	2350	2024-05-15 00:00:23	88	9.0	208.555556	164.828025	7.0	89.0	95.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-05-31 23:59:59.000000	False	0	88
27	NaN	2351	2024-06-05 00:00:27	84	17.0	101.705882	77.416701	7.0	34.0	77.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-06-11 03:00:05.341501	False	0	84
28	NaN	2352	2024-05-24 00:00:27	84	17.0	101.705882	77.416701	7.0	34.0	77.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-05-31 23:59:59.000000	False	0	84
29	NaN	2353	2024-05-24 00:00:29	83	17.0	101.705882	77.416701	7.0	34.0	77.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-05-31 23:59:59.000000	False	0	83
30	NaN	2356	2024-05-26 00:00:37	77	17.0	101.705882	77.416701	7.0	34.0	77.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-05-31 23:59:59.000000	False	0	77
31	NaN	2357	2024-05-26 00:00:39	77	17.0	101.705882	77.416701	7.0	34.0	77.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-05-31 23:59:59.000000	False	0	77
32	NaN	2359	2024-05-30 00:00:26	73	8.0	188.250000	89.961500	34.0	175.0	215.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-05-31 23:59:59.000000	False	0	73
33	NaN	2360	2024-05-31 00:00:28	72	17.0	101.705882	77.416701	7.0	34.0	77.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-05-31 23:59:59.000000	False	0	72
34	NaN	2361	2024-05-31 00:00:31	72	7.0	71.571429	2.760262	69.0	69.5	72.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-05-31 23:59:59.000000	False	0	72
35	NaN	2362	2024-05-29 21:44:55	72	7.0	71.571429	2.760262	69.0	69.5	72.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-05-31 23:59:59.000000	False	16	72
36	NaN	2363	2024-05-31 00:00:33	72	7.0	71.571429	2.760262	69.0	69.5	72.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-05-31 23:59:59.000000	False	0	72
37	NaN	2365	2024-06-07 07:16:09	70	7.0	71.571429	2.760262	69.0	69.5	72.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-06-11 03:00:05.341501	False	57	70
38	NaN	2366	2024-06-02 00:00:29	70	17.0	101.705882	77.416701	7.0	34.0	77.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-06-11 03:00:05.341501	False	0	70
39	NaN	2368	2024-05-28 20:38:51	69	7.0	71.571429	2.760262	69.0	69.5	72.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-05-31 23:59:59.000000	False	0	69
40	NaN	2369	2024-05-29 21:53:53	69	7.0	71.571429	2.760262	69.0	69.5	72.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-05-31 23:59:59.000000	False	57	69

41 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs