Analysis of OSM events in Bugzilla

Date and time of the report: 2024-09-17 05:00:05.175539

Analysed period: 2020-07-01 to 2024-09-17.

Bugs considered recent: Since 2024-08-27.

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:

16

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	6	2	8
LCM	1	0	1
NG-SA	1	0	1
NG-UI	1	0	1
OSMClient	3	0	3
RO	1	0	1
Robot-tests	1	0	1
Total	14	2	16

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	7	2	9
UNCONFIRMED	1	0	1
CONFIRMED	6	0	6
Total	14	2	16

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	8.0	160.75	116.983210	1.0	100.0	174.5	213.25	311.0
1	LCM	1.0	170.00	NaN	170.0	170.0	170.0	170.00	170.0
2	NG-SA	1.0	230.00	NaN	230.0	230.0	230.0	230.00	230.0
3	NG-UI	1.0	98.00	NaN	98.0	98.0	98.0	98.00	98.0
4	OSMClient	3.0	129.00	5.196152	123.0	127.5	132.0	132.00	132.0
5	RO	1.0	105.00	NaN	105.0	105.0	105.0	105.00	105.0
6	Robot-tests	1.0	271.00	NaN	271.0	271.0	271.0	271.00	271.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	3	4	7.0
LCM	0	1	1.0
NG-SA	0	1	1.0
NG-UI	0	1	1.0
OSMClient	0	3	3.0
RO	0	1	1.0
Robot-tests	0	1	1.0
All	3	12	15.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	2312	2024-08-26 00:00:16	311	6.0	213.5	76.170204	132.0	171.25	181.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-08-31 23:59:59.000000	False	228	311
1	NaN	2314	2024-08-26 00:00:19	307	6.0	213.5	76.170204	132.0	171.25	181.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-08-31 23:59:59.000000	False	224	307
2	NaN	2381	2024-09-12 06:46:49	4	2.0	2.5	2.121320	1.0	1.75	2.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-09-17 03:00:05.207338	False	0	4

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	2331	2024-08-07 00:07:36	271	1.0	271.0	NaN	271.0	271.00	271.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	bug_status	CURRENT	2024-08-31 23:59:59.000000	False	230	271
1	NaN	2337	2024-08-20 17:29:58	230	1.0	230.0	NaN	230.0	230.00	230.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-08-31 23:59:59.000000	False	147	230
2	NaN	2352	2024-09-16 00:00:13	182	6.0	213.5	76.170204	132.0	171.25	181.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-09-17 03:00:05.207338	False	120	182
3	NaN	2353	2024-09-16 00:00:16	181	6.0	213.5	76.170204	132.0	171.25	181.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-09-17 03:00:05.207338	False	119	181
4	NaN	2361	2024-09-01 00:00:20	170	1.0	170.0	NaN	170.0	170.00	170.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-09-17 03:00:05.207338	False	92	170
5	NaN	2366	2024-09-01 00:00:24	168	6.0	213.5	76.170204	132.0	171.25	181.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-09-17 03:00:05.207338	False	0	168
6	NaN	2372	2024-08-22 00:00:19	132	6.0	213.5	76.170204	132.0	171.25	181.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-08-31 23:59:59.000000	False	0	132
7	NaN	2373	2024-08-21 00:00:19	132	3.0	129.0	5.196152	123.0	127.50	132.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-08-31 23:59:59.000000	False	0	132
8	NaN	2374	2024-09-12 00:00:20	132	3.0	129.0	5.196152	123.0	127.50	132.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-09-17 03:00:05.207338	False	0	132
9	NaN	2376	2024-09-09 00:00:21	123	3.0	129.0	5.196152	123.0	127.50	132.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-09-17 03:00:05.207338	False	0	123
10	NaN	2379	2024-07-17 06:12:49	105	1.0	105.0	NaN	105.0	105.00	105.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-07-31 23:59:59.000000	False	0	105
11	NaN	2380	2024-09-01 00:00:29	98	1.0	98.0	NaN	98.0	98.00	98.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-09-17 03:00:05.207338	False	0	98

12 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs