Analysis of OSM events in Bugzilla

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

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

Bugs considered recent: Since 2024-04-16.

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	63.000000	NaN	63.0	63.0	63.0	63.00	63.0
1	Documentation / Wiki	1.0	340.000000	NaN	340.0	340.0	340.0	340.00	340.0
2	IM-NBI	15.0	138.266667	112.147522	35.0	45.0	152.0	179.00	374.0
3	LCM	10.0	129.600000	201.851541	34.0	35.0	37.0	40.75	600.0
4	NG-SA	1.0	97.000000	NaN	97.0	97.0	97.0	97.00	97.0
5	NG-UI	3.0	60.333333	1.154701	59.0	60.0	61.0	61.00	61.0
6	OSMClient	3.0	253.333333	168.624830	59.0	199.5	340.0	350.50	361.0
7	POL	1.0	41.000000	NaN	41.0	41.0	41.0	41.00	41.0
8	RO	11.0	132.545455	138.574430	38.0	55.0	57.0	155.00	389.0
9	Robot-tests	2.0	239.000000	142.835570	138.0	188.5	239.0	289.50	340.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
NG-UI	0	0	2	2.0
OSMClient	0	1	1	2.0
RO	2	0	1	3.0
Robot-tests	0	0	2	2.0
All	3	5	15	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	389	9.0	130.000	145.445866	53.0	56.00	57.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	389
1	NaN	2235	2024-03-11 17:25:51	384	9.0	130.000	145.445866	53.0	56.00	57.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	384
2	NaN	2355	2024-03-25 04:52:49	42	8.0	36.375	2.615203	34.0	34.75	36.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	42

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	374	2.0	367.0	9.899495	360.0	363.50	367.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	374
1	NaN	2251	2024-03-13 00:00:17	340	2.0	199.5	198.697006	59.0	129.25	199.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	340
2	NaN	2307	2024-04-22 00:00:10	180	12.0	99.0	69.184864	35.0	42.00	49.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59	False	0	180
3	NaN	2308	2024-04-22 00:00:12	180	12.0	99.0	69.184864	35.0	42.00	49.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59	False	0	180
4	NaN	2312	2024-03-19 00:00:37	178	12.0	99.0	69.184864	35.0	42.00	49.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	178

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	600	1.0	600.000000	NaN	600.0	600.0	600.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-04-30 23:59:59	False	138	600
1	NaN	2230	2024-03-11 17:25:47	405	1.0	405.000000	NaN	405.0	405.0	405.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	405
2	NaN	2243	2024-04-02 17:29:43	361	1.0	361.000000	NaN	361.0	361.0	361.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59	False	305	361
3	NaN	2245	2024-04-02 17:35:28	360	2.0	367.000000	9.899495	360.0	363.5	367.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59	False	0	360
4	NaN	2252	2024-03-13 00:00:19	340	1.0	340.000000	NaN	340.0	340.0	340.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	340
5	NaN	2253	2024-03-13 00:00:21	340	1.0	340.000000	NaN	340.0	340.0	340.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	340
6	NaN	2286	2024-04-10 08:42:42	250	1.0	250.000000	NaN	250.0	250.0	250.0	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2024-04-30 23:59:59	False	223	250
7	NaN	2313	2024-03-22 00:00:41	174	12.0	99.000000	69.184864	35.0	42.0	49.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	174
8	NaN	2314	2024-04-22 00:00:14	174	12.0	99.000000	69.184864	35.0	42.0	49.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59	False	0	174
9	NaN	2322	2024-04-16 16:49:30	152	1.0	152.000000	NaN	152.0	152.0	152.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59	False	132	152
10	NaN	2326	2024-04-07 00:00:42	138	1.0	138.000000	NaN	138.0	138.0	138.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	comment	CURRENT	2024-04-30 23:59:59	False	0	138
11	NaN	2337	2024-04-08 00:00:50	97	1.0	97.000000	NaN	97.0	97.0	97.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59	False	0	97
12	NaN	2338	2024-03-13 22:13:04	63	1.0	63.000000	NaN	63.0	63.0	63.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	1	63
13	NaN	2339	2024-03-06 10:59:11	61	3.0	60.333333	1.154701	59.0	60.0	61.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	61
14	NaN	2340	2024-03-06 11:51:00	61	3.0	60.333333	1.154701	59.0	60.0	61.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	61

15 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs