Analysis of OSM events in Bugzilla

Date and time of the report: 2024-04-11 05:00:04.975441

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

Bugs considered recent: Since 2024-03-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:

53

Bugs present in multiple branches:

	BUG_DESCRIPTION	NUM_BRANCHES	RELEASE	MODULE	TIMESTAMP
0	NS deletion takes longer than expected for bas...	2	[Master, v15.0]	LCM	2024-03-14 15:35:49
1	Operational-status is not getting updated when...	2	[v14.0, v14.0]	LCM	2024-03-30 17:07:09

Number of bugs per module

AGE	CURRENT	RECENT	Total
MODULE
DEVOPS	1	0	1
Documentation / Wiki	1	0	1
IM-NBI	10	4	14
LCM	3	10	13
NG-SA	1	0	1
NG-UI	3	0	3
OSMClient	5	0	5
POL	0	1	1
RO	9	2	11
Robot-tests	3	0	3
Total	36	17	53

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	32	14	46
UNCONFIRMED	0	1	1
CONFIRMED	3	0	3
IN_PROGRESS	1	2	3
Total	36	17	53

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	37.000000	NaN	37.0	37.0	37.0	37.0	37.0
1	Documentation / Wiki	1.0	314.000000	NaN	314.0	314.0	314.0	314.0	314.0
2	IM-NBI	14.0	111.285714	116.314182	9.0	17.5	85.5	153.5	348.0
3	LCM	13.0	108.153846	175.205996	8.0	9.0	11.0	112.0	574.0
4	NG-SA	1.0	71.000000	NaN	71.0	71.0	71.0	71.0	71.0
5	NG-UI	3.0	34.333333	1.154701	33.0	34.0	35.0	35.0	35.0
6	OSMClient	5.0	256.400000	125.703222	33.0	300.0	300.0	314.0	335.0
7	POL	1.0	15.000000	NaN	15.0	15.0	15.0	15.0	15.0
8	RO	11.0	106.545455	138.574430	12.0	29.0	31.0	129.0	363.0
9	Robot-tests	3.0	179.333333	116.624754	112.0	112.0	112.0	213.0	314.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	3	7.0
LCM	2	1	3	6.0
NG-SA	0	0	1	1.0
OSMClient	0	1	3	4.0
RO	2	0	1	3.0
Robot-tests	0	1	2	3.0
All	4	7	14	25.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	363	9.0	104.000000	145.445866	27.0	30.0	31.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	363
1	NaN	2235	2024-03-11 17:25:51	358	9.0	104.000000	145.445866	27.0	30.0	31.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	358
2	NaN	2319	2024-03-21 01:00:10	146	9.0	25.444444	45.274472	8.0	9.0	11.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-31 23:59:59	False	125	146
3	NaN	2355	2024-03-25 04:52:49	16	9.0	25.444444	45.274472	8.0	9.0	11.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-31 23:59:59	False	0	16

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	2230	2024-03-11 17:25:47	379	2.0	245.50	188.797511	112.0	178.75	245.5	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	379
1	NaN	2241	2024-03-11 16:03:32	348	2.0	341.00	9.899495	334.0	337.50	341.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	348
2	NaN	2251	2024-03-13 00:00:17	314	4.0	236.75	135.993566	33.0	233.25	300.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	314
3	NaN	2253	2024-03-13 00:00:21	314	2.0	213.00	142.835570	112.0	162.50	213.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	314
4	NaN	2307	2024-02-20 16:25:14	154	12.0	73.00	69.184864	9.0	16.00	23.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59	False	0	154
5	NaN	2308	2024-02-20 16:24:22	154	12.0	73.00	69.184864	9.0	16.00	23.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59	False	0	154
6	NaN	2312	2024-03-19 00:00:37	152	12.0	73.00	69.184864	9.0	16.00	23.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	152

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-04-05 00:00:12	574	1.0	574.00	NaN	574.0	574.00	574.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-04-11 03:00:05.006935	False	138	574
1	NaN	2243	2024-04-02 17:29:43	335	1.0	335.00	NaN	335.0	335.00	335.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-11 03:00:05.006935	False	305	335
2	NaN	2245	2024-04-02 17:35:28	334	2.0	341.00	9.899495	334.0	337.50	341.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-11 03:00:05.006935	False	0	334
3	NaN	2252	2024-03-13 00:00:19	314	1.0	314.00	NaN	314.0	314.00	314.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	314
4	NaN	2259	2024-03-12 17:32:24	300	4.0	236.75	135.993566	33.0	233.25	300.0	...	gerardo.garciadeblas@telefonica.com	2024-03-31 23:59:59	CURRENT	1.0	assigned_to	CURRENT	2024-03-31 23:59:59.000000	False	0	300
5	NaN	2260	2024-03-12 17:32:32	300	4.0	236.75	135.993566	33.0	233.25	300.0	...	gerardo.garciadeblas@telefonica.com	2024-03-31 23:59:59	CURRENT	1.0	assigned_to	CURRENT	2024-03-31 23:59:59.000000	False	0	300
6	NaN	2286	2024-04-10 08:42:42	224	1.0	224.00	NaN	224.0	224.00	224.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-04-11 03:00:05.006935	False	223	224
7	NaN	2313	2024-03-22 00:00:41	148	12.0	73.00	69.184864	9.0	16.00	23.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-31 23:59:59.000000	False	0	148
8	NaN	2314	2024-02-20 16:27:21	148	12.0	73.00	69.184864	9.0	16.00	23.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	148
9	NaN	2326	2024-04-07 00:00:42	112	1.0	112.00	NaN	112.0	112.00	112.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-04-11 03:00:05.006935	False	0	112
10	NaN	2328	2024-03-14 15:35:49	112	2.0	245.50	188.797511	112.0	178.75	245.5	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2024-03-31 23:59:59.000000	False	85	112
11	NaN	2329	2024-03-21 00:35:22	112	1.0	112.00	NaN	112.0	112.00	112.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-31 23:59:59.000000	False	91	112
12	NaN	2332	2024-04-04 00:00:48	112	2.0	213.00	142.835570	112.0	162.50	213.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-11 03:00:05.006935	False	0	112
13	NaN	2337	2024-04-08 00:00:50	71	1.0	71.00	NaN	71.0	71.00	71.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-11 03:00:05.006935	False	0	71

14 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs