Analysis of OSM events in Bugzilla

Date and time of the report: 2024-07-02 05:00:04.780851

Analysed period: 2020-07-01 to 2024-07-02.

Bugs considered recent: Since 2024-06-11.

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:

34

Bugs present in multiple branches:

	BUG_DESCRIPTION	NUM_BRANCHES	RELEASE	MODULE	TIMESTAMP
0	Robot testsuite lcmop_01 fails in daily job wh...	2	[Master, v15.0]	Robot-tests	2024-05-07 09:43:12
1	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	11	3	14
LCM	5	1	6
NG-SA	0	1	1
NG-UI	1	0	1
OSMClient	4	0	4
RO	5	0	5
Robot-tests	3	0	3
Total	29	5	34

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	17	0	17
UNCONFIRMED	1	1	2
CONFIRMED	8	4	12
IN_PROGRESS	3	0	3
Total	29	5	34

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	14.0	139.642857	110.496507	28.0	55.00	104.5	224.5	416.0
1	LCM	6.0	185.500000	230.500976	90.0	90.25	92.0	93.0	656.0
2	NG-SA	1.0	153.000000	NaN	153.0	153.00	153.0	153.0	153.0
3	NG-UI	1.0	21.000000	NaN	21.0	21.00	21.0	21.0	21.0
4	OSMClient	4.0	143.250000	182.549308	46.0	52.75	55.0	145.5	417.0
5	RO	5.0	198.200000	148.019256	28.0	55.00	249.0	306.0	353.0
6	Robot-tests	3.0	255.000000	105.655099	194.0	194.00	194.0	285.5	377.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	6	9.0
LCM	0	6	6.0
NG-SA	0	1	1.0
OSMClient	0	1	1.0
RO	2	1	3.0
Robot-tests	1	2	3.0
All	6	17	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 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	2263	2024-06-10 17:33:21	377	2.0	285.500000	129.400541	194.0	239.75	285.5	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	comment	CURRENT	2024-06-30 23:59:59	False	322	377
1	NaN	2271	2024-06-10 17:35:49	353	2.0	190.500000	229.809704	28.0	109.25	190.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-06-30 23:59:59	False	326	353
2	NaN	2298	2024-06-04 17:20:18	249	2.0	152.000000	137.178716	55.0	103.50	152.0	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2024-06-30 23:59:59	False	221	249
3	NaN	2308	2024-06-25 17:02:27	236	12.0	110.916667	78.494306	28.0	54.75	97.5	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2024-06-30 23:59:59	False	230	236
4	NaN	2312	2024-06-25 16:58:23	234	12.0	110.916667	78.494306	28.0	54.75	97.5	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2024-06-30 23:59:59	False	228	234
5	NaN	2314	2024-06-25 16:55:32	230	12.0	110.916667	78.494306	28.0	54.75	97.5	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2024-06-30 23:59:59	False	224	230

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-06-11 00:00:10	656	1.0	656.000000	NaN	656.0	656.00	656.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-06-30 23:59:59.000000	False	138	656
1	NaN	2243	2024-06-10 17:31:26	417	1.0	417.000000	NaN	417.0	417.00	417.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-06-30 23:59:59.000000	False	305	417
2	NaN	2245	2024-06-03 00:00:16	416	1.0	416.000000	NaN	416.0	416.00	416.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-06-30 23:59:59.000000	False	0	416
3	NaN	2286	2024-06-12 00:00:16	306	1.0	306.000000	NaN	306.0	306.00	306.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-06-30 23:59:59.000000	False	223	306
4	NaN	2322	2024-05-20 15:57:54	208	1.0	208.000000	NaN	208.0	208.00	208.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-05-31 23:59:59.000000	False	132	208
5	NaN	2330	2024-05-07 09:43:21	194	2.0	285.500000	129.400541	194.0	239.75	285.5	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	keywords	CURRENT	2024-05-31 23:59:59.000000	False	138	194
6	NaN	2331	2024-05-07 09:43:47	194	1.0	194.000000	NaN	194.0	194.00	194.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	keywords	CURRENT	2024-05-31 23:59:59.000000	False	138	194
7	NaN	2337	2024-06-25 16:55:25	153	1.0	153.000000	NaN	153.0	153.00	153.0	...	NaN	NaT	NaN	NaN	everconfirmed	RECENT	2024-06-30 23:59:59.000000	False	147	153
8	NaN	2351	2024-06-05 00:00:27	105	12.0	110.916667	78.494306	28.0	54.75	97.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-06-30 23:59:59.000000	False	0	105
9	NaN	2352	2024-05-24 00:00:27	105	12.0	110.916667	78.494306	28.0	54.75	97.5	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-05-31 23:59:59.000000	False	0	105
10	NaN	2353	2024-05-24 00:00:29	104	12.0	110.916667	78.494306	28.0	54.75	97.5	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-05-31 23:59:59.000000	False	0	104
11	NaN	2361	2024-07-01 18:48:49	93	5.0	91.400000	1.516575	90.0	90.00	91.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-07-02 03:00:04.811060	False	92	93
12	NaN	2362	2024-05-29 21:44:55	93	5.0	91.400000	1.516575	90.0	90.00	91.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-05-31 23:59:59.000000	False	16	93
13	NaN	2365	2024-06-07 07:16:09	91	5.0	91.400000	1.516575	90.0	90.00	91.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-06-30 23:59:59.000000	False	57	91
14	NaN	2366	2024-07-01 10:25:41	91	12.0	110.916667	78.494306	28.0	54.75	97.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-07-02 03:00:04.811060	False	0	91
15	NaN	2368	2024-05-28 20:38:51	90	5.0	91.400000	1.516575	90.0	90.00	91.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-05-31 23:59:59.000000	False	0	90
16	NaN	2369	2024-05-29 21:53:53	90	5.0	91.400000	1.516575	90.0	90.00	91.0	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2024-05-31 23:59:59.000000	False	57	90

17 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs