Analysis of OSM events in Bugzilla

Date and time of the report: 2024-04-20 05:00:05.719614

Analysed period: 2020-07-01 to 2024-04-20.

Bugs considered recent: Since 2024-03-30.

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:

51

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

Number of bugs per module

AGE	CURRENT	RECENT	Total
MODULE
DEVOPS	1	0	1
Documentation / Wiki	1	0	1
IM-NBI	12	3	15
LCM	5	7	12
NG-SA	1	0	1
NG-UI	3	0	3
OSMClient	3	0	3
POL	1	0	1
RO	10	1	11
Robot-tests	3	0	3
Total	40	11	51

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	35	7	42
UNCONFIRMED	0	1	1
CONFIRMED	3	2	5
IN_PROGRESS	2	1	3
Total	40	11	51

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	46.000000	NaN	46.0	46.0	46.0	46.0	46.0
1	Documentation / Wiki	1.0	323.000000	NaN	323.0	323.0	323.0	323.0	323.0
2	IM-NBI	15.0	121.266667	112.147522	18.0	28.0	135.0	162.0	357.0
3	LCM	12.0	116.833333	182.992714	17.0	18.0	20.0	129.5	583.0
4	NG-SA	1.0	80.000000	NaN	80.0	80.0	80.0	80.0	80.0
5	NG-UI	3.0	43.333333	1.154701	42.0	43.0	44.0	44.0	44.0
6	OSMClient	3.0	236.333333	168.624830	42.0	182.5	323.0	333.5	344.0
7	POL	1.0	24.000000	NaN	24.0	24.0	24.0	24.0	24.0
8	RO	11.0	115.545455	138.574430	21.0	38.0	40.0	138.0	372.0
9	Robot-tests	3.0	188.333333	116.624754	121.0	121.0	121.0	222.0	323.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
Documentation / Wiki	0	0	1	1.0
IM-NBI	0	4	4	8.0
LCM	2	0	3	5.0
NG-SA	0	0	1	1.0
OSMClient	0	1	1	2.0
RO	2	0	1	3.0
Robot-tests	0	1	2	3.0
All	4	6	13	23.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	2233	2024-03-11 17:25:49	372	9.0	113.000000	145.445866	36.0	39.0	40.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	372
1	NaN	2235	2024-03-11 17:25:51	367	9.0	113.000000	145.445866	36.0	39.0	40.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	367
2	NaN	2319	2024-03-21 01:00:10	155	9.0	34.444444	45.274472	17.0	18.0	20.0	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2024-03-31 23:59:59	False	125	155
3	NaN	2355	2024-03-25 04:52:49	25	9.0	34.444444	45.274472	17.0	18.0	20.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	25

4 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	2241	2024-03-11 16:03:32	357	2.0	350.0	9.899495	343.0	346.50	350.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	357
1	NaN	2251	2024-03-13 00:00:17	323	2.0	182.5	198.697006	42.0	112.25	182.5	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	CURRENT	2024-03-31 23:59:59	False	0	323
2	NaN	2253	2024-03-13 00:00:21	323	2.0	222.0	142.835570	121.0	171.50	222.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	CURRENT	2024-03-31 23:59:59	False	0	323
3	NaN	2307	2024-02-20 16:25:14	163	12.0	82.0	69.184864	18.0	25.00	32.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59	False	0	163
4	NaN	2308	2024-02-20 16:24:22	163	12.0	82.0	69.184864	18.0	25.00	32.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59	False	0	163
5	NaN	2312	2024-03-19 00:00:37	161	12.0	82.0	69.184864	18.0	25.00	32.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	161

6 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-04-05 00:00:12	583	1.0	583.0	NaN	583.0	583.0	583.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-04-20 03:00:05.749126	False	138	583
1	NaN	2230	2024-03-11 17:25:47	388	1.0	388.0	NaN	388.0	388.0	388.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	388
2	NaN	2243	2024-04-02 17:29:43	344	1.0	344.0	NaN	344.0	344.0	344.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-20 03:00:05.749126	False	305	344
3	NaN	2245	2024-04-02 17:35:28	343	2.0	350.0	9.899495	343.0	346.5	350.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-20 03:00:05.749126	False	0	343
4	NaN	2252	2024-03-13 00:00:19	323	1.0	323.0	NaN	323.0	323.0	323.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	323
5	NaN	2286	2024-04-10 08:42:42	233	1.0	233.0	NaN	233.0	233.0	233.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-04-20 03:00:05.749126	False	223	233
6	NaN	2313	2024-03-22 00:00:41	157	12.0	82.0	69.184864	18.0	25.0	32.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	157
7	NaN	2314	2024-02-20 16:27:21	157	12.0	82.0	69.184864	18.0	25.0	32.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	157
8	NaN	2322	2024-04-16 16:49:30	135	1.0	135.0	NaN	135.0	135.0	135.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-20 03:00:05.749126	False	132	135
9	NaN	2326	2024-04-07 00:00:42	121	1.0	121.0	NaN	121.0	121.0	121.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-04-20 03:00:05.749126	False	0	121
10	NaN	2329	2024-03-21 00:35:22	121	1.0	121.0	NaN	121.0	121.0	121.0	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2024-03-31 23:59:59.000000	False	91	121
11	NaN	2332	2024-04-04 00:00:48	121	2.0	222.0	142.835570	121.0	171.5	222.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-20 03:00:05.749126	False	0	121
12	NaN	2337	2024-04-08 00:00:50	80	1.0	80.0	NaN	80.0	80.0	80.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-20 03:00:05.749126	False	0	80

13 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs