Analysis of OSM events in Bugzilla

Date and time of the report: 2024-05-06 05:00:05.509717

Analysed period: 2020-07-01 to 2024-05-06.

Bugs considered recent: Since 2024-04-15.

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:

48

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	14	1	15
LCM	7	3	10
NG-SA	1	0	1
NG-UI	3	0	3
OSMClient	3	0	3
POL	1	0	1
RO	11	0	11
Robot-tests	2	0	2
Total	44	4	48

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	40	0	40
UNCONFIRMED	1	0	1
CONFIRMED	3	2	5
IN_PROGRESS	0	2	2
Total	44	4	48

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	62.000000	NaN	62.0	62.0	62.0	62.00	62.0
1	Documentation / Wiki	1.0	339.000000	NaN	339.0	339.0	339.0	339.00	339.0
2	IM-NBI	15.0	137.266667	112.147522	34.0	44.0	151.0	178.00	373.0
3	LCM	10.0	128.600000	201.851541	33.0	34.0	36.0	39.75	599.0
4	NG-SA	1.0	96.000000	NaN	96.0	96.0	96.0	96.00	96.0
5	NG-UI	3.0	59.333333	1.154701	58.0	59.0	60.0	60.00	60.0
6	OSMClient	3.0	252.333333	168.624830	58.0	198.5	339.0	349.50	360.0
7	POL	1.0	40.000000	NaN	40.0	40.0	40.0	40.00	40.0
8	RO	11.0	131.545455	138.574430	37.0	54.0	56.0	154.00	388.0
9	Robot-tests	2.0	238.000000	142.835570	137.0	187.5	238.0	288.50	339.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
DEVOPS	0	0	1	1.0
Documentation / Wiki	0	0	1	1.0
IM-NBI	0	4	4	8.0
LCM	1	0	2	3.0
NG-SA	0	0	1	1.0
OSMClient	0	1	1	2.0
RO	2	0	1	3.0
Robot-tests	0	0	2	2.0
All	3	5	13	21.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	388	9.0	129.000	145.445866	52.0	55.00	56.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	388
1	NaN	2235	2024-03-11 17:25:51	383	9.0	129.000	145.445866	52.0	55.00	56.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	383
2	NaN	2355	2024-03-25 04:52:49	41	8.0	35.375	2.615203	33.0	33.75	35.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	41

3 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	373	2.0	366.0	9.899495	359.0	362.50	366.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	373
1	NaN	2251	2024-03-13 00:00:17	339	2.0	198.5	198.697006	58.0	128.25	198.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	339
2	NaN	2307	2024-04-22 00:00:10	179	12.0	98.0	69.184864	34.0	41.00	48.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59	False	0	179
3	NaN	2308	2024-04-22 00:00:12	179	12.0	98.0	69.184864	34.0	41.00	48.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59	False	0	179
4	NaN	2312	2024-03-19 00:00:37	177	12.0	98.0	69.184864	34.0	41.00	48.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	177

5 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	599	1.0	599.0	NaN	599.0	599.0	599.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-04-30 23:59:59	False	138	599
1	NaN	2230	2024-03-11 17:25:47	404	1.0	404.0	NaN	404.0	404.0	404.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	404
2	NaN	2243	2024-04-02 17:29:43	360	1.0	360.0	NaN	360.0	360.0	360.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59	False	305	360
3	NaN	2245	2024-04-02 17:35:28	359	2.0	366.0	9.899495	359.0	362.5	366.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59	False	0	359
4	NaN	2252	2024-03-13 00:00:19	339	1.0	339.0	NaN	339.0	339.0	339.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	339
5	NaN	2253	2024-03-13 00:00:21	339	1.0	339.0	NaN	339.0	339.0	339.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	339
6	NaN	2286	2024-04-10 08:42:42	249	1.0	249.0	NaN	249.0	249.0	249.0	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2024-04-30 23:59:59	False	223	249
7	NaN	2313	2024-03-22 00:00:41	173	12.0	98.0	69.184864	34.0	41.0	48.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	173
8	NaN	2314	2024-04-22 00:00:14	173	12.0	98.0	69.184864	34.0	41.0	48.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59	False	0	173
9	NaN	2322	2024-04-16 16:49:30	151	1.0	151.0	NaN	151.0	151.0	151.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59	False	132	151
10	NaN	2326	2024-04-07 00:00:42	137	1.0	137.0	NaN	137.0	137.0	137.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	comment	CURRENT	2024-04-30 23:59:59	False	0	137
11	NaN	2337	2024-04-08 00:00:50	96	1.0	96.0	NaN	96.0	96.0	96.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59	False	0	96
12	NaN	2338	2024-03-13 22:13:04	62	1.0	62.0	NaN	62.0	62.0	62.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	1	62

13 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs