Analysis of OSM events in Bugzilla

Date and time of the report: 2024-04-23 05:00:05.037235

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

Bugs considered recent: Since 2024-04-02.

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:

49

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	10	1	11
Robot-tests	3	0	3
Total	44	5	49

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	41	1	42
UNCONFIRMED	0	1	1
CONFIRMED	3	2	5
IN_PROGRESS	0	1	1
Total	44	5	49

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	49.000000	NaN	49.0	49.0	49.0	49.00	49.0
1	Documentation / Wiki	1.0	326.000000	NaN	326.0	326.0	326.0	326.00	326.0
2	IM-NBI	15.0	124.266667	112.147522	21.0	31.0	138.0	165.00	360.0
3	LCM	10.0	115.600000	201.851541	20.0	21.0	23.0	26.75	586.0
4	NG-SA	1.0	83.000000	NaN	83.0	83.0	83.0	83.00	83.0
5	NG-UI	3.0	46.333333	1.154701	45.0	46.0	47.0	47.00	47.0
6	OSMClient	3.0	239.333333	168.624830	45.0	185.5	326.0	336.50	347.0
7	POL	1.0	27.000000	NaN	27.0	27.0	27.0	27.00	27.0
8	RO	11.0	118.545455	138.574430	24.0	41.0	43.0	141.00	375.0
9	Robot-tests	3.0	191.333333	116.624754	124.0	124.0	124.0	225.00	326.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	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	1	2	3.0
All	3	6	12	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	375	9.0	116.000	145.445866	39.0	42.00	43.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	375
1	NaN	2235	2024-03-11 17:25:51	370	9.0	116.000	145.445866	39.0	42.00	43.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	370
2	NaN	2355	2024-03-25 04:52:49	28	8.0	22.375	2.615203	20.0	20.75	22.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	28

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	360	2.0	353.0	9.899495	346.0	349.50	353.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	360
1	NaN	2251	2024-03-13 00:00:17	326	2.0	185.5	198.697006	45.0	115.25	185.5	...	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	326
2	NaN	2253	2024-03-13 00:00:21	326	2.0	225.0	142.835570	124.0	174.50	225.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	326
3	NaN	2307	2024-04-22 00:00:10	166	12.0	85.0	69.184864	21.0	28.00	35.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-23 03:00:05.067147	False	0	166
4	NaN	2308	2024-04-22 00:00:12	166	12.0	85.0	69.184864	21.0	28.00	35.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-23 03:00:05.067147	False	0	166
5	NaN	2312	2024-03-19 00:00:37	164	12.0	85.0	69.184864	21.0	28.00	35.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	164

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	586	1.0	586.0	NaN	586.0	586.0	586.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-04-23 03:00:05.067147	False	138	586
1	NaN	2230	2024-03-11 17:25:47	391	1.0	391.0	NaN	391.0	391.0	391.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	391
2	NaN	2243	2024-04-02 17:29:43	347	1.0	347.0	NaN	347.0	347.0	347.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-23 03:00:05.067147	False	305	347
3	NaN	2245	2024-04-02 17:35:28	346	2.0	353.0	9.899495	346.0	349.5	353.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-23 03:00:05.067147	False	0	346
4	NaN	2252	2024-03-13 00:00:19	326	1.0	326.0	NaN	326.0	326.0	326.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	326
5	NaN	2286	2024-04-10 08:42:42	236	1.0	236.0	NaN	236.0	236.0	236.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-04-23 03:00:05.067147	False	223	236
6	NaN	2313	2024-03-22 00:00:41	160	12.0	85.0	69.184864	21.0	28.0	35.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	160
7	NaN	2314	2024-04-22 00:00:14	160	12.0	85.0	69.184864	21.0	28.0	35.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-23 03:00:05.067147	False	0	160
8	NaN	2322	2024-04-16 16:49:30	138	1.0	138.0	NaN	138.0	138.0	138.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-23 03:00:05.067147	False	132	138
9	NaN	2326	2024-04-07 00:00:42	124	1.0	124.0	NaN	124.0	124.0	124.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-04-23 03:00:05.067147	False	0	124
10	NaN	2332	2024-04-04 00:00:48	124	2.0	225.0	142.835570	124.0	174.5	225.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-23 03:00:05.067147	False	0	124
11	NaN	2337	2024-04-08 00:00:50	83	1.0	83.0	NaN	83.0	83.0	83.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-23 03:00:05.067147	False	0	83

12 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs