Analysis of OSM events in Bugzilla

Date and time of the report: 2024-09-12 05:00:04.821372

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

Bugs considered recent: Since 2024-08-22.

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:

15

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	Total
MODULE
IM-NBI	6	6
LCM	1	1
NG-SA	1	1
NG-UI	1	1
OSMClient	3	3
RO	2	2
Robot-tests	1	1
Total	15	15

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	Total
VALUE
OPEN-UNCONFIRMED	7	7
UNCONFIRMED	2	2
CONFIRMED	6	6
Total	15	15

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	6.0	208.5	76.170204	127.0	166.25	176.5	270.75	306.0
1	LCM	1.0	165.0	NaN	165.0	165.00	165.0	165.00	165.0
2	NG-SA	1.0	225.0	NaN	225.0	225.00	225.0	225.00	225.0
3	NG-UI	1.0	93.0	NaN	93.0	93.00	93.0	93.00	93.0
4	OSMClient	3.0	124.0	5.196152	118.0	122.50	127.0	127.00	127.0
5	RO	2.0	239.0	196.575685	100.0	169.50	239.0	308.50	378.0
6	Robot-tests	1.0	266.0	NaN	266.0	266.00	266.0	266.00	266.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	4	6.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	2	2.0
Robot-tests	0	1	1.0
All	2	13	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	306	6.0	208.5	76.170204	127.0	166.25	176.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-08-31 23:59:59	False	228	306
1	NaN	2314	2024-08-26 00:00:19	302	6.0	208.5	76.170204	127.0	166.25	176.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-08-31 23:59:59	False	224	302

2 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	2286	2024-08-13 00:00:14	378	1.0	378.0	NaN	378.0	378.00	378.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-08-31 23:59:59.000000	False	223	378
1	NaN	2331	2024-08-07 00:07:36	266	1.0	266.0	NaN	266.0	266.00	266.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	266
2	NaN	2337	2024-08-20 17:29:58	225	1.0	225.0	NaN	225.0	225.00	225.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-08-31 23:59:59.000000	False	147	225
3	NaN	2352	2024-07-16 17:06:21	177	6.0	208.5	76.170204	127.0	166.25	176.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-07-31 23:59:59.000000	False	120	177
4	NaN	2353	2024-07-16 16:58:44	176	6.0	208.5	76.170204	127.0	166.25	176.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-07-31 23:59:59.000000	False	119	176
5	NaN	2361	2024-09-01 00:00:20	165	1.0	165.0	NaN	165.0	165.00	165.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-09-12 03:00:04.847836	False	92	165
6	NaN	2366	2024-09-01 00:00:24	163	6.0	208.5	76.170204	127.0	166.25	176.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-09-12 03:00:04.847836	False	0	163
7	NaN	2372	2024-08-22 00:00:19	127	6.0	208.5	76.170204	127.0	166.25	176.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-08-31 23:59:59.000000	False	0	127
8	NaN	2373	2024-08-21 00:00:19	127	3.0	124.0	5.196152	118.0	122.50	127.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-08-31 23:59:59.000000	False	0	127
9	NaN	2374	2024-07-13 00:00:15	127	3.0	124.0	5.196152	118.0	122.50	127.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-07-31 23:59:59.000000	False	0	127
10	NaN	2376	2024-09-09 00:00:21	118	3.0	124.0	5.196152	118.0	122.50	127.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-09-12 03:00:04.847836	False	0	118
11	NaN	2379	2024-07-17 06:12:49	100	1.0	100.0	NaN	100.0	100.00	100.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-07-31 23:59:59.000000	False	0	100
12	NaN	2380	2024-09-01 00:00:29	93	1.0	93.0	NaN	93.0	93.00	93.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-09-12 03:00:04.847836	False	0	93

13 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs