Analysis of OSM events in Bugzilla

Date and time of the report: 2024-08-15 05:00:05.485262

Analysed period: 2020-07-01 to 2024-08-15.

Bugs considered recent: Since 2024-07-25.

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:

27

Bugs present in multiple branches:

	BUG_DESCRIPTION	NUM_BRANCHES	RELEASE	MODULE	TIMESTAMP
0	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
IM-NBI	9	0	9
LCM	6	0	6
NG-SA	1	0	1
NG-UI	1	0	1
OSMClient	4	0	4
RO	4	0	4
Robot-tests	1	1	2
Total	26	1	27

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	10	0	10
UNCONFIRMED	2	0	2
CONFIRMED	11	1	12
IN_PROGRESS	3	0	3
Total	26	1	27

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	IM-NBI	9.0	165.00	82.339237	72.0	99.00	148.0	252.00	278.0
1	LCM	6.0	229.50	230.500976	134.0	134.25	136.0	137.00	700.0
2	NG-SA	1.0	197.00	NaN	197.0	197.00	197.0	197.00	197.0
3	NG-UI	1.0	65.00	NaN	65.0	65.00	65.0	65.00	65.0
4	OSMClient	4.0	187.25	182.549308	90.0	96.75	99.0	189.50	461.0
5	RO	4.0	278.00	143.766014	72.0	237.75	321.5	361.75	397.0
6	Robot-tests	2.0	329.50	129.400541	238.0	283.75	329.5	375.25	421.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	2. Open beyond q3	3. Open beyond 2 months	All
MODULE
IM-NBI	2	7	9.0
LCM	0	6	6.0
NG-SA	0	1	1.0
NG-UI	0	1	1.0
OSMClient	0	4	4.0
RO	1	3	4.0
Robot-tests	0	2	2.0
All	3	24	27.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 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	2271	2024-08-11 00:00:16	397	2.0	234.500	229.809704	72.0	153.25	234.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-08-15 03:00:05.520789	False	326	397
1	NaN	2312	2024-06-25 16:58:23	278	8.0	154.125	80.819795	72.0	93.75	141.5	...	NaN	NaT	NaN	NaN	everconfirmed	CURRENT	2024-06-30 23:59:59.000000	False	228	278
2	NaN	2314	2024-06-25 16:55:32	274	8.0	154.125	80.819795	72.0	93.75	141.5	...	NaN	NaT	NaN	NaN	everconfirmed	CURRENT	2024-06-30 23:59:59.000000	False	224	274

3 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-08-12 00:00:11	700	1.0	700.000	NaN	700.0	700.00	700.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-08-15 03:00:05.520789	False	138	700
1	NaN	2243	2024-08-11 00:00:11	461	1.0	461.000	NaN	461.0	461.00	461.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-08-15 03:00:05.520789	False	305	461
2	NaN	2263	2024-08-11 00:00:14	421	1.0	421.000	NaN	421.0	421.00	421.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	comment	RECENT	2024-08-15 03:00:05.520789	False	322	421
3	NaN	2286	2024-08-13 00:00:14	350	1.0	350.000	NaN	350.0	350.00	350.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-08-15 03:00:05.520789	False	223	350
4	NaN	2298	2024-08-05 00:00:11	293	1.0	293.000	NaN	293.0	293.00	293.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-08-15 03:00:05.520789	False	221	293
5	NaN	2322	2024-07-21 00:00:12	252	1.0	252.000	NaN	252.0	252.00	252.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-07-31 23:59:59.000000	False	132	252
6	NaN	2331	2024-08-07 00:07:36	238	1.0	238.000	NaN	238.0	238.00	238.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	bug_status	RECENT	2024-08-15 03:00:05.520789	False	230	238
7	NaN	2337	2024-07-15 16:15:37	197	1.0	197.000	NaN	197.0	197.00	197.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-07-31 23:59:59.000000	False	147	197
8	NaN	2352	2024-07-16 17:06:21	149	8.0	154.125	80.819795	72.0	93.75	141.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-07-31 23:59:59.000000	False	120	149
9	NaN	2353	2024-07-16 16:58:44	148	8.0	154.125	80.819795	72.0	93.75	141.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-07-31 23:59:59.000000	False	119	148
10	NaN	2361	2024-07-01 18:48:49	137	5.0	135.400	1.516575	134.0	134.00	135.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-07-31 23:59:59.000000	False	92	137
11	NaN	2362	2024-07-30 00:00:13	137	5.0	135.400	1.516575	134.0	134.00	135.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-07-31 23:59:59.000000	False	16	137
12	NaN	2365	2024-08-08 00:00:14	135	5.0	135.400	1.516575	134.0	134.00	135.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-08-15 03:00:05.520789	False	57	135
13	NaN	2366	2024-07-01 10:25:41	135	8.0	154.125	80.819795	72.0	93.75	141.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-07-31 23:59:59.000000	False	0	135
14	NaN	2368	2024-07-29 00:00:14	134	5.0	135.400	1.516575	134.0	134.00	135.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-07-31 23:59:59.000000	False	0	134
15	NaN	2369	2024-07-30 00:00:17	134	5.0	135.400	1.516575	134.0	134.00	135.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-07-31 23:59:59.000000	False	57	134
16	NaN	2372	2024-06-21 08:07:36	99	8.0	154.125	80.819795	72.0	93.75	141.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-06-30 23:59:59.000000	False	0	99
17	NaN	2373	2024-06-20 12:08:23	99	3.0	96.000	5.196152	90.0	94.50	99.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-06-30 23:59:59.000000	False	0	99
18	NaN	2374	2024-07-13 00:00:15	99	3.0	96.000	5.196152	90.0	94.50	99.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-07-31 23:59:59.000000	False	0	99
19	NaN	2376	2024-07-09 17:09:53	90	3.0	96.000	5.196152	90.0	94.50	99.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-07-31 23:59:59.000000	False	0	90
20	NaN	2377	2024-07-29 00:00:20	78	8.0	154.125	80.819795	72.0	93.75	141.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-07-31 23:59:59.000000	False	0	78
21	NaN	2378	2024-08-04 00:00:19	72	8.0	154.125	80.819795	72.0	93.75	141.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-08-15 03:00:05.520789	False	0	72
22	NaN	2379	2024-07-17 06:12:49	72	2.0	234.500	229.809704	72.0	153.25	234.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-07-31 23:59:59.000000	False	0	72
23	NaN	2380	2024-07-01 07:43:35	65	1.0	65.000	NaN	65.0	65.00	65.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-07-31 23:59:59.000000	False	0	65

24 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs